Linux 系统 Oracle 11g 修改监听端口

1.查看监听:lsnrctl status

2.停止监听:lsnrctl stop

3.修改oracle安装目录的下的配置文件listener.ora:一般路径为自己Oracle安装目录+/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

4.查看local_listener

  su - oracle

  sqlplus / as sysdba

  show parameter local_listener

  alter system set local_listener = "(address = (protocol = tcp)(host = 192.168.1.1)(port = 11521))";

  show parameter local_listener

  exit

5.启动监听:lsnrctl start

6.查看状态:netstat -an|grep 11521

posted @ 2021-05-24 17:17  diyigejianhun  阅读(469)  评论(0编辑  收藏  举报