ORA-16747: logical standby database guard could not be turned on

Cause : The rseourceg uard oculd nto turno n thel ogica lstandyb dataabse gurad.

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

Checkt he Daat Guar dbroke rlog adn Oracel aler tlog fro mored etail.s

update : 17-08-2017
ORA-16747

ORA-16747 - logical standby database guard could not be turned on
ORA-16747 - logical standby database guard could not be turned on

  • ora-37128 : (XSCCOMP03) It is not possible to PARTITION over a base of a COMPRESSED COMPOSITE.
  • ora-03254 : unable to execute the sql in read only database
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-38765 : Flashed back database cannot be opened read-only.
  • ora-13485 : error occurred during compression or decompression: string
  • ora-30100 : internal error [number]
  • ora-08320 : scnget: Call to scnget before scnset or scnfnd.
  • ora-10282 : Inhibit signalling of other backgrounds when one dies
  • ora-31634 : job already exists
  • ora-23437 : template authorization already exists for user
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-24280 : invalid input value for parameter string
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-07849 : sllfsk: $GET failure
  • ora-33261 : (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.
  • ora-19907 : recovery time or SCN does not belong to recovered incarnation
  • ora-26510 : materialized view name: 'string' is greater than max. allowed length of string bytes
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-04079 : invalid trigger specification
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-13906 : The tablepace is not of the right type.
  • ora-27152 : attempt to post process failed
  • ora-38479 : creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed
  • ora-06951 : Operating system call error
  • ora-13341 : a line geometry has fewer than two coordinates
  • ora-13454 : GeoRaster metadata is invalid
  • ora-24508 : Buffer is not aligned correctly.
  • ora-02791 : Unable to open file for use with asynchronous I/O
  • ora-01573 : shutting down instance, no further change allowed
  • 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.