1. 修改 listener.ora 和tnsnames.ora 这两个文件:
a 、在listener.ora文件中添加一个一个新的监听器
ordb1 =
(description_list =
(description =
(address_list =
ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 新的端口))
) ))
并启动新的监听器
b、tnsnames.ora 中需要加入一个新的注册名:
ordb1 =
(description_list =
(description =
(address_list =
ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 新的端口))
)
(connect_data =
(service_name = dbname)
)
)
2、修改数据库参数
SQL> show parameter local_listener ;
SQL> alter system set local_listener='listener_1' scope=spfile;
3、 修改 $ORACLE_HOME/hostname_sid/sysman/config下的emoms.properties文件:
oracle.sysman.eml.mntr.emdRepPort=新的端口
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION/=(ADDRESS_LIST/=(ADDRESS/=(PROTOCOL/=TCP)(HOST/=xxx)(PORT/=新的端口)))(CONNECT_DATA/=(SERVICE_NAME/=xxx)))
4. 最后,还要修改 $ORACLE_HOME/hostname_sid/sysman/emd下的targets.xml:
<Property NAME="Port" VALUE="新的端口"/>