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实例

ITPub博客

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

最新文章