1.设置自定义监听的连接串
vi tnsnames.ora
LISTENER_CROSS =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1)(PORT = 1521))
2.设置本地监听
alter system set local_listener='LISTENER_CROSS';
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
local_listener string LISTENER_CROSS
alter system register;
3.启动监听
lsnrctl start LISTENER_CROSS