6 Replies Latest reply: Feb 22, 2011 4:09 AM by hqt200475 RSS

    Alter  diagnostic_dest to ASM

    hqt200475
      Hi

      I have the following ASM-Volumgroups on REDHAT 5.4/Oracle 11.2.0.2/X86.64:

      /home/grid>asmcmd
      ASMCMD> ls
      CRS/
      DATA/
      FLASH/


      The database STRM has its Data on +DATA

      ASMCMD> ls -l +DATA/STRM
      Type Redund Striped Time Sys Name
      Y CONTROLFILE/
      Y DATAFILE/
      Y ONLINELOG/
      Y PARAMETERFILE/
      Y TEMPFILE/
      N spfileSTRM.ora => +DATA/STRM/PARAMETERFILE/spfile.259.743361239
      ASMCMD>

      and tried to change the Parameter diagnostic_dest in init.ora.

      But I got always the following error:

      SQL> startup;
      ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
      ORA-48140: the specified ADR Base directory does not exist [+DATA]
      ORA-48187: specified directory does not exist
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 1
      SQL>

      Can any expert helps?

      Thanks

      hqt200475