advertisements
_____________________________________________________________________________________________________________________
Error Description:
emca -config dbcontrol db command fails with following error messages.
Jun 23, 2011 8:28:17 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Jun 23, 2011 8:28:17 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1771)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:2682)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:368)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
Fix for this issue:
Set the following environments properly and try once again.
export ORACLE_HOSTNAME=localhost or export ORACLE_HOSTNAME=<actual hostname mentioned in listener.ora>
export ORACLE_SID=<your database SID>
export TNS_ADMIN=$ORACLE_HOME/network/admin
export HOSTNAME= localhost or export HOSTNAME=<actual hostname mentioned in listener.ora>
Also add an entry to the /etc/hosts file with server IP, Host name. Below mentioned is a sample entry
127.0.0.1 localhost.localdomain localhost
Try it and give me feedback!!!! J
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment