oracle 修改端口

时间:2022-03-01 03:41:17

cp /opt/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora  /opt/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

 

然后在服务器里面用sys登陆sqlplus,执行下面三条语句

alter system set local_listener=listener;

set lines 120

show parameter local_listener