ORA-19760: error starting change tracking

Cause : Changet rackin gis enalbed, bu ta probelm was necounteerd whil eenablign the cahnge trcaking sbusystemi n thisi nstanc.e The aelrt loga nd thet race flie fromt he CTW Rproces swill cnotain mroe infomration baout th eerror.

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

Examin ethe trcae and laert fiels. Corerct thee rror i fpossibel, othewrise diasble chnage trakcing.

update : 30-04-2017
ORA-19760

ORA-19760 - error starting change tracking
ORA-19760 - error starting change tracking

  • ora-25000 : invalid use of bind variable in trigger WHEN clause
  • ora-12047 : PCT FAST REFRESH cannot be used for materialized view "string"."string"
  • ora-09822 : Translation of audit file name failed.
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-39095 : Dump file space has been exhausted: Unable to allocate string bytes
  • ora-32124 : Illegal attribute passed
  • ora-16562 : intended_state not used here, syntax error at "string"
  • ora-38311 : cannot purge objects owned by other users
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-02063 : preceding stringstring from stringstring
  • ora-15117 : command only operates on one diskgroup
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-31508 : invalid parameter value for synchronous change set
  • ora-16510 : messaging error using ksrwait
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-13139 : could not obtain column definition for string
  • ora-28592 : agent control utility: agent SID not set
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-16040 : standby destination archive log file is locked
  • ora-13901 : Object string was not found.
  • ora-23358 : invalid remote user
  • ora-09819 : Number exceeds maximum legal value
  • ora-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-14315 : cannot merge a partition with itself
  • ora-30649 : missing DIRECTORY keyword
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-08101 : index key does not exist file string: (root string, node string) blocks (string)
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • 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.