AIX6104安装Oracle11GR2 RAC问题汇总
问题1) 磁盘共享参数为设置导致root脚本执行报错... 1
问题2)ORA_NLS10导致安装GRID时ASM实例连接失败报ORA-12705. 4
问题3)NTP配置导致安装database过程中验证安装条件处失败... 10
问题1) 磁盘共享参数为设置导致root脚本执行报错
在第二个节点执行root脚本的时候报错,查看日志:
p7501db1:/oracle/oraInventory/logs$ls
AttachHome2011-12-28_11-41-35AM.log.p7502db2 oraInstall2011-12-28_11-41-35AM.out
UpdateNodeList2011-12-28_12-23-15PM.log oraInstall2011-12-28_11-41-35AM.out.p7502db2
installActions2011-12-28_11-41-35AM.log oraInstall2011-12-28_12-23-15PM.err
oraInstall2011-12-28_11-41-35AM.err oraInstall2011-12-28_12-23-15PM.out
oraInstall2011-12-28_11-41-35AM.err.p7502db2 silentInstall2011-12-28_11-41-35AM.log
p7501db1:/oracle/oraInventory/logs$vi -f install*
p7502db2:/oracle/grid/cfgtoollogs/asmca$ls -alt
total 0
drwxr-x--- 2 grid dba 256 Dec 27 20:24 .
-rw-r----- 1 grid dba 23617 Dec 27 20:24 asmca-1112278PM2415.log
-rw-r----- 1 grid dba 0 Dec 27 20:24 sysError.log
drwxr-x--- 3 grid dba 256 Dec 27 20:24 ..
p7502db2:/oracle/grid/cfgtoollogs/asmca$vi asmca-1112278PM2415.log
[main] [ 2011-12-27 20:24:16.868 CST ] [OracleHome.getVersion:1013] Current version from sqlplus: 11.2.0.1.0
[main] [ 2011-12-27 20:24:16.868 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[main] [ 2011-12-27 20:24:16.869 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[main] [ 2011-12-27 20:24:16.869 CST ] [OracleHome.getVersion:951] using sqlplus: /oracle/11.2/grid/oracle/11.2/bin/sqlplus
[main] [ 2011-12-27 20:24:16.871 CST ] [OracleHome.getVersion:880] OracleHome.getVersion called. Current Version: 11.2.0.1.0
[main] [ 2011-12-27 20:24:16.871 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[main] [ 2011-12-27 20:24:16.871 CST ] [OracleHome.getVersion:951] using sqlplus: /oracle/11.2/grid/oracle/11.2/bin/sqlplus
ORA-15025: could not open disk '/dev/rhdiskpower8'
ORA-27041: unable to open file
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroups(USMDiskGroupManager.java:235)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroups(USMDiskGroupManager.java:120)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroupsLocal(USMDiskGroupManager.java:2041)
oracle.sysman.assistants.usmca.backend.USMInstance.configureLocalASM(USMInstance.java:2789)
oracle.sysman.assistants.usmca.service.UsmcaService.configureLocalASM(UsmcaService.java:1020)
oracle.sysman.assistants.usmca.model.UsmcaModel.performConfigureLocalASM(UsmcaModel.java:680)
oracle.sysman.assistants.usmca.model.UsmcaModel.performOperation(UsmcaModel.java:632)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:156)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:333)
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.backend.USMDiskGroupManager
Method : createDiskGroups
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logInfo:141] Diskgroup creation is not successful.
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : p
erformConfigureLocalASM
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : p
erformOperation
~
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logException:173] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorExceptio
[main] [ 2011-12-27 20:24:40.368 CST ] [UsmcaLogger.logException:171] SEVERE:method oracle.sysman.assistants.usmca.backend.USMDiskG
[main] [ 2011-12-27 20:24:40.129 CST ] [UsmcaLogger.logInfo:141] CREATE DISKGROUP SQL: CREATE DISKGROUP G_OCR EXTERNAL REDUNDANCY
[main] [ 2011-12-27 20:24:39.900 CST ] [SQLEngine.doSQLSubstitution:2392] The substituted sql statement:=select count(*) from v$ASM
[main] [ 2011-12-27 20:24:39.900 CST ] [UsmcaLogger.logEntry:113] Entering oracle.sysman.assistants.usmca.backend.USMDiskGroupManag
ORA-15017: diskgroup "G_OCR" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "G_OCR"
[main] [ 2011-12-27 20:24:39.900 CST ] [UsmcaLogger.logEntry:113] Entering oracle.sysman.assistants.usmca.backend.USMDiskGroupManag
er Method : createDiskGroups
[main] [ 2011-12-27 20:24:39.900 CST ] [SQLEngine.doSQLSubstitution:2392] The substituted sql statement:=select count(*) from v$ASM
_DISKGROUP where name=upper('G_OCR')
[main] [ 2011-12-27 20:24:40.129 CST ] [UsmcaLogger.logInfo:141] CREATE DISKGROUP SQL: CREATE DISKGROUP G_OCR EXTERNAL REDUNDANCY
DISK '/dev/rhdiskpower8' ATTRIBUTE 'compatible.asm'='11.2.0.0.0'
[main] [ 2011-12-27 20:24:40.367 CST ] [SQLEngine.done:2167] Done called
[main] [ 2011-12-27 20:24:40.368 CST ] [UsmcaLogger.logException:171] SEVERE:method oracle.sysman.assistants.usmca.backend.USMDiskG
roupManager:createDiskGroups
[main] [ 2011-12-27 20:24:40.368 CST ] [UsmcaLogger.logException:172] ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rhdiskpower8' matches no disks
ORA-15025: could not open disk '/dev/rhdiskpower8'
ORA-27041: unable to open file
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logException:173] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorExceptio
n: ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rhdiskpower8' matches no disks
ORA-15025: could not open disk '/dev/rhdiskpower8'
ORA-27041: unable to open file
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroups(USMDiskGroupManager.java:235)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroups(USMDiskGroupManager.java:120)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManager.createDiskGroupsLocal(USMDiskGroupManager.java:2041)
oracle.sysman.assistants.usmca.backend.USMInstance.configureLocalASM(USMInstance.java:2789)
oracle.sysman.assistants.usmca.service.UsmcaService.configureLocalASM(UsmcaService.java:1020)
oracle.sysman.assistants.usmca.model.UsmcaModel.performConfigureLocalASM(UsmcaModel.java:680)
oracle.sysman.assistants.usmca.model.UsmcaModel.performOperation(UsmcaModel.java:632)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:156)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:333)
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.backend.USMDiskGroupManager
Method : createDiskGroups
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logInfo:141] Diskgroup creation is not successful.
[main] [ 2011-12-27 20:24:40.369 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : p
erformConfigureLocalASM
解决方法:查看磁盘共享参数
p7501db1:/oracle/oraInventory/logs$lsattr -El hdisk2 |grep res
lun_reset_spt yes FC Forced Open LUN True
reserve_lock yes Reserve Device on open True
修改其为reserve_lock=no,如下,问题解决
p7501db1:/oracle/oraInventory/logs$chdev -l hdiskn -a reserve_lock=no
p7501db1:/oracle/oraInventory/logs$lsattr -El hdisk2 |grep reser
lun_reset_spt yes FC Forced Open LUN True
reserve_lock no Reserve Device on open True
reserve_policy no_reserve参考ORACLE 官方Grid安装文档:(Oracle? Grid Infrastructure Installation Guide 11g Release 2 (11.2) for IBM AIX Based Systems E10814-03)
6. To enable simultaneous access to a disk device from multiple nodes, you must set
the appropriate Object Data Manager (ODM) attribute, depending on the type of
reserve attribute used by your disks. The following section describes how to
perform this task using hdisk logical names. Refer to your operating system
documentation to find logical device names.
To determine the reserve setting your disks use, enter the following command,
where n is the hdisk device number:
# lsattr -E -l hdiskn | grep reserve_
The response is either a reserve_lock setting, or a reserve_policy setting. If
the attribute is reserve_lock, then ensure that the setting is reserve_lock =
no. If the attribute is reserve_policy, then ensure that the setting is reserve_
policy = no_reserve.
If necessary, change the setting with the chdev command using the following
syntax, where n is the hdisk device number:
chdev -l hdiskn -a [ reserve_lock=no | reserve_policy=no_reserve ]
For example, to change a setting for the device hdisk4 from reserve_lock=yes
to reserve_lock=no, enter the following command:
# chdev -l hdisk4 -a reserve_lock=no
To verify that the setting is correct on all disk devices, enter the following
command:
# lsattr -El hdiskn | grep reserve
问题2)ORA_NLS10导致安装GRID时ASM实例连接失败报ORA-12705
执行完root脚本、并配置完netca后开始配置ASM卷组及实例时报错,日志如下:
日志1)
p7501db1:/oracle/oraInventory/logs$vi install*
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: Automatic Storage Management Configuration Assistant failed.
INFO: ConfigClient.executeSelectedToolsInAggregate action performed
INFO: Exiting ConfigClient.executeSelectedToolsInAggregate method
INFO:
The Runconfig command constructed is /oracle/11.2/grid/oracle/11.2/oui/bin/runConfig.sh ORACLE_HOME=/oracle/11.2/grid/oracle/11.2 M
ODE=perform ACTION=configure RERUN=false $*
INFO: Since the option is to overwrite the existing /oracle/11.2/grid/oracle/11.2/cfgtoollogs/configToolFailedCommands file, backing
it up
INFO: The backed up file name is /oracle/11.2/grid/oracle/11.2/cfgtoollogs/configToolFailedCommands.bak.2
INFO: ConfigClient.saveSession method called
INFO: Calling event ConfigSessionEnding
INFO: ConfigClient.endSession method called
INFO: Completed Configuration
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is -2
INFO: Shutdown Oracle Grid Infrastructure
INFO: Unloading Setup Driver
INFO: Read: Unable to connect to local ASM Instance. The following error occured: ORA-12705: Cannot access NLS data files or invalid
INFO: Since the option is to overwrite the existing /oracle/11.2/grid/oracle/11.2/cfgtoollogs/configToolAllCommands file, backing it
The Runconfig command constructed is /oracle/11.2/grid/oracle/11.2/oui/bin/runConfig.sh ORACLE_HOME=/oracle/11.2/grid/oracle/11.2 M
INFO: Since the option is to overwrite the existing /oracle/11.2/grid/oracle/11.2/cfgtoollogs/configToolFailedCommands file, backing
The Runconfig command constructed is /oracle/11.2/grid/oracle/11.2/oui/bin/runConfig.sh ORACLE_HOME=/oracle/11.2/grid/oracle/11.2 M
INFO: Read: Unable to connect to local ASM Instance. The following error occured: ORA-12705: Cannot access NLS data files or invalid
INFO: Since the option is to overwrite the existing /oracle/11.2/grid/oracle/11.2/cfgtoollogs/configToolAllCommands file, backing it
The Runconfig command constructed is /oracle/11.2/grid/oracle/11.2/oui/bin/runConfig.sh ORACLE_HOME=/oracle/11.2/grid/oracle/11.2 M
日志2)
p7501db1:/oracle/grid/cfgtoollogs/asmca$ls -alt
total 0
drwxr-x--- 2 grid dba 4096 Dec 27 21:53 .
-rw-r----- 1 grid dba 101951 Dec 27 21:53 asmca-1112279PM5348.log
-rw-r----- 1 grid dba 0 Dec 27 21:53 sysError.log
-rw-r----- 1 grid dba 101951 Dec 27 21:52 asmca-1112279PM5231.log
-rw-r----- 1 grid dba 101858 Dec 27 21:18 asmca-1112279PM1818.log
drwxr-x--- 4 grid dba 256 Dec 27 21:18 ..
-rw-r----- 1 grid dba 58970 Dec 27 21:11 asmca-1112279PM1023.log
-rw-r----- 1 grid dba 87763 Dec 27 21:06 asmcadc_clean5144140833457066692.log
-rw-r----- 1 grid dba 50878 Dec 27 21:05 asmca-1112279PM0531.log
-rw-r----- 1 grid dba 23081 Dec 27 20:19 asmca-1112278PM1857.log
p7501db1:/oracle/grid/cfgtoollogs/asmca$vi asmca-1112279PM5348.log
Inside constructor of OCR
[main] [ 2011-12-27 21:53:55.945 CST ] [OCR.isCluster:939] Calling OCRNative for isCluster()
[main] [ 2011-12-27 21:53:55.945 CST ] [OCR.isCluster:943] OCR Result status = true
[main] [ 2011-12-27 21:53:55.946 CST ] [OCR.isCluster:955] Bolean result = true
[main] [ 2011-12-27 21:53:55.946 CST ] [Util.:86] Util Instance created.
[main] [ 2011-12-27 21:53:55.946 CST ] [ClusterAlias.:86] ClusterAlias Instance created.
[main] [ 2011-12-27 21:53:55.946 CST ] [HASContext.getCRSHome:507] /oracle/11.2/grid/oracle/11.2
[main] [ 2011-12-27 21:53:55.946 CST ] [Util.getCRSHome:542] getCRSHome: ret=/oracle/11.2/grid/oracle/11.2
[main] [ 2011-12-27 21:53:55.946 CST ] [Version.isPre:304] version to be checked 11.2.0.1.0 major version to check against10
[main] [ 2011-12-27 21:53:55.947 CST ] [Version.isPre:315] isPre.java: Returning FALSE
[main] [ 2011-12-27 21:53:55.947 CST ] [ClusterInfo.:234] m_olsnodesPath=/oracle/11.2/grid/oracle/11.2/bin/olsnodes
[main] [ 2011-12-27 21:53:55.947 CST ] [RuntimeExec.runCommand:75] Calling Runtime.exec() with the command
[main] [ 2011-12-27 21:53:55.947 CST ] [RuntimeExec.runCommand:77] /oracle/11.2/grid/oracle/11.2/bin/crsctl
[main] [ 2011-12-27 21:53:55.947 CST ] [RuntimeExec.runCommand:77] query
[main] [ 2011-12-27 21:53:55.947 CST ] [RuntimeExec.runCommand:77] crs
[main] [ 2011-12-27 21:53:55.947 CST ] [RuntimeExec.runCommand:77] activeversion
[Thread-54] [ 2011-12-27 21:53:55.970 CST ] [StreamReader.run:61] In StreamReader.run
[Thread-53] [ 2011-12-27 21:53:55.970 CST ] [StreamReader.run:61] In StreamReader.run
[main] [ 2011-12-27 21:53:55.970 CST ] [RuntimeExec.runCommand:142] runCommand: Waiting for the process
[Thread-53] [ 2011-12-27 21:53:56.257 CST ] [StreamReader.run:65] OUTPUT>Oracle Clusterware active version on the cluster is [11.2.
0.1.0]
[main] [ 2011-12-27 21:53:56.265 CST ] [RuntimeExec.runCommand:144] runCommand: process returns 0
[main] [ 2011-12-27 21:53:56.266 CST ] [RuntimeExec.runCommand:161] RunTimeExec: output>
[main] [ 2011-12-27 21:53:56.266 CST ] [RuntimeExec.runCommand:164] Oracle Clusterware active version on the cluster is [11.2.0.1.0
]
[main] [ 2011-12-27 21:53:56.266 CST ] [RuntimeExec.runCommand:170] RunTimeExec: error>
[main] [ 2011-12-27 21:53:56.266 CST ] [RuntimeExec.runCommand:192] Returning from RunTimeExec.runCommand
[main] [ 2011-12-27 21:53:56.266 CST ] [ClusterInfo.getCRSActiveVersionString:1446] output[0]=Oracle Clusterware active version on
the cluster is [11.2.0.1.0]
[main] [ 2011-12-27 21:53:56.266 CST ] [ClusterInfo.getCRSActiveVersionString:1459] Active version = 11.2.0.1.0]
[main] [ 2011-12-27 21:53:56.266 CST ] [OracleHome.getVersion:906] OracleHome.CRSActiveVersion: 11.2.0.1.0
[main] [ 2011-12-27 21:53:56.266 CST ] [OracleHome.getVersion:946] Current Version From Inventory: 11.2.0.1.0
[main] [ 2011-12-27 21:53:56.267 CST ] [OracleHome.getVersion:951] using sqlplus: /oracle/11.2/grid/oracle/11.2/bin/sqlplus
[main] [ 2011-12-27 21:53:56.267 CST ] [UsmcaLogger.logInfo:141] Role SYSASM
[main] [ 2011-12-27 21:53:56.267 CST ] [UsmcaLogger.logInfo:141] OS Auth false
[main] [ 2011-12-27 21:53:58.439 CST ] [SQLEngine.done:2167] Done called
[main] [ 2011-12-27 21:53:58.440 CST ] [UsmcaLogger.logInfo:141] Unable to connect to local ASM Instance. The following error occured: ORA-12705: Cannot access NLS data files or invalid environment specified
[main] [ 2011-12-27 21:53:58.440 CST ] [UsmcaLogger.logException:171] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInsta
nceRac:postConfigureASM
[main] [ 2011-12-27 21:53:58.440 CST ] [UsmcaLogger.logException:172] ORA-12705: Cannot access NLS data files or invalid environmen
t specified
[main] [ 2011-12-27 21:53:58.440 CST ] [UsmcaLogger.logException:173] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorExceptio
n: ORA-12705: Cannot access NLS data files or invalid environment specified
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
oracle.sysman.assistants.usmca.backend.USMInstance.connectToASM(USMInstance.java:555)
oracle.sysman.assistants.usmca.backend.USMInstanceRac.postConfigureASM(USMInstanceRac.java:1581)
oracle.sysman.assistants.usmca.service.UsmcaService.postConfigureASM(UsmcaService.java:1055)
oracle.sysman.assistants.usmca.model.UsmcaModelRac.performPostConfigureASM(UsmcaModelRac.java:430)
oracle.sysman.assistants.usmca.model.UsmcaModelRac.performOperation(UsmcaModelRac.java:321)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:156)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:333)
[main] [ 2011-12-27 21:53:58.441 CST ] [UsmcaLogger.logExit:122] Exiting oracle.sysman.assistants.usmca.model.UsmcaModelRac Method
: performOperation
解决方法:查询metalink后解决方法为unset ORA_NLS10,修改后内容
p7501db1:/home/grid$more .profile
umask 022
export ORACLE_BASE=/oracle/grid
export ORACLE_HOME=/oracle/11.2/grid
export ORACLE_SID=+ASM1
export NLS_LANG=AMERICAN_AMERICA.UTF8
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
export PS1=`hostname`:'$PWD'"$"
unset ORA_NLS10
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
if [ -t 0 ]; then
stty intr ^C
fi
参考:"[INS-30502] No ASM Disk Group found" in 11gR2 while creating a database [ID 1107138.1]
修改时间28-MAY-2010 类型PROBLEM 状态PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:Oracle Database Configuration Assistant - Version: 11.2.0.1and later [Release: 11.2 and later ]
Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later]
Information in this document applies to any platform.
SymptomsInstall of Oracle database server 11gR2 brings a pop up that states "[INS-30502] No ASM Disk Group found" when ASM storage is selected.
The Grid Infrastructure installation succeeded and is working (ASM is up and running with all disk groups mounted).
CauseThe installActions log (under $ORACLE_BASE/oraInventory/logs directory) show:
INFO: 'Parsing KFOD-00300: OCI error [-1] [OCI error] [ORA-12705: Cannot access NLS data files or invalid environment specified'
ORA_NLS10 is set.
SolutionUnset ORA_NLS10 OS environment variable (example: $ unset ORA_NLS10) and this time the installer completed the install successfully after it was able to find the ASM disk groups.
References
相关内容
产品
Oracle Database Products > Oracle Database > Oracle Database > Oracle Database Configuration Assistant
Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
ASM; DATABASE CONFIGURATION ASSISTANT; CREATE DATABASE
错误
ORA-12705; INS-30502
http://www.dba-oracle.com/t_ora_12705_resolution.htm
https://forums.oracle.com/forums/thread.jspa?messageID=9806421
http://blog.csdn.net/leishifei/article/details/6341044
http://www.tek-tips.com/viewthread.cfm?qid=1577137
http://space.itpub.net/35489/viewspace-684169 ORA_NLS (ORA_NLS33, ORA_NLS10) Environment Variables explained
问题3)NTP配置导致安装database过程中验证安装条件处失败
查看日志详细报错,显示为NTP配置缺少"-x"选项
p7501db1:/oracle/oraInventory/logs$vi installActions2011-12-28_11-41-35AM.log
INFO: Check passed.
INFO: Checking existence of NETWORK node application (optional)
INFO: Check passed.
INFO: Checking Single Client Access Name (SCAN)...
INFO: Checking name resolution setup for "p750-scan"...
INFO: ERROR:
INFO: PRVF-4664 : Found inconsistent name resolution entries for SCAN name "p750-scan"
INFO: ERROR:
INFO: PRVF-4657 : Name resolution setup check for "p750-scan" (IP address: 192.168.1.254) failed
INFO: ERROR:
INFO: PRVF-4663 : Found configuration issue with the 'hosts' entry in the /etc/nsswitch.conf file
INFO: Verification of SCAN VIP and Listener setup failed
INFO: OCR detected on ASM. Running ACFS Integrity checks...
INFO: Starting check to see if ASM is running on all cluster nodes...
INFO: ASM Running check passed. ASM is running on all cluster nodes
INFO: Starting Disk Groups check to see if at least one Disk Group configured...
INFO: Disk Group Check passed. At least one Disk Group configured
INFO: Task ACFS Integrity check passed
INFO: Checking Oracle Cluster Voting Disk configuration...
INFO: Oracle Cluster Voting Disk configuration check passed
INFO: User "grid" is not part of "root" group. Check passed
INFO: Checking if Clusterware is installed on all nodes...
INFO: Check of Clusterware install passed
INFO: Checking if CTSS Resource is running on all nodes...
INFO: CTSS resource check passed
INFO: Querying CTSS for time offset on all nodes...
INFO: Query of CTSS for time offset passed
INFO: Check CTSS state started...
INFO: CTSS is in Observer state. Switching over to clock synchronization checks using NTP
INFO: Starting Clock synchronization checks using Network Time Protocol(NTP)...
INFO: NTP Configuration file check started...
INFO: NTP Configuration file check passed
INFO: Checking daemon liveness...
INFO: Liveness check passed for "xntpd"
INFO: NTP daemon slewing option check failed on some nodes
INFO: Check failed on nodes:
INFO: p7501db1,p7502db2
INFO: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
INFO: Clock synchronization check using Network Time Protocol(NTP) failed
INFO: PRVF-9652 : Cluster Time Synchronization Services check failed
INFO: Post-check for cluster services setup was unsuccessful on all the nodes.
INFO:
WARNING:
INFO: Completed Plugin named: Oracle Cluster Verification Utility
解决方法:参照metalink [ID 1056693.1] 方法修改/etc/rc.tcpip
1、# ps -ef|grep ntp
root 786614 151686 0 08:02:32 - 0:00 /usr/sbin/xntpd
打开/etc/rc.tcpip文件,找到下面这一行
start /usr/sbin/xntpd "$src_running"
2、将这一行调整成如下内容,然后保存文件
start /usr/sbin/xntpd "$src_running" -a "-x"
3、重启所有节点的时钟服务
#stopsrc –s xntpd
# ps -ef|grep ntp
root 786614 151686 0 08:02:32 - 0:00 /usr/sbin/xntpd –x
参考:
How to Configure NTP or Windows Time to Resolve CLUVFY Error PRVF-5436 PRVF-9652 [ID 1056693.1]s
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=1056693.1
http://www.oracle321.com/article.asp?id=36
问题4)删除ASM卷组方法
p7501db1:/oracle$exit
# su - grid
p7501db1:/home/grid$export ORACLE_SID=+ASM1
p7501db1:/home/grid$sqlplus / as sysdba
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------
spfile string +G_OCR/p750/asmparameterfile/registry.253.771078009
SQL>
$ asmcmd
ASMCMD>dir
ASMCMD> umount G_DATA
p7501db1:/home/grid$export ORACLE_SID=+ASM1
p7501db1:/home/grid$sqlplus / as sysdba
SQL> select name from v$asm_diskgroup;
SQL> drop diskgroup G_DATA;
问题5) 设置归档路径在ASM卷组上
设置归档的方法同10G,可以在创建数据库的时候指定也可以创建数据库修改,
如果归档设为asm存储,那么ASM卷组下的归档目录要先创建好,否则建库的最后会提示一个报错;
如下归档设置于数据库数据存放在同一个ASM卷组下,但是有单独的目录(arch)存放,它需要手工建立
$ asmcmd
ASMCMD>dir
ASMCMD>cd +G_DATA
ASMCMD>mkdir arch
SQL> show parameter arch
NAME TYPE VALUE
------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=+G_DATA/arch
log_archive_dest_10 string
……………….
……………………..
(11G归档路径可设置多大32个)
参考:
http://gaoshan.blog.51cto.com/742525/291171
其他
1)RAC状态正常状态
p7501db1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.G_DATA.dg ora....up.type ONLINE ONLINE p7501db1
ora.G_OCR.dg ora....up.type ONLINE ONLINE p7501db1
ora....ER.lsnr ora....er.type ONLINE ONLINE p7501db1
ora....N1.lsnr ora....er.type ONLINE ONLINE p7501db1
ora.asm ora.asm.type ONLINE ONLINE p7501db1
ora.eons ora.eons.type ONLINE ONLINE p7501db1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE p7501db1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE p7501db1
ora.orcl.db ora....se.type ONLINE ONLINE p7501db1
ora....SM1.asm application ONLINE ONLINE p7501db1
ora....B1.lsnr application ONLINE ONLINE p7501db1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE p7501db1
ora....db1.vip ora....t1.type ONLINE ONLINE p7501db1
ora....SM2.asm application ONLINE ONLINE p7502db2
ora....B2.lsnr application ONLINE ONLINE p7502db2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE p7502db2
ora....db2.vip ora....t1.type ONLINE ONLINE p7502db2
ora.scan1.vip ora....ip.type ONLINE ONLINE p7501db1
p7501db1:/home/grid$
关闭一个节点状态
p7501db1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.G_DATA.dg ora....up.type ONLINE ONLINE p7501db1
ora.G_OCR.dg ora....up.type ONLINE ONLINE p7501db1
ora....ER.lsnr ora....er.type ONLINE ONLINE p7501db1
ora....N1.lsnr ora....er.type ONLINE ONLINE p7501db1
ora.asm ora.asm.type ONLINE ONLINE p7501db1
ora.eons ora.eons.type ONLINE ONLINE p7501db1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE p7501db1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE p7501db1
ora.orcl.db ora....se.type ONLINE ONLINE p7501db1
ora....SM1.asm application ONLINE ONLINE p7501db1
ora....B1.lsnr application ONLINE ONLINE p7501db1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE p7501db1
ora....db1.vip ora....t1.type ONLINE ONLINE p7501db1
ora....SM2.asm application ONLINE OFFLINE
ora....B2.lsnr application ONLINE OFFLINE
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE OFFLINE
ora....db2.vip ora....t1.type ONLINE ONLINE p7501db1
ora.scan1.vip ora....ip.type ONLINE ONLINE p7501db1
2)AIX内存设置方法:http://www.eygle.com/digest/2009/04/minperm_maxperm_lru_file.html
http://www.ibm.com/developerworks/cn/aix/library/au-vmm/#list6
3)解压缩报错 # unzip -q 10_Recommended.zip
note: didn't find end-of-central-dir signature at end of central dir.
(please check that you have transferred or created the zipfile in the
appropriate BINARY mode and that you have compiled UnZip properly)
文件拷贝到闪存的时候已经损坏,导致解压报错;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14710393/viewspace-1083558/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14710393/viewspace-1083558/