Where is my listener.ora file

[oradba101]

Good afternoon, all

Have an interesting one. I have been running Oracle10gR2 for quite a few months now. I have no problems connecting to it whatsoever nor have not had any issues to speak of. To get to the point I do not have a listener.ora or tnsnames.ora anywhere on the server (with the exception of the /samples subdirectory). How is this possible?

Regards,



William Chadbourne
Oracle DBA

 

[sedj]

Is it not in $ORACLE_HOME/network/admin ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[SantaMufasa]

William,

Is your listener actually running? If so, your "lsnrctl" program will tell you what listener.ora file it used to start up:

<server>:/corp/home/oracle$ lsnrctl

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 12-JUN-2006 12:36:14

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.1.0 - Productio
Start Date                11-JUN-2006 07:54:05
Uptime                    1 days 4 hr. 42 min. 10 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
[b]Listener Parameter File   /var/opt/oracle/listener.ora[/b]
Listener Log File         /var/log/oracle/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=foster.10fold.com)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=foster.10fold.com)(PORT=2481))(PR
NTATION=GIOP)(SESSION=RAW)))
Services Summary...
...
The command completed successfully
LSNRCTL>

If it's not running, and you are still connecting successfully, then your connections are not remote, they are local and you are not needing the listener to make the connections.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[oradba101]

Hi,

I don't have the line that begins with "Listener Parameter File" when I run "lsnrctl status"

Regards,



William Chadbourne
Oracle DBA

 

[SantaMufasa]

That is strange...my listener.log file confirms the "listener.ora" file. Is your log file absent that information, as well? If so, then I'd next log an SR with Metalink. (Then post your findings here.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[sedj]

Is that a "no" to whether it is in ORACLE_HOME/network/admin then (or /var/opt/oracle I guess too) ?

As root, do :

find / -type f |grep listener\.ora

It must be on the server somewhere ....

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[SantaMufasa]

Also, William, check to see if you have defined the system variable, "$TNS_ADMIN":

TNS_ADMIN=/dbsrv/oracle/app/oracle/product/10.2/network/admin

This setting overrides any default paths for your ".../network/admin" path where Oracle looks for the listener.ora file.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[oradba101]

Hi, all

I'll check all these suggestions and get back as soon as possible.

Regards,


William Chadbourne
Oracle DBA

 

[oradba101]

Good morning,

There is not a listener.ora file to be found anywhere on the server except, as noted before, in the /samples subdirectory.

Regards,



William Chadbourne
Oracle DBA

 

[KenCunningham]

And what about $TNS_ADMIN as suggested by Dave?

 

[oradba101]

Hi, Ken

It ran without any errors. I suppose I could try to redo netca and see if that makes a difference.

Regards,



William Chadbourne
Oracle DBA

 

[SantaMufasa]

It ran without any errors.

What ran without any errors?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[dbtoo2001]

Are there other oracle versions running on this server? What is the server?

 

[oradba101]

Hi, all

I ran 'netca' and reconfigured and/or added everything and now it seems to be fine. Thanks for all your help. Still, it seems rather curious that the database would run without the tnsnames.ora and listener.ora files.

Regards,


William Chadbourne
Oracle DBA

 

[dbtoo2001]

http://download-west.oracle.com/docs/cd/B14117_01/network.101/b10775/listenercfg.htm#i490311

" Dynamic service registration is configured in the database initialization file. It does not require any configuration in the listener.ora file."

Is there a local_listener variable in the init file for the database?

 

[taupirho]

Hi,its likely that you are using something called "host naming" to connect to your database which obviates the need for a listener.ora file

You can do this if your client and server are connecting using TCP/IP. The host name is resolved through an IP address translation mechanism such as Domain Name Services (DNS), Network Information Services (NIS), or a centrally maintained TCP/IP hosts file.

 

[oradba101]

Hi, all

I actually configured the database and netca with port 1521 and I used the IP address of the server not the host name. Everything seems to be the way its supposed to be so I am going to call it good. Thanks to all of you for your assistance.

Regards,


William Chadbourne
Oracle DBA