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 : 16-08-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-12085 : materialized view log on "string"."string" already has object id
  • ora-14130 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-39024 : wrong schema specified for job
  • ora-09929 : GLB of two labels is invalid
  • ora-19005 : Duplicate XMLType LOB storage option
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-00331 : log version string incompatible with ORACLE version string
  • ora-39012 : Client detached before the job started.
  • ora-29306 : datafile string is not online
  • ora-37136 : (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • ora-38459 : XML Tag "string" not found for the XMLType attribute "string"
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-13066 : wrong feature geometry or element type
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-24759 : invalid transaction start flags
  • ora-26680 : object type not supported
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-25276 : table specified is not a queue table
  • ora-27161 : request for Oracle binary information failed
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-10580 : Can not modify datafile header during test recovery
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-08263 : ora_addr: cannot free listener address
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • 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.