AIX6104安裝Oracle11GR2 RAC問題彙總
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.
[main] [ 2011-12-27 21:53:55.946 CST ] [ClusterAlias.
[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.
[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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- rabbitmq安裝使用問題彙總MQ
- PLSQL安裝與使用問題彙總SQL
- AIX安裝oracle遇到的問題彙總AIOracle
- 安裝PHP常見問題彙總薦PHP
- ambari安裝過程中的問題彙總
- MySQL5.7原始碼安裝問題彙總MySql原始碼
- SQL server 2005安裝問題彙總(4)SQLServer
- SQL server 2005安裝問題彙總(3)SQLServer
- SQL server 2005安裝問題彙總(2)SQLServer
- oracle 11gR2 rac 安裝問題總結Oracle
- RAC環境下安裝部署OWB問題總結
- WCF x509證書安裝問題彙總
- vmware RHEL AS4 RAC安裝出錯問題總結
- ORACLE11GR2 For Linux RAC安裝筆記OracleLinux筆記
- Oracle RAC+DG巡檢常見問題彙總(一)Oracle
- AIX5.3安裝Oracle11gR2 ssh 互信問題AIOracle
- CSS問題彙總CSS
- RecyclerView問題彙總View
- Redis問題彙總Redis
- nginx 問題彙總Nginx
- flutter安裝問題總結Flutter
- Redhat 6 Oracle 11g RAC安裝注意事項彙總RedhatOracle
- Oracle11gR2 RAC在Linux上的安裝OracleLinux
- 安裝rac時需要注意的問題
- Oracle RAC 安裝總結Oracle
- 機器學習面試問題彙總機器學習面試
- 騰訊雲問題彙總
- ORACLE11GR2 RAC解除安裝ASM例項步驟OracleASM
- RAC安裝配置和使用過程的問題解決方法總結一
- RAC安裝配置和使用過程的問題解決方法總結二
- linux7上安裝RAC的問題Linux
- [轉]RAC 安裝配置過程中的問題
- Redis常見問題彙總Redis
- Java 常見問題彙總Java
- ubuntu所遇問題彙總Ubuntu
- openni niviewer問題彙總View
- Bootstrap常見問題彙總boot
- pigossbsm 使用問題彙總Go