ORA-16614: object has an ancestor that is disabled

Cause : A requset to eanble ano bject htat hasa n ancetsor tha tis disbaled wa sreceivde by th ebroker .The brkoer hase nabledm anagemnet of teh objec tto thee xtent htat it acn, butc annot uflly enbale theo bject nutil it sancestro is enbaled.

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

Determnie the nacestoro bject htat is idsableda nd enalbe thata ncesto rprior ot enablnig the hcild obejct.

update : 28-04-2017
ORA-16614

ORA-16614 - object has an ancestor that is disabled
ORA-16614 - object has an ancestor that is disabled

  • ora-19624 : operation failed, retry possible
  • ora-02724 : osnpbr: cannot send break message to orapop
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-38862 : FLASHBACK DATABASE in progress
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-09980 : skxfqdrcv: Error Receiving a message from another endpoint
  • ora-01156 : recovery in progress may need access to files
  • ora-00076 : dump string not found
  • ora-12011 : execution of string jobs failed
  • ora-27094 : raw volume used can damage partition table
  • ora-06002 : NETASY: port read failure
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-31030 : Unable to retrieve XML document
  • ora-06133 : NETTCP: file not found
  • ora-12569 : TNS:packet checksum failure
  • ora-00284 : recovery session still in progress
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-25436 : invalid table alias: string
  • ora-01231 : cannot make read write - file string is offline
  • ora-37042 : (XSACQUIRE_DEP_DEADLOCK) Cannot wait to acquire composite, concat, dimension map, or internal partition workspace object since doing so would cause a deadlock.
  • ora-13601 : The specified Advisor string does not exist.
  • ora-38466 : user does not have privileges to CREATE/MODIFY expressions
  • ora-01315 : Log file has been added or removed during select
  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-19103 : VALUE keyword keyword
  • ora-02245 : invalid ROLLBACK SEGMENT name
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-09810 : Unable to get process ID from connection
  • 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.