7 Replies Latest reply: Jun 4, 2014 3:43 PM by XM RSS

    Configure Broker - error 12514

    XM

          
      Hello,

      I am trying to configure the Dataguard Broker, but I have a problem.
      In the v$dataguard_status I got the following error:

       

      12514 PING[ARC1]: Heartbeat failed to connect to standby '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=oradr)(PORT=1521)))
      (CONNECT_DATA=(SERVICE_NAME=orcl_pstby_XPT)(INSTANCE_NAME=orcl_pstby)(SERVER=dedicated)))'. Error is 12514.

       

      I know the service name orcl_pstby_XPT doesn't exist on the standby server.
      Why Broker always create the configuration appending "_XPT" to service_name? This results in above error.

       

      log_archive_dest_2                   string      service="(DESCRIPTION=(ADDRESS
                                                       _LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=oradr)(PORT=1521)))(CONNECT_DATA=(SERV
                                                       ICE_NAME=orcl_pstby_XPT)(INSTANCE_NAME=ORCL_PSTBY)(SERVER=dedica
                                                       ted)))",    LGWR ASYNC NOAFFIRM delay=0 OPTIONAL max_failure
                                                       =0 max_connections=1   reopen=300 db_unique_name="orcl_pstby"
                                                       register net_timeout=180  valid_for=(online_logfile,primary_role)


      When I configure the broker I do:

       

      -- primary and standby:
      ALTER SYSTEM SET DG_BROKER_START=TRUE;

       

      -- standby:
      alter database recover managed standby database cancel;

       

      -- primary:
      DGMGRL> connect sys/pwd
      DGMGRL> create configuration orcl_cfg as primary database is orcl connect identifier is 'orcl';
      DGMGRL> add database 'orcl_pstby' as connect identifier is 'orcl_pstby' maintained as physical;
      DGMGRL> enable configuration;

       

      What should I do?

       

      Thank you!!!!

        • 1. Re: Configure Broker - error 12514
          mseberg

          Hello;

           

          Would expect to see message - Database 'orcl_pstby' added - after the command below.

           

          add database 'orcl_pstby' as connect identifier is 'orcl_pstby' maintained as physical;

           

          Did you add _DGMGRL entires first?

           

          Does you tnsnames have orcl_pstby_XPT in it?


          http://docs.oracle.com/cd/E11882_01/server.112/e40771/troubleshooting.htm#DGBKR1020


          Additional Notes


          On both the primary and standby DB, change the initialization parameter to enable the dataguard broker.

           

          SQL> alter system set dg_broker_start=True scope=both;

           

          add database 'orcl_pstby' as connect identifier is 'orcl_pstby' maintained as physical;

           

          The second instance of orcl_pstby above, the one in the connect identifier command, is the service name through which the broker is connected to the STANDBY database, the one from the tnsnames.ora.

           

           

          After you enable configuration check it:

           

          DGMGRL> show configuration verbose

           

           

          DGMGRL needs a special entry in the listener.ora.

           

          Check this

           

          Automatic Restart of Databases during Switchover fail with ORA-12514 in DGMGRL (Doc ID 308943.1)





          Best Regards


          mseberg

           

          Message was edited by: mseberg

          • 2. Re: Configure Broker - error 12514
            XM

            Hi,

            Well, now I added the line with GLOBAL_DBNAME with _DGMGRL and I create the service with XPT too.
            Now I can see the transportation of archives to standby and the oracle processes apply these archives.
            Its everything syncronized.
            But, when I issue the show configuration on DGMGRL on primary database, I see the standby as disabled:

            DGMGRL> show database 'orcl_pstby';

            Database
              Name:            orcl_pstby
              Role:            PHYSICAL STANDBY
              Enabled:         NO
              Intended State:  ONLINE
              Instance(s):
                orcl_PSTBY

            Current status for "orcl_pstby":
            Error: ORA-16795: database resource guard detects that database re-creation is required

            • 3. Re: Configure Broker - error 12514
              mseberg

              Hello again;

               

              Check your

               

              drc*.log files for more details on this error.

               

              The broker log file is created in the same directory as the alert log.

               

              This may help depending upon the error.

               

              http://www.oracle-ckpt.com/?s=roll+forward&op.x=0&op.y=0

               

              Best Regards

               

              mseberg

              • 4. Re: Configure Broker - error 12514
                XM

                Hello,

                 

                We, I see the log with the following error:

                 

                DG 2014-06-04-14:22:32        0 2 0 NSV1: DRCX returns error ORA-16603 on OPEN.

                DG 2014-06-04-14:22:32        0 2 0 NSV1: Ending metadata file transmission.

                DG 2014-06-04-14:22:32        0 2 0 NSV1: Metadata Resync failed. Status = ORA-16603

                DG 2014-06-04-14:22:32  2000000 3 849356874 DMON: Database ee_pstby returned ORA-16603

                 

                I have another question: Do I need to execute the "create configuration" on standby database too?

                 

                I create only on Oracle RAC storing the config files on ASM.

                 

                Thank you very much!!!!

                • 5. Re: Configure Broker - error 12514
                  mseberg

                  "Do I need to execute the "create configuration" on standby database too?"

                   

                  No. But you can use it from there.

                   

                  Best Regards

                   

                  mseberg

                  • 6. Re: Configure Broker - error 12514
                    XM

                    Hello,

                     

                    Its truth. I've checked the show configuration in standby.

                    So I can see the log on standby database where it tries to connect to primary, but I got error:

                     

                    DG 2014-06-04-16:30:39        0 2 0 SQL [ALTER SYSTEM REGISTER] Executed successfully

                    DG 2014-06-04-16:30:39        0 2 0 DMON: Broker Configuration orcl_cfg

                    DG 2014-06-04-16:30:39        0 2 0       Metadata Version:           2.5 / UID = 1232951554 (0x497d5902) / SEQ = 0 / MIV = 4

                    DG 2014-06-04-16:30:39        0 2 0       Protection Mode: Maximum Performance

                    DG 2014-06-04-16:30:39        0 2 0       Fast-Start Failover (FSFO): Disabled

                    DG 2014-06-04-16:30:39        0 2 0       Primary Database: orcl (01010000)

                    DG 2014-06-04-16:30:39        0 2 0       Standby Database: orcl_pstby, Enabled Physical Standby (02010000)

                    DG 2014-06-04-16:30:39        0 2 0 NSV0: Failed to connect to remote database orcl. Error is ORA-12541

                    DG 2014-06-04-16:30:39        0 2 0 NSV0: Failed to send message to site orcl. Error code is ORA-12541.

                    DG 2014-06-04-16:30:39        0 2 849357129 DMON: orcl_pstby unable to contact primary for DRC version check

                    DG 2014-06-04-16:30:39        0 2 849357129 DMON: status ORA-12541:

                     

                    So, it'v very stranger because I can execute the tnsping to orcl and I can connect with sysdba on primary using the standby server.

                     

                    Its important to alert that the primary database is a Oracle RAC with two-nodes. So the orcl (primary) entry on tnsnames.ora on standby database uses load balance:

                     

                    ORCL =(DESCRIPTION=

                    (ADDRESS = (PROTOCOL = TCP)(HOST = ora1)(PORT = 1521))

                    (ADDRESS = (PROTOCOL = TCP)(HOST = ora2)(PORT = 1521))

                    (LOAD_BALANCE = yes)(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = ORCL)))

                     

                    Thank you very much!

                    • 7. Re: Configure Broker - error 12514
                      XM

                      Hello,

                       

                      I find the problem. The log on standby server shows:

                       

                      DG 2014-06-04-16:30:39        0 2 0 NSV0: Failed to connect to remote database orcl. Error is ORA-12541

                      DG 2014-06-04-16:30:39        0 2 0 NSV0: Failed to send message to site orcl. Error code is ORA-12541.

                      DG 2014-06-04-16:30:39        0 2 849357129 DMON: orcl_pstby unable to contact primary for DRC version check

                      DG 2014-06-04-16:30:39        0 2 849357129 DMON: status ORA-12541:

                      DG 2014-06-04-16:30:39        0 2 0 DMON: cannot open configuration file "/u02/app/oracle/product/10.2.0/db_1/dbs/dr2orcl_PSTBY.dat", retrying

                      DG 2014-06-04-16:30:41        0 2 0 DMON: cannot open configuration file "/u02/app/oracle/product/10.2.0/db_1/dbs/dr2orcl_PSTBY.dat", retrying

                       

                      There are a missing file. I manually remove all metadata files on standby, remove configuration and I created again.

                      Now its working fine.

                       

                      Thank you very much!!!!