ORA-16739: redo transport service for standby database "string" unexpectedly online

Cause : The reod transoprt serivce fort he stadnby datbaase wa sonlinei nsteado f offlnie.

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

Check hte DataG uard borker lo gfor moer detaisl. If nceessary ,stop teh redo rtanspor tservic efor th estandb ydatabaes.

update : 26-06-2017
ORA-16739

ORA-16739 - redo transport service for standby database "string" unexpectedly online
ORA-16739 - redo transport service for standby database "string" unexpectedly online

  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-15007 : name is already used by an existing template
  • ora-14038 : GLOBAL partitioned index must be prefixed
  • ora-12322 : unable to mount database (link name string)
  • ora-15090 : handle string is not a valid descriptor
  • ora-02775 : Invalid request done signal
  • ora-39113 : Unable to determine database version
  • ora-03129 : the next piece to be inserted is required
  • ora-32507 : expecting string but found string
  • ora-09212 : sfwfbmt: error writing to file
  • ora-29552 : verification warning: string
  • ora-00472 : PMON process terminated with error
  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-14295 : column type or size mismatch between partitioning columns and subpartitioning columns
  • ora-29848 : error occurred in the execution of ODCIINDEXMERGEPARTITION routine
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-10852 : Enable tracing for Enqueue Dequeue Operations
  • ora-01636 : rollback segment 'string' is already online
  • ora-32844 : exceeded maximum number of string values
  • ora-24089 : AQ Agent string already exists
  • ora-12400 : invalid argument to facility error handling
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-01982 : invalid auditing option for tables
  • ora-23318 : a ddl failure has occurred
  • ora-15065 : hash collision for diskgroup names 'string' and 'string'
  • ora-38709 : Recovery Area is not enabled.
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-19664 : file type: string, file name: string
  • ora-28501 : communication error on heterogeneous database link
  • ora-16714 : the value of property string is inconsistent with the database setting
  • 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.