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 : 26-04-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-08454 : more than one S symbol specified in picture mask
  • ora-27000 : skgfqsbi: failed to initialize storage subsystem (SBT) layer
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-04077 : WHEN clause cannot be used with table level triggers
  • ora-19230 : XP0010 - unsupported axis string
  • ora-26031 : index maintenance error, the load cannot continue
  • ora-28026 : user with same external name already exists
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-39149 : cannot link privileged user to non-privileged user
  • ora-13461 : the interleaving type is not supported
  • ora-28267 : Invalid NameSpace Value
  • ora-02809 : Jump buffer not valid
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-13907 : Threshold value is invalid.
  • ora-19594 : control file already included as string
  • ora-06133 : NETTCP: file not found
  • ora-30990 : insufficient privileges to change owner of resource string
  • ora-07700 : sksarch: interrupt received
  • ora-00204 : error in reading (block string, # blocks string) of control file
  • ora-40104 : invalid training data for model build
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-02463 : Duplicate HASH IS option specified
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-24784 : Transaction exists
  • ora-06523 : Maximum number of arguments exceeded
  • ora-25442 : too many column values for table alias: string
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • 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.