如何监听Oracle

102次阅读

共计 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/[email protected]: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/[email protected]: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/[email protected]: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”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。

正文完