-
Title
ora_setup fails with "ORA-20000: Trigger xdb_installation_trigger does not support object creatio -
Description
When running ora_setup, you come across the following errors:
.
.
.
SPLEX.SHAREPLEX_COMMAND already exists; continuing setup . . .
SQL> CREATE SEQUENCE splex.SHAREPLEX_JOBID
MINVALUE 1
MAXVALUE 9999999999
START WITH 1
INCREMENT BY 1
CACHE 20
OCIStmtExecute: Oracle error ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SEQUENCE
ORA-06512: at line 32 -
Cause
A trigger interferes with the ora_setup process.
-
Resolution
The ora_setup is failing because of the error ORA-20000. The xdb_installation_trigger is avoiding the creation of sequences.
The trigger xdb_installation_trigger may need to be disabled at least during the running of ora_setup. It can be re-enabled after successfully running ora_setup. The trigger has to do with the installation of XDB Feature. The feature is Mandatory in order to use any of the member functions of the XMLTYPE. -
Additional Information
The workaround provided above works well for our situation. If facing the above error more often (other than with ora_setup), you may want to refer to Metalink Doc ID: Note:559632.1 that provides a permanent solution.