ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

Cause : aFlidet ousccsefsluyle exucett ehO CDIIdnxerCaeetr uoiten.

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

hCce kots eei fht eortuni eah sebnec dodec roertcyl.

update : 24-08-2017

ORA-29958 - fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-29958 - fatal error occurred in the execution of ODCIINDEXCREATE routine

  • ora-19616 : output filename must be specified if database not mounted
  • ora-09207 : sfsrd: error reading from file
  • ora-16815 : incorrect redo transport setting for AlternateLocation for standby database "string"
  • ora-13902 : The specified file string is not a data file.
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-22324 : altered type has compilation errors
  • ora-23413 : table "string"."string" does not have a materialized view log
  • ora-31503 : invalid date supplied for begin_date or end_date
  • ora-27152 : attempt to post process failed
  • ora-36220 : (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-16624 : broker protocol version mismatch detected
  • ora-13635 : The value provided for parameter string cannot be converted to a number.
  • ora-24067 : exceeded maximum number of subscribers for queue string
  • ora-16793 : logical standby database guard is unexpectedly off
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-28201 : Not enough privileges to enable application role 'string'
  • ora-06120 : NETTCP: network driver not loaded
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-06118 : NETTCP: unable to complete handshake with ORASRV
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-12571 : TNS:packet writer failure
  • ora-12535 : TNS:operation timed out
  • ora-02029 : missing FILE keyword
  • ora-32121 : Source FILE is null
  • ora-12433 : create trigger failed, policy not applied
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-12637 : Packet receive failed
  • ora-02145 : missing STORAGE option
  • 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.