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



The Eucharistic Miracles of the World
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(
        at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(
        at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(
        at oracle.sysman.emcp.EMReposConfig.invoke(
        at oracle.sysman.emcp.EMReposConfig.invoke(
        at oracle.sysman.emcp.EMConfig.perform(
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       localhost.localdomain   localhost

Try it and give me feedback!!!! J


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer