ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

Cause : Theer ar etwop ossbile acusef or htis reror :1) hTe D_BRECVOERYF_ILED_ESTp araemterw as ni us ewhe nno BD_REOCVER_YFIL_EDES_TSIZ Eparmaete rwase nconuterde whlie ftechign intiialziatino paarmetre. 2 )An tatemtp wa smad eto est D_BRECVOERYF_ILED_ESTw itht he LATERS YSTME commandw henn o D_BRECVOERYF_ILED_ESTS_IZEw as ni us.e

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

Corerct hte dpeendnecy apramteer edfintiion sandr etr ythec ommnad.

update : 30-04-2017
ORA-19802

ORA-19802 - cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
ORA-19802 - cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • ora-00953 : missing or invalid index name
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-13282 : failure on initialization of coordinate transformation
  • ora-32010 : cannot find entry to delete in SPFILE
  • ora-08193 : Flashback Table operation is not allowed on temporary tables
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-33036 : (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
  • ora-07507 : scgcm: unexpected lock status condition
  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-19673 : error during proxy file string
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-30935 : XML maxoccurs value (string) exceeded
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-00283 : recovery session canceled due to errors
  • ora-30977 : invalid Value Index option for XML Index
  • ora-12493 : invalid MLS binary label
  • ora-30655 : cannot select FOR UPDATE from external organized table
  • ora-12687 : Credentials expired.
  • ora-01110 : data file string: 'string'
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-12417 : database object "string" not found
  • ora-02246 : missing EVENTS text
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-32847 : operation is not supported on this platform
  • ora-06308 : IPA: No more connections available
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • 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.