如何監聽Oracle

157次閱讀

共計 4611 個字符，預計需要花費 12 分鐘才能閱讀完成。

這篇文章將為大家詳細講解有關如何監聽 Oracle，丸趣 TV 小編覺得挺實用的，因此分享給大家做個參考，希望大家閱讀完這篇文章后可以有所收獲。

Oracle 監聽

一：沒有 listener.ora 監聽文件

監聽文件 listener.ora 文件丟失；
沒有 listener.ora 文件情況時，以默認方式運行監聽器，此時，監聽器將在解析為計算機主機名 (端口 1521) 的任何地址上進行監聽；
建議始終配置 listener.ora 文件，使 Oracle Net 環境可以自我記錄；

[oracle@chen admin]$ pwd
/u01/app/oracle/product/11.2.0.4/network/admin

[oracle@chen admin]$ ls
samples shrept.lst tnsnames.ora

沒有配置 listener.ora 時，自動使用動態注冊
[oracle@chen admin]$
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 20-JUL-2017 15:05:25
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Start Date 20-JUL-2017 15:03:54
Uptime 0 days 0 hr. 1 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/chen/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=chen)(PORT=1521)))
Services Summary…
Service orcl has 1 instance(s).
Instance orcl , status READY, has 1 handler(s) for this service…
Service orclXDB has 1 instance(s).
Instance orcl , status
READY, has 1 handler(s) for this service…
The command completed successfully

二：監聽靜態注冊

[oracle@chen admin]$ pwd
/u01/app/oracle/product/11.2.0.4/network/admin

[oracle@chen admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4)
(SID_NAME = orcl)
)
)

靜態注冊時：
可以遠程啟動數據庫(需要有口令文件)；

C:\Users\Administrator sqlplus sys/oracle@10.1.233.100:1521/orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 星期四 7 月 20 13:33:09 2017

已連接到空閑例程。

SQL
startup
ORACLE 例程已經啟動。

Total System Global Area 839282688 bytes
Fixed Size 2257880 bytes
Variable Size 545262632 bytes
Database Buffers 289406976 bytes
Redo Buffers 2355200 bytes
數據庫裝載完畢。
數據庫已經打開。 [oracle@chen admin]$ lsnrctl status
…..
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=chen)(PORT=1521)))
Services Summary…
Service orcl has 2 instance(s).
Instance orcl , status
UNKNOWN, has 1 handler(s) for this service…
Instance orcl , status READY, has 1 handler(s) for this service…
Service orclXDB has 1 instance(s).
Instance orcl , status READY, has 1 handler(s) for this service…
The command completed successfully

配置 DG,EM 等建議使用靜態注冊

三：監聽動態注冊

[oracle@chen admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chen)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SQL alter system register;
System altered.

[oracle@chen admin]$ lsnrctl status
Services Summary…
Service orcl has 1 instance(s).
Instance orcl , status
READY, has 1 handler(s) for this service…
Service orclXDB has 1 instance(s).
Instance orcl , status
READY, has 1 handler(s) for this service…
The command completed successfully

實例未啟動時，注冊不了服務
Services Summary…
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=chen)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

動態注冊時無法遠程啟動數據庫
C:\Users\Administrator sqlplus sys/oracle@10.1.233.100:1521/orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 星期四 7 月 20 14:26:57 2017

ERROR:
ORA-12514: TNS: 監聽程序當前無法識別連接描述符中請求的服務

請輸入用戶名:

四：監聽動態注冊 + 靜態注冊

[oracle@chen admin]$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = chen)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

[oracle@chen admin]$ lsnrctl status
……
Services Summary…
Service orcl has 2 instance(s).
Instance orcl , status
UNKNOWN, has 1 handler(s) for this service…
Instance orcl , status
READY, has 1 handler(s) for this service…
Service orclXDB has 1 instance(s).
Instance orcl , status
READY, has 1 handler(s) for this service…
The command completed successfully

可以遠程啟動數據庫
C:\Users\Administrator sqlplus sys/oracle@10.1.233.100:1521/orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 星期四 7 月 20 14:22:59 2017

已連接到空閑例程。

SQL
startup
ORACLE 例程已經啟動。

Total System Global Area 839282688 bytes
Fixed Size 2257880 bytes
Variable Size 545262632 bytes
Database Buffers 289406976 bytes
Redo Buffers 2355200 bytes
數據庫裝載完畢。
數據庫已經打開。官方文檔位置如下：
Oracle Database Net Services Reference
http://docs.oracle.com/cd/E11882_01/network.112/e10835/listener.htm#NETRF008
Oracle Net Listener Parameters (listener.ora)
http://docs.oracle.com/cd/E11882_01/network.112/e10835/listener.htm#NETRF008

關于“如何監聽 Oracle”這篇文章就分享到這里了，希望以上內容可以對大家有一定的幫助，使各位可以學到更多知識，如果覺得文章不錯，請把它分享出去讓更多的人看到。

正文完