ORA-12828: Can't start parallel transaction at a remote site

Cause : PDML transaction cannot be started because we are not in the coordinator site of the distributed transaction.

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

Do not use PDML at remote sites.

update : 29-04-2017
ORA-12828

ORA-12828 - Can't start parallel transaction at a remote site
ORA-12828 - Can't start parallel transaction at a remote site

  • ora-30726 : cannot specify referenced column list here
  • ora-15072 : command requires at least string failure groups, discovered only string
  • ora-16825 : Fast-Start Failover and other errors or warnings detected for the database
  • ora-23609 : unable to find directory object for directory string
  • ora-19206 : Invalid value for query or REF CURSOR parameter
  • ora-06528 : Error executing PL/SQL profiler
  • ora-31512 : name cannot contain double quotation marks
  • ora-13464 : error loading GeoRaster data: string
  • ora-37030 : (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
  • ora-01283 : Options specified is invalid
  • ora-31016 : Attempted to delete entry without name
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-30108 : invalid positional parameter value 'string'
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-28539 : gateway does not support result sets
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-28116 : insufficient privileges to do direct path access
  • ora-10262 : Don't check for memory leaks
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-14638 : cannot MERGE subpartitions in different Range Composite partitions
  • ora-02263 : need to specify the datatype for this column
  • ora-03296 : cannot resize datafile - file string not found
  • ora-01743 : only pure functions can be indexed
  • ora-30045 : No undo tablespace name specified
  • ora-06254 : NETNTT: cannot share connection to cube
  • ora-26502 : error resignal
  • ora-36406 : (VCACHE00) 'number' is an invalid value for the VARCACHE option. The only permissible values are 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-32803 : value for string cannot be altered
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • 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.