Oracle 11g中新增兩個listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bruce)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1\BIN)
(SID_NAME = bruce)
)
)
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1621))
)
C:\Users\xxxxxxxx>lsnrctl status --預設是listener
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:38:51
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:27:24
Uptime 0 days 0 hr. 11 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
Service "bruceXDB" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
Service "bruce_XPT" has 1 instance(s).
Instance "bruce", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Users\xxxxxxxx>lsnrctl start listener2
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:39:01
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系統引數檔案為E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
寫入E:\oracle\product\10.2.0\db_1\network\log\listener2.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
STATUS of the LISTENER
------------------------
Alias listener2
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:39:07
Uptime 0 days 0 hr. 0 min. 6 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\xxxxxxxx>lsnrctl status listener2
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2015 08:39:15
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
STATUS of the LISTENER
------------------------
Alias listener2
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 03-DEC-2015 08:39:07
Uptime 0 days 0 hr. 0 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1621)))
Services Summary...
Service "bruce" has 1 instance(s).
Instance "bruce", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1852119/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 在一臺機器配置兩個listener(Oracle)(轉)Oracle
- oracle 11g 【listener.ora tnsnames.ora】Oracle
- How To modify listener port in oracle 11g GridOracle
- [Oracle] Oracle 11g 關閉listener產生xml log方法OracleXML
- ORACLE 11G 靜默安裝soft db listenerOracle
- [Oracle] Oracle RAC中local_listener指定Oracle
- Oracle 11g RAC 叢集 SCAN IP Listener說明Oracle
- Oracle ListenerOracle
- 【LISTENER】一個資料庫配置兩個監聽埠號資料庫
- oracle 11g 新增控制檔案Oracle
- oracle監聽檔案listener.ora for 10g/11gOracle
- Oracle 11g RAC手動新增serviceOracle
- ORACLE 11G新特性之列新增操作Oracle
- Oracle RAC環境新增新的network和listener(未完成)Oracle
- oracle一個例項配置多個listener或多個埠Oracle
- oracle一個listener偵聽多個例項的配置Oracle
- Oracle 11g RAC重新新增節點Oracle
- oracle 11G 新增欄位調整效能Oracle
- [zt]Oracle rac 11g線上新增ocr,votediskOracle
- 【Laravel 5.4】新增兩個中介軟體Laravel
- [Laravel 5.4] 新增兩個中介軟體Laravel
- Oracle 11g Data Guard搭建過程中問題解決兩例Oracle
- oracle一個別例項配置多個listener或多個埠Oracle
- oracle的兩個bugOracle
- listener為何要fork兩次子程式
- Oracle LISTENER 中各種狀態資訊的含義Oracle
- 資料庫出現兩個Listener問題的官方處理方法資料庫
- oracle listener工具知識Oracle
- 為oracle listener set passwordOracle
- oracle 11g中的 oracle restart特性OracleREST
- Oracle 11g中Listener靜態註冊,報ora-01034和ora-27101錯誤Oracle
- oracle 11g rac 新增重做日誌檔案Oracle
- [Oracle] 統計listener.log中IP的幾種方法Oracle
- oracle兩個 retention 引數Oracle
- Oracle Linux中安裝Oracle 11gOracleLinux
- Oracle dblink比較兩個庫中的表欄位Oracle
- Oracle中對兩個資料表交集的查詢(轉)Oracle
- Oracle listener log配置與管理Oracle