Oracle单机修改监听端口注册多个监听端口
修改监听端口
--修改监听端口 关闭监听 $(ORACLE) lsnrctl stop 监听端口不采用默认的 1521，调整为 1526 $(ORACLE) cd $ORACLE_HOME/network/admin sed -i '/TCP/s/1521/1526/g' listener.ora cat listener.ora 修改 DB 监听参数 $(ORACLE) sqlplus / as sysdba alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.126.6)(PORT=1526))'; set lines 999 pages 999 show parameter listener 修改 tnsnames.ora $(ORACLE) cd $ORACLE_HOME/network/admin sed -i 's/1521/1526/g' tnsnames.ora cat tnsnames.ora 启动监听验证 $(ORACLE) lsnrctl start sqlplus / as sysdba alter system register; exit; 监听状态 $(ORACLE) lsnrctl status 测试连接 $(ORACLE) sqlplus -S system/oracle@192.168.126.6:1526/cesdb << FFF select open_mode from v\$database; FFF注册多个监听端口
--多个监听端口 停止监听 $ lsnrctl stop 修改端口 $ cd $ORACLE_HOME/network/admin $ vi listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.6)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.6)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.126.6)(PORT = 1523)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /u01/app/oracle SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = cesdb) (ORACLE_HOME = /u01/app/oracle/product/11.2/db_1) (SID_NAME = primary) ) ) 启动监听 $ lsnrctl start 修改db监听配置 sqlplus / as sysdba alter system set local_listener=' (DESCRIPTION_LIST= (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.126.6)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.126.6)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.126.6)(PORT=1523))) ) ' SCOPE=BOTH; set lines 999 pages 999 show parameter listener ALTER SYSTEM REGISTER; 监听状态 $ lsnrctl status 修改 tnsnames.ora $(ORACLE) cd $ORACLE_HOME/network/admin cat tnsnames.ora ##根据需求修改 测试连接 sqlplus -S system/oracle@192.168.126.6:1521/cesdb << FFF select open_mode from v\$database; FFF sqlplus -S system/oracle@192.168.126.6:1522/cesdb << FFF select open_mode from v\$database; FFF sqlplus -S system/oracle@192.168.126.6:1523/cesdb << FFF select open_mode from v\$database; FFF