1 2 Previous Next 15 Replies Latest reply: Apr 4, 2014 10:40 PM by GeetaM RSS

    Error: DGMGRL> show database....

    GeetaM

      Hi Gurus

       

      I have received an alert today morning

       

      The Data Guard status of **** is Error ORA-16810: multiple errors or warnings detected for the database.

      I have logged into dgmgrl to look for more  errors and typed below commands . Please help me in fixing the issue.

       

      {code}

      DGMGRL> show database ***** statusreport;

      Object "*****" was not found

       

      DGMGRL> show configuration

       

      Configuration - ****_DG_CONFIG

          Protection Mode: MaxPerformance

        Databases:

          ****DUKE1 - Primary database

          ****DUKE2 - Physical standby database

        Fast-Start Failover: DISABLED

      Configuration Status:

      SUCCESS

      {/code}

       

      Regards

        • 1. Re: Error: DGMGRL> show database....
          mseberg

          Hello;

           

          Try

           

          Show database <db_name> InconsistentProperties ;

           

          Best Regards

           

          mseberg

          • 2. Re: Error: DGMGRL> show database....
            GeetaM

            Hi Mseberg

             

            I am still getting the same error message...i have question here regarding database name...where is it looking for db name?

             

            {code}

            DGMGRL> show database*****  inconsistent_properties

            Object "***" was not found

             

            DGMGRL> show configuration

            Configuration - *****_DG_CONFIG

              Protection Mode: MaxPerformance

              Databases:

                ****DUKE1 - Primary database

               ****DUKE2 - Physical standby database

            Fast-Start Failover: DISABLED

            Configuration Status:

            SUCCESS

            {/code}

             

            Regards

            • 3. Re: Error: DGMGRL> show database....
              mseberg

              Hello;

               

              Not sure I understand you question, but I'm thinking it's in the Broker setup.

               

              Do both database do this?

               

              Are you using a format like this?

               

              SHOW DATABASE '****DUKE1' 'inconsistent_properties' ;

               

              When all else fails do over:

               

              How to Safely Remove a Data Guard Broker Configuration (Doc ID 261336.1)

               

              Also I assume you know once you start using Broker you cannot use SQL to change your config without creating SYNC issue between the Broker setup and the Database. 

               

              Best Regards

               

              mseberg

              • 4. Re: Error: DGMGRL> show database....
                GeetaM

                Hi Mseberg

                 

                sorry not to make you understand...below are the exact commands i am using -

                 

                DGMGRL> show database pappdm  inconsistent_properties;

                ORA-16525: the Data Guard broker is not yet available

                 

                 

                Configuration details cannot be determined by DGMGRL

                 

                Regards

                • 5. Re: Error: DGMGRL> show database....
                  BPeaslandDBA

                  ORA-16525: the Data Guard broker is not yet available

                   

                   

                   

                  This means that the DMON process is not running for that database. Sign on to that database and issue:

                   

                  ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=both;

                   

                  Wait a few minutes for DMON to start and then try again.

                   

                  HTH,

                  Brian

                  • 6. Re: Error: DGMGRL> show database....
                    GeetaM

                    Here is the current dg value -

                     

                    SQL> show parameter dg

                     

                     

                    NAME                                 TYPE        VALUE

                    ------------------------------------ ----------- ------------------------------

                    dg_broker_start                      boolean     TRUE

                     

                     

                    Regards

                    • 7. Re: Error: DGMGRL> show database....
                      mseberg

                      Hello again;

                       

                      What OS is this? Windows has several issues that will throw an ORA-16525

                       

                      Best Regards

                       

                      mseberg

                      • 8. Re: Error: DGMGRL> show database....
                        GeetaM

                        Hi Mseberg

                         

                        its not windows..its linux box.sorry for the late response.

                         

                        regards

                        • 9. Re: Error: DGMGRL> show database....
                          BPeaslandDBA

                          Have you tried to stop then start DMON to see if that gets you past the ORA-16525 error? Just set DG_BROKER_START=FALSE and then do "ps -ef|grep dmon" to make sure DMON is no longer running on the nodes. Then set the parameter to TRUE.

                           

                          HTH,

                          Brian

                          • 10. Re: Error: DGMGRL> show database....
                            FreddieEssex

                            Is it perhaps a case thing...if my database name is in upper case and I don't put the database name in single quotes I get the "Object not found error:

                             

                            DGMGRL> show database MODS

                            Object "mods" was not found

                            DGMGRL> show database 'MODS'

                             

                             

                             

                            Database - MODS

                             

                             

                             

                              Enterprise Manager Name: MODS.UK.INTRANET

                              Role:                    PRIMARY

                              Intended State:          TRANSPORT-ON

                              Instance(s):

                                MODS

                             

                             

                             

                            Database Status:

                            SUCCESS

                            • 11. Re: Error: DGMGRL> show database....
                              Franck Pachot

                              Hi,

                              Yes in dgmgrl you must quote uppercase database names.

                              Regards,

                              Franck.

                              • 12. Re: Error: DGMGRL> show database....
                                GeetaM

                                Hi Franck

                                 

                                I have tried that too, here i have question for database name...what is database name?

                                 

                                DGMGRL> show database PAPPDM

                                Object "pappdm" was not found

                                 

                                Regards

                                • 13. Re: Error: DGMGRL> show database....
                                  GeetaM

                                  Hi Brian

                                   

                                  here is the output of current  dmon status

                                   

                                  dukedmps03db05 | PAPPDM5 | /home/oracle

                                  > ps -ef |grep dmon

                                  oracle     3790      1  0 Mar23 ?        00:00:56 ora_dmon_PAPPDM5

                                  oracle    56508  11262  0 11:59 pts/9    00:00:00 grep dmon

                                  root      76478      1  0 Jan13 ?        01:16:43 /u01/app/11.2.0.3/grid/bin/cssdmonitor

                                  oracle    84141      1  0 Mar25 ?        00:00:48 ora_dmon_PEDW5

                                   

                                  Regards

                                  • 14. Re: Error: DGMGRL> show database....
                                    Franck Pachot

                                    Hi,

                                    In dgmgrl the database is the one you define in the configuration with 'create configuration' for the primary or 'create database' for others.

                                    The name must match the db_unique_name, but the case can be different. In dgmgrl non quoted identifiers are translated to lower case.

                                     

                                    exemple:

                                    SQL> show parameter db_unique_name NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_unique_name                       string      U1 DGMGRL> connect / Connected as SYSDG.

                                    DGMGRL> create configuration MYCONF as primary database is U1 connect identifier is "//localhost/beta1"; Configuration "myconf" created with primary database "u1" DGMGRL> show configuration Configuration - myconf   Protection Mode: MaxPerformance   Members:   u1 - Primary database

                                    Here the name used by data guard broker is lowercase (you see it from the output where dgmgrl added the quotes after making it lowercase.

                                     

                                    In your case, it has been entered uppercase with quotes, so you must do the same.

                                     

                                    Regards,

                                    Franck.

                                    1 2 Previous Next