节点2
[root@tpps-ora02 tmp]# /oracle/u01/11.2.0.1/grid/root.sh Performing root user operation for Oracle 11g
The following environment variables are set as: ORACLE_OWNER= grid
ORACLE_HOME= /oracle/u01/11.2.0.1/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...
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/u01/11.2.0.1/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 tpps-ora01, 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
如果报错
导致这个错误的原因是在/etc/hosts中配置了SCAN的地址,尝试ping这个地址信息,如果可以成功,则这个错误可以忽略。
至此,CLUSTER软件以及ASM磁盘配置完成。 OGI安装成功。
检查OGI安装、运行状态: 节点1
[root@tpps-ora01 tmp]# /oracle/u01/11.2.0.1/grid/bin/srvctl status nodeapps VIP tpps-ora01-vip is enabled
VIP tpps-ora01-vip is running on node: tpps-ora01 VIP tpps-ora02-vip is enabled
VIP tpps-ora02-vip is running on node: tpps-ora02 Network is enabled
Network is running on node: tpps-ora01 Network is running on node: tpps-ora02 GSD is disabled
GSD is not running on node: tpps-ora01 GSD is not running on node: tpps-ora02 ONS is enabled
ONS daemon is running on node: tpps-ora01 ONS daemon is running on node: tpps-ora02
[root@tpps-ora01 tmp]# /oracle/u01/11.2.0.1/grid/bin/crs_stat -t
Name Type Target State Host ------------------------------------------------------------
ora.CRSDG.dgora....up.type ONLINE ONLINE tpps-ora01 ora....ER.lsnrora....er.type ONLINE ONLINE tpps-ora01 ora....N1.lsnr ora....er.type ONLINE ONLINE tpps-ora01
ora.asm ora.asm.type ONLINE ONLINE tpps-ora01 ora.cvuora.cvu.type ONLINE ONLINE tpps-ora01 ora.gsdora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE tpps-ora01 ora.oc4j ora.oc4j.type ONLINE ONLINE tpps-ora01 ora.onsora.ons.type ONLINE ONLINE tpps-ora01
ora....SM1.asm application ONLINE ONLINE tpps-ora01 ora....01.lsnr application ONLINE ONLINE tpps-ora01 ora.tpps-ora01.gsd application OFFLINE OFFLINE
ora.tpps-ora01.ons application ONLINE ONLINE tpps-ora01 ora.tpps-ora01.vip ora....t1.type ONLINE ONLINE tpps-ora01 ora....SM2.asm application ONLINE ONLINE tpps-ora02 ora....02.lsnr application ONLINE ONLINE tpps-ora02 ora.tpps-ora02.gsd application OFFLINE OFFLINE
ora.tpps-ora02.ons application ONLINE ONLINE tpps-ora02 ora.tpps-ora02.vip ora....t1.type ONLINE ONLINE tpps-ora02 ora....ry.acfsora....fs.type ONLINE ONLINE tpps-ora01 ora.scan1.vip ora....ip.type ONLINE ONLINE tpps-ora01
节点2,相同
查看当前机器ASM相关进程:
[oracle@tpps-ora01 ~]$ ps -ef|grep ASM
grid 1101 1 0 14:48 ? 00:00:00 asm_pmon_+ASM1 grid 1105 1 0 14:48 ? 00:00:00 asm_psp0_+ASM1 grid 1109 1 0 14:49 ? 00:00:00 asm_vktm_+ASM1 grid 1115 1 0 14:49 ? 00:00:00 asm_gen0_+ASM1 grid 1119 1 0 14:49 ? 00:00:00 asm_diag_+ASM1 grid 1123 1 0 14:49 ? 00:00:00 asm_ping_+ASM1 grid 1127 1 0 14:49 ? 00:00:10 asm_dia0_+ASM1 grid 1131 1 0 14:49 ? 00:00:00 asm_lmon_+ASM1 grid 1135 1 0 14:49 ? 00:00:00 asm_lmd0_+ASM1 grid 1139 1 0 14:49 ? 00:00:00 asm_lms0_+ASM1 grid 1145 1 0 14:49 ? 00:00:00 asm_lmhb_+ASM1 grid 1149 1 0 14:49 ? 00:00:00 asm_mman_+ASM1 grid 1153 1 0 14:49 ? 00:00:00 asm_dbw0_+ASM1 grid 1157 1 0 14:49 ? 00:00:00 asm_lgwr_+ASM1 grid 1161 1 0 14:49 ? 00:00:00 asm_ckpt_+ASM1 grid 1165 1 0 14:49 ? 00:00:00 asm_smon_+ASM1 grid 1169 1 0 14:49 ? 00:00:00 asm_rbal_+ASM1 grid 1173 1 0 14:49 ? 00:00:00 asm_gmon_+ASM1 grid 1177 1 0 14:49 ? 00:00:00 asm_mmon_+ASM1 grid 1181 1 0 14:49 ? 00:00:00 asm_mmnl_+ASM1 grid 1185 1 0 14:49 ? 00:00:00 asm_lck0_+ASM1
grid 1189 1 0 14:49 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 1234 1 0 14:49 ? 00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 1241 1 0 14:49 ? 00:00:00 asm_asmb_+ASM1
grid 1245 1 0 14:49 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 1761 1 0 14:50 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 10936 10884 0 16:27 pts/1 00:00:00 grep ASM
节点2
[oracle@tpps-ora02 ~]$ ps -ef|grep ASM
grid 8465 1 0 14:58 ? 00:00:00 asm_pmon_+ASM2 grid 8469 1 0 14:58 ? 00:00:00 asm_psp0_+ASM2 grid 8473 1 0 14:58 ? 00:00:00 asm_vktm_+ASM2 grid 8479 1 0 14:58 ? 00:00:00 asm_gen0_+ASM2 grid 8483 1 0 14:58 ? 00:00:00 asm_diag_+ASM2 grid 8487 1 0 14:58 ? 00:00:00 asm_ping_+ASM2 grid 8491 1 0 14:58 ? 00:00:05 asm_dia0_+ASM2 grid 8495 1 0 14:58 ? 00:00:00 asm_lmon_+ASM2
grid 8499 1 0 14:58 ? 00:00:00 asm_lmd0_+ASM2 grid 8503 1 0 14:58 ? 00:00:00 asm_lms0_+ASM2 grid 8509 1 0 14:58 ? 00:00:00 asm_lmhb_+ASM2 grid 8513 1 0 14:58 ? 00:00:00 asm_mman_+ASM2 grid 8517 1 0 14:58 ? 00:00:00 asm_dbw0_+ASM2 grid 8521 1 0 14:58 ? 00:00:00 asm_lgwr_+ASM2 grid 8525 1 0 14:58 ? 00:00:00 asm_ckpt_+ASM2 grid 8529 1 0 14:58 ? 00:00:00 asm_smon_+ASM2 grid 8533 1 0 14:58 ? 00:00:00 asm_rbal_+ASM2 grid 8537 1 0 14:58 ? 00:00:00 asm_gmon_+ASM2 grid 8541 1 0 14:58 ? 00:00:00 asm_mmon_+ASM2 grid 8545 1 0 14:58 ? 00:00:00 asm_mmnl_+ASM2 grid 8549 1 0 14:58 ? 00:00:00 asm_lck0_+ASM2
grid 8553 1 0 14:58 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8596 1 0 14:58 ? 00:00:00 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8605 1 0 14:58 ? 00:00:00 asm_asmb_+ASM2
grid 8609 1 0 14:58 ? 00:00:00 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8770 1 0 14:58 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 17147 17098 0 16:33 pts/2 00:00:00 grep ASM
5安装ORACLE 11g DBMS
准备安装介质
[root@tpps-ora01 tmp]# mount -o loop DB_11.2.0.1_LINUX_X86-64.iso /media/
打开软件
[root@tpps-ora01 ~]# export DISPLAY=10.10.0.104:0.0 [root@tpps-ora01 ~]# xhost +
access control disabled, clients can connect from any host [root@tpps-ora01 ~]# xclock
Warning: Missing charsets in String to FontSet conversion [root@tpps-ora01 ~]# su – oracle
启动安装:
[oracle@tpps-ora01 ~]$ /media/runInstaller Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 108957 MB Passed