Oracle Enterprise Linux 6.4安装Oracle Database 12c RAC图文详细教程

Oracle Database 12c早发布了，这几天尝试了下单机、RESTART和RAC的安装，其中发生了不少趣事。比如安装Oracle 12c Restart花费了4小时多最终笔记本死机、RAC安装过程中采用HAIP特性却失败等等。Oracle 12c RAC引入了Flex Cluster的概念，但我尚未研究成功。下面是传统方式安装Oracle 12c RAC的教程。 环境介绍OS: Oracle Enterprise Linux 6.4 （For RAC Nodes），Oracle Enterprise Linux 5.8（For DNS Server），Openfiler 2.3（For SAN Storage）DB: GI and Database 12.1.0.1 所需介质linuxamd64_12c_database_1of2.ziplinuxamd64_12c_database_2of2.ziplinuxamd64_12c_grid_1of2.ziplinuxamd64_12c_grid_2of2.zip– 这里只给出Oracle相关的，操作系统以及其他软件请自身准备。 操作系统信息RAC节点服务器:（以node1节点为例）[root@12crac1 ~]# cat /etc/RedHat-release RedHatEnterpriseLinuxServer release 6.4（Santiago）[root@12crac1 ~]# uname -aLinux12crac1.luocs.com 2.6.39-400.17.1.el6uek.x86_64 #1 SMP Fri Feb 22 18:16:18 PST 2013 x86_64 x86_64 x86_64 GNU/Linux[root@12crac1 ~]# grep MemTotal /proc/meminfoMemTotal:2051748 kB[root@12crac1 ~]# grep SwapTotal /proc/meminfoSwapTotal:5119996 kB[root@12crac1 ~]# df -hFilesystemSizeUsedAvailUse%Mounted on/dev/sda345G16G27G38%/tmpfs 2.0G652M1.4G32% /dev/shm/dev/sda1 194M50M135M27%/boot 网络配置信息：备注：从下面信息中可以发现，每个节点服务器我都添加了五个网卡，eth0用于PUBLIC，而eth1~eth4用于Private，本想采用HAIP特性。但我在安装实验过程中HAIP特性上发生了节点2无法启动ASM实例的问题，因此最后只用了其中eth1接口。至于HAIP导致的问题，可能是出于BUG，这个问题还有待仔细troubleshooting。（节点1）[root@12crac1 ~]# ifconfigeth0Link encap:EthernetHWaddr00:0C:29:75:36:EDinet addr:192.168.1.150Bcast:192.168.1.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fe75:36ed/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:64 errors:0 dropped:0 overruns:0 frame:0TX packets:56 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:7014（6.8KiB）TX bytes:6193（6.0KiB）eth1Link encap:EthernetHWaddr00:0C:29:75:36:F7inet addr:192.168.80.150Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fe75:36f7/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:12 errors:0 dropped:0 overruns:0 frame:0TX packets:12 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:720（720.0 b）TX bytes:720（720.0 b）eth2Link encap:EthernetHWaddr00:0C:29:75:36:01inet addr:192.168.80.151Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fe75:3601/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:9 errors:0 dropped:0 overruns:0 frame:0TX packets:10 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:540（540.0 b）TX bytes:636（636.0 b）eth3Link encap:EthernetHWaddr00:0C:29:75:36:0Binet addr:192.168.80.152Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fe75:360b/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:5 errors:0 dropped:0 overruns:0 frame:0TX packets:10 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:300（300.0 b）TX bytes:636（636.0 b）eth4Link encap:EthernetHWaddr00:0C:29:75:36:15inet addr:192.168.80.153Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fe75:3615/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:1 errors:0 dropped:0 overruns:0 frame:0TX packets:9 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:60（60.0 b）TX bytes:566（566.0 b）loLink encap:LocalLoopbackinet addr:127.0.0.1Mask:255.0.0.0inet6 addr:::1/128Scope:HostUP LOOPBACK RUNNINGMTU:16436Metric:1RX packets:0 errors:0 dropped:0 overruns:0 frame:0TX packets:0 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:0（0.0 b）TX bytes:0（0.0 b）（节点2）[root@12crac2 ~]# ifconfigeth0Link encap:EthernetHWaddr00:0C:29:A1:81:7Cinet addr:192.168.1.151Bcast:192.168.1.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fea1:817c/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:126 errors:0 dropped:0 overruns:0 frame:0TX packets:62 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:10466（10.2KiB）TX bytes:6193（6.0KiB）eth1Link encap:EthernetHWaddr00:0C:29:A1:81:86inet addr:192.168.80.154Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fea1:8186/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:23 errors:0 dropped:0 overruns:0 frame:0TX packets:27 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:2081（2.0KiB）TX bytes:1622（1.5KiB）eth2Link encap:EthernetHWaddr00:0C:29:A1:81:90inet addr:192.168.80.155Bcast:192.168.80.255Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fea1:8190/64Scope:LinkUP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:1 errors:0 dropped:0 overruns:0 frame:0TX packets:10 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:60（60.0 b）TX bytes:636（636.0 b）eth3Link encap:EthernetHWaddr00:0C:29:A1:81:9Ainet addr:192.168.80.156Bcast:192.168.80.255Mask:255.255.255.0UP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:0 errors:0 dropped:0 overruns:0 frame:0TX packets:0 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:0（0.0 b）TX bytes:0（0.0 b）eth4Link encap:EthernetHWaddr00:0C:29:A1:81:A4inet addr:192.168.80.157Bcast:192.168.80.255Mask:255.255.255.0UP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:0 errors:0 dropped:0 overruns:0 frame:0TX packets:0 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:0（0.0 b）TX bytes:0（0.0 b）loLink encap:LocalLoopbackinet addr:127.0.0.1Mask:255.0.0.0inet6 addr:::1/128Scope:HostUP LOOPBACK RUNNINGMTU:16436Metric:1RX packets:0 errors:0 dropped:0 overruns:0 frame:0TX packets:0 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:0（0.0 b）TX bytes:0（0.0 b）确认防火墙和SELinux是禁用的（以Node1为例，两个节点相同）[root@12crac1 ~]# iptables -LChain INPUT （policy ACCEPT）target prot opt source destination Chain FORWARD （policy ACCEPT）target prot opt source destination Chain OUTPUT （policy ACCEPT）target prot opt source destination如果防火墙没禁用，那么通过如下方式修改：[root@12crac1 ~]# service iptables stop[root@12crac1 ~]# chkconfig iptables off[root@12crac1 ~]# getenforce Disabled如果SELinux没有被禁止，那就通过如下方式修改：[root@12crac1 ~]# cat /etc/selinux/config --改成SELINUX=disabled# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - No SELinux policy is loaded.SELINUX=disabled# SELINUXTYPE= can take one of these two values:# targeted - Targeted processes are protected,# mls - Multi Level Security protection.SELINUXTYPE=targeted DNS服务器：[root@dns12c ~]# cat /etc/redhat-release RedHatEnterpriseLinuxServer release 5.8（Tikanga）[root@dns12c ~]# uname -aLinux dns12c.luocs.com 2.6.32-300.10.1.el5uek#1 SMP Wed Feb 22 17:37:40 EST 2012 x86_64 x86_64 x86_64 GNU/Linux[root@dns12c ~]# grep MemTotal /proc/meminfoMemTotal:494596 kB[root@dns12c ~]# grep SwapTotal /proc/meminfoSwapTotal:3277252 kB[root@dns12c ~]# ifconfigeth0Link encap:EthernetHWaddr00:0C:29:7A:FD:82inet addr:192.168.1.158Bcast:192.168.1.255Mask:255.255.255.0UP BROADCAST RUNNING MULTICASTMTU:1500Metric:1RX packets:114941 errors:0 dropped:0 overruns:0 frame:0TX packets:6985 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000 RX bytes:11015974（10.5MiB）TX bytes:1151788（1.0MiB）loLink encap:LocalLoopbackinet addr:127.0.0.1Mask:255.0.0.0UP LOOPBACK RUNNINGMTU:16436Metric:1RX packets:104 errors:0 dropped:0 overruns:0 frame:0TX packets:104 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:0 RX bytes:9531（9.3KiB）TX bytes:9531（9.3KiB）Iptables和SELinux也禁止。 SAN服务器：Openfiler 2.3来部署的，在这里分配3个LUN，大小分别为5G和两个8G。 正式部署安装1、配置DNS服务以下操作在DNS服务器上进行：安装bind三个包[root@dns12c ~]# rpm -ivh /mnt/Server/bind-9.3.6-20.P1.el5.x86_64.rpm [root@dns12c ~]# rpm -ivh /mnt/Server/bind-chroot-9.3.6-20.P1.el5.x86_64.rpm [root@dns12c ~]# rpm -ivh /mnt/Server/caching-nameserver-9.3.6-20.P1.el5.x86_64.rpm 配置主区域[root@dns12c ~]# cd /var/named/chroot/etc[root@dns12c etc]# cp -p named.caching-nameserver.conf named.conf[root@dns12c etc]# cat named.conf options {listen-on port 53{ any;};listen-on-v6 port 53{::1;};directory "/var/named";dump-file "/var/named/data/cache_dump.db";statistics-file "/var/named/data/named_stats.txt";memstatistics-file "/var/named/data/named_mem_stats.txt";// Those options should be used carefully because they disable port// randomization// query-sourceport 53;// query-source-v6 port 53;allow-query { any;};allow-query-cache { any;};};logging {channel default_debug {file "data/named.run";severity dynamic;};};view any_resolver {match-clients{ any;};match-destinations { any;};recursion yes;include "/etc/named.zones";}; [root@dns12c etc]# cp -p named.rfc1912.zones named.zones[root@dns12c etc]# cat named.zones zone "luocs.com" IN {type master;file "luocs.com.zone";allow-update { none;};};zone "1.168.192.in-addr.arpa" IN {type master;file "1.168.192.local";allow-update { none;};};[root@dns12c ~]# cd /var/named/chroot/var/named[root@12crac1 named]# cp -p named.zero luocs.com.zone[root@12crac1 named]# cp -p named.local 1.168.192.local[root@12crac1 named]# cat luocs.com.zone $TTL86400@ IN SOAdns.luocs.com.root.luocs.com.（42; serial （d. adams）3H; refresh15M;retry1W; expiry1D）; minimumINNSdns.luocs.com.scanINA 192.168.1.154scanINA 192.168.1.155scanINA 192.168.1.156gns INA 192.168.1.15712crac1 INA 192.168.1.15012crac2 INA 192.168.1.151[root@12crac1 named]# cat 1.168.192.local $TTL86400@ INSOA dns.luocs.com. root.luocs.com.（1997022700;Serial28800;Refresh14400;Retry3600000;Expire86400）;MinimumINNSdns.luocs.com.154 INPTR scan.luocs.com.155 INPTR scan.luocs.com.156 INPTR scan.luocs.com.157 INPTR gns.luocs.com. nslookup或 dig检查给两个节点配置DNS（以Node1为例，两个节点相同）[root@12crac1 ~]# cat /etc/resolv.conf #domain localdomainsearch localdomainnameserver 192.168.1.158 测试：[root@12crac1 ~]# nslookup scan.luocs.comServer:192.168.1.158Address:192.168.1.158#53Name: scan.luocs.comAddress:192.168.1.156Name: scan.luocs.comAddress:192.168.1.154Name: scan.luocs.comAddress:192.168.1.155[root@12crac1 ~]# nslookup 192.168.1.154Server:192.168.1.158Address:192.168.1.158#53154.1.168.192.in-addr.arpaname = scan.luocs.com.[root@12crac1 ~]# nslookup 192.168.1.155Server:192.168.1.158Address:192.168.1.158#53155.1.168.192.in-addr.arpaname = scan.luocs.com.[root@12crac1 ~]# nslookup 192.168.1.156Server:192.168.1.158Address:192.168.1.158#53156.1.168.192.in-addr.arpaname = scan.luocs.com. 2、配置/etc/hosts修改/etc/hosts文件，前两行不懂，添加hostname对应信息。（以Node1为例，两个节点相同）[root@12crac1 ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6# For Public192.168.1.15012crac1.luocs.com 12crac1192.168.1.15112crac2.luocs.com 12crac2# For VIP192.168.1.15212crac1-vip.luocs.com 12crac1-vip.luocs.com192.168.1.15312crac2-vip.luocs.com 12crac2-vip.luocs.com# For Private IP192.168.80.15012crac1-priv1.luocs.com 12crac1-priv1192.168.80.15112crac1-priv2.luocs.com 12crac1-priv2192.168.80.15212crac1-priv3.luocs.com 12crac1-priv3192.168.80.15312crac1-priv4.luocs.com 12crac1-priv4192.168.80.15412crac2-priv1.luocs.com 12crac2-priv1192.168.80.15512crac2-priv2.luocs.com 12crac2-priv2192.168.80.15612crac2-priv3.luocs.com 12crac2-priv3192.168.80.15712crac2-priv4.luocs.com 12crac2-priv4# For SCAN IP# 192.168.1.154 scan.luocs.com# 192.168.1.155 scan.luocs.com# 192.168.1.155 scan.luocs.com# For DNS Server192.168.1.158 dns12c.luocs.comdns12c 3、系统配置修改/etc/sysctl.conf，添加如下内容：fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500 生效：[root@12c ~]# sysctl -p 修改/etc/security/limits.conf，添加如下内容：grid soft nofile 1024grid hard nofile 65536grid soft nproc 2047grid hard nproc 16384grid soft stack 10240grid hard stack 32768oracle soft nofile 1024oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768 4、配置YUM源并安装所需包先将默认的yum配置文件删除或者移动，然后创建一个新的（以Node1为例，两个节点相同）[root@12crac1 ~]# cd /etc/yum.repos.d[root@12crac1 yum.repos.d]# mkdir bk[root@12crac1 yum.repos.d]# mv public-yum-ol6.repo bk/[root@12crac1 yum.repos.d]# vi luocs.repo --添加如下内容[Oracle]name=OEL-$releasever -Mediabaseurl=file:///mntgpgcheck=0enabled=1 将光驱挂载上[root@12crac1 yum.repos.d]# mount /dev/cdrom /mntmount: block device /dev/sr0 is write-protected, mounting read-only 下面就可以Yum方式安装所需包了[root@12crac1 yum.repos.d]# yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static gcc gcc-c++ glibc glibc-common glibc-devel kernel-headers ksh libaio libaio-devel libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat unixODBC unixODBC-devel pdksh compat-libcap1 5、创建用户和组（以Node1为例，两个节点相同）创建组：[root@12crac1 ~]# /usr/sbin/groupadd -g 54321 oinstall[root@12crac1 ~]# /usr/sbin/groupadd -g 54322 dba[root@12crac1 ~]# /usr/sbin/groupadd -g 54323 oper[root@12crac1 ~]# /usr/sbin/groupadd -g 54324 backupdba[root@12crac1 ~]# /usr/sbin/groupadd -g 54325 dgdba[root@12crac1 ~]# /usr/sbin/groupadd -g 54327 asmdba[root@12crac1 ~]# /usr/sbin/groupadd -g 54328 asmoper[root@12crac1 ~]# /usr/sbin/groupadd -g 54329 asmadmin创建用户：[root@12crac1 ~]# /usr/sbin/useradd -u 54321 -g oinstall -G asmadmin,asmdba,asmoper,dba grid[root@12crac1 ~]# /usr/sbin/useradd -u 54322 -g oinstall -G dba,backupdba,dgdba,asmadmin oracle设置口令：[root@12crac1 ~]# passwd grid[root@12crac1 ~]# passwd oracle 6、创建安装目录以及授权（以Node1为例，两个节点相同）[root@12crac1 ~]# mkdir -p /u01/app/grid[root@12crac1 ~]# mkdir -p /u01/app/12.1.0/grid[root@12crac1 ~]# mkdir -p /u01/app/oracle/product/12.1.0/db_1[root@12crac1 ~]# chown -R grid.oinstall /u01[root@12crac1 ~]# chown -R oracle.oinstall /u01/app/oracle[root@12crac1 ~]# chmod -R 775 /u01 7、配置境变量节点1：[root@12crac1 ~]# vi /home/grid/.bash_profile export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=12crac1.luocs.comexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/12.1.0/gridexport ORACLE_SID=+ASM1export PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibalias sqlplus="rlwrap sqlplus"[root@12crac1 ~]# vi /home/oracle/.bash_profile export PATHexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=12crac1.luocs.comexport ORACLE_UNQNAME=luocs12c1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1export ORACLE_SID=luocs12c1export PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibalias sqlplus="rlwrap sqlplus"alias rman="rlwrap rman"节点2：[root@12crac2 ~]# vi /home/grid/.bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=12crac1.luocs.comexport ORACLE_BASE=/u01/app/gridexport ORACLE_HOME=/u01/app/12.1.0/gridexport ORACLE_SID=+ASM1export PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibalias sqlplus="rlwrap sqlplus"[root@12crac2 ~]# vi /home/oracle/.bash_profileexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_HOSTNAME=12crac2.luocs.comexport ORACLE_UNQNAME=luocs12c2export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1export ORACLE_SID=luocs12c2export PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibalias sqlplus="rlwrap sqlplus"alias rman="rlwrap rman" 8、Iscsi挂载磁盘并配置UDEV[root@12cr ~]# yum -y install iscsi-initiator-utils[root@12cr ~]# service iscsid start[root@12cr ~]# chkconfig iscsid on[root@12cr ~]# iscsiadm -m discovery -t sendtargets -p 192.168.80.140:3260[OK] iscsid:[OK]192.168.80.140:3260,1 iqn.2006-01.com.openfiler:tsn.3a9cad78121d[root@12cr ~]# service iscsi restartStopping iscsi:[OK]Starting iscsi:[OK][root@12crac1 ~]# fdisk -lDisk/dev/sda:53.7 GB,53687091200 bytes255 heads,63 sectors/track,6527 cylindersUnits= cylinders of 16065*512=8225280 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00046ecdDeviceBootStartEndBlocksIdSystem/dev/sda1 *12620480083LinuxPartition1 does notend on cylinder boundary./dev/sda226664512000082Linux swap /SolarisPartition2 does notend on cylinder boundary./dev/sda3 66465284710297683LinuxDisk/dev/sdb:2147 MB,2147483648 bytes67 heads,62 sectors/track,1009 cylindersUnits= cylinders of 4154*512=2126848 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000Disk/dev/sdc:10.5 GB,10502537216 bytes64 heads,32 sectors/track,10016 cylindersUnits= cylinders of 2048*512=1048576 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000Disk/dev/sdd:6610 MB,6610223104 bytes204 heads,62 sectors/track,1020 cylindersUnits= cylinders of 12648*512=6475776 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000Disk/dev/sdf:8388 MB,8388608000 bytes64 heads,32 sectors/track,8000 cylindersUnits= cylinders of 2048*512=1048576 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000Disk/dev/sde:8388 MB,8388608000 bytes64 heads,32 sectors/track,8000 cylindersUnits= cylinders of 2048*512=1048576 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000Disk/dev/sdg:5335 MB,5335154688 bytes165 heads,62 sectors/track,1018 cylindersUnits= cylinders of 10230*512=5237760 bytesSector size （logical/physical）:512 bytes /512 bytesI/O size （minimum/optimal）:512 bytes /512 bytesDisk identifier:0x00000000 这里我只用sde、sdf、sdg，其他的是给别的集群使用的。 [root@12crac1 ~]# for i in e f g;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"">doneKERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c450058444273784d2d64705a6a2d544c4756", NAME="asm-diske", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45003030365263642d32714a702d6866744c", NAME="asm-diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45006c58576a76452d716d50492d71436c76", NAME="asm-diskg", OWNER="grid", GROUP="asmadmin", MODE="0660"配置UDEV：（以Node1为例，两个节点相同）[root@12crac1 ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules--添加如下内容：KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45003030365263642d32714a702d6866744c", NAME="asm-data", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4500796861656a6b2d3632475a2d66384631", NAME="asm-fra", OWNER="grid", GROUP="asmadmin", MODE="0660"KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45006c58576a76452d716d50492d71436c76", NAME="asm-crs", OWNER="grid", GROUP="asmadmin", MODE="0660"[root@12crac1 ~]# /sbin/start_udevStarting udev:[OK][root@12crac1 ~]# ls -l /dev/asm*brw-rw----1 grid asmadmin 8,96Jun2921:56/dev/asm-crsbrw-rw----1 grid asmadmin 8,64Jun2921:56/dev/asm-databrw-rw----1 grid asmadmin 8,80Jun2921:56/dev/asm-fra 9、禁用NTP服务（以Node1为例，两个节点相同）[root@12crac1 ~]# chkconfig ntpd off[root@12crac1 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak 10、解压介质节点1：[root@12crac1 ~]# chown -R grid.oinstall /install/[root@12crac1 ~]# chown oracle.oinstall /install/linuxamd64_12c_database_*[root@12crac1 ~]# chmod 775 /install[root@12crac1 ~]# su - grid[root@12crac1 ~]# cd /install/[grid@12crac1 install]$ unzip linuxamd64_12c_grid_1of2.zip [grid@12crac1 install]$ unzip linuxamd64_12c_grid_2of2.zip [root@12crac1 ~]# su - oracle[oracle@12crac1 install]$ unzip linuxamd64_12c_database_1of2.zip 解压之后大小为：[oracle@12crac1 install]$ du -sh grid2.1Ggrid[oracle@12crac1 install]$ du -sh database/2.6Gdatabase/安装cvu相关rpm包：[root@12crac1 ~]# cd /install/grid/rpm/[root@12crac1 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm Preparing...########################################### [100%]Usingdefaultgroup oinstall to install package1:cvuqdisk ########################################### [100%]拷贝到节点2并安装：[root@12crac1 rpm]# scp cvuqdisk-1.0.9-1.rpm 12crac2:/install[root@12crac2 install]# rpm -ivh cvuqdisk-1.0.9-1.rpm Preparing...########################################### [100%]Usingdefaultgroup oinstall to install package1:cvuqdisk ########################################### [100%] 11、校验这里只贴失败的项，其中第一个是物理内存不足问题，Oracle推荐每节点至少4GB内存空间，我这里只有2G；第二个问题是配置DNS，这个问题我们可以忽略。节点1：[grid@12crac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n 12crac1,12crac2-verboseCheck:Total memory NodeNameAvailableRequiredStatus----------------------------------------------------------------------12crac21.9567GB（2051748.0KB）4GB（4194304.0KB） failed12crac11.9567GB（2051748.0KB）4GB（4194304.0KB） failedResult:Total memory check failedResult:Default user file creation mask check passedChecking integrity of file "/etc/resolv.conf" across nodesChecking the file "/etc/resolv.conf" to make sure only one of domain and search entries isdefined"domain"and"search" entries donot coexist in any"/etc/resolv.conf" fileCheckingif domain entry in file "/etc/resolv.conf"is consistent across the nodes..."domain" entry does not exist in any "/etc/resolv.conf" fileCheckingif search entry in file "/etc/resolv.conf"is consistent across the nodes...Checking file "/etc/resolv.conf" to make sure that only one search entry isdefinedMore than one "search" entry does not exist in any "/etc/resolv.conf" fileAll nodes have same "search" order definedin file "/etc/resolv.conf"Checking DNS response time for an unreachable nodeNodeNameStatus------------------------------------------------------------12crac1 failed12crac2 failedPRVF-5636:The DNS response time for an unreachable node exceeded "15000" ms on following nodes:12crac1,12crac2Checkfor integrity of file "/etc/resolv.conf" failed 12、安装1）安装GI[root@12cr ~]# su - grid[grid@12cr ~]$ cd /install/grid/我打开Xmanager-Passive，设置DISPLAY，调用runInstaller启动OUI[grid@12cr grid]$ export DISPLAY=192.168.1.1:0.0[grid@12cr grid]$ ./runInstaller
这里有几项校验不过去，这几个都忽略。 更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2016-04/130003p2.htm

Oracle中的存储过程简单应用在OEL6.4上安装Oracle Database 12c[初体验]相关资讯 Oracle 12c Oracle 12C安装

RedHat Enterprise Linux7.0安装（今 12:59）
Oracle 12C 新特性-扩展数据类型（07月16日）
Oracle Enterprise Manager Cloud （04月10日）

Oracle 12C 新特性-表分区或子分区（07月16日）
Oracle 12c中如何自动启动PDB （04月10日）
在OEL6.4上安装Oracle Database （04月10日）

本文评论查看全部评论（0）