--#查看local_listener
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL>
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.6)(PORT = 1526))';
System altered.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.15.6)(PORT = 1526
))
SQL>
--#别名、
SQL> alter system set local_listener='LISN2';
System altered.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISN2
SQL>
--需要在tnsnames.ora中配置下
LISN2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.6)(PORT = 1526))
)
)
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL>
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.6)(PORT = 1526))';
System altered.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL = TCP)(HO
ST = 192.168.15.6)(PORT = 1526
))
SQL>
--#别名、
SQL> alter system set local_listener='LISN2';
System altered.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISN2
SQL>
--需要在tnsnames.ora中配置下
LISN2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.6)(PORT = 1526))
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2129885/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
