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.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
--------------------------------------------------------------------------------
# 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
# groupadd oinstall
# groupadd dba
# groupadd oper
# groupadd asmadmin
# groupadd asmdba
# groupadd asmoper
# useradd -g oinstall -G dba,asmdba,oper --home=/u1/oracle oracle
# useradd -g oinstall -G asmadmin,asmdba,asmoper --home=/u1/grid grid
# 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.
# 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"
# scsi_id --whitelisted --replace-whitespace --device=/dev/sdc
36000c299575041448c8f93d14d21bc8e
# 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 IdSystem
/dev/sda1 * 1 13 102400 83Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 13 2356 18820096 83Linux
/dev/sda3 2356 2484 1024000 83Linux
/dev/sda4 2484 2611 1024000 5Extended
/dev/sda5 2484 2611 1022976 82Linux 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 IdSystem
/dev/sdb1 1 2610 20964793+83Linux
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 IdSystem
/dev/sdc1 1 1305 10482381 83Linux
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 IdSystem
/dev/sdd1 1 1305 10482381 83Linux
# 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
# cd /etc/udev/rules.d/
# ls
40-hplip.rules 90-alsa.rules
56-hpmud_support.rules 90-hal.rules
60-fprint-autosuspend.rules91-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
# 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"
# start_udev
Starting udev:
# 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
# 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
# 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]