静默安装11G RAC(1)-主机环境配置
下面是ORACLE数据库安装部分
1，配置目录
|
mkdir /oracle chown oracle:dba /oracle chmod 777 /oracle |
2，配置SSH
包括grid,oracle两个用户的ssh等效性
|
配置用户密码 echo “oracle” |passwd oracle –stdin echo “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.rpm Preparing… ########################################### [100%] 1:cvuqdisk ########################################### [100%] |
5，安装GRID
grid.rsp下载grid
|
[grid@www.htz.pw slient1 grid1123]$./runInstaller -silent -ignorePrereq -responseFile /soft/test/grid1123/response/grid.rsp Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 8264 MB Passed Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed Preparing 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.log The 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.sh 2. /oracle/app/11.2/grid/root.sh
Execute /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/configToolAllCommands
Note: 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.sh Check /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.log
Performing root user operation for Oracle 11g
The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2/grid
Creating /etc/oratab file… Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished 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_params Creating trace directory User ignored Prerequisites during installation OLR initialization – successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa cert TP profile reader peer cert TP peer user cert pa user cert Adding Clusterware entries to inittab CRS-2672: Attempting to start ‘ora.mdnsd’ on ‘slient1’ CRS-2676: Start of ‘ora.mdnsd’ on ‘slient1’ succeeded CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘slient1’ CRS-2676: Start of ‘ora.gpnpd’ on ‘slient1’ succeeded CRS-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’ succeeded CRS-2676: Start of ‘ora.gipcd’ on ‘slient1’ succeeded CRS-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’ succeeded CRS-2676: Start of ‘ora.cssd’ on ‘slient1’ succeeded
ASM created and started successfully.
Disk Group OCR created successfully.
clscfg: -install mode specified Successfully accumulated necessary OCR keys. Creating OCR keys for user ‘root’, privgrp ‘root’.. Operation successful. CRS-4256: Updating the profile Successful addition of voting disk 56ed84e467d34f85bf3db365ab5f6b06. Successfully replaced voting disk group with +OCR. CRS-4256: Updating the profile CRS-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’ succeeded CRS-2672: Attempting to start ‘ora.OCR.dg’ on ‘slient1’ CRS-2676: Start of ‘ora.OCR.dg’ on ‘slient1’ succeeded CRS-2672: Attempting to start ‘ora.registry.acfs’ on ‘slient1’ CRS-2676: Start of ‘ora.registry.acfs’ on ‘slient1’ succeeded Configure Oracle Grid Infrastructure for a Cluster … succeeded
[root@www.htz.pw slient2 ~]#/oracle/app/11.2/grid/root.sh Check /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.log
Performing root user operation for Oracle 11g
The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/11.2/grid
Creating /etc/oratab file… Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished 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_params Creating trace directory User ignored Prerequisites during installation OLR initialization – successful Adding Clusterware entries to inittab CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node slient1, number 1, and is terminating An active cluster was found during exclusive startup, restarting to join the cluster Configure 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.dg ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.asm ONLINE ONLINE slient1 Started ONLINE ONLINE slient2 Started ora.gsd OFFLINE OFFLINE slient1 OFFLINE OFFLINE slient2 ora.net1.network ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.ons ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.registry.acfs ONLINE ONLINE slient1 ONLINE ONLINE slient2 ——————————————————————————– Cluster Resources ——————————————————————————– ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE slient1 ora.cvu 1 ONLINE ONLINE slient1 ora.oc4j 1 ONLINE ONLINE slient1 ora.scan1.vip 1 ONLINE ONLINE slient1 ora.slient1.vip 1 ONLINE ONLINE slient1 ora.slient2.vip 1 ONLINE ONLINE slient2
[root@localhost ~]# /oracle/app/11.2/grid/cfgtoollogs/configToolAllCommands Setting the invPtrLoc to /oracle/app/11.2/grid/oraInst.loc
perform – mode is starting for action: configure
perform – mode finished for action: configure
You 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/grid
The 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]$ls comps.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/grid Starting Oracle Universal Installer…
Checking swap space: must be greater than 500 MB. Actual 8178 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /oracle/app/oraInventory |
下面看一下在/tmp中生成的trace文件
|
[root@www.htz.pw slient1 OraInstall2014-09-23_11-13-01PM]#ls -lrt total 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.properties drwxr-x— 2 grid dba 4096 Sep 23 23:13 images -rwxr-x— 1 grid dba 100 Sep 23 23:13 command_output_11571 drwxr-x— 6 grid dba 4096 Sep 23 23:13 jdk drwxr-x— 3 grid dba 4096 Sep 23 23:13 diagnostics drwxr-x— 3 grid dba 4096 Sep 23 23:13 srvm drwxr-x— 8 grid dba 4096 Sep 23 23:13 oui drwxrwx— 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.out drwxr-xr-x 3 grid dba 4096 Sep 23 23:13 UserActions drwxr-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.sh drwxr-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-vi p”} ClusterwareType ORACLE_CLUSTERWARE FROM_LOCATION /soft/test/grid1123/install/../stage/produ cts.xml INSTALL_TYPE Complete INVENTORY_LOCATION /oracle/app/oraInventory ORACLE_BASE /oracle/app/grid ORACLE_HOME /oracle/app/11.2/grid ORACLE_HOSTNAME slient1 SELECTED_LANGUAGES [en] TOPLEVEL_COMPONENT [oracle.crs, 11.2.0.3.0] UNIX_GROUP_NAME dba oracle.install.component.var.rdbmsInstalling false oracle.install.crs.interfaceList {“eth0:192.168.111.0:1”,”eth1:192.168.112. 0:2″} oracle_install_9iRACPresent false oracle_install_DBCAProgressOnly -progressOnly oracle_install_IsGridInstall true oracle_install_LanguageID AMERICAN_AMERICA.WE8ISO8859P1 oracle_install_LaunchNetCA true oracle_install_NoMigration true oracle_install_OSASM dba oracle_install_OSDBA dba oracle_install_OSOPER dba oracle_install_RACInstall false oracle_install_WindowsSystemDirectory oracle_install_asm_DiskDiscoveryString /dev/mapper/* oracle_install_asm_DiskGroup oracle.install.asm.bean.DiskGroupSettings@ 63779885 oracle_install_asm_DiskGroupAUSize 1 oracle_install_asm_DiskGroupName OCR oracle_install_asm_DiskGroupRedundancy EXTERNAL oracle_install_asm_Disks {“/dev/mapper/ocr”} oracle_install_asm_MigrateASM false oracle_install_asm_MonitorPassword *Protected value, not to be logged* oracle_install_asm_SYSASMPassword *Protected value, not to be logged* oracle_install_asm_UseExistingDG false oracle_install_autoupdates_httpProxyPort 0 oracle_install_autoupdates_httpProxySettings oracle.install.ivw.common.bean.HttpProxySe ttings@3b35b1f3 oracle_install_autoupdates_myOracleSupportCredentials oracle.install.ivw.common.bean.MyOracleSup portSettings@126d2380 oracle_install_crs_AdvancedInstall true oracle_install_crs_AutoConfig false oracle_install_crs_ClusterName slient-cluster oracle_install_crs_ClusterNodeList slient1:slient1-vip,slient2:slient2-vip oracle_install_crs_CommaSeparatedNodes slient1,slient2 oracle_install_crs_ConfigureGNS false oracle_install_crs_FinalInterfaceList {“”eth0″/192.168.111.0:public”,””eth1″/192 .168.112.0:cluster_interconnect”} oracle_install_crs_InstallOption CRS_CONFIG oracle_install_crs_IsVendorClusterware false oracle_install_crs_LaunchASMCA true oracle_install_crs_LaunchCRSInst false oracle_install_crs_LaunchCRSUpgrd false oracle_install_crs_LaunchCluvfy true oracle_install_crs_LaunchRootBat false oracle_install_crs_LaunchUpdateNodeList true oracle_install_crs_NodeVips “‘slient1-vip/255.255.255.0/eth0,slient2-v ip/255.255.255.0/eth0′” oracle_install_crs_OCRDeviceList NO_VAL oracle_install_crs_OCRLocations {} oracle_install_crs_OCRMirrorLocation NO_VAL oracle_install_crs_OCRMirrorLocation2 NO_VAL oracle_install_crs_OCRPartitionLocation NO_VAL oracle_install_crs_OCRRedundancy 2 oracle_install_crs_PublicNodeListWithoutDomain {“slient1″,”slient2”} oracle_install_crs_SCANName slient-scan oracle_install_crs_SCANPortNumber 1521 oracle_install_crs_SWOnly false oracle_install_crs_SelectedNodesForUpgrade {“slient1″,”slient2”} oracle_install_crs_StorageOption 1 oracle_install_crs_Timezone Asia/Shanghai oracle_install_crs_Upgrade false oracle_install_crs_UseIPMI false oracle_install_crs_VDSKLocation NO_VAL oracle_install_crs_VDSKMirror1Location1 NO_VAL oracle_install_crs_VDSKMirror1Location2 NO_VAL oracle_install_crs_VotingDiskList NO_VAL oracle_install_crs_VotingDiskLocations {} oracle_install_crs_VotingDiskRedundancy 2 oracle_install_crs_asmcaCmd asmca oracle_install_crs_cluvfyCmd bin/cluvfy oracle_install_crs_configuredCRSHome oracle_install_crs_configuredCRSHomeShared false oracle_install_crs_crsDeinstCmd oracle_install_crs_crsInstCmd oracle_install_crs_crsUpgrdCmd oracle_install_crs_emcaCmd bin/emca oracle_install_crs_installingHomeShared false oracle_install_crs_ipmiCACmd bin/ndfnceca oracle_install_crs_isConfigWizard false oracle_install_crs_isRolling true oracle_install_crs_prereq_Ignored true oracle_install_crs_updnodelistCfsArgConfiguredHome oracle_install_crs_updnodelistCfsArgInstallingHome oracle_install_db_ConfigurationType Software Only oracle_install_db_InstallEdition EE oracle_install_db_InstallType EE oracle_install_db_LaunchDBCA false oracle_install_db_LaunchODMA false oracle_install_db_SetOracleBase false oracle_install_db_dbcaCmd bin/dbca oracle_install_db_dbuaCmd bin/dbua oracle_install_installerCmd runInstaller oracle_install_netcaCmd bin/netca oracle_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=true Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 4877 MB Passed Checking swap space: must be greater than 150 MB. Actual 8191 MB Passed Preparing 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.log The 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.sh
Execute /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.dg ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.LISTENER.lsnr ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.OCR.dg ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.asm ONLINE ONLINE slient1 Started ONLINE ONLINE slient2 Started ora.gsd OFFLINE OFFLINE slient1 OFFLINE OFFLINE slient2 ora.net1.network ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.ons ONLINE ONLINE slient1 ONLINE ONLINE slient2 ora.registry.acfs ONLINE ONLINE slient1 ONLINE ONLINE slient2 ——————————————————————————– Cluster Resources ——————————————————————————– ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE slient2 ora.cvu 1 ONLINE ONLINE slient2 ora.oc4j 1 ONLINE ONLINE slient2 ora.scan1.vip 1 ONLINE ONLINE slient2 ora.slient1.vip 1 ONLINE ONLINE slient1 ora.slient2.vip 1 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 OLTP Copying database files 1% complete 3% complete 9% complete 15% complete 21% complete 30% complete Creating and starting Oracle instance 32% complete 36% complete 40% complete 44% complete 45% complete 48% complete 50% complete Creating cluster database views 52% complete 70% complete Completing Database Creation 73% complete 76% complete 85% complete 94% complete 100% complete Look at the log file “/oracle/app/oracle/cfgtoollogs/dbca/htz/htz0.log” for further details.
查看一下参数，已经修改成功
processes integer 1000 parallel_force_local boolean FALSE |
静默安装11G RAC(2)-数据库安装：等您坐沙发呢！