Skip to Main Content
  • Questions
  • Listener working without listener.ora

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, gonzalo.

Asked: November 04, 2016 - 1:41 pm UTC

Last updated: November 05, 2016 - 2:46 am UTC

Version: 11g R2

Viewed 1000+ times

You Asked

I have an oracleDB working en production for more than a year. I have my listener working but NO listener.ora file.

[oracle@base admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0     
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                02-NOV-2016 14:22:38
Uptime                    1 days 20 hr. 3 min. 13 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /o/app/oracle/diag/tnslsnr/base/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=base)(PORT=1521)))
Services Summary...
Service "BASE" has 1 instance(s).
  Instance "BASE", status READY, has 1 handler(s) for this service...
Service "BASEXDB" has 1 instance(s).
  Instance "BASE", status READY, has 1 handler(s) for this service...
The command completed successfully
But i have no listener.ora


$ ls /o/app/oracle/product/DB_11.2_SE/dbhome_2/network/admin/
samples  shrept.lst  tnsnames.ora


This is the content of my tnsnames.ora

$ cat tnsnames.ora 
BASE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.20.19)(PORT = 1521))
      (LOAD_BALANCE = yes)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BASE)
    )
  )


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.20.20)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )


How is this possible? As far as I know, for the listener to work, I have to have listener.ora file.

and Connor said...

From the Net Services Admin Guide:

"Because the configuration parameters have default values, it is possible to start and use a listener with no configuration. This default listener has a name of LISTENER, supports no services on startup, and listens on the following TCP/IP protocol address:

(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1521))"

Cheers,
Connor

Rating

  (1 rating)

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

Comments

Answered

A reader, November 07, 2016 - 12:35 pm UTC