Step One :
ps -ef | grep tns
oracle 4214 1 0 22:51 ? 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
Step two :
lsnrctl stop LISTENER
[[email protected] ~]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.5.0 – Production on 17-NOV-2012 22:55:41
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
Step Three :
Go to $ORACLE_HOME/network/admin and modify Listener.ora
[[email protected] ~]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/
SID_LIST_OSAMA=
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
OSAMA =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
Step Four :
lsnrctl start OSAMA
Step Five :
SQL> show parameter local_listener
SQL> alter system set local_listener='(address=(protocol=tcp)(host=xx.xx.xx.xx)(port=1521))’;
SQL> alter system register;
