1 2 3 4 Previous Next 58 Replies Latest reply: Nov 18, 2013 5:13 AM by petra-K Go to original post RSS
      • 15. Re: DG Primary Not sending arch to Standby

        Hi Anar,

         

        This is the alert log found in primary:

         

        Fatal NI connect error 12504, connecting to:

        (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521))(SERVER=DEDICATED)(SERVICE_NAME=orcl)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=server1.localdomain)(USER=oracle))))

         

         

          VERSION INFORMATION:

                TNS for Linux: Version 11.2.0.2.0 - Production

                TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production

          Time: 14-NOV-2013 00:45:07

          Tracing not turned on.

          Tns error struct:

            ns main err code: 12564

         

         

        TNS-12564: TNS:connection refused

            ns secondary err code: 0

            nt main err code: 0

            nt secondary err code: 0

            nt OS err code: 0

        Error 12504 received logging on to the standby

        PING[ARCp]: Heartbeat failed to connect to standby 'orcl_stby'. Error is 12504.

         

        ================

         

        But why is that I can connect to SERVER2 (standby db) using:

         

        sqlplus sys/oracle@server2:1521/orcl_stby as sysdba

         

        I can also TNSPING orcl_stby

         

        Thanks

        • 16. Re: DG Primary Not sending arch to Standby
          Anar Godjaev

          in Standby Location listener is up? if no please start listener

           

          And please paste here listener.ora in Standby location

           

          And please paste here tnsnames.ora in Primary database

          • 17. Re: DG Primary Not sending arch to Standby

            Hi Anar,

             

            I run "lsnrctl status" on both server and they are up.

             

            Wait I will cut n paste the listener.ora ....brb

            • 18. Re: DG Primary Not sending arch to Standby

              Hi Anar,

               

              Here it is:

               

              # PRIMARY

              # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora

              # Generated by Oracle configuration tools.

               

               

              LISTENER_ORCL =

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

               

               

               

               

              ORCL =

                (DESCRIPTION =

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

                  (CONNECT_DATA =

                    (SERVER = DEDICATED)

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              ORCL_STBY =

                (DESCRIPTION =

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

                    (SERVER = DEDICATED)

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              TTORCL =

                (DESCRIPTION =

                  (ADDRESS_LIST =

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

                  )

                  (CONNECT_DATA =

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              =====================================

              # STANDBY

              # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

              # Generated by Oracle configuration tools.

               

               

              LISTENER_ORCL =

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

               

               

               

               

              ORCL =

                (DESCRIPTION =

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

                  (CONNECT_DATA =

                    (SERVER = DEDICATED)

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              ORCL_STBY =

                (DESCRIPTION =

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

                  (CONNECT_DATA =

                    (SERVER = DEDICATED)

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              TTORCL =

                (DESCRIPTION =

                  (ADDRESS_LIST =

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

                  )

                  (CONNECT_DATA =

                    (SERVICE_NAME = orcl)

                  )

                )

               

               

              ===========================================

              At Primary

               

               

              [oracle@server1 trace]$ lsnrctl status

               

               

              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 14-NOV-2013 02:25:37

               

               

              Copyright (c) 1991, 2010, Oracle.  All rights reserved.

               

               

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)))

              STATUS of the LISTENER

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

              Alias                     LISTENER

              Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

              Start Date                13-NOV-2013 17:36:03

              Uptime                    0 days 8 hr. 49 min. 34 sec

              Trace Level               off

              Security                  ON: Local OS Authentication

              SNMP                      OFF

              Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora

              Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/server1/listener/alert/log.xml

              Listening Endpoints Summary...

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.localdomain)(PORT=1521)))

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.localdomain)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW)))

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server1.localdomain)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))

              Services Summary...

              Service "orcl" has 1 instance(s).

                Instance "orcl", status READY, has 2 handler(s) for this service...

              Service "orclXDB" has 1 instance(s).

                Instance "orcl", status READY, has 1 handler(s) for this service...

              The command completed successfully

              ===================================================

               

               

              At Standby

               

               

              [oracle@server2 trace]$ lsnrctl stat

               

               

              LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 14-NOV-2013 02:27:12

               

               

              Copyright (c) 1991, 2010, Oracle.  All rights reserved.

               

               

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521)))

              STATUS of the LISTENER

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

              Alias                     LISTENER

              Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

              Start Date                14-NOV-2013 00:20:34

              Uptime                    0 days 2 hr. 6 min. 38 sec

              Trace Level               off

              Security                  ON: Local OS Authentication

              SNMP                      OFF

              Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora

              Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/server2/listener/alert/log.xml

              Listening Endpoints Summary...

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server2.localdomain)(PORT=1521)))

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server2.localdomain)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW)))

                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server2.localdomain)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))

              Services Summary...

              Service "orcl_stby" has 1 instance(s).

                Instance "orcl", status READY, has 1 handler(s) for this service...

              The command completed successfully

              • 19. Re: DG Primary Not sending arch to Standby
                Anar Godjaev

                please show me :

                 

                In Primary

                 

                SQl> show parameter LOG_ARCHIVE_DEST

                • 20. Re: DG Primary Not sending arch to Standby

                  Hi Anar,

                   

                  There are lots of list but only LOG_ARCHIVE_DEST_2 has value :

                  SERVICE=orcl_stby NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_stby

                  • 21. Re: DG Primary Not sending arch to Standby
                    Anar Godjaev

                    HI,

                     

                    I am very sure of that there is a problem in your tnsnames.ora and parameter file. you would better control  listener.ora tnsnames.ora ve spfile(it can be also init.ora) in both database check again.

                     

                    Thank you

                    • 22. Re: DG Primary Not sending arch to Standby

                      Is there a way to validate it? can  create pfile from spfile and paste the output on both primary and stanyby?

                      • 23. Re: DG Primary Not sending arch to Standby
                        Anar Godjaev

                        can you please send me e-mail :  anar.godjaev@gmail.com         

                         

                        Primary and Standby :

                         

                        1) Tnsnames.ora

                        2) listener.ora

                        3) spfile ((it can be also init.ora)

                         

                        I need to analyze it

                         

                        Thank you

                         

                         


                        • 25. Re: DG Primary Not sending arch to Standby

                          Ok, I will email it also

                           

                          Thanks,

                           

                          going home now its late.

                          • 26. Re: DG Primary Not sending arch to Standby

                            Hi Anar,

                             

                            Files sent to your email.

                             

                            Thanks

                            • 27. Re: DG Primary Not sending arch to Standby
                              Anar Godjaev

                              Hi,

                              Thank you for response:

                               

                              In Standby Database:

                               

                              1. sqlplus "/ as sysdba"

                              2. select name from v$services;

                               

                              and paste here  resut

                              • 28. Re: DG Primary Not sending arch to Standby
                                Anar Godjaev

                                Hi,

                                 

                                please connect to oracle user in Primary database and copy orapw password.

                                 

                                bash-3.2$ scp /u01/app/oracle/product/11.2.0/db_1/dbs/orapwXXX Standby_ip:/u01/app/oracle/product/11.2.0/db_1/dbs/orapwXXX

                                orapwXXX1         100% |**************************************************************************************************************************************************|  2048       00:00

                                  

                                Thank you

                                • 29. Re: DG Primary Not sending arch to Standby

                                  Hi Anar,

                                   

                                  [oracle@server1 dbs]$ scp orapworcl 192.168.56.102:/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs

                                  oracle@192.168.56.102's password:

                                  scp orapworcl 192.168.56.102:/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs

                                  oracle @192.168.56.102's password:

                                  orapworcl                                                                     100% 1536     1.5KB/s   00:00

                                   

                                   

                                   

                                    1* select * from v$services

                                  SQL> /

                                           0

                                           0

                                  orclXDB

                                                             0 NONE         N NO  SHORT

                                   

                                   

                                           0 orcl_stby

                                  1238890504

                                  orcl_stby

                                                             0 NONE         N NO  SHORT

                                   

                                   

                                           0 SYS$BACKGROUND

                                  165959219

                                   

                                   

                                                             0 NONE         N NO  SHORT

                                   

                                   

                                           0 SYS$USERS

                                  3427055676

                                   

                                   

                                                             0 NONE         N NO  SHORT