更改oracle 默认的1521端口,只需要在/ORACLE_HOME/network/admin目录下修改或者新建一个listener.ora文件即可 。
修改完成以后,直接用lsnrctl reload命令即可完成端口配置。
例如:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /opt/oracle/product/10.2.0)
(SID_NAME = test)
)
)
如移植到其他机器上,需要修改端口号port,oracle_home 路径,以及sid_name即可