Listener error, log included
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Listener error, log included

  1. #1
    Join Date
    Jul 2008
    Posts
    6

    Listener error, log included

    I'm no longer able to log into an oracle database I had set up weeks ago, and I need some help troubleshooting. I'm very new to this, I'd appreciate any help with terminology as well as helping identify a cause or solution.

    I'm unable to log into my database named ORCL through SQL Plus or the Enterprise Manager Console. When I supply a username, password, and host I receive "ORA-12541: TNS:no listener".

    I checked the listener status and receive this:

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL>

    I checked the listener.log file, and think it appears to have failed a few days after my installation. See below log:

    28-JUN-2008 23:55:15 * ping * 0
    28-JUN-2008 23:55:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(P ROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))(VERSION=169869568)) * status * 0
    28-JUN-2008 23:55:22 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=fullcomputername)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2462)) * establish * orcl * 0
    28-JUN-2008 23:55:22 * service_update * orcl * 0
    28-JUN-2008 23:59:22 * service_update * orcl * 0
    28-JUN-2008 23:59:41 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\emagent.exe)(HOST=fullcomput ername)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2496)) * establish * orcl * 12518
    TNS-12518: TNS:listener could not hand off client connection
    TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 2: No such file or directory
    28-JUN-2008 23:59:41 * service_died * orcl * 12547
    TNS-12547: TNS:lost contact
    28-JUN-2008 23:59:56 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\emagent.exe)(HOST=fullcomput ername)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2498)) * establish * orcl * 12505
    TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

    TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-JUN-2008 00:44:42

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

    System parameter file is C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
    Log messages written to C:\oracle\product\10.2.0\db_1\network\log\listener.log
    Trace information written to C:\oracle\product\10.2.0\db_1\network\trace\listener.trc
    Trace level is currently 0

    Started with pid=428
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PARTIAL=yes)(QUEUESIZE=1))
    No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
    TNS-12560: TNS:protocol adapter error
    TNS-00583: Valid node checking: unable to parse configuration parameters


    I'm not too sure what other information is relevant, I'd appreciate any and all help. What can I check and test?

    Regards

  2. #2
    Join Date
    Jul 2008
    Posts
    6

    Providing more information

    Here's some more information regarding:

    'TNS-12505: TNS:listener does not currently know of SID given in connect descriptor'


    My listener.ora file
    # listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = fullcomputername)(PORT = 1521))
    )
    )


    And my tsnames.ora file


    # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = fullcomputername)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    do you have a listener runing?

  4. #4
    Join Date
    Jul 2008
    Posts
    6
    When I try to force start the service, it automatically stops and gives the error.

    "The Listener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

  5. #5
    Join Date
    Oct 2007
    Posts
    16
    dway,

    even i faced the same issue. You just stop the listener, stop the oracle service and then restart the oracle serviceand the listener.

  6. #6
    Join Date
    Jul 2008
    Posts
    6
    Knitty, thanks for your reply.

    I restarted the OracleService and Listener service, and still faced the same errors. When I manually stop all Oracle services and try logging in I still get a no listener error. When I try logging on as SYSTEM, it gives me a protocol adapter error. I find that very strange....

    Any other suggestions?
    Last edited by dway; 07-09-2008 at 06:58 PM.

  7. #7
    Join Date
    Oct 2007
    Posts
    16
    dway,

    how ur connecting to the database? just by username system or system@connect_string??

  8. #8
    Join Date
    Jul 2008
    Posts
    6
    I can log on as SYSTEM, without supplying a host string. Any attempt to authenticate with ORCL gives the listener error.

  9. #9
    Join Date
    Dec 2007
    Posts
    82
    can you attach below command out put from command prompt

    lsnrctl status

  10. #10
    Join Date
    Jul 2008
    Posts
    6
    mvdreddy, I have already done so on my first post. Here it is again for good measure:

    LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JUL-2008 08:03
    :58

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

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> status
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fullcomputername)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
    LSNRCTL>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width