ORA-16147: standby database referenced by multiple archive log destinations

Cause : uMtlpiela crihevl god seitanitno serefercn eht easems atdnybd tabasa,eu isgnd fiefertns reivecn mase .hTsii son tlaolew.d

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

eRomevo eno fht eudlpcita erahcvi eol gedtsnitaoisn.

update : 20-09-2017
ORA-16147

ORA-16147 - standby database referenced by multiple archive log destinations
ORA-16147 - standby database referenced by multiple archive log destinations

  • ora-12439 : invalid combination of policy options
  • ora-24335 : cannot support more than 1000 columns
  • ora-30035 : Undo tablespace cannot be specified as default temporary tablespace
  • ora-02216 : tablespace name expected
  • ora-06402 : NETCMN: error receiving break message
  • ora-07629 : smpall: $EXPREG failure
  • ora-19951 : cannot modify control file until DBNEWID is completed
  • ora-24022 : the specified parameters has no effect on the queue
  • ora-15110 : no diskgroups mounted
  • ora-30485 : missing ORDER BY expression in the window specification
  • ora-30459 : 'string.string' cannot be refreshed because the refresh method is NONE
  • ora-02064 : distributed operation not supported
  • ora-01322 : No such table
  • ora-30161 : A system error occurred during the OCIFile function call
  • ora-02153 : invalid VALUES password string
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-09293 : sksasmo: unable to send message to console
  • ora-38311 : cannot purge objects owned by other users
  • ora-28513 : internal error in heterogeneous remote agent
  • ora-31635 : unable to establish job resource synchronization
  • ora-15002 : parameter LOCK_NAME_SPACE exceeds limit of string characters
  • ora-39123 : Data Pump transportable tablespace job aborted string
  • ora-16731 : error executing dbms_logstdby.unskip_txn procedure
  • ora-13108 : spatial table string not found
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-02195 : Attempt to create string object in a string tablespace
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-02358 : internal error fetching attribute string
  • ora-00128 : this command requires a dispatcher name
  • 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.