DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: lsnrctl stop , status , log_status throws error

  1. #11
    Join Date
    Apr 2003
    Posts
    353
    1 I think in your previous post of listener.ora file, you have skipped
    some entries.

    2. Run services command and paste the result.

  2. #12
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    LSNRCTL> services
    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

    engiri where are u based i mean country

  3. #13
    Join Date
    Apr 2003
    Posts
    353
    Answer for the question 1 is posted.

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    show your /etc/hosts file

    also how can you have DHCP in a server?

  5. #15
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    this is the entry in the /etc/hosts

    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    192.168.1.35 oracle10g.pdcindscape.com oracle10g


    DHCP i mean the ip address to this server is private IP.
    It is not having a public IP ie 216 or 64 series.

    we have a dhcp server that issues the IP address.

    but for this server we have kept the IP address fixed.
    while installing linux we gave this ip address.

  6. #16
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    clean up your listener.log

    lsnrctl status LISTENER

    post listener.log

    post listener.ora again

  7. #17
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    and add this in your hosts

    Code:
    127.0.0.1      localhost.pdcindscape.com localhost
    Last edited by pando; 06-01-2005 at 03:24 AM.

  8. #18
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    pando i added the entry in /etc/hosts
    root@oracle10g etc]# cat hosts
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    192.168.1.35 oracle10g.pdcindscape.com oracle10g
    127.0.0.1 localhost.pdcindscape.com loaclhost

    to have change effect i did
    [root@oracle10g etc]# service network restart

    it restarted
    but still no luck

    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



    LSNRCTL> services
    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
    =====================================================
    LSNRCTL> start
    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=1521)))

    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 01-JUN-2005 14:46:33
    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=1521)))
    Services Summary...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    =========================================

    LISTENER .LOG
    TNSLSNR for Linux: Version 10.1.0.3.0 - Production on 01-JUN-2005 14:42:48

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

    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
    Trace information written to /u01/app/oracle/product/10.1.0/db_1/network/trace/listener.trc
    Trace level is currently 0

    Started with pid=19453
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1521)))

    TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
    WARNING: Subscription for node down event still pending
    01-JUN-2005 14:42:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=oracle10g)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LI STENER)(VERSION=168821504)) * status * 0

  9. #19
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you have spelling mistakes in your hosts file

  10. #20
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132
    yes dave - i corrected it

    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    192.168.1.35 oracle10g.pdcindscape.com oracle10g
    127.0.0.1 localhost.pdcindscape.com localhost

    i restarted the network service
    [root@oracle10g etc]# service network restart
    Shutting down interface eth0: [ OK ]
    Setting network parameters: [ OK ]
    Bringing up interface lo: [ OK ]
    Bringing up interface eth0: [ OK ]


    still no luck
    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

    i tried RELOAD ALSO
    ============================
    LSNRCTL> reload
    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


    and the worst part is when i log in to lsnrctl and do start it starts
    it doesnt say listener already started.
    it starts as if i am starting the listener first time.

    no clue - why is this happening,

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