With the onset of Sarbanes-Oxley, one of the new requirements that DBA’s have to meet is to create instance specific Oracle listeners that are not on the default listener port of 1521. This is really a fairly straightforward process, but one that a DBA may not be familiar with if his site standard is to always use the default.
Most DBA’s create the new listener with the word listener in the name, and an identifying string either preceding or following the word listener. For example, LISTENER_KRB11G or KRB11G_LISTENER. The entry for creating the listener would look like this:
LISTENER_KRB11G =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = krbrhel)(PORT = 1522))
)
)
SID_LIST_LISTENER_KRB11G=
( SID_LIST =
( SID_DESC =
( GLOBAL_DBNAME = krb11g )
( ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1 )
( SID_NAME = krb11g )
)
)
The command to start the listener is (remember, on Unix the listener name is case sensitive):
lsnrctl start LISTENER_KRB11G
To check the status:
lsnrctl status LISTENER_KRB11G
To set the listener password (also part of Sarbanes-Oxley), see this excellent post on the subject:
http://www.dba-oracle.com/t_listener_password_security_lsnrctl.htm
