ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)

From:
ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)

Suitable for:
Oracle goldengate-version 11.1.1.0.0 and later
Oracle database-enterprise edition-version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms:
Below errors while dropping tablespace, datafile offline drop and even creation.

Ora-00604:error occurred at recursive SQL level 1ora-00376:file cannot is read at this timeora-01110:data file 42: ' +DATA01/TST/DATAFILE/OGG_TS02.DBF ' ora-06512:at line 1169ora-00376:file-cannot be-read at this timeora-01110:data fil E: ' +data01/tst/datafile/ogg_ts02.dbf '

Reason:
The datafile was mistakenly removed from the ASM level. OGG's DDL trigger attempts to read this nonexistent file.

Solution:

1149946.1 and 786567.1 have tried, no.

Disable the DDL trigger for Ogg, drop tablespace, and then enable DDL triggers.

Cd/u02/ggssqlplus/as sysdbasql> @ddl_disable; sql> drop tablespace tbs including contents; Sql> @ddl_enable

ORA-00604 ORA-00376 Unable to Drop a tablespace in GoldenGate (document ID 1930964.1)