系统环境:
操作系统: 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的集群环境了。
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
[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>
|
正常的安装索引目录应该是:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
[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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
1
、通过ftp上传:
[root@aix
211
ContentsXML]#pwd
/u
01
/app/oracle/oraInventory/ContentsXML
[root@aix
211
ContentsXML]#ls
comps.xml inventory.xml libs.xml
[root@aix
211
ContentsXML]#ftp
192.168
.
8.227
Connected to
192.168
.
8.227
.
220
aix
227
FTP server (Version
4.2
Sat Sep
8
09:
49:
58
CDT
2007
) ready.
Name (
192.168
.
8.227:
root): ^C[root@aix
211
ContentsXML]#
[root@aix
211
ContentsXML]#
[root@aix
211
ContentsXML]#su - oracle
[YOU HAVE NEW MAIL]
[u@h W]$bash
[oracle@aix
211
~]$cd /u
01
/app/oracle/oraInventory/
[oracle@aix
211
oraInventory]$ls
Contents logs orainstRoot.sh
ContentsXML oraInst.loc oui
install.platform oraInstaller.properties sessionContext.ser
[oracle@aix
211
oraInventory]$cd ContentsXML/
[oracle@aix
211
ContentsXML]$ls
comps.xml inventory.xml libs.xml
[oracle@aix
211
ContentsXML]$pwd
/u
01
/app/oracle/oraInventory/ContentsXML
[oracle@aix
211
ContentsXML]$ftp
192.168
.
8.227
Connected to
192.168
.
8.227
.
220
aix
227
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@aix
227:
/home/oracle]$ls -l
total
8
-rw-r-----
1
oracle oinstall
666
Nov
17
10:
45
inventory.xml
[oracle@aix
227:
/home/oracle]$cp inventory.xml /u
01
/app/oracle/oraInventory/ContentsXML
[oracle@aix
227:
/home/oracle]$cd /u
01
/app/oracle/oraInventory/ContentsXML
[oracle@aix
227:
/u
01
/app/oracle/oraInventory/ContentsXML]$ls
comps.xml inventory.xml libs.xml
[oracle@aix
227:
/u
01
/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):
《注意更新命令在图形界面下执行》
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
执行更新命令:
[oracle@aix
227:
/u
01
/database/Disk
1
]$/u
01
/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@aix
227:
/u
01
/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@aix
227:
/u
01
/database/Disk
1
]$/u
01
/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@aix
227:
/u
01
/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软件
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
[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
|
@至此,已经能正常识别为集群环境
本文转自 客居天涯 51CTO博客,原文链接:http://blog.51cto.com/tiany/1577353,如需转载请自行联系原作者