2 Replies Latest reply: Jun 1, 2010 10:11 AM by Srini Chavali-Oracle RSS

    diagnostic_dest parameter setting -11.2

    user9016606
      I am going to upgrade my database from 10.2 to 11.2 and i have doubt defining Diagnostic_dest parameter.
      What i understood is i have to remove all the cdump,bdump and udump parameters from pfile and add new paramet as follows

      Diagnostic_dest='data01/app/oracle'

      then while upgrade it will create all the dump folders under ORACLE_BASE and no need any further action or need different configuration for this??

      If some one can comment on this would be great.
        • 1. Re: diagnostic_dest parameter setting -11.2
          Rajesh Lathwal
          user9016606 wrote:
          I am going to upgrade my database from 10.2 to 11.2 and i have doubt defining Diagnostic_dest parameter.
          What i understood is i have to remove all the cdump,bdump and udump parameters from pfile and add new paramet as follows

          Diagnostic_dest='data01/app/oracle'

          then while upgrade it will create all the dump folders under ORACLE_BASE and no need any further action or need different configuration for this??
          Yes you are right .. In 11G , we dont require bdump/udump etc and only diagnostic_dest will be enough.

          http://www.dba-oracle.com/oracle11g/oracle_11g_diagnostic_dest_tips.htm

          http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28320/initparams071.htm

          Regards
          Rajesh
          • 2. Re: diagnostic_dest parameter setting -11.2
            Srini Chavali-Oracle
            Correct - pl see the documentation - http://download.oracle.com/docs/cd/E11882_01/server.112/e10820/initparams074.htm#REFRN10280

            HTH
            Srini