Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: January 19, 2017 - 12:28 pm UTC

Last updated: January 20, 2017 - 12:18 pm UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi team,

I am checking the database it is working fine all day In evening suddenly the connection of db is became very slow i ping tns it is repling OK but time is (77000mns) I have check the listener.ora file but i have not found.

Can you pls let me know without listener.ora file on db server how the user can connect the db.

When i fire the command lsnrctl status it is showing the status like this - Here Listener Parameter File is missing .

How to get the listener.log file location default it is in $ORACLE_HOME/network/admin in linux but it is not i this location.

$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-JAN-2017 17:34:21

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-JAN-2017 01:29:14
Uptime 15 days 16 hr. 11 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/RNTL-SRV-05/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RNTL-SRV-05)(PORT=1521)))
Services Summary...
Service "ftgprod" has 1 instance(s).
Instance "ftgprod", status READY, has 1 handler(s) for this service...
Service "ftgprodXDB" has 1 instance(s).
Instance "ftgprod", status READY, has 1 handler(s) for this service...
The command completed successfully

Thanks


and Chris said...

Looks like your listener is up and running fine to me. The listener log location is right there in your output:

Listener Log File /u01/app/oracle/diag/tnslsnr/RNTL-SRV-05/listener/alert/log.xml


If it's taking a long time to connect to the database and tnsping is slow I'd start:

- Checking the network: is this running OK?
- Check what's happening on the database server and inside the DB itself: are these maxed out for some reason?

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

oracle oracle, January 20, 2017 - 10:21 am UTC

Thanks For reply,

I understand the listener is ok and working fine.

But not be able to find the listener.ora file on my db server. It is not present in $ORACLE_HOME/network/admin location and not in any other location.
So, how it's possible user can connect .

I have find it but showing only log file but not the listener.ora file .

$ find $ORACLE_HOME -name listener.ora

Listener.log file continuously print like -

20-JAN-2017 15:39:04 * (CONNECT_DATA=(SID=genprod)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.14)(PORT=19993)) * establish * genprod * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

And when we fire the command like lsnrctl status
it showing one parameter with listener location but it is missing in my query

Listener Parameter File it is not showing in status command.
Connor McDonald
January 20, 2017 - 12:18 pm UTC

It possible you dont have one...without listener.ora, a listener will just assume all of the defaults. If one is there, it should appear in a STATUS command, eg

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date                16-JAN-2017 07:50:10
Uptime                    4 days 12 hr. 26 min. 35 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   c:\oracle\product\12.1.0.2\network\admin\listener.ora
Listener Log File         c:\oracle\diag\tnslsnr\COMCDONA-AU\listener\alert\log.xml