https://blog.csdn.net/qq_39611053/article/details/79033947
一、查看当前监听的状态
lsnrctl status
lsnrctl stop
三、修改监听文件的端口号
把端口号修改为1523,分别修改listener.ora和tnsname.ora文件
1、进入D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\
2、编辑 listener.ora文件 修改端口号(仅修改涂黄部分)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
#端口号修改后,如果实例名丢失,则手动添加实例名(添加涂红部分)
(SID_DESC =
(SID_NAME = dev)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SJJGJWW10)(PORT = 1523))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
3、编辑tnsname.ora文件 修改端口号(仅修改涂黄部分)
DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.157.154)(PORT = 1523))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = DEV)
(SERVICE_NAME = dev)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.157.154)(PORT = 1523))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
4、注册使用新端口号
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.157.154)(PORT = 1523))';
5、启动监听
lsnrctl start
参考链接:https://blog.csdn.net/qq_39611053/article/details/79033947