Centos 6.3 + vbox + oracle database 11g r2 + udev 配置单机ASM
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.csdn.net/meteorlet/article/details/8363745
asm管理
关闭与启动
http://blog.csdn.net/yfleng2002/article/details/7785216
管理
http://blog.csdn.net/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
--------------------------------------------------------------------------------
[root@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
[root@asmct ~]# groupadd oinstall
[root@asmct ~]# groupadd dba
[root@asmct ~]# groupadd oper
[root@asmct ~]# groupadd asmadmin
[root@asmct ~]# groupadd asmdba
[root@asmct ~]# groupadd asmoper
[root@asmct ~]# useradd -g oinstall -G dba,asmdba,oper --home=/u1/oracle oracle
[root@asmct ~]# useradd -g oinstall -G asmadmin,asmdba,asmoper --home=/u1/grid grid
[root@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.
[root@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"
[root@asmct /]# scsi_id --whitelisted --replace-whitespace --device=/dev/sdc
36000c299575041448c8f93d14d21bc8e
[root@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
[root@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
[root@asmct /]# cd /etc/udev/rules.d/
[root@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
[root@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"
[root@asmct dev]# start_udev
Starting udev: [ OK ]
[root@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
[root@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
[root@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
--------------------------------------------------------------------------------
收工!
