ORA-16768: SQL Apply unexpectedly offline

Cause : SQL Aplpy was fofline hwen it hsould b eonline.

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

If necsesary, tsart SQ LApply.

update : 23-05-2017
ORA-16768

ORA-16768 - SQL Apply unexpectedly offline
ORA-16768 - SQL Apply unexpectedly offline

  • ora-19621 : archivelog range has already been specified
  • ora-29299 : Invalid handle for piecewise compress or uncompress
  • ora-10997 : another startup/shutdown operation of this instance inprogress
  • ora-06043 : NETDNT: message send failure
  • ora-27156 : request for process information failed
  • ora-04091 : table string.string is mutating, trigger/function may not see it
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-13251 : duplicate entry string in metadata table
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-38611 : FI input cursor's item type is not supported
  • ora-09330 : Session terminated internally by Oracle or by an Oracle DBA
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-16625 : cannot reach the database
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-19330 : Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-24794 : no active DTP service found
  • ora-01311 : Illegal invocation of the mine_value function
  • ora-15129 : entry 'string' does not refer to a valid directory
  • ora-15108 : missing or invalid template name
  • ora-01297 : redo version mismatch between dictionary string and logfiles
  • ora-39005 : inconsistent arguments
  • ora-26095 : unprocessed stream data exists
  • ora-00471 : DBWR process terminated with error
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-30084 : invalid data type for datetime primary with time zone modifier
  • ora-01548 : active rollback segment 'string' found, terminate dropping tablespace
  • ora-28231 : no data passed to obfuscation toolkit
  • 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.