11 Replies Latest reply: Feb 19, 2013 1:40 AM by yxes2013 RSS

    standby database

    yxes2013
      Hi all,

      For setting up standby database, (linux) I need to ssh to both ways to oracle users wihtout password? Or one way only from primary to standby database.


      Thanks,

      Yxz
        • 1. Re: standby database
          vlethakula
          That is not a requirement.
          User equivalency (ssh without password) is requirement for RAC installation.
          • 2. Re: standby database
            CKPT
            yxes2013 wrote:
            Hi all,

            For setting up standby database, (linux) I need to ssh to both ways to oracle users wihtout password? Or one way only from primary to standby database.


            Thanks,

            Yxz
            That is applicable for RAC,
            For dataguard/standby always there will be authentication took place even by password file. You have to take care of it
            you can copy and rename password on standby system.
            • 3. Re: standby database
              asahide
              Hi,

              ssh is working for oracle user between primary and standby.
              <<http://managingoracle.blogspot.jp/2012/04/oracle-manual-standby-no-dataguard.html>>
              Regards,

              Edited by: asahideO on 2013/02/19 13:13
              • 4. Re: standby database
                user011232
                hi,

                I hope this link will help you:

                http://docs.oracle.com/cd/E11882_01/server.112/e25608/toc.htm
                • 5. Re: standby database
                  Osama_Mustafa
                  yxes2013 wrote:
                  Hi all,

                  For setting up standby database, (linux) I need to ssh to both ways to oracle users wihtout password? Or one way only from primary to standby database.


                  Thanks,

                  Yxz
                  you are talking about Real Application cluster In data guard no need to do that.
                  • 6. Re: standby database
                    yxes2013
                    I thank you all :)


                    I am referring to manual or dataguard standby setup.

                    Supposing the primary server failed and I switch to the standby db where in all the apps users will be directed too.
                    Is the IP address of the primary server be taken by the standby server? How can the apps connect if the IP is not taken over too? :(
                    • 7. Re: standby database
                      Osama_Mustafa
                      you have two options :

                      a) use connect time failover (you can use a directory, you do NOT need to maintain
                      tnsnames.ora files on every client, you CAN centralize this) in the tns connect entry.
                      In your case, yes, this would mean changing the tnsnames.ora file if you persist in
                      keeping a copy on every client machine.

                      b) take over the production IP address (change DNS). This takes time to propagate.

                      Check
                      http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:52258813563764
                      • 8. Re: standby database
                        CKPT
                        yxes2013 wrote:
                        I thank you all :)


                        I am referring to manual or dataguard standby setup.

                        Supposing the primary server failed and I switch to the standby db where in all the apps users will be directed too.
                        Is the IP address of the primary server be taken by the standby server? How can the apps connect if the IP is not taken over too? :(
                        When primary server failed, then dont use word of "switch", you have to say it as "failover".
                        You have to use oracle net service name of standby, Actually they were pointing to old primary.
                        So specifically you no need to change from the database server.
                        • 9. Re: standby database
                          yxes2013
                          Thanks Sb and Osama :)

                          Are your explanations similar or different? which one is easier to setup?
                          • 10. Re: standby database
                            Osama_Mustafa
                            it's the same as i mention , no different but with another words
                            • 11. Re: standby database
                              yxes2013
                              Thanks :)

                              But Sb said:

                              You have to use oracle net service name of standby, Actually they were pointing to old primary.
                              So specifically you dont need to change from the database server.
                              Does this mean it is transparent and I do not change anything?