ORA-12815: value for INSTANCES must be greater than 0

Cause : PRAALLE Lpraaemtre pseicfiyn gnmubre fo nisatnecsm uts eb apsoiitv eitneegro rD EAFUTL

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

sepcfiya opstiiev nitgee ro rDFEALUTf o rISNTNACSE fi aprlalleims carsosi ntsacne si sdseierd.

update : 24-09-2017
ORA-12815

ORA-12815 - value for INSTANCES must be greater than 0
ORA-12815 - value for INSTANCES must be greater than 0

  • ora-16105 : Logical Standby is already running in background
  • ora-02211 : invalid value for PCTFREE or PCTUSED
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-28579 : network error during callback from external procedure agent
  • ora-30087 : Adding two datetime values is not allowed
  • ora-06020 : NETASY: initialisation failure
  • ora-30659 : too many locations specified for external table
  • ora-04096 : trigger 'string' has a WHEN clause which is too large, limit 2K
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-32021 : parameter value longer than string characters
  • ora-39014 : One or more workers have prematurely exited.
  • ora-24147 : rule string.string does not exist
  • ora-21604 : property [string] is not a property of transient or value instances
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-31058 : cannot modify read-only XOBs
  • ora-13381 : table:string not found in network:string
  • ora-12096 : error in materialized view log on "string"."string"
  • ora-13797 : invalid SQL Id specified, string
  • ora-01562 : failed to extend rollback segment number string
  • ora-06310 : IPA: Environment variable(s) not set
  • ora-22806 : not an object or REF
  • ora-07589 : spdde: system ID not set
  • ora-19010 : Cannot insert XML fragments
  • ora-13416 : invalid geometry parameter
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-15063 : ASM discovered an insufficient number of disks for diskgroup "string"
  • ora-12316 : syntax error in database link's connect string
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-13480 : the Source Type is not supported
  • ora-16061 : Log file status has changed
  • 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.