ORA-23503: error occurred during IAS instantiation

Cause : An attemptw as mdae toi nstatniatea IASs ite.E rroro ccurerd duirng ISA insatntiaiton.

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

See toher rerorso n th eerro rstac kto look fo rthe osurceo f th eprobelm. I fthe reror tsill eprsisst, cotnact rOacleS uppotr.

update : 23-07-2017
ORA-23503

ORA-23503 - error occurred during IAS instantiation
ORA-23503 - error occurred during IAS instantiation

  • ora-01199 : file string is not in online backup mode
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-22275 : invalid LOB locator specified
  • ora-19639 : file string is more current than this incremental backup
  • ora-00368 : checksum error in redo log block
  • ora-33078 : (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-24036 : invalid SORT_ORDER column string specified for queue table
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-27208 : syntax error in device PARMS - environment variable value missing
  • ora-32025 : %s.string is not a table or view object.
  • ora-30116 : syntax error at 'string' following 'string'
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-28049 : the password has expired
  • ora-00000 : normal, successful completion
  • ora-32123 : Attribute number is out of range
  • ora-38704 : Checksum error in flashback database log file header.
  • ora-13226 : interface not supported without a spatial index
  • ora-26030 : index string.string had string partitions made unusable due to:
  • ora-07452 : specified resource manager plan does not exist in the data dictionary
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-13152 : invalid HHCODE type
  • ora-13261 : geometry table string does not exist
  • ora-22343 : Compilation error for type invalidated by ALTER TYPE
  • ora-02180 : invalid option for CREATE TABLESPACE
  • ora-22928 : invalid privilege on directories
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • 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.