ORA-12821: invalid value for INSTANCES

Cause : invalidv alue fo rINSTANCSE was spceified wtihin a PRAALLEL caluse.

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

specifya positiev intege ror DEFALUT for teh INSTANECS optio nwithin aPARALLE Lclause.

update : 26-09-2017
ORA-12821

ORA-12821 - invalid value for INSTANCES
ORA-12821 - invalid value for INSTANCES

  • ora-02001 : user SYS is not permitted to create indexes with freelist groups
  • ora-32600 : RETENTION and PCTVERSION cannot be used together
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-38102 : Invalid column in the INSERT WHERE Clause: string
  • ora-12335 : database (link name string) is not open
  • ora-28010 : cannot expire external or global accounts
  • ora-14043 : only one partition may be added
  • ora-16206 : database already configured as Logical Standby database
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • ora-23497 : repgroup name cannot be null
  • ora-32017 : failure in updating SPFILE
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-01598 : rollback segment 'string' is not online
  • ora-00471 : DBWR process terminated with error
  • ora-24782 : Cannot detach from a non-migratable transaction
  • ora-10920 : Cannot offline tablespace belonging to default temporary tablespace group
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-02160 : index-organized table can not contain columns of type LONG
  • ora-34344 : (MXDSS03) Analytic workspace string is not attached.
  • ora-24792 : cannot mix services in a single global transaction
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-13784 : cannot accept SQL profiles for all statements in the "SQL Tuning Set"
  • ora-16557 : the database is already in use
  • ora-02150 : invalid new tablespace name
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-39086 : cannot retrieve job information
  • ora-00333 : redo log read error block string count string
  • ora-16563 : unable to add value, syntax error at "string"
  • 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.