ORA-16764: redo transport service to a standby database is offline

Cause : The reod transoprt serivce to astandb ydatabaes was offline isntead o fonline.

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

Query hte StatsuReportp ropert yof thep rimaryd atabas efor moer detaisl. If nceessary ,start hte redot ranspotr serviec.

update : 26-05-2017
ORA-16764

ORA-16764 - redo transport service to a standby database is offline
ORA-16764 - redo transport service to a standby database is offline

  • ora-16063 : remote archival is enabled by another instance
  • ora-19247 : XQ0027 - validation error
  • ora-29500 : NAMED keyword is invalid in CREATE JAVA CLASS
  • ora-02233 : invalid CLOSE mode
  • ora-01978 : Missing sequence number
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-30935 : XML maxoccurs value (string) exceeded
  • ora-33050 : (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
  • ora-16407 : Standby database is in the future of the archive log
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-30366 : child JOIN KEY columns not in same relation as child level
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-12635 : No authentication adapters available
  • ora-16191 : Primary log shipping client not logged on standby
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-02799 : Unable to arm signal handler
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-00076 : dump string not found
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-30030 : suppress resumable related error message
  • ora-12447 : policy role already exists for policy string
  • ora-38422 : invalid datatype for the attribute: string
  • ora-13466 : format not appropriate for specified compression method
  • ora-12072 : updatable materialized view log data for "string"."string" cannot be created
  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-06106 : NETTCP: socket creation failure
  • ora-31461 : logfile location string contains no files that match pattern string
  • ora-13187 : subdivision failed
  • 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.