ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 静态监听

静态监听

原创 Linux操作系统 作者:ttboylb 时间:2011-08-03 17:01:14 0 删除 编辑

静态监听:

1.监听器不是最早启动,oracle实例先启动 

2.监听器重启

3.oracle实例没有open


静态监听:

  oracle实例运行后,监听程序启动时,根据listener.ora的配置注册相应的服务。其中global_dbname对应的是oracle对外的服务名,即初始化参数里的service_names而sid_name对应的是oralce实例的名称,即初始化参数里的instance_name

 

[oracle@primary ~]$ cat /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

#SID_LIST_LISTENER =
#  (SID_LIST =
#    (SID_DESC =
#     (SID_NAME = PLSExtProc)
#     (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
#     (PROGRAM = extproc)
#    )
#  )

#LISTENER =
# (DESCRIPTION_LIST =
#   (DESCRIPTION =
#     (ADDRESS = (PROTOCOL = TCP)(HOST = primary)(PORT = 1521))
#     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
#    )
#  )


SID_LIST_LISTENER =
 (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME =orcl)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME =orcl)
    )
 


先打开LSNR

LSNRCTL> START


数据库未开时的lsnr状态

 

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                03-AUG-2011 16:58:19
Uptime                    0 days 0 hr. 21 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


数据库startup nomount 的 LSNR 状态

LSNRCTL> status  
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                03-AUG-2011 16:58:19
Uptime                    0 days 0 hr. 24 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=primary)(PORT=1521)))
Services Summary...
Service "orcl" has 2 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
  Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

 

客户端成功连接。

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12131609/viewspace-704008/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-07

  • 博文量
    60
  • 访问量
    252976