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