oracle11g使用pl/sql developer連線asm例項，步驟如下：[@more@]

1,在tnsnames.ora 配置相應的連線字串

如下：

asmasm =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.131)(PORT = 1521))
)
(CONNECT_DATA =
(SID = +ASM)
(SERVER = DEDICATED)
)
)

2,tnsping asmasm是否通:

C:UsersFounder>tnsping asmasm

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-2月 -2013 10:03:02

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
D:appproduct11.2.0dbhome_1networkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.131)(PORT = 1521))) (
CONNECT_DATA = (SID = +ASM) (SERVER = DEDICATED)))
OK (10 msec)

3,在cmd中執行如下:

都可以連線asm例項

C:UsersFounder>sqlplus sys/oracle@asmasm as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 1 10:03:48 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

C:UsersFounder>sqlplus sys/oracle@asmasm as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 1 10:04:00 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL>

SQL> show parameter instance

NAME TYPE VALUE
------------------------------------ ---------------------- ---------------------------
cluster_database_instances integer 1
instance_name string +ASM
instance_number integer 1
instance_type string asm

4,在pl/sql developer中

username 輸入 sys

password 輸入 oracle (密碼)

database 輸入 asmasm

connect as 選擇sysdba

即可連線asm例項

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

相關文章