ON CALL DBA SUPPORT

— Database blog

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: