前端时间在红旗DC server 6.0上安装oracle 11gR2时出现了几个错误,经过不断的排查,最终解决了这些错误,现将其整理如下,以供大家参考,如果需补充的请大家补充。
1. 在校验时会碰到如下两个错误:
a)PRVF-5150的错误,此错误可以忽略。
这个是oracle的一个bug,可以不用管,具体见:Device Checks for ASM Fails with PRVF-5150: Path ORCL: is not a valid path [ID 1210863.1]
b)PRVF-5623,PRVF-5636
这种错误可以忽略
2. 在第一个节点上运行root.sh脚本后,报下面的错误:
./root.sh on node1:
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: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
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 daemon to inittab
ACFS-9200: Supported
Invalid kernel variation 'AXS3'.
Operation aborted.
CRS-2672: Attempting to start 'ora.mdnsd' on 'xxxx_db-01'
CRS-2676: Start of 'ora.mdnsd' on 'xxxx_db-01' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'xxxx_db-01'
CRS-2676: Start of 'ora.gpnpd' on 'xxxx_db-01' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'xxxx_db-01'
CRS-2672: Attempting to start 'ora.gipcd' on 'xxxx_db-01'
CRS-2676: Start of 'ora.cssdmonitor' on 'xxxx_db-01' succeeded
CRS-2676: Start of 'ora.gipcd' on 'xxxx_db-01' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'xxxx_db-01'
CRS-2672: Attempting to start 'ora.diskmon' on 'xxxx_db-01'
CRS-2676: Start of 'ora.diskmon' on 'xxxx_db-01' succeeded
CRS-2676: Start of 'ora.cssd' on 'xxxx_db-01' succeeded
ASM created and started successfully.
Disk Group DATA 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 4b0f3c0e9c3c4f89bf3f7280c0a20d07.
Successfully replaced voting disk group with +DATA.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 4b0f3c0e9c3c4f89bf3f7280c0a20d07 (ORCL:DATA01) [DATA]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'xxxx_db-01'
CRS-2676: Start of 'ora.asm' on 'xxxx_db-01' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'xxxx_db-01'
CRS-2676: Start of 'ora.DATA.dg' on 'xxxx_db-01' succeeded
ACFS-9200: Supported
ACFS-9200: Supported
CRS-2672: Attempting to start 'ora.registry.acfs' on 'xxxx_db-01'
CRS-5016: 进程 "/u01/app/11.2.0/grid/bin/acfsregistrymount" (由代理 "/u01/app/11.2.0/grid/bin/orarootagent.bin" 衍生, 用于操作 "start") 失败: 详细信息见 "(:CLSN00010:)" (位于 "/u01/app/11.2.0/grid/log/xxxx_db-01/agent/crsd/orarootagent_root/orarootagent_root.log")
CRS-2674: Start of 'ora.registry.acfs' on 'xxxx_db-01' failed
CRS-4000: Command Start failed, or completed with errors.
FirstNode configuration failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 8373.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
2.1此错误是红旗DC Sserver6.0中的bug,因此需要在运行root.sh前修改/u01/app/11.2.0/grid/lib/osds_acfsroot.pm文件中的一行代码(两个节点都修改),并执行2.2后,再执行root.sh:
具体补丁包:/tmp/osds_acfsroot.pm.diff
内容如下:
--- /u01/app/11.2.0/grid/lib/osds_acfsroot.pm 2011-03-02 13:51:41.000000000 +0800
+++ /u01/app/11.2.0/grid/lib/osds_acfsroot.pm.new 2011-03-02 13:51:25.000000000 +0800
@@ -712,7 +712,7 @@
# case, it's an internal error that should have been caught before we got
# here and so we just bail. We don't want to fail the entire oracle install
# and so return USM_NOT_SUPPORTED so that OUI can complete sans USM.
- if (!(($variation eq 'el5') ||
+ if (!(($variation eq 'el5') || ($variation eq 'AXS3') ||
($variation eq 'el5PAE') || ($variation eq 'el5xen')))
{
lib_error_print(9999, "Invalid kernel variation '$variation'.");
patch -p0 < /tmp/osds_acfsroot.pm.diff
2.2 添加内核目录:
cd $ORACLE_HOME/install/usm/EL5/x86_64/2.6.18-8
cp -a 2.6.18-8.el5-x86_64 2.6.18-8.AXS3-x86_64
3. 当第一个节点运行root.sh文件后,在第二个节点上执行root.sh文件,会报如下错误:
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
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: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
OLR initialization - successful
Adding daemon to inittab
ACFS-9200: Supported
Invalid kernel variation 'AXS3'.
Operation aborted.
CRS-4402: CSS 守护程序已在独占模式下启动, 但在节点 xxxx_db-01 (编号为 1) 上发现活动 CSS 守护程序, 因此正在终止
An active cluster was found during exclusive startup, restarting to join the cluster
Failed to start Oracle Clusterware stack
Failed to start Cluster Synchorinisation Service in clustered mode at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 1016.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
这是oracle 11.2.0.2上的一bug,需要打补丁:p9974223_112020_Linux-x86-64.zip
打补丁的方法如下:
a)两个节点上(root):
b)两个节点上(grid):
/u01/app/11.2.0/grid/OPatch/opatch napply -local -oh /u01/app/11.2.0/grid -id 9974223
c)两个节点上(root):
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
4. 将补丁打完后,在节点2上再次执行root.sh,即可安装完成。
5. 在后续的校验中可能出现scan ip不一致的问题,如:
信息: 正在检查 "dbnode-scan" 的名称解析设置...
信息: ERROR:
信息: PRVF-4664 : 发现与 SCAN 名称 "dbnode-scan" 不一致的名称解析条目
信息: ERROR:
信息: PRVF-4657 : "dbnode-scan" (IP 地址: 192.168.1.129) 的名称解析设置检查失败
信息: ERROR:
信息: PRVF-4664 : 发现与 SCAN 名称 "dbnode-scan" 不一致的名称解析条目
可以忽略。
6. 安装完后,发现数据库的时间是错的,grid,oracle日志的时间也是错的,和正确的时间差了16个小时整。
时区错误的解决办法:
Oracle用户下:srvctl setenv database -d track -t TZ=Asia/Beijing
但是这样只能解决oracle的时区时间,对于grid的时区时间却没有改变过来,
要想彻底解决时区的问题,
需要修改:$GRID_HOME/crs/install/s_crsconfig_
详细见How To Change Timezone for 11gR2 Grid Infrastructure [ID 1209444.1]
因此,建议在安装完grid后,检查一下此文件的内容,如果错误,调整完后,再安装oracle数据库软件,建库就不会出现时区错误。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12129601/viewspace-709864/ ,如需转载,请注明出处,否则将追究法律责任。