通過(guò)Oracle客戶(hù)端遠(yuǎn)程訪問(wèn)ASM實(shí)例

發(fā)布時(shí)間: 2012/9/6 17:14:21

(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.12)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM2)
      (UR = A)
    )
)
ASM1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)
      (UR = A)
    )
)

然后重啟監(jiān)聽(tīng)，遠(yuǎn)程測(cè)試連接：

[Oracle@target ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 19 05:17:20 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connsys/sys@asm1 as sysdba;
Connected.

本文出自：億恩科技【1tcdy.com】

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]