oracle 修改端口

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;