DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: lsnrctl stop , status , log_status throws error

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

    lsnrctl stop , status , log_status throws error

    hi

    Using 10g on advance server linux 2.1
    10.1

    Ip address is issued by DHCP SERVER.

    LISTENER is up and running BUT I AM getting these errors while i am executing.

    LSNRCTL> STOP
    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
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

    LSNRCTL > STATUS
    LSNRCTL> STATUS
    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
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

    ENTRY IN TNSNAMES.ORA
    ====================================

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

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

    ENTRY IN LISTENER.ORA FILE
    ========================================
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = orcl)
    (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.35)(PORT = 1521))
    )
    )
    )

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    try lsnrctl start then.

    by the way, DHCP belongs nowhere near a database (or any other) server

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    Set tnsadmin before opening lsnrctl and try.

    Or go to the oracle home bin and then start lsnrctl.

    Regards

  4. #4
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    I am able to start the server no issues in that.

    my question is
    when the listener is started and when i want to see the status it throws error.
    [oracle@oracle10g bin]$ pwd
    /u01/app/oracle/product/10.1.0/db_1/bin

    [oracle@oracle10g bin]$ lsnrctl status

    LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 31-MAY-2005 14:18:59

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

    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
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused


    why so.

    I am at bin directory too.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    humour us, what does lsnrctl start do when you type it (post the output) also is that ip address correct

  6. #6
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    LISTNER STARTED


    [oracle@oracle10g admin]$ pwd
    /u01/app/oracle/product/10.1.0/db_1/network/admin
    [oracle@oracle10g admin]$ lsnrctl start

    LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 31-MAY-2005 15:22:20

    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=ipc)(KEY=EXTPROC)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1522)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
    Start Date 31-MAY-2005 15:22:20
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    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=ipc)(KEY=EXTPROC)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1522)))
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    where there is HOST word mentioned i gace both IP address ie ( 192.168.1.135) and also hostname ie oracle10g.pdcindscape.com
    but no luck

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    that listener is running on port 1522, the stuff before was looking on port 1521.

    So whats the deal here?

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

    yes i tired all things here

    i tried port 1521 didnt work on - lsnrctl status & stop

    then i changed to
    port 1522 still didnt work - lsnrctl status & stop

    now back to 1521 still no luck.

  9. #9
    Join Date
    Apr 2003
    Posts
    353
    I think listener is not set.

    Lsnrctl> set current_listener LISTENER
    Lsnrctl> status

    Give the result now.

    Regards

  10. #10
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    i did as per u per no luck. Listener is up and running.
    but when i want to see the status - it throws error.



    oracle@oracle10g oracle]$ lsnrctl

    LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 01-JUN-2005 08:42:43

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

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> set current_listener LISTENER
    Current Listener is LISTENER



    LSNRCTL> status
    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
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle10g.pdcindscape.com)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused

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