2 Replies Latest reply on Jan 17, 2012 6:40 PM by user13549752

    Syntax error setting the dgmgrl

    user13549752
      DB:11.2.0.1
      OS:Linux
      RAC:11.2.0.2


      Get the error below while trying to set it in the primary side.

      DGMGRL> edit database eioidp1_dal set property DbFileNameConvert = '+DB_ORCL_DAT0098','+DB_ORCL_DAT0099','+DB_ORCL_FRA0098','+DB_ORCL_FRA0099';
      edit database eioidp1_dal set property DbFileNameConvert = '+DB_ORCL_DAT0098','+DB_ORCL_DAT0099','+DB_ORCL_FRA0098','+DB_ORCL_FRA0099';
      ^
      Syntax error before or at ","
        • 1. Re: Syntax error setting the dgmgrl
          Helios-GunesEROL
          Hi;

          See below for syntax:
          http://docs.oracle.com/cd/B12037_01/server.101/b10822/dgmgrl.htm
          http://docs.oracle.com/cd/B28359_01/server.111/b28295/dgmgrl.htm
          http://docs.oracle.com/cd/B12037_01/server.101/b10822/cli.htm

          Regard
          Helios
          • 2. Re: Syntax error setting the dgmgrl
            user13549752
            Hi,

            DGMGRL> edit database eioidp1_dal set property 'LogFileNameConvert'='+DB_ORCL_DAT0098,+DB_ORCL_DAT0099,+DB_ORCL_FRA0098,+DB_ORCL_FRA0099';
            Property "LogFileNameConvert" updated
            DGMGRL> edit database eioidp1_dal set property 'DbFileNameConvert'='+DB_ORCL_DAT0098,+DB_ORCL_DAT0099,+DB_ORCL_FRA0098,+DB_ORCL_FRA0099';
            Property "DbFileNameConvert" updated
            DGMGRL> exit


            DGMGRL> show database verbose eioidp1_dal

            Database - eioidp1_dal

            Role: PRIMARY
            Intended State: TRANSPORT-ON
            Instance(s):
            eioidp11
            Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
            Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting

            eioidp12
            Warning: ORA-16714: the value of property DbFileNameConvert is inconsistent with the database setting
            Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the database setting