因系统安全需要,修改oracle默认数据库端口。步骤如下:
1、停止监听 lsnrctl stop
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_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 = 本地实例名)
(ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1)
)
)
然后把LISTENER默认端口PORT = 1251修改为PORT = 1234,保存
3、修改配置文件tnsnames.ora,把LISTENER_本地实例名、本地实例名等的PORT = 1521,修改为PORT = 1234,修改完成后保存即可。
4、启动监听lsnrctl start,即可。正常情况下不需要重启数据库。