Sample listener.ora

Configuration and Administration Tools: Oracle Net Manager, Oracle Net Configuration Assistant, Oracle Net Control Utilities and Duties of a Network Administrator
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:

Sample listener.ora

Post by jimb »

Sample Oracle Net Listener Parameters (listener.ora)

Below is a sample of listener.ora.
Listener Name: LISTENER
ORACLE_HOME: /u01/app/oracle/product/10.2.0/db_1
SID: ORCL10G
PROTOCOL: TCP
HOST: oracle10g.localdomain
PORT: 1521

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL10G)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL10G)
)

(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.localdomain)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
Oracle Database Administration Forums
http://www.oracle-forums.com/
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: Sample listener.ora

Post by xaeresis »

Post Reply