【ASM】asmca图形化工具与/etc/oratab

11g的asmca图形化工具启动后可能存在问题, 对于已经启动的ASM实例无法识别, 报是否需要启动asm实例。

asmca的日志位于 ASMCA logs from $ORACLE_BASE/cfgtoollogs/asmca/*

日志显示:

 

[main] [ 2013-09-26 15:53:29.906 GMT+08:00 ] [InventoryUtil.getOUIInvSession:336]  oracleHome is null. Leaving OUI properties to defaults
[Finalizer thread] [ 2013-09-26 15:53:29.912 GMT+08:00 ] [Util.finalize:126]  Util: finalized called for oracle.ops.mgmt.has.Util@32523252
[main] [ 2013-09-26 15:53:29.917 GMT+08:00 ] [InventoryUtil.getOUIInvSession:347]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2013-09-26 15:53:29.917 GMT+08:00 ] [OracleHome.getVersion:957]  Current Version From Inventory: null
[main] [ 2013-09-26 15:53:29.918 GMT+08:00 ] [SQLPlusEngine.getCmmdParams:222]  m_home null
[main] [ 2013-09-26 15:53:29.918 GMT+08:00 ] [SQLPlusEngine.getCmmdParams:223]  version > 112 false
[main] [ 2013-09-26 15:53:29.918 GMT+08:00 ] [SQLEngine.getEnvParams:555]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[main] [ 2013-09-26 15:53:29.918 GMT+08:00 ] [SQLEngine.getEnvParams:565]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[main] [ 2013-09-26 15:53:29.919 GMT+08:00 ] [SQLEngine.initialize:325]  Execing SQLPLUS/SVRMGR process...
[main] [ 2013-09-26 15:53:29.920 GMT+08:00 ] [UsmcaLogger.logException:173]  SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:checkAndStartupInstance
[main] [ 2013-09-26 15:53:29.920 GMT+08:00 ] [UsmcaLogger.logException:174]  There is an error in creating the following process:
null/bin/sqlplus -S /NOLOG 
The error is:
null/bin/sqlplus: not found
[main] [ 2013-09-26 15:53:29.920 GMT+08:00 ] [UsmcaLogger.logException:175]  java.io.IOException: There is an error in creating the following process:
null/bin/sqlplus -S /NOLOG 
The error is:
null/bin/sqlplus: not found

 

 

oracleHome is null 与  null/bin/sqlplus: not found 2点都很可疑,怀疑是ORACLE_HOME/ORACLE_BASE/ORAINVENTORY信息问题, 之后发现/etc/目录下 缺失oraInst.loc和oratab。

 

重建oratab并填入ASM实例名字及ORACLE_HOME后问题解决, 真的是什么细节都不能忽视

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569