更改监听端口号（动态注册）
修改listener.ora,port为1522
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = yichunmei.chinasoft.com)(PORT = 1522))
)
)
修改tnsname.ora ,port为1522
YCM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = yichunmei.chinasoft.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ycm)
)
)
配置local_listener参数为tnsname.ora中listener名
alter system set local_listener='YCM' scope=both;
默认PMON进程只会对1521
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25989950/viewspace-738627/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
nyfedit_2
下一篇：
show_space
请登录后发表评论
登录
全部评论
