Listener.ora is missing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Listener.ora is missing

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Unhappy Listener.ora is missing

    I notice that when I rebooted my Solaris 8 machine with Oracle 9.0.1 the listener and Oracle can be started automatically. I have 2 instances. However, the listener.ora file is nowhere to be found. After I stop one of the listener for 1 of the 2 instances, I cannot start back. I enter -> 'lsnrctl start pro2'. Whas has happened? The listener is started after rebooting the machine but I cannot start it manually. Please help. Tks.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    lets see the exact error message you get when you type that command in

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    are you configured for pmon to perform automatic instance registration thus negating need for a listener file?

    steve
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Sep 2003
    Location
    China
    Posts
    72
    $ lsnrctl start wpl

    LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 09:21:02

    Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

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

    TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
    Log messages written to /u01/app/oracle/product/9.1.0/network/log/wpl.log
    TNS-01151: Missing listener name, wpl, in LISTENER.ORA

    Listener failed to start. See the error message(s) above...

    $

  5. #5
    Join Date
    Sep 2003
    Location
    China
    Posts
    72
    How to check whether the machine has pmon to perform auto instance registration? I'm not sure about this.

  6. #6
    Join Date
    May 2002
    Posts
    2,645

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you dont have a listener called wpl

    what happens if you type lsnrctl start on its own?

  8. #8
    Join Date
    Sep 2003
    Location
    China
    Posts
    72
    Here is what I got...

    $ lsnrctl start

    LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 16:55:54

    Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

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

    TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
    Log messages written to /u01/app/oracle/product/9.1.0/network/log/listener.log
    Error listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
    TNS-12542: TNS:address already in use
    TNS-12560: TNSrotocol adapter error
    TNS-00512: Address already in use
    Solaris Error: 125: Address already in use

    Listener failed to start. See the error message(s) above...

    $ lsnrctl status

    LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 16:56:13

    Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
    Start Date 20-OCT-2003 17:37:10
    Uptime 6 days 23 hr. 19 min. 3 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Log File /u01/app/oracle/product/9.1.0/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.wplink)(PORT=1521)))
    Services Summary...
    Service "wplp" has 1 instance(s).
    Instance "wplp", status READY, has 1 handler(s) for this service...
    The command completed successfully
    $

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