Configure TNSNAME

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#sthref692

sales=
(DESCRIPTION= 
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=sales.us.acme.com)))
  1. tnsname.ora

LISTENER_PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = atom04-10g)(PORT = 1621))
)
)

PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD)
)
)

OMR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OMR)
)
)

SQL> alter system set local_listener='listener_prod' scope=both;
SQL> show parameter listener
NAME_COL_PLUS_SHOW_PARAM  TYPE  VALUE_COL_PLUS_SHOW_PARAM
local_listener                            string  listener_prod
remote_listener                         string
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License