修改监听端口--修改监听端口 关闭监听 $(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(PROTOCOLTCP)(HOST192.168.126.6)(PORT1526)); 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/oracle192.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(PROTOCOLTCP)(HOST192.168.126.6)(PORT1521))) (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST192.168.126.6)(PORT1522))) (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST192.168.126.6)(PORT1523))) ) SCOPEBOTH; 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/oracle192.168.126.6:1521/cesdb FFF select open_mode from v\$database; FFF sqlplus -S system/oracle192.168.126.6:1522/cesdb FFF select open_mode from v\$database; FFF sqlplus -S system/oracle192.168.126.6:1523/cesdb FFF select open_mode from v\$database; FFF
