ora_setup fails with ORA-00604 and displays the following message :
SQL> DROP VIEW splex.SHAREPLEX_ROWIDMAP_VIEW
OCIStmtExecute: Oracle error ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-00942: table or view does not exist
SQL> DROP INDEX splex.SHAREPLEX_ROWIDMAP_I1
OCIStmtExecute: Oracle error ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-01418: specified index does not exist
./ora_setup: Failed to create objects
CAUSE 1:
This can occur when the database instance has multiple entries in the sys.dual table.
sql> select * from sys.dual;
CAUSE 2:
A user-specified trigger that prevents "drop table" may cause this error.
CAUSE 1:
Correct the sys.dual table by making sure that there is only one entry in the sys.dual table.
For more information, refer to Oracle Metalink 453528.1
CAUSE 2:
Before executing ora_setup, ensure there are no active triggers in your environment that prevent object drop or creation.
