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

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博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1060388/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1060388/