Rumah >pangkalan data >tutorial mysql >Oracle10gRACInstaller故障之--Oracle软件安装无法发现集群

Oracle10gRACInstaller故障之--Oracle软件安装无法发现集群

WBOY
WBOYasal
2016-06-07 14:53:121241semak imbas

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

一、故障现象

wKioL1RpcUHSbh9YAAHA2NM5OeA678.jpg

       在安装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>

更新错误信息:

wKiom1Rpc5LAycV6AAZzpUW6sgA267.jpg


三、重新安装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

wKioL1RpdHXD34HTAAXDi64KwZQ598.jpg

@至此,已经能正常识别为集群环境



Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn