Ora_setup failed to create objects with ORA-00604 (4335524)

When ora_setup it run , it fails 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 if the the  database instance has multiple entires in the dual table.

select * from dual; >> return one entry

create table my_dual as select * from dual;

select * from my_dual; >> return two entries

CAUSE 2:

A user specified trigger that avoids "drop table" will cause this issue.

For CAUSE 1:

Correct the Dual Table.

Make sure that there is only one entry in the dual table.

For more info refer to oracle metalink 453528.1

For CAUSE 2:

Turn on logon TKPROF for SYSDBA and SHAREPLEX database users that you are inputting on ora_setup.

See if any triggersd are being executed for the sessions that were running ora_setup.