LISTENER STATUS not working - 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: LISTENER STATUS not working - 10g

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    LISTENER STATUS not working - 10g

    hi
    oracle 10g
    for Linux: Version 10.1.0.3.0 - Production
    advance server linux 2.1

    when i execute the command lsnrctl status it gives me error message not able to figure out why. although listener is getting started successfully. can u please help me out.

    ip address is 192.168.1.104.

    -----------------------------------------------------------

    [oracle@oracle10g admin]$ lsnrctl status

    LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 16-OCT-2005 23:41:49

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused


    ============================
    [oracle@oracle10g admin]$ lsnrctl start

    LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 16-OCT-2005 23:41:46

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

    Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 10.1.0.3.0 - Production
    System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
    Start Date 16-OCT-2005 23:41:46
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
    Listener Log File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    The listener supports no services
    The command completed successfully

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you are running status before starting it. What else do you expect, it even tells you "no listener"

  3. #3
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    no dave

    i have started the listener already

    it is just i gave the sequence order wrong when i posted this message in forum.

    first i should have put "start" message and then status

    till now no luck

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Are there any details in "/u01/app/oracle/product/10.1.0/db_1/network/log/listener.log" that might shed a little more light?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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