1 2 Previous Next 21 Replies Latest reply: Jul 31, 2013 11:11 AM by Abufazal Go to original post RSS
      • 15. Re: [DataGuard][Error 12514]  Error received logging on to the standby
        Piotr91

        OK, I have created (on standby) listener.ora file with contest as follows:

         

        SID_LIST_LISTENER =

          (SID_LIST =

            (SID_DESC =

              (GLOBAL_DBNAME = primdb1)

              (ORACLE_HOME = /u01/app/oracle/product/11gR2/dbhome_1)

              (SID_NAME = primdb1)

            )

          )

         

        LISTENER =

          (DESCRIPTION_LIST =

            (DESCRIPTION =

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

            )

            (DESCRIPTION =

              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

            )

          )

         

        ADR_BASE_LISTENER = /u01/app/oracle

         

        [oracle@rh1 dbhome_1]$ bin/lsnrctl start

         

        LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 31-JUL-2013 10:35:26

         

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

         

        Starting /u01/app/oracle/product/11gR2/dbhome_1/bin/tnslsnr: please wait...

         

        TNSLSNR for Linux: Version 11.2.0.1.0 - Production

        System parameter file is /u01/app/oracle/product/11gR2/dbhome_1/network/admin/listener.ora

        Log messages written to /u01/app/oracle/diag/tnslsnr/rh1/listener/alert/log.xml

        Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.132.28.33)(PORT=1521)))

        Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

         

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

        STATUS of the LISTENER

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

        Alias                     LISTENER

        Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

        Start Date                31-JUL-2013 10:35:26

        Uptime                    0 days 0 hr. 0 min. 0 sec

        Trace Level               off

        Security                  ON: Local OS Authentication

        SNMP                      OFF

        Listener Parameter File   /u01/app/oracle/product/11gR2/dbhome_1/network/admin/listener.ora

        Listener Log File         /u01/app/oracle/diag/tnslsnr/rh1/listener/alert/log.xml

        Listening Endpoints Summary...

          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.132.28.33)(PORT=1521)))

          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

        Services Summary...

        Service "primdb1" has 1 instance(s).

          Instance "primdb1", status UNKNOWN, has 1 handler(s) for this service...

        The command completed successfully

         

        Something is wrong, I guess. Is my listener.ora file correct?

        • 16. Re: [DataGuard][Error 12514]  Error received logging on to the standby
          mseberg

          Hello;

           

          Would expect the GLOBAL_DBNAME to be:

           

           

           

          (GLOBAL_DBNAME = primdb1_DGMGRL.your.host.com)

           

           

           

           

          Might add :

           

           

          INBOUND_CONNECT_TIMEOUT_ = 120

           

           

           

          As a new line under ADR_BASE_LISTENER

           

          Make sure you restart the listener.

           

           

          Data Guard Listener Example

           

          Best Regards

           

           

          mseberg

          • 17. Re: [DataGuard][Error 12514]  Error received logging on to the standby
            Piotr91

            (GLOBAL_DBNAME = primdb1_DGMGRL.your.host.com)

            I don't get the .your.host.com. Do I need to add there an ip address of my primary db server or I have to add to my primary db server  /etc/hosts and then replace .your.host.com with name I have specified for my primdb server in /etc/hosts/?

            And could you explain why do I need to add 'DGMGRL' after SID of my primary db?

             

            Thanks.

            • 18. Re: [DataGuard][Error 12514]  Error received logging on to the standby
              mseberg

              Hello;

               

              I always use DNS instead of IP address. But the /etc/hosts should cover you as well.

               

              DGMGRL is an entry for Data Guard Broker. You may not use it, but by adding it now you don't have to change the listener again. Mostly your listener looks like it should fly.

               

              I assume the standby is already in MOUNT.

               

              Until you can do the following:

               

              sqlplus sys/pass@Standby as sysdba (from the primary system)

               

              and

               

              sqlplus sys/pass@primary as sysdba (from the standby system)

               

              You will not be able to ship redo.

               

              Best Regards

               

              mseberg

              • 19. Re: [DataGuard][Error 12514]  Error received logging on to the standby
                Abufazal

                What name should have the password file on standby server?

                On standby and primary server ORACLE_SID=primdb1. The db_unique_name=stbydb1 for standby and db_unique_name=primdb1 for primary.

                orapwd file=$ORACLE_HOME/dbs/orapwd<ORACLE_SID>.ora password=<password> entries=<maximum number of distict DBA>

                 

                Therefor for primary it would be,

                 

                orapwd file=$ORACLE_HOME/dbs/orapwprimdb1.ora password=<intended password> entries=10 (example)

                 

                Once created, copy the file to standby server to $ORACLE_HOME/dbs location of standby database and rename the file as orapwstbydb1.ora

                • 20. Re: [DataGuard][Error 12514]  Error received logging on to the standby
                  Piotr91

                  Solved. I'm ashamed of the fact that the only issue was with the name of password file. I have used password file naming for Windows while working on Linux. The file listener.ora was unnecessary.

                  Thank you, Abufazal.

                  • 21. Re: [DataGuard][Error 12514]  Error received logging on to the standby
                    Abufazal

                    Glad to know, its working now.

                    1 2 Previous Next