2 Replies Latest reply: Nov 12, 2008 11:40 AM by 474103 RSS

    ILM install problem with Automatic storage management and RAC

      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:

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