修改Oracle端口

1、lsnrctl stop  --停止监听

2、进入监听所在的目录下

cd $ORACLE_HOME/network/admin

 3、编辑listener.ora文件(端口更改为9999)

vi listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.51)(PORT = 9999))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC9999))
)
)

 

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_NAME = ORCLCDB)
(SID_NAME = ORCLCDB)
(ORACLE_HOME = /opt/oracle/product/19c/dbhome_1)

)
)

 4、启动监听

lsnrctl start   启动监听

5、重启数据库

shutdown immediate   --关闭数据库

startup 　　--启动数据库

 7、sudo firewall-cmd --zone=public --add-port=9999/tcp --permanent

 8、sudo firewall-cmd --reload