listern配置[@more@]

[root@rac1 admin]# more listener.ora

# listener.ora.rac1 Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora.rac1

# Generated by Oracle configuration tools.

LISTENER_RAC1 =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.141)(PORT = 1521)(IP = FIRST))

    )

  )

SID_LIST_LISTENER_RAC1 =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DB_NAME = ASM1)

      (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)

      (SID_NAME = +ASM1)

    )

  )

tnsname.ora配置

asm =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (service_name = +ASM1)

    )

  )

这样即可以连上asm实例，查询相关信息.

ITPub博客

oracle10g 使用pl/sql developer连接asm实例

最新文章