linux 静态监听,静态监听

静态监听：

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

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

客户端成功连接。