DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: The 'invisible' LISTENER ???

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    The 'invisible' LISTENER ???

    Got a call from a colleague who can't find the listener.ora file on a 9.2 Windows box.

    He's developing a call to a C prog and needs to set some External Call settings.

    He can't find any file called listener.ora on the box.

    I've run LSNRCTL and the current listener is called LISTENER and I can see the services it's listening for. We know it works as we can connect.

    Just where is the listener.ora text file?

    Using Net Assistant or Manager, there doesn't appear to be a listener configured. Which is strange.

    Any ideas?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Try executing lsnrctl status it should show the listener.ora path...

    Code:
    c:\>lsnrctl stat
    
    LSNRCTL for 32-bit Windows: Version 9.2.0.6.0 - Production on 15-JUL-2005 20:25:39
    
    Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for 32-bit Windows: Version 9.2.0.6.0 - Production
    Start Date                12-JUL-2005 14:07:09
    Uptime                    3 days 6 hr. 18 min. 32 sec
    Trace Level               off
    Security                  OFF
    SNMP                      OFF
    Listener Parameter File   C:\oracle\ora92\network\admin\listener.ora
    Listener Log File         C:\oracle\ora92\network\log\listener.log
    Listening Endpoints Summary...
    .
    .
    .
    .
    .
    Services Summary...
    Service "ACME.WORLD" has 1 instance(s).
      Instance "ACME", status READY, has 1 handler(s) for this service...
    Service "ACMEXDB.WORLD" has 1 instance(s).
      Instance "ACME", status READY, has 1 handler(s) for this service...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Ah this is where it gets interesting...

    I have already tried that, and the line for

    Listener Parameter File C:\oracle\ora92\network\admin\listener.ora

    is not there!

    Now I noticed from the Uptime entry that this has only been up for 1 hr or so. This Listener should have been running for DAYS. If the developer has shutdown and restarted the listener (which I suspect), might that have done something?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you dont need a listener.ora to have a listener, if none is present it will use defaults fo everything and status will show the .or afile as being there (even though it isnt)

  5. #5
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Yep, agreed Davey. I've often seen that.

    But does Net Manager work on LISTENER or LISTENER.ora? The developer needs something he can see and edit.

    Is it possible to reverse engineer a listener.ora from the listener LSNRCTL settings?

    And IF status shows it being there when it isn't ... how have I got status showing it NOT there (when it isn't?? )
    Last edited by JMac; 07-15-2005 at 12:16 PM.

  6. #6
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    It's also possible that it was started from another server, where the listener.ora file on that server has the hostname of the 'other' server.

    Many an oops has occured by stopping a listener in development, that had the hostname of production in the listener.ora.

    This is why you want to name listeners not the default "LISTENER", and also apply a password (if feasible in your environment).

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