ORA-29362: plan directive string, string does not exist

Cause : A no-nexisetnt paln dierctiv ewas psecifeid fo rprocdeure PUDATEP_LAN_IDRECTVIE ofp ackaeg DBM_SRESORUCE_MNAAGER.

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

Specfiy ane xistnig plna dircetivef or udpate.

update : 28-05-2017
ORA-29362

ORA-29362 - plan directive string, string does not exist
ORA-29362 - plan directive string, string does not exist

  • ora-19764 : database id string does not match database id string in control file
  • ora-29870 : specified options are only valid for altering a domain index
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-31692 : The following SQL statement failed trying to insert a row into the Master table: string
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-22328 : object "string"."string" has errors. string
  • ora-12598 : TNS:banner registration failed
  • ora-16214 : apply stalled for apply delay
  • ora-33100 : (APABBR02) Value 'number' is not valid for the workspace object option.
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-24069 : cannot downgrade queue table string while it is being upgraded
  • ora-23446 : duplicate template site
  • ora-29276 : transfer timeout
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-12435 : invalid audit success: string
  • ora-27366 : job "string.string" is not running
  • ora-09747 : pw_detachPorts: server call pws_detach failed.
  • ora-15190 : Internal ASM testing event number 15190
  • ora-01921 : role name 'string' conflicts with another user or role name
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-16224 : Database Guard is enabled
  • ora-32586 : multiple specification of a supplemental logging attribute
  • ora-09312 : slspool: error spooling file to printer
  • ora-39021 : Database compatibility version string is not supported.
  • ora-25217 : enqueue failed, visibility must be IMMEDIATE for queue string.string
  • ora-07267 : spwat: invalid process number.
  • ora-12686 : Invalid command specified for a service
  • 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.