设为首页 收藏本站
查看: 945|回复: 0

[经验分享] Centos 6.3 + vbox + oracle database 11g r2 + udev 配置单机ASM

[复制链接]

尚未签到

发表于 2015-4-17 08:05:53 | 显示全部楼层 |阅读模式
  udev配置
  https://blogs.oracle.com/askmaclean/entry/%E5%9C%A8linux_6%E4%B8%8A%E4%BD%
  BF%E7%94%A8udev%E8%A7%A3%E5%86%B3rac_asm%E5%AD%98%E5%82%A8%
  E8%AE%BE%E5%A4%87%E5%90%8D%E9%97%AE%E9%A2%98
  安装grid配置磁盘组
http://wenku.baidu.com/view/e5d826c22cc58bd63186bdbd.html
root.sh出错,解决参考文件//http://blog.iyunv.com/meteorlet/article/details/8363745
  asm管理
关闭与启动
http://blog.iyunv.com/yfleng2002/article/details/7785216
管理
http://blog.iyunv.com/tianlesoftware/article/details/8435670
  安装oracle software
  配置数据库所需lsnr//进入grid用户配置
  dbca创建数据库
  由于ORACLE_HOME权限错误导致DBCA建库时找不到ASM磁盘
http://wenku.it168.com/d_000635936.shtml
  Oracle Enterprise Linux6.3下安装Oracle11g Grid ASM
http://wenku.baidu.com/view/975996feaef8941ea76e0563.html
  --------------------------------------------------------------------------------
  [iyunv@asmct Packages]# lsb_release -a
  LSB Version:    :core-4.0-ia32:core-4.0-noarch:graphics-4.0-ia32:graphics-4.0-noarch:printing-4.0-ia32:printing-4.0-noarch
  Distributor ID: CentOS
  Description:    CentOS release 6.3 (Final)
  Release:        6.3
  Codename:       Final
  [iyunv@asmct ~]# groupadd oinstall
  [iyunv@asmct ~]# groupadd dba
  [iyunv@asmct ~]# groupadd oper
  [iyunv@asmct ~]# groupadd asmadmin
  [iyunv@asmct ~]# groupadd asmdba
  [iyunv@asmct ~]# groupadd asmoper
  [iyunv@asmct ~]# useradd -g oinstall -G dba,asmdba,oper --home=/u1/oracle oracle
  [iyunv@asmct ~]# useradd -g oinstall -G asmadmin,asmdba,asmoper --home=/u1/grid grid
  [iyunv@asmct ~]# passwd oracle
  Changing password for user oracle.
  New password:
  BAD PASSWORD: it is based on a dictionary word
  BAD PASSWORD: is too simple
  Retype new password:
  passwd: all authentication tokens updated successfully.
  [iyunv@asmct ~]# passwd grid
  Changing password for user grid.
  New password:
  BAD PASSWORD: it is too short
  BAD PASSWORD: is too simple
  Retype new password:
  passwd: all authentication tokens updated successfully.
  package
Oracle Linux 6 and Red Hat Enterprise Linux 6

The following packages (or later versions) must be installed:

binutils-2.20.51.0.2-5.11.el6.i686

compat-libcap1-1.10-1.i686

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.4-13.el6.i686

gcc-c++-4.4.4-13.el6.i686

glibc-2.12-1.7.el6.i686

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.4-13.el6.i686

libstdc++-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6.i686

libaio-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6.i686

make-3.81-19.el6.i686

sysstat-9.0.4-11.el6.i686

unixODBC-devel-2.2.14-11.el6.i686

unixODBC-2.2.14-11.el6.i686

pdksh-5.2.14-1.i386

  Grid env:
  export PATH
  export ORACLE_SID=+ASMCT
  export ORACLE_HOME=/u1/grid/app/product/
  export PATH=$PATH:/u1/grid/app/product/bin
  vmware 需在*.vmx文件中加入:disk.EnableUUID = "TRUE"
  [iyunv@asmct /]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdc
  36000c299575041448c8f93d14d21bc8e
  [iyunv@asmct rules.d]# fdisk -l
  Disk /dev/sda: 21.5 GB, 21474836480 bytes
  255 heads, 63 sectors/track, 2610 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes
  Sector size (logical/physical): 512 bytes / 512 bytes
  I/O size (minimum/optimal): 512 bytes / 512 bytes
  Disk identifier: 0x000ce40f
  Device Boot      Start         End      Blocks   Id  System
  /dev/sda1   *           1          13      102400   83  Linux
  Partition 1 does not end on cylinder boundary.
  /dev/sda2              13        2356    18820096   83  Linux
  /dev/sda3            2356        2484     1024000   83  Linux
  /dev/sda4            2484        2611     1024000    5  Extended
  /dev/sda5            2484        2611     1022976   82  Linux swap / Solaris
  Disk /dev/sdb: 21.5 GB, 21474836480 bytes
  255 heads, 63 sectors/track, 2610 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes
  Sector size (logical/physical): 512 bytes / 512 bytes
  I/O size (minimum/optimal): 512 bytes / 512 bytes
  Disk identifier: 0x264a5c6a
  Device Boot      Start         End      Blocks   Id  System
  /dev/sdb1               1        2610    20964793+  83  Linux
  Disk /dev/sdc: 10.7 GB, 10737418240 bytes
  255 heads, 63 sectors/track, 1305 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes
  Sector size (logical/physical): 512 bytes / 512 bytes
  I/O size (minimum/optimal): 512 bytes / 512 bytes
  Disk identifier: 0x3f7831d9
  Device Boot      Start         End      Blocks   Id  System
  /dev/sdc1               1        1305    10482381   83  Linux
  Disk /dev/sdd: 10.7 GB, 10737418240 bytes
  255 heads, 63 sectors/track, 1305 cylinders
  Units = cylinders of 16065 * 512 = 8225280 bytes
  Sector size (logical/physical): 512 bytes / 512 bytes
  I/O size (minimum/optimal): 512 bytes / 512 bytes
  Disk identifier: 0x9b134d5e
  Device Boot      Start         End      Blocks   Id  System
  /dev/sdd1               1        1305    10482381   83  Linux
  
  [iyunv@asmct /]# for i in c d;
  > do
  > echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""      >> /etc/udev/rules.d/99-oracle-asmdevices.rules
  > done
  [iyunv@asmct /]# cd /etc/udev/rules.d/
  [iyunv@asmct rules.d]# ls
  40-hplip.rules               90-alsa.rules
  56-hpmud_support.rules       90-hal.rules
  60-fprint-autosuspend.rules  91-drm-modeset.rules
  60-pcmcia.rules              97-bluetooth-serial.rules
  60-raw.rules                 98-kexec.rules
  70-persistent-cd.rules       99-fuse.rules
  70-persistent-net.rules      99-oracle-asmdevices.rules
  [iyunv@asmct rules.d]# less 99-oracle-asmdevices.rules
  KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c299575041448c8f93d14d21bc8e", NAME="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
  KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c29c688fb0101fbaac4a3f83bdbb", NAME="asm-diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"
  [iyunv@asmct dev]# start_udev
  Starting udev: [  OK  ]
  [iyunv@asmct dev]# ls -l asm*
  brw-rw----. 1 grid asmadmin 8, 32 Apr 14 08:13 asm-diskc
  brw-rw----. 1 grid asmadmin 8, 48 Apr 14 08:13 asm-diskd
  
  [iyunv@asmct dev]# less /etc/hosts
  127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
  ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
  192.168.50.201 asmct
  127.0.0.1 asmct
  
  [iyunv@asmct Packages]# grep -v ^# /etc/sysctl.conf
  net.ipv4.ip_forward = 0
  net.ipv4.conf.default.rp_filter = 1
  net.ipv4.conf.default.accept_source_route = 0
  kernel.sysrq = 0
  kernel.core_uses_pid = 1
  net.ipv4.tcp_syncookies = 1
  kernel.msgmnb = 65536
  kernel.msgmax = 65536
  kernel.shmmax = 4294967295
  kernel.shmall = 268435456
  kernel.shmmni = 4096
  kernel.sem = 250 3200 100 128
  fs.file-max = 6815744
  fs.aio-max-nr = 1048576
  net.ipv4.ip_local_port_range = 9000 65500
  net.core.rmem_default = 262144
  net.core.rmem_max = 4194304
  net.core.wmem_default = 262144
  net.core.wmem_max = 1048576
  
  ORACLE ENV
  export PATH
  export ORACLE_SID=ASMCT
  export ORACLE_HOME=/u1/oracle/app/product
  export ORACLE_BASE=/u1/oracle/app
  export PATH=$PATH:/u1/oracle/app/product/bin
  export DISPLAY=192.168.50.1:0.0;
  -------------------------------------------------------------------------------
  详细文档下载地址 http://www.itpub.net/thread-1802178-1-1.html
  --------------------------------------------------------------------------------
  收工!

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-57877-1-1.html 上篇帖子: vbox 虚拟机添加usb 下篇帖子: 连接远程系统里的vbox虚拟机
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表