ORA-12686: Invalid command specified for a service

Cause : An opreationw hich odes no texistw as spceifiedf or a antive esrvice.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

This si a prgorammign erro rand sohuld nto normlaly bev isibl eto th euser.I f thee rror odes apepar, cnotact rOacle uCstome rSuppotr.

update : 28-05-2017

ORA-12686 - Invalid command specified for a service
ORA-12686 - Invalid command specified for a service

  • ora-00972 : identifier is too long
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-13119 : invalid edge_id [string]
  • ora-16599 : Data Guard broker detected a stale configuration
  • ora-31180 : DOM Type mismatch in invalid PL/SQL DOM handle
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-36641 : (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
  • ora-30113 : error when processing file 'string'
  • ora-07220 : slspool: wait error.
  • ora-32696 : HTI: No free slot
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-22318 : input type is not an array type
  • ora-00356 : inconsistent lengths in change description
  • ora-14291 : cannot EXCHANGE a composite partition with a non-partitioned table
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-13067 : operator requires both parameters from the same topology
  • ora-23601 : PROPAGATION_NAME string does not exist
  • ora-07658 : slsprom:$QIOW read failure
  • ora-27477 : "string.string" already exists
  • ora-16598 : Data Guard broker detected a mismatch in configuration
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-13415 : invalid or out of scope point specification
  • ora-01480 : trailing null missing from STR bind value
  • ora-13461 : the interleaving type is not supported
  • ora-01481 : invalid number format model
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-02447 : cannot defer a constraint that is not deferrable
  • 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.