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
