oracle修改实例端口,oracle修改监听端口

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

https://blog.csdn.net/Willy__QI/article/details/81435967