<<Back to Oracle ASM Main Page
ORA-15000: command disallowed by current instance type
$ sqlplus /nologSQL*Plus: Release 12.2.0.1.0 Production on Mon Jun 18 14:07:01 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> conn ASM_PER1
Enter password:
ERROR:
ORA-15000: command disallowed by current instance type
ASM instance accepts command allowed to ASM and RDBMS accepts command allowed to RDBMS and therefore check and re-issue the command
Action
Check following
1) Correct ORACLE_SID and ORACLE_HOME is set
2) Correct privileges is granted and is used while connecting (eg username as sysasm)
3) If connecting over listener check tnsentry is correct and tnsping resolves it
$ sqlplus /nolog
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jun 18 14:07:29 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> conn ASM_PER1 as sysasm
Enter password:
Connected.
SQL>
$ oerr ora 15000
15000, 00000, "command disallowed by current instance type"
// *Cause: The user has issued a command to a conventional RDBMS instance
// that is only appropriate for an ASM instance. Alternatively, the
// user has issued a command to an ASM instance that is only
// appropriate for an RDBMS instance.
// *Action: Connect to the correct instance type and re-issue the command.
//
Comments
Post a Comment