1 Reply Latest reply: Apr 27, 2012 4:25 PM by 929689 RSS

    Need help for TNS-00511: Kein Listener

    929689
      Hi everybody,

      by testing the Listener status after installing the Oracle Client for second time I get the following results, can you please give me a feedback if the listener is really working or if I need to correct something regarding the results?. I would really appreciate:

      C:\Dokumente und Einstellungen\db2admin>lsnrctl status

      LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 22:57
      :56

      Copyright (c) 1991, 2005, Oracle. All rights reserved.

      Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      TNS-12541: TNS: Kein Listener
      TNS-12560: TNS: Fehler bei Protokolladapter
      TNS-00511: Kein Listener
      32-bit Windows Error: 2: No such file or directory
      Anmeldung bei (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.10)(PORT=1521)
      ))
      STATUS des LISTENER
      ------------------------
      Alias SIEBELDBTEST
      Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
      ction
      Startdatum 27-APR-2012 22:43:51
      Uptime 0 Tage 0 Std. 14 Min. 4 Sek.
      Trace-Ebene off
      Sicherheit ON: Local OS Authentication
      SNMP OFF
      Parameterdatei des Listener C:\oracle\product\10.2.0\db_5\network\admin\listener
      .ora
      Log-Datei des Listener C:\oracle\product\10.2.0\db_5\network\log\siebeldbtest
      .log
      Zusammenfassung Listening-Endpunkte...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.10)(PORT=1521)))
      Services â–„bersicht...
      Dienst "SiebelDBTestXDB" hat 1 Instance(s).
      Instance "siebeldbtest", Status READY, hat 1 Handler f³r diesen Dienst...
      Dienst "SiebelDBTest_XPT" hat 1 Instance(s).
      Instance "siebeldbtest", Status READY, hat 1 Handler f³r diesen Dienst...
      Dienst "orcl4" hat 1 Instance(s).
      Instance "orcl4", Status READY, hat 1 Handler f³r diesen Dienst...
      Dienst "orcl4XDB" hat 1 Instance(s).
      Instance "orcl4", Status READY, hat 1 Handler f³r diesen Dienst...
      Dienst "orcl4_XPT" hat 1 Instance(s).
      Instance "orcl4", Status READY, hat 1 Handler f³r diesen Dienst...
      Dienst "siebeldbtest" hat 1 Instance(s).
      Instance "siebeldbtest", Status READY, hat 1 Handler f³r diesen Dienst...
      Der Befehl wurde erfolgreich ausgef³hrt.

      There is no listener.ora under the Oracle Client Home but a backup: listener.bak, because everytime I try to put it as listener.ora, the Siebel Listener crashes.
        • 1. Re: Need help for TNS-00511: Kein Listener
          929689
          Furthermore I did:

          C:\Dokumente und Einstellungen\db2admin>lsnrctl start LISTENER

          LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 23:20
          :13

          Copyright (c) 1991, 2005, Oracle. All rights reserved.

          TNS-01106: Listener process with the name SIEBELDBTEST was already started.

          What I did is to delete the OracleOraDb10g_home1TNSListener with the Net Assistant, because it was causing the problem that I couldn't start the SiebelDBTest Listener.

          Should I correct that?