집 >데이터 베이스 >MySQL 튜토리얼 >Oracle10gRACInstaller故障之--Oracle软件安装无法发现集群
Oracle 10g RAC Installer 故障之--Oracle软件安装无法发现集群 系统环境: 操作系统:AIX 5300-08 集群软件: CRS 10.2.0.1 数据库: Oracle 10.2.0.1 一、故障现象 650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151209/115222I24-
Oracle 10g RAC Installer 故障之--Oracle软件安装无法发现集群
系统环境:
操作系统: AIX 5300-08
集群软件: CRS 10.2.0.1
数据库: Oracle 10.2.0.1
一、故障现象
在安装CRS后,安装Oracle软件时失败,重新安装,删除了/u01/app/oracle下所有的目录,导致Oracle再次安装时不能识别集群环境。
查看Oracle软件安装索引目录:/u01/app/oracle/oraInventory,已经非CRS的集群环境了。
[root@aix227:/u01/app/oracle/oraInventory/ContentsXML]#vi inventory.xml "inventory.xml" 12 lines, 409 characters <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OUIHome1" LOC="/u01/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="1"/> </HOME_LIST> </INVENTORY>
正常的安装索引目录应该是:
[root@aix211 app]#cd oracle/ [root@aix211 oracle]#ls admin oraInventory oradata product [root@aix211 oracle]#cd oraInventory/ [root@aix211 oraInventory]#ls Contents logs orainstRoot.sh ContentsXML oraInst.loc oui install.platform oraInstaller.properties sessionContext.ser [root@aix211 oraInventory]#cd ContentsXML/ [root@aix211 ContentsXML]#ls comps.xml inventory.xml libs.xml [root@aix211 ContentsXML]#more inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OUIHome1" LOC="/u01/crs_1" TYPE="O" IDX="1" CRS="true"> <NODE_LIST> <NODE NAME="aix211"/> <NODE NAME="aix212"/> </NODE_LIST> </HOME> <HOME NAME="OUIHome2" LOC="/u01/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="2"> <NODE_LIST> <NODE NAME="aix211"/> <NODE NAME="aix212"/> </NODE_LIST> </HOME> </HOME_LIST> </INVENTORY>
二、解决方法
在一个安装好CRS软件的主机上(aix211),将aix211主机的 inventory.xml文件上传到aix211主机,替代原来的inventory.xml文件
1、通过ftp上传: [root@aix211 ContentsXML]#pwd /u01/app/oracle/oraInventory/ContentsXML [root@aix211 ContentsXML]#ls comps.xml inventory.xml libs.xml [root@aix211 ContentsXML]#ftp 192.168.8.227 Connected to 192.168.8.227. 220 aix227 FTP server (Version 4.2 Sat Sep 8 09:49:58 CDT 2007) ready. Name (192.168.8.227:root): ^C[root@aix211 ContentsXML]# [root@aix211 ContentsXML]# [root@aix211 ContentsXML]#su - oracle [YOU HAVE NEW MAIL] [u@h W]$bash [oracle@aix211 ~]$cd /u01/app/oracle/oraInventory/ [oracle@aix211 oraInventory]$ls Contents logs orainstRoot.sh ContentsXML oraInst.loc oui install.platform oraInstaller.properties sessionContext.ser [oracle@aix211 oraInventory]$cd ContentsXML/ [oracle@aix211 ContentsXML]$ls comps.xml inventory.xml libs.xml [oracle@aix211 ContentsXML]$pwd /u01/app/oracle/oraInventory/ContentsXML [oracle@aix211 ContentsXML]$ftp 192.168.8.227 Connected to 192.168.8.227. 220 aix227 FTP server (Version 4.2 Sat Sep 8 09:49:58 CDT 2007) ready. Name (192.168.8.227:root): oracle 331 Password required for oracle. Password: 230-Last login: Mon Nov 17 10:36:38 2014 on /dev/pts/2 from 192.168.8.248 230 User oracle logged in. ftp> bin 200 Type set to I. ftp> put inventory.xml 200 PORT command successful. 150 Opening data connection for inventory.xml. 226 Transfer complete. 666 bytes sent in 0.001007 seconds (645.9 Kbytes/s) local: inventory.xml remote: inventory.xml ftp> 覆盖以前的inventory.xml: [oracle@aix227:/home/oracle]$ls -l total 8 -rw-r----- 1 oracle oinstall 666 Nov 17 10:45 inventory.xml [oracle@aix227:/home/oracle]$cp inventory.xml /u01/app/oracle/oraInventory/ContentsXML [oracle@aix227:/home/oracle]$cd /u01/app/oracle/oraInventory/ContentsXML [oracle@aix227:/u01/app/oracle/oraInventory/ContentsXML]$ls comps.xml inventory.xml libs.xml [oracle@aix227:/u01/app/oracle/oraInventory/ContentsXML]$more inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OUIHome1" LOC="/u01/crs_1" TYPE="O" IDX="1" CRS="true"> <NODE_LIST> <NODE NAME="aix211"/> <NODE NAME="aix212"/> </NODE_LIST> </HOME> <HOME NAME="OUIHome2" LOC="/u01/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="2"> <NODE_LIST> <NODE NAME="aix211"/> <NODE NAME="aix212"/> </NODE_LIST> </HOME> </HOME_LIST> </INVENTORY>
更新inventory.xml 中node的信息(将aix211,aix212更新为aix227,aix228):
《注意更新命令在图形界面下执行》
执行更新命令: [oracle@aix227:/u01/database/Disk1]$/u01/crs_1/oui/bin/runInstaller -updateNOdeList CLUSTER_NODES='aix227,aix228' ORACLE_HOME='/u01/crs_1' Starting Oracle Universal Installer... No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed. 'UpdateNodeList' was successful. 更新成功: [oracle@aix227:/u01/app/oracle/oraInventory/ContentsXML]$more inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OUIHome1" LOC="/u01/crs_1" TYPE="O" IDX="1" CRS="true"> <NODE_LIST> <NODE NAME="aix227"/> <NODE NAME="aix228"/> </NODE_LIST> </HOME> <HOME NAME="OUIHome2" LOC="/u01/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="2"> <NODE_LIST> <NODE NAME="aix211"/> <NODE NAME="aix212"/> </NODE_LIST> </HOME> </HOME_LIST> </INVENTORY> [oracle@aix227:/u01/database/Disk1]$/u01/crs_1/oui/bin/runInstaller -updateNOdeList CLUSTER_NODES='aix227,aix228' ORACLE_HOME='/u01/app/oracle/product/10.2.0/db_1' Starting Oracle Universal Installer... No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed. 'UpdateNodeList' was successful. [oracle@aix227:/u01/app/oracle/oraInventory/ContentsXML]$more inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 2005 Oracle Corporation. All rights Reserved --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>10.2.0.1.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OUIHome1" LOC="/u01/crs_1" TYPE="O" IDX="1" CRS="true"> <NODE_LIST> <NODE NAME="aix227"/> <NODE NAME="aix228"/> </NODE_LIST> </HOME> <HOME NAME="OUIHome2" LOC="/u01/app/oracle/product/10.2.0/db_1" TYPE="O" IDX="2"> <NODE_LIST> <NODE NAME="aix227"/> <NODE NAME="aix228"/> </NODE_LIST> </HOME> </HOME_LIST> </INVENTORY>
更新错误信息:
三、重新安装Oracle软件
[oracle@aix227:/u01/database/Disk1/rootpre]$su - root's Password: readline: warning: turning on OPOST for terminal readline: warning: turning on OPOST for terminal [root@aix227:/]#cd /u01/database/Disk1/rootpre/ [root@aix227:/u01/database/Disk1/rootpre]#./rootpre.sh ./rootpre.sh output will be logged in /tmp/rootpre.out_14-11-17.10:58:29 Kernel extension /etc/pw-syscall.64bit_kernel is loaded. Unloading the existing extension: /etc/pw-syscall.64bit_kernel.... Oracle Kernel Extension Loader for AIX Copyright (c) 1998,1999 Oracle Corporation Unconfigured the kernel extension successfully Unloaded the kernel extension successfully Saving the original files in /etc/ora_save_14-11-17.10:58:29.... Copying new kernel extension to /etc.... Loading the kernel extension from /etc Oracle Kernel Extension Loader for AIX Copyright (c) 1998,1999 Oracle Corporation Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x41f8b00 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x41f8b00 The kernel extension was successfuly loaded. Configuring Asynchronous I/O.... Asynchronous I/O is already defined Configuring POSIX Asynchronous I/O.... Posix Asynchronous I/O is already defined Checking if group services should be configured.... Please confirm your Oracle userid is a member of the group: hagsuser Configuring HACMP group services socket for possible use by Oracle. cp: /opt/ORCLcluster/lib/libskgxnr.a: Text file busy cp: /opt/ORCLcluster/lib/libskgxnr.so: Text file busy cp: /opt/ORCLcluster/lib32/libskgxnr.so: Text file busy
@至此,已经能正常识别为集群环境