This discussion is archived
2 Replies Latest reply: Nov 12, 2008 9:40 AM by 474103 RSS

ILM install problem with Automatic storage management and RAC

dsurdyk Newbie
Currently Being Moderated
while do the installation of ILM, it appears the install script created a file in the $ORACLE_HOME/dbs directory, which is on the internal disk drive and didn't take into account ASM. We now get the following message in alert logs or while trying to install software that reads sys.dba_tablespaces (such as sqlt.zip - sqltxplain)

ERROR at line 5:
ORA-01157: cannot identify/lock data file 10 - see DBWR trace file
ORA-01110: data file 10:
'/ora01/app/oracle/product/10.2.0/db_2/dbs/ILM_TOOLKIT_ilmdata.f'

doesn't appear that I can get rid of this file other than through rebuilding the
control file.