Troubleshoot Fix emca oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

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
CONFIG: ORA-12541: TNS:no listener

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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google