5 Replies Latest reply on Jun 24, 2008 10:14 PM by james.

    ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) Error in EM

    james.
      Hi All,

      When I try to drop and re-create the EM i am getting the TNS: no Listener error.

      The command i issued is : emca -deconfig dbcontrol db -repos drop

      Error:
      ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach). Please help me.


      From where it picks up the connect information "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(H
      OST=e2k.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=E2K.E2K.COM
      ))) "


      Here is the log file

      CONFIG: SQLEngine created successfully and connected
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvA
      rray
      CONFIG: New Env List: [ORACLE_HOME=/u03/app/oracle/product/10.2.0/db_1, ORACLE_S
      ID=E2K, PATH=/u03/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerbero
      s/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin]
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface executeComman
      d
      CONFIG: Starting execution: /u03/app/oracle/product/10.2.0/db_1/sysman/admin/emd
      rep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(H
      OST=e2k.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=E2K.E2K.COM
      ))) -repos_user SYSMAN -action drop -verbose -output_file /u03/ap
      p/oracle/product/10.2.0/db_1/cfgtoollogs/emca/E2K/emca_repos_drop_2008-06-2
      4_12-32-31-PM.log
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface executeComman
      d
      CONFIG: Exit value of 50
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface executeComman
      d
      CONFIG: Enter SYS user's password :
      Enter repository user password :
      Getting temporary tablespace from database...
      Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST
      =e2k.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=E2K.E2K.COM
      ))): ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface executeComman
      d
      CONFIG: stty: standard input: Invalid argument
      stty: standard input: Invalid argument
      stty: standard input: Invalid argument
      stty: standard input: Invalid argument

      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.util.PlatformInterface executeComman
      d
      WARNING: Error executing /u03/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep
      /bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST
      =e2k.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=E2K.E2K.COM
      ))) -repos_user SYSMAN -action drop -verbose -output_file /u03/app/o
      racle/product/10.2.0/db_1/cfgtoollogs/emca/E2K/emca_repos_drop_2008-06-24_1
      2-32-31-PM.log
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error dropping the repository
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at /u03/app/oracle/product/10.2.0/db_1/cfgtoollogs/e
      mca/E2K/emca_repos_drop_<date>.log for more details.
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.EMConfig perform
      SEVERE: Error dropping the repository
      Refer to the log file at /u03/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/E2K/emca_2008-06-24_12-32-11-PM.log for more details.
      Jun 24, 2008 12:32:32 PM oracle.sysman.emcp.EMConfig perform
      CONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:173)
      at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
      at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
      at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.jav
      a:479)
      at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
      istant.java:1123)

      --Thanks