ORA-23536: the object "string"."string" is not cached at the middle tier as expected.

Cause : The object may have been dropped or renamed at the back end after dbms_ias_inst.start_ias_inst was executed.

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

Check the validity of the object at the back end and retry the instantiation.

update : 16-08-2017

ORA-23536 - the object "string"."string" is not cached at the middle tier as expected.
ORA-23536 - the object "string"."string" is not cached at the middle tier as expected.

  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-14079 : illegal option for a partition marked Index Unusable
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-25455 : evaluation error for rule set: string.string, evaluation context: string.string
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-00053 : maximum number of enqueues exceeded
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-10373 : parallel query server kill event
  • ora-01625 : rollback segment 'string' does not belong to this instance
  • ora-26035 : Error attempting to encrypt or decrypt column
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-19608 : %s is not a backup piece
  • ora-24396 : invalid attribute set in server handle
  • ora-19236 : XQ0016 - module declaration or import not supported
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-32516 : cannot wait for ORADEBUG command completion; waited number ms for process string
  • ora-09949 : Unable to get client operating system privileges
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-19204 : Non-scalar value 'string' is marked as XML attribute
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-12683 : encryption/crypto-checksumming: no Diffie-Hellman seed
  • ora-06125 : NETTCP: ORASRV exited unexpectedly
  • ora-33022 : (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
  • ora-29326 : SET COMPATIBILITY release number higher than string
  • ora-00472 : PMON process terminated with error
  • ora-12077 : temporary updatable materialized view log does not exist
  • 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.