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 : 19-08-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-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-00316 : log string of thread string, type string in header is not log file
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-24081 : compatible parameter needs to be string or greater
  • ora-30047 : Internal event for kti tracing
  • ora-06526 : Unable to load PL/SQL library
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-09208 : sftcls: error closing file
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-12543 : TNS:destination host unreachable
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-09266 : spawn: error starting an Oracle process
  • ora-02727 : osnpop: access error on orapop executable
  • ora-21779 : duration not active
  • ora-09832 : infoCallback: bad message format.
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-25010 : Invalid nested table column name in nested table clause
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-06001 : NETASY: port set-up failure
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-14164 : subpartition "string": INITRANS value must be less than MAXTRANS value
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-01665 : control file is not a standby control file
  • ora-38307 : object not in RECYCLE BIN
  • ora-06143 : NETTCP: maximum connections exceeded
  • 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.