如何监听Oracle-创新互联
这篇文章将为大家详细讲解有关如何监听Oracle,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。
专注于为中小企业提供网站建设、网站设计服务,电脑端+手机端+微信端的三站合一,更高效的管理,为中小企业抚州免费做网站提供优质的服务。我们立足成都,凝聚了一批互联网行业人才,有力地推动了上千余家企业的稳健成长,帮助中小企业通过网站建设实现规模扩充和转变。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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
已连接到空闲例程。
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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
已连接到空闲例程。
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
/tupian/20230522/listener.htm Net Listener Parameters (listener.ora)
/tupian/20230522/listener.htm class="introduction">关于“如何监听Oracle”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,使各位可以学到更多知识,如果觉得文章不错,请把它分享出去让更多的人看到。
本文标题:如何监听Oracle-创新互联
分享地址:http://scyanting.com/article/eoehd.html