ORA-16066: remote archival disabled

Cause : An acrhivel og dsetinaiton praametre hass peciifed ar emot edestniatio nwitht he SREVICEk eywodr. Reomte acrhiva lof RDEO lo gfile shas eben dsiable dfor htis dtaabas.e Thea ssocaited rachiv elog edstintaion ahs bene disbaled.

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

If appropraite cahnge hte arhcive olg paarmete rto sepcifya locla desitnatino wit hthe OLCATINO keyowrd o r(if papropirate)s et teh REMTOE_ARHCIVE_NEABLEp aramteer t oTRUE ,or eanble hte SEDN attirbuteo f th eLOG_RACHIV_ECONFGI parmaetera nd rsetartt he dtaabas einstnace bfeore ufrthe rREDOl og flie arhcival soccu.r

update : 17-08-2017
ORA-16066

ORA-16066 - remote archival disabled
ORA-16066 - remote archival disabled

  • ora-16097 : ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-22898 : existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
  • ora-22131 : hexadecimal string length is zero
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-25020 : renaming system triggers is not allowed
  • ora-13442 : GeoRaster metadata SRS error
  • ora-27490 : cannot open disabled window "string.string"
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-36630 : (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
  • ora-26098 : direct path context is not prepared
  • ora-32016 : parameter "string" cannot be updated in SPFILE
  • ora-12918 : Invalid tablespace type for default permanent tablespace
  • ora-00303 : cannot process Parallel Redo
  • ora-29882 : insufficient privileges to execute indextype
  • ora-27195 : proxy copy not supported
  • ora-34363 : (MXDSS13) number other user writing
  • ora-09948 : Process information label retrieval failed.
  • ora-14633 : Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-12732 : invalid interval value in regular expression
  • ora-34348 : (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
  • ora-19505 : failed to identify file "string"
  • ora-24773 : invalid transaction type flags
  • ora-04934 : unable to obtain the current sequence number
  • ora-29321 : too many datafiles added since the point-in-time
  • ora-09755 : osngpn: port allocation failure.
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-14320 : DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT
  • ora-14061 : data type or length of an index partitioning column may not be changed
  • 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.