RelationalDBDesign RelationalDBDesign


Managing Users  «Prev 

Example 2-5 Example listener.ora File

LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=sales.us.example.com)
(ORACLE_HOME=/oracle11g)
(SID_NAME=sales))
(SID_DESC=
(SID_NAME=plsextproc)
(ORACLE_HOME=/oracle11g)
(PROGRAM=extproc)))

The SID_LIST_LISTENER heading

SID_LIST_LISTENER=
 (SID_LIST=
  (SID_DESC=
   (SID_NAME=PLSExtProc)
   (ORACLE_HOME = C:\Oracle\Ora81)
   (PROGRAM =extproc)
  )
  (SID_DESC=
   (GLOBAL_DBNAME=jonathan)
   (ORACLE_HOME = C:\Oracle\Ora81)
   (SID_NAME=JONATHAN)
  )
)
   
The SID_LIST_LISTENER entry marks the list of services that the listener is handling. Notice that the entire list is enclosed within parentheses.

Oracle allows you to have multiple listeners running at once. The word LISTENER, shown here in bold, represents the name of the listener to which this entry applies. The default name is 'LISTENER' , which is what we are using now.

Our listener has a SID list or list of services that it is handling. This list is highlighted above, and consists of two entries, each of which starts with SID_DESC.


The first item that we are listening for is named PLSExtProc. This represents an executable file that is used to interface Oracle to external DLL libraries. You will only see extproc on Windows.

The second item does refer to a database. You can tell because it refers to a SID name rather than a program. JONATHAN happens to be the database that I created when I first installed the Oracle software.

The GLOBAL_DBNAME entry allows clients to reference the database by the name and domain specified in the database initialization file.

The SID_NAME entry allows clients to reference the database by the name of the instance.


The ORACLE_HOME entry tells the listener the location of the Oracle home directory for this database.