Creating an Oracle listener on a Non-Standard port

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: