由于博客中有大量代码,通过页面浏览效果更佳。
静默安装11G RAC(2)-数据库安装
下面是ORACLE数据库安装部分
1,配置目录
mkdir /oraclechown oracle:dba /oraclechmod 777 /oracle
2,配置SSH
包括grid,oracle两个用户的ssh等效性
配置用户密码
echo “oracle” |passwd oracle –stdinecho “oracle” |passwd grid –stdin
配置ssh
cd /soft/test/grid1123/sshsetup./sshUserSetup.sh -user oracle -hosts ‘slient1 slient2’ -advanced -exverify./sshUserSetup.sh -user grid -hosts ‘slient1 slient2’ -advanced -exverify
3,runcluvfy检查
[grid@www.htz.pw slient1 grid1123]$./runcluvfy.sh stage -pre crsinst -n slient1,slient2 -r 11gR2 -verbose Performing pre-checks for cluster services setup Checking node reachability… Check: Node reachability from node “slient1” Destination Node Reachable? ———————————— ———————— slient1 yes slient2 yes Result: Node reachability check passed from node “slient1” Checking user equivalence… Check: User equivalence for user “grid” Node Name Status ———————————— ———————— slient2 passed slient1 passed Result: User equivalence check passed for user “grid” Checking node connectivity… Checking hosts config file… Node Name Status ———————————— ———————— slient2 passed slient1 passed Verification of the hosts config file successful Interface information for node “slient2” Name IP Address Subnet Gateway Def. Gateway HW Address MTU —— ————— ————— ————— ————— —————– —— eth0 192.168.111.14 192.168.111.0 0.0.0.0 192.168.111.2 00:0C:29:6E:5A:D2 1500 eth1 192.168.112.14 192.168.112.0 0.0.0.0 192.168.111.2 00:0C:29:6E:5A:DC 1500 Interface information for node “slient1” Name IP Address Subnet Gateway Def. Gateway HW Address MTU —— ————— ————— ————— ————— —————– —— eth0 192.168.111.13 192.168.111.0 0.0.0.0 192.168.111.2 00:0C:29:33:E6:2E 1500 eth1 192.168.112.13 192.168.112.0 0.0.0.0 192.168.111.2 00:0C:29:33:E6:38 1500 Check: Node connectivity of subnet “192.168.111.0” Source Destination Connected? —————————— —————————— —————- slient2[192.168.111.14] slient1[192.168.111.13] yes Result: Node connectivity passed for subnet “192.168.111.0” with node(s) slient2,slient1 Check: TCP connectivity of subnet “192.168.111.0” Source Destination Connected? —————————— —————————— —————- slient1:192.168.111.13 slient2:192.168.111.14 passed Result: TCP connectivity check passed for subnet “192.168.111.0” Check: Node connectivity of subnet “192.168.112.0” Source Destination Connected? —————————— —————————— —————- slient2[192.168.112.14] slient1[192.168.112.13] yes Result: Node connectivity passed for subnet “192.168.112.0” with node(s) slient2,slient1 Check: TCP connectivity of subnet “192.168.112.0” Source Destination Connected? —————————— —————————— —————- slient1:192.168.112.13 slient2:192.168.112.14 passed Result: TCP connectivity check passed for subnet “192.168.112.0” Interfaces found on subnet “192.168.111.0” that are likely candidates for VIP are: slient2 eth0:192.168.111.14 slient1 eth0:192.168.111.13 Interfaces found on subnet “192.168.112.0” that are likely candidates for a private interconnect are: slient2 eth1:192.168.112.14 slient1 eth1:192.168.112.13 Checking subnet mask consistency… Subnet mask consistency check passed for subnet “192.168.111.0”. Subnet mask consistency check passed for subnet “192.168.112.0”. Subnet mask consistency check passed. Result: Node connectivity check passed Checking multicast communication… Checking subnet “192.168.111.0” for multicast communication with multicast group “230.0.1.0”… Check of subnet “192.168.111.0” for multicast communication with multicast group “230.0.1.0” passed. Checking subnet “192.168.112.0” for multicast communication with multicast group “230.0.1.0”… Check of subnet “192.168.112.0” for multicast communication with multicast group “230.0.1.0” passed. Check of multicast communication passed. Checking ASMLib configuration. Node Name Status ———————————— ———————— slient2 passed slient1 passed Result: Check for ASMLib configuration passed. Check: Total memory Node Name Available Required Status ———— ———————— ———————— ———- slient2 3.8544GB (4041580.0KB) 1.5GB (1572864.0KB) passed slient1 3.8544GB (4041580.0KB) 1.5GB (1572864.0KB) passed Result: Total memory check passed Check: Available memory Node Name Available Required Status ———— ———————— ———————— ———- slient2 3.7868GB (3970724.0KB) 50MB (51200.0KB) passed slient1 3.7076GB (3887660.0KB) 50MB (51200.0KB) passed Result: Available memory check passed Check: Swap space Node Name Available Required Status ———— ———————— ———————— ———- slient2 8GB (8388600.0KB) 3.8544GB (4041580.0KB) passed slient1 8GB (8388600.0KB) 3.8544GB (4041580.0KB) passed Result: Swap space check passed Check: Free disk space for “slient2:/tmp” Path Node Name Mount point Available Required Status —————- ———— ———— ———— ———— ———— /tmp slient2 / 8.6953GB 1GB passed Result: Free disk space check passed for “slient2:/tmp” Check: Free disk space for “slient1:/tmp” Path Node Name Mount point Available Required Status —————- ———— ———— ———— ———— ———— /tmp slient1 / 8.6749GB 1GB passed Result: Free disk space check passed for “slient1:/tmp” Check: User existence for “grid” Node Name Status Comment ———— ———————— ———————— slient2 passed exists(500) slient1 passed exists(500) Checking for multiple users with UID value 500 Result: Check for multiple users with UID value 500 passed Result: User existence check passed for “grid” Check: Group existence for “oinstall” Node Name Status Comment ———— ———————— ———————— slient2 failed does not exist slient1 failed does not exist Result: Group existence check failed for “oinstall” Check: Group existence for “dba” Node Name Status Comment ———— ———————— ———————— slient2 passed exists slient1 passed exists Result: Group existence check passed for “dba” Check: Membership of user “grid” in group “oinstall” [as Primary] Node Name User Exists Group Exists User in Group Primary Status —————- ———— ———— ———— ———— ———— slient2 yes yes no N/A failed slient1 yes yes no N/A failed Result: Membership check for user “grid” in group “oinstall” [as Primary] failed Check: Membership of user “grid” in group “dba” Node Name User Exists Group Exists User in Group Status —————- ———— ———— ———— —————- slient2 yes yes yes passed slient1 yes yes yes passed Result: Membership check for user “grid” in group “dba” passed Check: Run level Node Name run level Required Status ———— ———————— ———————— ———- slient2 5 3,5 passed slient1 5 3,5 passed Result: Run level check passed Check: Hard limits for “maximum open file descriptors” Node Name Type Available Required Status —————- ———— ———— ———— —————- slient2 hard 131072 65536 passed slient1 hard 131072 65536 passed Result: Hard limits check passed for “maximum open file descriptors” Check: Soft limits for “maximum open file descriptors” Node Name Type Available Required Status —————- ———— ———— ———— —————- slient2 soft 1024 1024 passed slient1 soft 1024 1024 passed Result: Soft limits check passed for “maximum open file descriptors” Check: Hard limits for “maximum user processes” Node Name Type Available Required Status —————- ———— ———— ———— —————- slient2 hard 16384 16384 passed slient1 hard 16384 16384 passed Result: Hard limits check passed for “maximum user processes” Check: Soft limits for “maximum user processes” Node Name Type Available Required Status —————- ———— ———— ———— —————- slient2 soft 2047 2047 passed slient1 soft 2047 2047 passed Result: Soft limits check passed for “maximum user processes” Check: System architecture Node Name Available Required Status ———— ———————— ———————— ———- slient2 x86_64 x86_64 passed slient1 x86_64 x86_64 passed Result: System architecture check passed Check: Kernel version Node Name Available Required Status ———— ———————— ———————— ———- slient2 2.6.18-308.el5 2.6.18 passed slient1 2.6.18-308.el5 2.6.18 passed Result: Kernel version check passed Check: Kernel parameter for “semmsl” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 1024 1024 250 passed slient1 1024 1024 250 passed Result: Kernel parameter check passed for “semmsl” Check: Kernel parameter for “semmns” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 64000 64000 32000 passed slient1 64000 64000 32000 passed Result: Kernel parameter check passed for “semmns” Check: Kernel parameter for “semopm” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 1024 1024 100 passed slient1 1024 1024 100 passed Result: Kernel parameter check passed for “semopm” Check: Kernel parameter for “semmni” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 512 512 128 passed slient1 512 512 128 passed Result: Kernel parameter check passed for “semmni” Check: Kernel parameter for “shmmax” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 68719476736 68719476736 2069288960 passed slient1 68719476736 68719476736 2069288960 passed Result: Kernel parameter check passed for “shmmax” Check: Kernel parameter for “shmmni” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 4096 4096 4096 passed slient1 4096 4096 4096 passed Result: Kernel parameter check passed for “shmmni” Check: Kernel parameter for “shmall” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 4294967296 4294967296 2097152 passed slient1 4294967296 4294967296 2097152 passed Result: Kernel parameter check passed for “shmall” Check: Kernel parameter for “file-max” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 6815744 6815744 6815744 passed slient1 6815744 6815744 6815744 passed Result: Kernel parameter check passed for “file-max” Check: Kernel parameter for “ip_local_port_range” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed slient1 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed Result: Kernel parameter check passed for “ip_local_port_range” Check: Kernel parameter for “rmem_default” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 1048576 1048576 262144 passed slient1 1048576 1048576 262144 passed Result: Kernel parameter check passed for “rmem_default” Check: Kernel parameter for “rmem_max” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 4194304 4194304 4194304 passed slient1 4194304 4194304 4194304 passed Result: Kernel parameter check passed for “rmem_max” Check: Kernel parameter for “wmem_default” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 262144 262144 262144 passed slient1 262144 262144 262144 passed Result: Kernel parameter check passed for “wmem_default” Check: Kernel parameter for “wmem_max” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 4194304 4194304 1048576 passed slient1 4194304 4194304 1048576 passed Result: Kernel parameter check passed for “wmem_max” Check: Kernel parameter for “aio-max-nr” Node Name Current Configured Required Status Comment —————- ———— ———— ———— ———— ———— slient2 1048576 1048576 1048576 passed slient1 1048576 1048576 1048576 passed Result: Kernel parameter check passed for “aio-max-nr” Check: Package existence for “make” Node Name Available Required Status ———— ———————— ———————— ———- slient2 make-3.81-3.el5 make-3.81 passed slient1 make-3.81-3.el5 make-3.81 passed Result: Package existence check passed for “make” Check: Package existence for “binutils” Node Name Available Required Status ———— ———————— ———————— ———- slient2 binutils-2.17.50.0.6-20.el5 binutils-2.17.50.0.6 passed slient1 binutils-2.17.50.0.6-20.el5 binutils-2.17.50.0.6 passed Result: Package existence check passed for “binutils” Check: Package existence for “gcc(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 gcc(x86_64)-4.1.2-52.el5 gcc(x86_64)-4.1.2 passed slient1 gcc(x86_64)-4.1.2-52.el5 gcc(x86_64)-4.1.2 passed Result: Package existence check passed for “gcc(x86_64)” Check: Package existence for “libaio(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 libaio(x86_64)-0.3.106-5 libaio(x86_64)-0.3.106 passed slient1 libaio(x86_64)-0.3.106-5 libaio(x86_64)-0.3.106 passed Result: Package existence check passed for “libaio(x86_64)” Check: Package existence for “glibc(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 glibc(x86_64)-2.5-81 glibc(x86_64)-2.5-24 passed slient1 glibc(x86_64)-2.5-81 glibc(x86_64)-2.5-24 passed Result: Package existence check passed for “glibc(x86_64)” Check: Package existence for “compat-libstdc++-33(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 compat-libstdc++-33(x86_64)-3.2.3-61 compat-libstdc++-33(x86_64)-3.2.3 passed slient1 compat-libstdc++-33(x86_64)-3.2.3-61 compat-libstdc++-33(x86_64)-3.2.3 passed Result: Package existence check passed for “compat-libstdc++-33(x86_64)” Check: Package existence for “elfutils-libelf(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 elfutils-libelf(x86_64)-0.137-3.el5 elfutils-libelf(x86_64)-0.125 passed slient1 elfutils-libelf(x86_64)-0.137-3.el5 elfutils-libelf(x86_64)-0.125 passed Result: Package existence check passed for “elfutils-libelf(x86_64)” Check: Package existence for “elfutils-libelf-devel” Node Name Available Required Status ———— ———————— ———————— ———- slient2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed slient1 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed Result: Package existence check passed for “elfutils-libelf-devel” Check: Package existence for “glibc-common” Node Name Available Required Status ———— ———————— ———————— ———- slient2 glibc-common-2.5-81 glibc-common-2.5 passed slient1 glibc-common-2.5-81 glibc-common-2.5 passed Result: Package existence check passed for “glibc-common” Check: Package existence for “glibc-devel(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 glibc-devel(x86_64)-2.5-81 glibc-devel(x86_64)-2.5 passed slient1 glibc-devel(x86_64)-2.5-81 glibc-devel(x86_64)-2.5 passed Result: Package existence check passed for “glibc-devel(x86_64)” Check: Package existence for “glibc-headers” Node Name Available Required Status ———— ———————— ———————— ———- slient2 glibc-headers-2.5-81 glibc-headers-2.5 passed slient1 glibc-headers-2.5-81 glibc-headers-2.5 passed Result: Package existence check passed for “glibc-headers” Check: Package existence for “gcc-c++(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 gcc-c++(x86_64)-4.1.2-52.el5 gcc-c++(x86_64)-4.1.2 passed slient1 gcc-c++(x86_64)-4.1.2-52.el5 gcc-c++(x86_64)-4.1.2 passed Result: Package existence check passed for “gcc-c++(x86_64)” Check: Package existence for “libaio-devel(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 libaio-devel(x86_64)-0.3.106-5 libaio-devel(x86_64)-0.3.106 passed slient1 libaio-devel(x86_64)-0.3.106-5 libaio-devel(x86_64)-0.3.106 passed Result: Package existence check passed for “libaio-devel(x86_64)” Check: Package existence for “libgcc(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 libgcc(x86_64)-4.1.2-52.el5 libgcc(x86_64)-4.1.2 passed slient1 libgcc(x86_64)-4.1.2-52.el5 libgcc(x86_64)-4.1.2 passed Result: Package existence check passed for “libgcc(x86_64)” Check: Package existence for “libstdc++(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 libstdc++(x86_64)-4.1.2-52.el5 libstdc++(x86_64)-4.1.2 passed slient1 libstdc++(x86_64)-4.1.2-52.el5 libstdc++(x86_64)-4.1.2 passed Result: Package existence check passed for “libstdc++(x86_64)” Check: Package existence for “libstdc++-devel(x86_64)” Node Name Available Required Status ———— ———————— ———————— ———- slient2 libstdc++-devel(x86_64)-4.1.2-52.el5 libstdc++-devel(x86_64)-4.1.2 passed slient1 libstdc++-devel(x86_64)-4.1.2-52.el5 libstdc++-devel(x86_64)-4.1.2 passed Result: Package existence check passed for “libstdc++-devel(x86_64)” Check: Package existence for “sysstat” Node Name Available Required Status ———— ———————— ———————— ———- slient2 sysstat-7.0.2-11.el5 sysstat-7.0.2 passed slient1 sysstat-7.0.2-11.el5 sysstat-7.0.2 passed Result: Package existence check passed for “sysstat” Check: Package existence for “ksh” Node Name Available Required Status ———— ———————— ———————— ———- slient2 ksh-20100621-5.el5 ksh-20060214 passed slient1 ksh-20100621-5.el5 ksh-20060214 passed Result: Package existence check passed for “ksh” Checking for multiple users with UID value 0 Result: Check for multiple users with UID value 0 passed Check: Current group ID Result: Current group ID check passed Starting check for consistency of primary group of root user Node Name Status ———————————— ———————— slient2 passed slient1 passed Check for consistency of root user’s primary group passed Starting Clock synchronization checks using Network Time Protocol(NTP)… NTP Configuration file check started… The NTP configuration file “/etc/ntp.conf” is available on all nodes NTP Configuration file check passed No NTP Daemons or Services were found to be running PRVF-5507 : NTP daemon or service is not running on any node but NTP configuration file exists on the following node(s):slient2,slient1 Result: Clock synchronization check using Network Time Protocol(NTP) failed Checking Core file name pattern consistency… Core file name pattern consistency check passed. Checking to make sure user “grid” is not in “root” group Node Name Status Comment ———— ———————— ———————— slient2 passed does not exist slient1 passed does not exist Result: User “grid” is not part of “root” group. Check passed Check default user file creation mask Node Name Available Required Comment ———— ———————— ———————— ———- slient2 0022 0022 passed slient1 0022 0022 passed Result: Default user file creation mask check passed Checking consistency of file “/etc/resolv.conf” across nodes Checking the file “/etc/resolv.conf” to make sure only one of domain and search entries is defined File “/etc/resolv.conf” does not have both domain and search entries defined Checking if domain entry in file “/etc/resolv.conf” is consistent across the nodes… domain entry in file “/etc/resolv.conf” is consistent across nodes Checking if search entry in file “/etc/resolv.conf” is consistent across the nodes… search entry in file “/etc/resolv.conf” is consistent across nodes Checking file “/etc/resolv.conf” to make sure that only one search entry is defined All nodes have one search entry defined in file “/etc/resolv.conf” Checking all nodes to make sure that search entry is “localdomain” as found on node “slient2” All nodes of the cluster have same value for ‘search’ Checking DNS response time for an unreachable node Node Name Status ———————————— ———————— slient2 failed slient1 failed PRVF-5636 : The DNS response time for an unreachable node exceeded “15000” ms on following nodes: slient2,slient1 File “/etc/resolv.conf” is not consistent across nodes Check: Time zone consistency Result: Time zone consistency check passed Pre-check for cluster services setup was unsuccessful on all the nodes.
这里DNS,NTP报错都是正常的,可以不用管
4,安装cvuqdisk
需要在两台主机上面同时安装
[root@www.htz.pw slient1 rpm]#export CVUQDISK_GRP=dba[root@www.htz.pw slient1 rpm]#rpm -ivh cvuqdisk-1.0.9-1.rpmPreparing… ########################################### [100%]1:cvuqdisk ########################################### [100%]
5,安装GRID
grid.rsp下载grid
[grid@www.htz.pw slient1 grid1123]$./runInstaller -silent -ignorePrereq -responseFile /soft/test/grid1123/response/grid.rspStarting Oracle Universal Installer…Checking Temp space: must be greater than 120 MB. Actual 8264 MB PassedChecking swap space: must be greater than 150 MB. Actual 8191 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-23_11-13-01PM. Please wait …[grid@www.htz.pw slient1 grid1123]$[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].ACTION: Provide a password that conforms to the Oracle recommended standards.[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].ACTION: Provide a password that conforms to the Oracle recommended standards.[WARNING] [INS-41808] Possible invalid choice for OSASM Group.CAUSE: The name of the group you selected for the OSASM group is commonly used to grant other system privileges (For example: asmdba, asmoper, dba, oper).ACTION: Oracle recommends that you designate asmadmin as the OSASM group.[WARNING] [INS-41809] Possible invalid choice for OSDBA Group.CAUSE: The group name you selected as the OSDBA for ASM group is commonly used for Oracle Database administrator privileges.ACTION: Oracle recommends that you designate asmdba as the OSDBA for ASM group, and that the group should not be the same group as an Oracle Database OSDBA group.[WARNING] [INS-41810] Possible invalid choice for OSOPER Group.CAUSE: The group name you selected as the OSOPER for ASM group is commonly used for Oracle Database administrator privileges.ACTION: Oracle recommends that you designate asmoper as the OSOPER for ASM group, and that the group should not be the same group as an Oracle Database OSOPER group.[WARNING] [INS-41813] OSDBA for ASM, OSOPER for ASM, and OSASM are the same OS group.CAUSE: The group you selected for granting the OSDBA for ASM group for database access, and the OSOPER for ASM group for startup and shutdown of Oracle ASM, is the same group as the OSASM group, whose members have SYSASM privileges on Oracle ASM.ACTION: Choose different groups as the OSASM, OSDBA for ASM, and OSOPER for ASM groups.You can find the log of this install session at:/oracle/app/oraInventory/logs/installActions2014-09-23_11-13-01PM.logThe installation of Oracle Grid Infrastructure was successful.Please check ‘/oracle/app/oraInventory/logs/silentInstall2014-09-23_11-13-01PM.log’ for more details.As a root user, execute the following script(s):1. /oracle/app/oraInventory/orainstRoot.sh2. /oracle/app/11.2/grid/root.shExecute /oracle/app/oraInventory/orainstRoot.sh on the following nodes:[slient1, slient2]Execute /oracle/app/11.2/grid/root.sh on the following nodes:[slient1, slient2]As install user, execute the following script to complete the configuration.1. /oracle/app/11.2/grid/cfgtoollogs/configToolAllCommandsNote:1. This script must be run on the same system from where installer was run.2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).Successfully Setup Software.[root@localhost ~]# /oracle/app/11.2/grid/root.shCheck /oracle/app/11.2/grid/install/root_slient1_2014-09-23_23-25-25.log for the output of root script[root@localhost ~]#[root@localhost ~]#[root@localhost ~]# cat /oracle/app/11.2/grid/install/root_slient1_2014-09-23_23-25-25.logPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /oracle/app/11.2/gridCreating /etc/oratab file…Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /oracle/app/11.2/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationOLR initialization – successfulroot walletroot wallet certroot cert exportpeer walletprofile reader walletpa walletpeer wallet keyspa wallet keyspeer cert requestpa cert requestpeer certpa certpeer root cert TPprofile reader root cert TPpa root cert TPpeer pa cert TPpa peer cert TPprofile reader pa cert TPprofile reader peer cert TPpeer user certpa user certAdding Clusterware entries to inittabCRS-2672: Attempting to start ‘ora.mdnsd’ on ‘slient1’CRS-2676: Start of ‘ora.mdnsd’ on ‘slient1’ succeededCRS-2672: Attempting to start ‘ora.gpnpd’ on ‘slient1’CRS-2676: Start of ‘ora.gpnpd’ on ‘slient1’ succeededCRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘slient1’CRS-2672: Attempting to start ‘ora.gipcd’ on ‘slient1’CRS-2676: Start of ‘ora.cssdmonitor’ on ‘slient1’ succeededCRS-2676: Start of ‘ora.gipcd’ on ‘slient1’ succeededCRS-2672: Attempting to start ‘ora.cssd’ on ‘slient1’CRS-2672: Attempting to start ‘ora.diskmon’ on ‘slient1’CRS-2676: Start of ‘ora.diskmon’ on ‘slient1’ succeededCRS-2676: Start of ‘ora.cssd’ on ‘slient1’ succeededASM created and started successfully.Disk Group OCR created successfully.clscfg: -install mode specifiedSuccessfully accumulated necessary OCR keys.Creating OCR keys for user ‘root’, privgrp ‘root’..Operation successful.CRS-4256: Updating the profileSuccessful addition of voting disk 56ed84e467d34f85bf3db365ab5f6b06.Successfully replaced voting disk group with +OCR.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced## STATE File Universal Id File Name Disk group— —– —————– ——— ———1. ONLINE 56ed84e467d34f85bf3db365ab5f6b06 (/dev/mapper/ocr) [OCR]Located 1 voting disk(s).CRS-2672: Attempting to start ‘ora.asm’ on ‘slient1’CRS-2676: Start of ‘ora.asm’ on ‘slient1’ succeededCRS-2672: Attempting to start ‘ora.OCR.dg’ on ‘slient1’CRS-2676: Start of ‘ora.OCR.dg’ on ‘slient1’ succeededCRS-2672: Attempting to start ‘ora.registry.acfs’ on ‘slient1’CRS-2676: Start of ‘ora.registry.acfs’ on ‘slient1’ succeededConfigure Oracle Grid Infrastructure for a Cluster … succeeded [root@www.htz.pw slient2 ~]#/oracle/app/11.2/grid/root.shCheck /oracle/app/11.2/grid/install/root_slient2_2014-09-23_23-35-00.log for the output of root script[root@www.htz.pw slient2 ~]#cat /oracle/app/11.2/grid/install/root_slient2_2014-09-23_23-35-00.logPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /oracle/app/11.2/gridCreating /etc/oratab file…Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /oracle/app/11.2/grid/crs/install/crsconfig_paramsCreating trace directoryUser ignored Prerequisites during installationOLR initialization – successfulAdding Clusterware entries to inittabCRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node slient1, number 1, and is terminatingAn active cluster was found during exclusive startup, restarting to join the clusterConfigure Oracle Grid Infrastructure for a Cluster … succeeded[grid@www.htz.pw slient2 ~]$crsctl stat resource -t——————————————————————————–NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————–Local Resources——————————————————————————–ora.OCR.dgONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.asmONLINE ONLINE slient1 Started ONLINE ONLINE slient2 Started ora.gsdOFFLINE OFFLINE slient1 OFFLINE OFFLINE slient2 ora.net1.networkONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.onsONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.registry.acfsONLINE ONLINE slient1 ONLINE ONLINE slient2 ——————————————————————————–Cluster Resources——————————————————————————–ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE slient1 ora.cvu1 ONLINE ONLINE slient1 ora.oc4j1 ONLINE ONLINE slient1 ora.scan1.vip1 ONLINE ONLINE slient1 ora.slient1.vip1 ONLINE ONLINE slient1 ora.slient2.vip1 ONLINE ONLINE slient2[root@localhost ~]# /oracle/app/11.2/grid/cfgtoollogs/configToolAllCommandsSetting the invPtrLoc to /oracle/app/11.2/grid/oraInst.locperform – mode is starting for action: configureperform – mode finished for action: configureYou can see the log file: /oracle/app/11.2/grid/cfgtoollogs/oui/configActions2014-09-23_11-43-49-PM.log [grid@www.htz.pw slient1 grid1123]$vi /oracle/app/11.2/grid/cfgtoollogs/oui/configActions2014-09-23_11-43-49-PM.log ###################################################The action configuration is performing——————————————————The plug-in Update Inventory is running/oracle/app/11.2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true “CLUSTER_NODES={slient1,slient2}” ORACLE_HOME=/oracle/app/11.2/gridThe plug-in Update Inventory has failed its perform method——————————————————The action configuration has failed its perform method################################################### [grid@www.htz.pw slient1 cfgtoollogs]$cat configToolAllCommands# Copyright (c) 1999, 2011, Oracle. All rights reserved./oracle/app/11.2/grid/oui/bin/runConfig.sh ORACLE_HOME=/oracle/app/11.2/grid MODE=perform ACTION=configure RERUN=true $*[grid@www.htz.pw slient1 ContentsXML]$lscomps.xml inventory.xml libs.xml[grid@www.htz.pw slient1 ContentsXML]$cat inventory.xml<?xml version=”1.0″ standalone=”yes” ?><!– Copyright (c) 1999, 2011, Oracle. All rights reserved. –><!– Do not modify the contents of this file by hand. –><INVENTORY><VERSION_INFO><SAVED_WITH>11.2.0.3.0</SAVED_WITH><MINIMUM_VER>2.1.0.6.0</MINIMUM_VER></VERSION_INFO><HOME_LIST><HOME NAME=”Ora11g_gridinfrahome1″ LOC=”/oracle/app/11.2/grid” TYPE=”O” IDX=”1″><NODE_LIST><NODE NAME=”slient1″/><NODE NAME=”slient2″/></NODE_LIST></HOME></HOME_LIST><COMPOSITEHOME_LIST></COMPOSITEHOME_LIST></INVENTORY>[grid@www.htz.pw slient1 ~]$/oracle/app/11.2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true “CLUSTER_NODES={slient1,slient2}” ORACLE_HOME=/oracle/app/11.2/gridStarting Oracle Universal Installer…Checking swap space: must be greater than 500 MB. Actual 8178 MB PassedThe inventory pointer is located at /etc/oraInst.locThe inventory is located at /oracle/app/oraInventory下面看一下在/tmp中生成的trace文件[root@www.htz.pw slient1 OraInstall2014-09-23_11-13-01PM]#ls -lrttotal 4856-rwxrwx— 1 grid dba 619381 Sep 22 2011 products.xml-rwxrwx— 1 grid dba 198 Sep 22 2011 shiphomeinfo.properties-rwxrwx— 1 grid dba 1561 Sep 22 2011 config.xml-rwxrwx— 1 grid dba 2962292 Sep 22 2011 install1.jar-rwxrwx— 1 grid dba 280 Sep 22 2011 shiphomeproperties.xml-rwxrwx— 1 grid dba 3836 Sep 22 2011 OuiConfigVariables.xml-rwxrwx— 1 grid dba 770 Sep 22 2011 fastcopy.xml-rwxrwx— 1 grid dba 18002 Sep 22 2011 oracle.crs.11_2_0_3_0.xml-rwxrwx— 1 grid dba 16424 Sep 22 2011 libs.xml-rwxrwx— 1 grid dba 57 Sep 22 2011 TopLevel_UserAction.properties-rwxrwx— 1 grid dba 198 Sep 22 2011 invDetails.properties-rwxrw-rwx 1 grid dba 3032 Sep 22 2011 oracle.crs_Complete.propertiesdrwxr-x— 2 grid dba 4096 Sep 23 23:13 images-rwxr-x— 1 grid dba 100 Sep 23 23:13 command_output_11571drwxr-x— 6 grid dba 4096 Sep 23 23:13 jdkdrwxr-x— 3 grid dba 4096 Sep 23 23:13 diagnosticsdrwxr-x— 3 grid dba 4096 Sep 23 23:13 srvmdrwxr-x— 8 grid dba 4096 Sep 23 23:13 ouidrwxrwx— 5 grid dba 4096 Sep 23 23:13 ext-rw——- 1 grid dba 0 Sep 23 23:13 oraInstall2014-09-23_11-13-01PM.err-rwxr-x— 1 grid dba 80897 Sep 23 23:13 installActions2014-09-23_11-13-01PM.log-rw——- 1 grid dba 2170 Sep 23 23:13 oraInstall2014-09-23_11-13-01PM.outdrwxr-xr-x 3 grid dba 4096 Sep 23 23:13 UserActionsdrwxr-xr-x 2 grid dba 4096 Sep 23 23:13 globalvariables-rwxr-xr-x 1 grid dba 134254 Sep 23 23:13 oifcfg-rw-r–r– 1 grid dba 250 Sep 23 23:13 tmpScript-rwxr–r– 1 grid dba 250 Sep 23 23:13 mvstubs.shdrwxr-xr-x 2 grid dba 4096 Sep 23 23:13 fastcopy-rw-r–r– 1 grid dba 452988 Sep 23 23:14 oracle.crs_Complete_racfiles.lst-rw-r–r– 1 grid dba 77 Sep 23 23:14 setpermslog.err-rw-r–r– 1 grid dba 1275 Sep 23 23:15 installRemoveFile.lst-rw-r–r– 1 grid dba 0 Sep 23 23:15 installRemoveDirFile.lst-rw-r–r– 1 grid dba 40 Sep 23 23:15 installExcludeFile.lst-rw-r–r– 1 grid dba 2918 Sep 23 23:15 installDirFile.lst-rw-r–r– 1 grid dba 541045 Sep 23 23:15 installCopyFile.ls
下面就是参数的配置信息
[root@www.htz.pw slient1 OraInstall2014-09-23_11-13-01PM]#vi installActions2014-09-23_11-13-01PM.log—————————————————————————————————-PROPERTY VALUE—————————————————————————————————-COMPONENT_LANGUAGES [en]ClusterNodes {“slient1:slient1-vip”,”slient2:slient2-vip”}ClusterwareType ORACLE_CLUSTERWAREFROM_LOCATION /soft/test/grid1123/install/../stage/products.xmlINSTALL_TYPE CompleteINVENTORY_LOCATION /oracle/app/oraInventoryORACLE_BASE /oracle/app/gridORACLE_HOME /oracle/app/11.2/gridORACLE_HOSTNAME slient1SELECTED_LANGUAGES [en]TOPLEVEL_COMPONENT [oracle.crs, 11.2.0.3.0]UNIX_GROUP_NAME dbaoracle.install.component.var.rdbmsInstalling falseoracle.install.crs.interfaceList {“eth0:192.168.111.0:1”,”eth1:192.168.112.0:2″}oracle_install_9iRACPresent falseoracle_install_DBCAProgressOnly -progressOnlyoracle_install_IsGridInstall trueoracle_install_LanguageID AMERICAN_AMERICA.WE8ISO8859P1oracle_install_LaunchNetCA trueoracle_install_NoMigration trueoracle_install_OSASM dbaoracle_install_OSDBA dbaoracle_install_OSOPER dbaoracle_install_RACInstall falseoracle_install_WindowsSystemDirectoryoracle_install_asm_DiskDiscoveryString /dev/mapper/*oracle_install_asm_DiskGroup oracle.install.asm.bean.DiskGroupSettings@63779885oracle_install_asm_DiskGroupAUSize 1oracle_install_asm_DiskGroupName OCRoracle_install_asm_DiskGroupRedundancy EXTERNALoracle_install_asm_Disks {“/dev/mapper/ocr”}oracle_install_asm_MigrateASM falseoracle_install_asm_MonitorPassword *Protected value, not to be logged*oracle_install_asm_SYSASMPassword *Protected value, not to be logged*oracle_install_asm_UseExistingDG falseoracle_install_autoupdates_httpProxyPort 0oracle_install_autoupdates_httpProxySettings oracle.install.ivw.common.bean.HttpProxySettings@3b35b1f3oracle_install_autoupdates_myOracleSupportCredentials oracle.install.ivw.common.bean.MyOracleSupportSettings@126d2380oracle_install_crs_AdvancedInstall trueoracle_install_crs_AutoConfig falseoracle_install_crs_ClusterName slient-clusteroracle_install_crs_ClusterNodeList slient1:slient1-vip,slient2:slient2-viporacle_install_crs_CommaSeparatedNodes slient1,slient2oracle_install_crs_ConfigureGNS falseoracle_install_crs_FinalInterfaceList {“”eth0″/192.168.111.0:public”,””eth1″/192.168.112.0:cluster_interconnect”}oracle_install_crs_InstallOption CRS_CONFIGoracle_install_crs_IsVendorClusterware falseoracle_install_crs_LaunchASMCA trueoracle_install_crs_LaunchCRSInst falseoracle_install_crs_LaunchCRSUpgrd falseoracle_install_crs_LaunchCluvfy trueoracle_install_crs_LaunchRootBat falseoracle_install_crs_LaunchUpdateNodeList trueoracle_install_crs_NodeVips “‘slient1-vip/255.255.255.0/eth0,slient2-vip/255.255.255.0/eth0′”oracle_install_crs_OCRDeviceList NO_VALoracle_install_crs_OCRLocations {}oracle_install_crs_OCRMirrorLocation NO_VALoracle_install_crs_OCRMirrorLocation2 NO_VALoracle_install_crs_OCRPartitionLocation NO_VALoracle_install_crs_OCRRedundancy 2oracle_install_crs_PublicNodeListWithoutDomain {“slient1″,”slient2”}oracle_install_crs_SCANName slient-scanoracle_install_crs_SCANPortNumber 1521oracle_install_crs_SWOnly falseoracle_install_crs_SelectedNodesForUpgrade {“slient1″,”slient2”}oracle_install_crs_StorageOption 1oracle_install_crs_Timezone Asia/Shanghaioracle_install_crs_Upgrade falseoracle_install_crs_UseIPMI falseoracle_install_crs_VDSKLocation NO_VALoracle_install_crs_VDSKMirror1Location1 NO_VALoracle_install_crs_VDSKMirror1Location2 NO_VALoracle_install_crs_VotingDiskList NO_VALoracle_install_crs_VotingDiskLocations {}oracle_install_crs_VotingDiskRedundancy 2oracle_install_crs_asmcaCmd asmcaoracle_install_crs_cluvfyCmd bin/cluvfyoracle_install_crs_configuredCRSHomeoracle_install_crs_configuredCRSHomeShared falseoracle_install_crs_crsDeinstCmdoracle_install_crs_crsInstCmdoracle_install_crs_crsUpgrdCmdoracle_install_crs_emcaCmd bin/emcaoracle_install_crs_installingHomeShared falseoracle_install_crs_ipmiCACmd bin/ndfncecaoracle_install_crs_isConfigWizard falseoracle_install_crs_isRolling trueoracle_install_crs_prereq_Ignored trueoracle_install_crs_updnodelistCfsArgConfiguredHomeoracle_install_crs_updnodelistCfsArgInstallingHomeoracle_install_db_ConfigurationType Software Onlyoracle_install_db_InstallEdition EEoracle_install_db_InstallType EEoracle_install_db_LaunchDBCA falseoracle_install_db_LaunchODMA falseoracle_install_db_SetOracleBase falseoracle_install_db_dbcaCmd bin/dbcaoracle_install_db_dbuaCmd bin/dbuaoracle_install_installerCmd runInstalleroracle_install_netcaCmd bin/netcaoracle_install_netcaDeinstCmd bin/netca_deinst.sh—————————————————————————————————-
6,安装DB
dbinstall.rsp下载dbinstall[oracle@www.htz.pw slient1 database1123]$./runInstaller -silent -ignorePrereq -responseFile /soft1/database1123/response/dbinstall.rsp DECLINE_SECURITY_UPDATES=trueStarting Oracle Universal Installer…Checking Temp space: must be greater than 120 MB. Actual 4877 MB PassedChecking swap space: must be greater than 150 MB. Actual 8191 MB PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2014-09-24_11-13-27PM. Please wait …[oracle@www.htz.pw slient1 database1123]$You can find the log of this install session at:/oracle/app/oraInventory/logs/installActions2014-09-24_11-13-27PM.logThe installation of Oracle Database 11g was successful.Please check ‘/oracle/app/oraInventory/logs/silentInstall2014-09-24_11-13-27PM.log’ for more details.As a root user, execute the following script(s):1. /oracle/app/oracle/product/11.2/db_1/root.shExecute /oracle/app/oracle/product/11.2/db_1/root.sh on the following nodes:[slient1, slient2]
7,创建磁盘组与监听
SQL> create diskgroup data external redundancy disk ‘/dev/mapper/data’;Diskgroup created.
另一个节点
ASMCMD> mount data[grid@www.htz.pw slient1 ~]$srvctl add listener -l listener -o $ORACLE_HOME[grid@www.htz.pw slient1 ~]$srvctl start listener -l listener[grid@www.htz.pw slient1 ~]$crsctl stat resource -t——————————————————————————–NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————–Local Resources——————————————————————————–ora.DATA.dgONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.LISTENER.lsnrONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.OCR.dgONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.asmONLINE ONLINE slient1 Started ONLINE ONLINE slient2 Started ora.gsdOFFLINE OFFLINE slient1 OFFLINE OFFLINE slient2 ora.net1.networkONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.onsONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.registry.acfsONLINE ONLINE slient1 ONLINE ONLINE slient2 ——————————————————————————–Cluster Resources——————————————————————————–ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE slient2 ora.cvu1 ONLINE ONLINE slient2 ora.oc4j1 ONLINE ONLINE slient2 ora.scan1.vip1 ONLINE ONLINE slient2 ora.slient1.vip1 ONLINE ONLINE slient1 ora.slient2.vip1 ONLINE ONLINE slient2
8,创建数据库实例
[oracle@www.htz.pw slient1 ~]$dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName htz -sid htz -sysPassword oracle -systemPassword oracle -sysmanPassword oracle -dbsnmpPassword oracle -emConfiguration NONE -storageType ASM -diskGroupName DATA -datafileDestination DATA -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -nodeinfo slient1,slient2 -characterset ZHS16GBK -obfuscatedPasswords false -sampleSchema false -asmSysPassword oracle -redoLogFileSize 52 -recoveryAreaDestination DATA -initParams processes=1000,PARALLEL_FORCE_LOCAL=false -memoryPercentage 50 -automaticMemoryManagement false -databaseType OLTPCopying database files1% complete3% complete9% complete15% complete21% complete30% completeCreating and starting Oracle instance32% complete36% complete40% complete44% complete45% complete48% complete50% completeCreating cluster database views52% complete70% completeCompleting Database Creation73% complete76% complete85% complete94% complete100% completeLook at the log file “/oracle/app/oracle/cfgtoollogs/dbca/htz/htz0.log” for further details.
查看一下参数,已经修改成功
processes integer 1000parallel_force_local boolean FALSE
------------------作者介绍-----------------------
姓名:黄廷忠
现就职:Oracle中国高级服务团队
曾就职:OceanBase、云和恩墨、东方龙马等