ORA-16246: User initiated abort apply successfully completed

Cause : SQL Apply was stopped using the abort option.

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

No action necessary, this informational statement is provided to record the event for diagnostic purposes.

update : 24-05-2017
ORA-16246

ORA-16246 - User initiated abort apply successfully completed
ORA-16246 - User initiated abort apply successfully completed

  • ora-24199 : message store is overflow
  • ora-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-07249 : slsget: open error, unable to open /proc/pid.
  • ora-10372 : parallel query server kill event proc
  • ora-12654 : Authentication conversion failed
  • ora-02271 : table does not have such constraint
  • ora-16563 : unable to add value, syntax error at "string"
  • ora-27004 : invalid blocksize specified
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-12079 : materialized view options require COMPATIBLE parameter to be string or greater
  • ora-01524 : cannot create data file as 'string' - file already part of database
  • ora-29393 : user string does not exist or is not logged on
  • ora-29810 : inadequate operator privileges
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-06976 : X.25 Driver: endpoint creation failure
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-23363 : mismatch of mview base table "string" at master and mview site
  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-30175 : invalid type given for an argument
  • ora-40254 : priors cannot be specified for one-class models
  • ora-12228 : TNS:protocol adapter not loadable
  • ora-38702 : Cannot update flashback database log file header.
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-09217 : sfsfs: failed to resize file
  • ora-30341 : dropped level has references
  • ora-38402 : invalid name: empty string or spaces in the name
  • ora-22910 : cannot specify schema name for nested tables
  • 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.