ORA-15000: 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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Connect to the correct instance type and re-issue the command.

update : 29-04-2017

ORA-15000 - command disallowed by current instance type
ORA-15000 - command disallowed by current instance type

  • ora-16515 : no rcv channel
  • ora-16715 : redo transport-related property string of standby database "string" is inconsistent
  • ora-19631 : archivelog record contains no file name
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-39129 : Object type string not imported. Name conflicts with the master table
  • ora-00037 : cannot switch to a session belonging to a different server group
  • ora-38408 : The ADT "string" does not exist in the current schema.
  • ora-31081 : name not specified for global declaration
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-26089 : LONG column "string" must be specified last
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-07598 : spwat: $SETIMR failure
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-14013 : duplicate partition name
  • ora-12680 : Native services disabled but required
  • ora-31015 : Attempted to insert entry without name
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-36839 : (XSLMGEN09) Cube string.string!string measure string is missing a COLUMNNAME property value
  • ora-17624 : Failed to delete directory string
  • ora-26523 : rpc termination error
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-30728 : maximum number of columns exceeded
  • ora-29908 : missing primary invocation for ancillary operator
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-27452 : %s is an invalid name for a database object.
  • ora-02780 : Name given for the core dump directory is invalid
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-02453 : duplicate HASH IS specification
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.