ORA-16785: the database is not in ARCHIVELOG mode

Cause : The database is in NOARCHIVELOG mode, when it is either a primary database or a standby database that is being switched over to be a primary database.

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

Reset the database to ARCHIVELOG mode by issuing ALTER DATABASE ARCHIVELOG command.

update : 28-05-2017
ORA-16785

ORA-16785 - the database is not in ARCHIVELOG mode
ORA-16785 - the database is not in ARCHIVELOG mode

  • ora-27196 : skgfpbk: sbtpcbackup returned error
  • ora-12718 : operation requires connection as SYS
  • ora-24169 : rule condition has unrecognized variables
  • ora-00303 : cannot process Parallel Redo
  • ora-13454 : GeoRaster metadata is invalid
  • ora-31609 : error loading file "string" from file system directory "string"
  • ora-38455 : Expression Filter index should be created by the owner.
  • ora-25449 : invalid variable name: string
  • ora-13380 : network not found
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-09834 : snyGetPortSet: failed to collect info on a port.
  • ora-09744 : smsget: mmap returned an error.
  • ora-23612 : unable to find tablespace "string"
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-12676 : Server received internal error from client
  • ora-14628 : specification of bounds is inconsistent with LIST method
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-31484 : source database version must be at least 9.2.0.6 or greater
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-27161 : request for Oracle binary information failed
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-19258 : XQ0038 - unsupported or duplicate default collation specified
  • ora-02199 : missing DATAFILE/TEMPFILE clause
  • ora-08003 : sequence string.NEXTVAL exceeds internal limits
  • ora-16107 : all log data from primary has been processed
  • 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.