静态监听配置

作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】

静态监听配置

 

    两台主机分别配置静态监听，配置完成后，任意一台主机都能通过SQL*PLUS远程连接另一主机上的数据库，即便远程数据库未打开也能连接。

HOST1：sigle

HOST2：clone_sigle

ORACLE_HOME均为：/oracle/db10g

实例1：orcl

实例2：orclaux

 

1、在监听配置文件listener.ora中加入如下内容

[oracle@clone_sigle admin]$ cat listener.ora

# listener.ora Network Configuration File: /oracle/db10g/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /oracle/db10g)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = orcl)

      (ORACLE_HOME = /oracle/db10g)

      (SID_NAME = orcl)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = orclaux)

      (ORACLE_HOME = /oracle/db10g)

      (SID_NAME = orclaux)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = clone_sigle)(PORT = 1521))

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

 

[oracle@clone_sigle admin]$

 

2、在tnsnames.ora文件中配置对方的服务名

SIGLE =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.120)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcl)

    )

  )

SIGLEAUX =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.121)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orclaux)

    )

  )

3、启动监听

 

[oracle@sigle admin]$ lsnrctl start

 

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 29-12月-2012 20:13:57

 

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

 

Starting /oracle/db10g/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 10.2.0.4.0 - Production

System parameter file is /oracle/db10g/network/admin/listener.ora

Log messages written to /oracle/db10g/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sigle)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sigle)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date                29-12月-2012 20:13:59

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oracle/db10g/network/admin/listener.ora

Listener Log File         /oracle/db10g/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sigle)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "orcl" has 1 instance(s).

  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

Service "orclaux" has 1 instance(s).

  Instance "orclaux", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@sigle admin]$

可以看到在监听中存在orcl和orclaux的相关服务进程，状态：UNKOWN

 

4、测试连接

在都不启动数据库的情况下，使用SQL*PLUS工具连接对方数据库。

在HOST1上：

[oracle@sigle admin]$ sqlplus /nolog

[uniread] Loaded history (184 lines)

 

SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 12月 29 20:21:39 2012

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

SQL> conn sys/sysadmin@SIGLEAUX as sysdba

Connected to an idle instance.

SQL> conn sys/sysadmin@SIGLE as sysdba

Connected to an idle instance.

SQL> exit

Disconnected

[uniread] Saved history (187 lines)

[oracle@sigle admin]$

在主机1上连接成功。

在HOST2上：

[oracle@clone_sigle admin]$ sqlplus /nolog

[uniread] Loaded history (443 lines)

 

SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 12月 29 20:23:23 2012

 

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

 

SQL> conn sys/sysadmin@SIGLEAUX as sysdba

Connected to an idle instance.

SQL>

SQL> conn sys/sysadmin@SIGLE as sysdba

Connected to an idle instance.

SQL>

SQL> exit

Disconnected

[uniread] Saved history (446 lines)

[oracle@clone_sigle admin]$

在主机2上连接成功。