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 : 24-05-2017
ORA-23536

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-06622 : LU6.2 Driver: Unable to attach to SNA
  • ora-33462 : (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
  • ora-27021 : sequential file handle must be specified
  • ora-29808 : specified primary operator binding does not exist
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-19563 : %s header validation failed for file string
  • ora-21603 : property id [string] is invalid
  • ora-23601 : PROPAGATION_NAME string does not exist
  • ora-30054 : invalid upper limit snapshot expression
  • ora-06261 : NETNTT: nrange() failed
  • ora-02827 : Invalid file number
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-07283 : sksaprd: invalid volume size for archive destination.
  • ora-09858 : sfngat: the input file name is not in the OMF format
  • ora-24814 : operation not allowed for temporary LOBs
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-16021 : session string destination cannot be the same as session string destination
  • ora-03204 : the segment type specification should indicate partitioning
  • ora-08005 : specified row does not exist
  • ora-30087 : Adding two datetime values is not allowed
  • ora-16803 : unable to query a database table or fixed view
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-09814 : Unable to expand file name
  • ora-27452 : %s is an invalid name for a database object.
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-25196 : keyword MOVE in ALTER TABLE MOVE must immediately follow
  • ora-28521 : no heterogeneous capability information available
  • ora-02460 : Inappropriate index operation on a hash cluster
  • ora-30926 : unable to get a stable set of rows in the source tables
  • 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.