SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
[oracle@gechong admin]$ vi tnsnames.ora
默认监听
EMLISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.171.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = emListener)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 169.254.171.1)(PORT = 1522))
[oracle@gechong admin]$ lsnrctl status
此时可以看到pmon将实例注册到EMLISTENER监听器中
SQL> alter system set local_listener = LISTENER_ORCL
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_ORCL
SQL
>
ALTER SYSTEM REGISTER;
[oracle@gechong admin]$ lsnrctl status
此时可以看到pmon将实例注册到LISTENER_ORCL监听器中
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28212711/viewspace-768220/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28212711/viewspace-768220/