Oracle11g 修改listener监听端口

Oracle基础 08/22 阅读 10589 views次 人气 564
摘要:

Oracle监听1521端口修改为1523

1. lsnrctl stop停止监听   2. 修改listener.ora文件中的端口号
vi $ORACLE_HOME/network/admin/listener.ora

LISTENER_ORA =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.122.20)(PORT = 1523))
    )
  )

SID_LIST_LISTENER_ORA =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ultranms)
      (ORACLE_HOME = /home/oracle/product/11gR2/db)
      (SID_NAME = ultranms)
    )
  )
ADR_BASE_LISTENER = /home/oracle ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON   3. 修改tnsnames.ora文件中的端口号为“1523”
vi $ORACLE_HOME/network/admin/tnsnames.ora

ora11g =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.122.20)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ultranms)
    )
  )
  4. 在数据库中修改初始化参数local_listener SQL> show parameter local_listener  

评论

该文章不支持评论!

分享到: