Archive for May, 2014

EM12c will not delete database system targets after dropping database

May 23, 2014 Leave a comment

Had an issue where I dropped a few database and i wanted to remove these from em12c , Once I deleted the databases from EM12c , I was left with the database system targets in am unknown state


When I tried deleting these targets in EM12c it threw the following error


Found a solution to delete these target using emcli

make sure all the targets belonging to the system are removed successfully.

Setup -> Manage Cloud Control -> Health Overview -> click on ‘Deleted Targets’ link -> ‘Time Deleted Column’ should have a date.


/u01/app/oracle/middleware12.1.0.3/oms/bin/emcli login -username=SYSMAN -password=xxxxx
/u01/app/oracle/middleware12.1.0.3/oms/bin/emcli  sync 
/u01/app/oracle/middleware12.1.0.3/oms/bin/emcli  delete_target -name="APPSH3.cpp_sys" -type="oracle_dbsys"
/u01/app/oracle/middleware12.1.0.3/oms/bin/emcli  delete_target -name="DBAH3.cpp_sys" -type="oracle_dbsys"
/u01/app/oracle/middleware12.1.0.3/oms/bin/emcli delete_target -name="H3PRE.cpp_sys" -type="oracle_dbsys"
Categories: cloud control1 2c

ORA-01187: cannot read from file 201 because it failed verification tests

May 15, 2014 Leave a comment

you will see the ORA-01187 error mainly when

1. you duplicate your database.
2. you trying to take backup controlfile to trace

when you query dba_temp_files you will see the error
SQL> select FILE_NAME,BYTES from dba_temp_files;
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 204: ‘/u11_2/oradata/nppxch/temp_mi02.dbf’

so to fix the error you can

SQL> alter tablespace TEMP_MI add tempfile '/u10_2/oradata/nppxch/temp_mi01.dbf' size 100M;

Tablespace altered.

SQL> alter database tempfile '/u10_2/oradata/nppxch/temp_mi02.dbf' drop;

Database altered.

This should resolve your issue.

Categories: Oracle