AIX6104安裝Oracle11GR2 RAC問題彙總

文章版權所有Jusin Hao（luckyfriends），支援原創，轉載請註明。

AIX6104安裝Oracle11GR2 RAC問題彙總

問題1） 磁碟共享引數為設定導致root指令碼執行報錯... 1

解決方法：... 3

參考ORACLE 官方Grid安裝文件：... 4

問題2）ORA_NLS10導致安裝GRID時ASM例項連線失敗報ORA-12705. 4

解決方法：... 7

參考：... 8

問題3）NTP配置導致安裝database過程中驗證安裝條件處失敗... 10

解決方法：... 11

問題4）刪除ASM卷組方法... 11

問題5) 設定歸檔路徑在ASM卷組上... 12

其他... 12

1）RAC狀態... 12

2）AIX記憶體設定方法：... 14

3）解壓縮報錯... 14

問題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

# startsrc -s xntpd -a "-x"

# 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/，如需轉載，請註明出處，否則將追究法律責任。