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