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 : 28-05-2017
ORA-12815

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

  • ora-16534 : no more requests accepted
  • ora-00030 : User session ID does not exist.
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-09285 : sllfop: unrecognizable processing option, incorrect format
  • ora-12341 : maximum number of open mounts exceeded
  • ora-24184 : transformation string.string already exists
  • ora-00334 : archived log: 'string'
  • ora-26502 : error resignal
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-39174 : Encryption password must be supplied.
  • ora-26521 : rpc initialization error
  • ora-24317 : define handle used in a different position
  • ora-39304 : conflicting changes to object "string" : string
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-29510 : name, string.string, already used by an existing object
  • ora-07755 : slemcf: fseek before read failure
  • ora-07634 : smsdbp: $CRETVA failure
  • ora-39954 : DEFERRED is required for this system parameter
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-33030 : (XSAGDNGL14) In AGGMAP workspace object, you can have either a single independent PROTECT statement or PROTECT statements in your RELATION statements.
  • ora-06261 : NETNTT: nrange() failed
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-12433 : create trigger failed, policy not applied
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-08231 : smscre: unable to attach to SGA
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-12438 : repeated policy option: string
  • ora-12224 : TNS:no listener
  • 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.