oracle10g 使用pl/sql developer連線asm例項

tolilong發表於2013-04-11
OracleSQLDeveloperASM
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章