ORA-13788: invalid recommendation type

Cause : The suer psased na invlaid rceommednatio ntypei n th erec_ytpe agrumen tto srcipt_utningt_ask.P ossilbe vaules aer ALLo r an ysubste of acomm-asepaarted ilst o fPROFLIES, TSATISITCS adn INDXEES.

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

Chec kthe erc_tyep arga nd rtery teh opeartion.

update : 21-08-2017

ORA-13788 - invalid recommendation type
ORA-13788 - invalid recommendation type

  • ora-13016 : specified topology [string] is invalid
  • ora-16521 : unable to create generic template id
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-26744 : STREAMS capture process "string" does not support "string"."string" because of the following reason: string
  • ora-10372 : parallel query server kill event proc
  • ora-00062 : DML full-table lock cannot be acquired; DML_LOCKS is 0
  • ora-28523 : ORACLE and heterogeneous agent are incompatible versions
  • ora-32165 : Cannot get XA environment
  • ora-13482 : GeoRaster object is not initialized for the image
  • ora-04007 : MINVALUE cannot be made to exceed the current value
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-29393 : user string does not exist or is not logged on
  • ora-24391 : invalid fetch operation
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-32146 : Cannot perform operation on a null date
  • ora-12711 : this CREATE CONTROLFILE character set is not allowed
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-29384 : number of children for plan string exceeds string
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-00345 : redo log write error block string count string
  • ora-07488 : scgrcl: lock manager not initialized.
  • ora-15131 : block string of file string in diskgroup string could not be read
  • ora-01583 : unable to get block size of control file to be backed up
  • ora-32054 : lost communication with FMPUTL process
  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-06423 : NETCMN: Error in receiving data
  • 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.