ON CALL DBA SUPPORT

— Database blog

Archive for March, 2014

ORA-15000: command disallowed by current instance type

Posted by ssgottik on 05/03/2014

ORA-15000: command disallowed by current instance type

When you try to connect to ASM instance remotly you will get this error:

SOLUTION :

connect to the ASM instance as sysasm :

$ sqlplus
SQLPLUS > CONNECT SCOTT/TIGER AS SYSASM

If above fix did not worked for you, then you have to add one more step:

1. Take the backup of the listener.ora file.

2. stop the lisneter :

$lsnrctl stop listener

3. Add below entry to listener.ora file :

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = +ASM)
(ORACLE_HOME = /u01/app/oracle/product/11g/grid)
)
)

3. Start listener :

$lsnrctl start listener

TNS ENTRY :

ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VMLINUX1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASM)(INSTANCE_NAME = +ASM)(UR=A)
)
)

Advertisements

Posted in ASM | Leave a Comment »