5 Replies Latest reply: Jul 17, 2014 4:17 AM by Roshin RSS

    DRM data files getting saved in File system

    Roshin

      Hi Team , In DRM i have 2 to 3 applications created initially 2 months ago . Now i am getting space issue in DB such that Data files are getting created on Local Filesystem . Sample file names are like below  .


      /ddtrg7/oracle/product/112/dbs/DRM_DATA

      /ddtrg7/oracle/product/112/dbs/DRM_INDEX

      /ddtrg7/oracle/product/112/dbs/DRM_PROPS

      /ddtrg7/oracle/product/112/dbs/DRM_TRANS

      /ddtrg7/oracle/product/112/dbs/DTRSPECDRM_DATA

      /ddtrg7/oracle/product/112/dbs/DTRSPECDRM_INDEX

      /ddtrg7/oracle/product/112/dbs/DTRSPECDRM_PR

      /ddtrg7/oracle/product/112/dbs/DTRSPECDRM_TRANS

      /ddtrg7/oracle/product/112/dbs/DTRDRM_DATA

      /ddtrg7/oracle/product/112/dbs/DTRDRM_INDEX

      /ddtrg7/oracle/product/112/dbs/DTRDRM_PROPS

      /ddtrg7/oracle/product/112/dbs/DTRDRM_TRANS


      We can see in the logs that data files and tablespaces were created in ASM diskgroup even during the time of installation. I think Since “/dmtng7/oracle/product/112/dbs/” is the location where DB parameter file, it could be that the location was provided as an input during installation/configuration . Request your kind help in this on How to get rid of this issue . We don't need this to be grown in File System . Please advise why these files are created.

      Request kind help in this .



      thanks, roshi