Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to connect ASM instance from remote machine

Srikanth GanesanJun 6 2016 — edited Jun 7 2016

I would like to know how to connect to ASM instance from a remote machine.I created a user 'asmdev' and granted both asmdba and sysasm privilege. But still it didn't help.

It says 'ORA-15000: command disallowed by current instance type' when I use the following method. when I connect to ASM instance +ASM1. But I am able to connect locally on that machine where ASM is running.

>>>>

[grid@racqe1 ~]$ sqlplus asmdev/asmdev@'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=10.71.113.101) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))'

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 6 19:05:19 2016

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

ERROR:

ORA-15000: command disallowed by current instance type

Enter user-name:

<<<<<

But the following work on local machine.

>>>>

[grid@racqe1 ~]$ sqlplus "asmdev/asmdev as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 6 19:06:31 2016

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> quit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

[grid@racqe1 ~]$ sqlplus "asmdev/asmdev as sysasm"

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 6 19:06:40 2016

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL>

<<<<

Any help is really appreciated. Thanks in advance.

Regards,

Srikanth

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2016
Added on Jun 6 2016
6 comments
3,550 views