5 Replies Latest reply: Mar 20, 2012 11:22 AM by CKPT RSS

    SID name and password file

    greeny
      DB version : 11.2
      Platform : AIX 6

      I am going to create a Physical standby. My primary database's DB_NAME = jedprod

      From googling , I have learnt that from 11g onwards , instead of creating a separate password file at the standby site , you need to copy the password file from Primary to standby and RENAME it with the standby name ?

      But, my Primary and standby database's DB_NAME is going to be same. Right?

      esentially this is what I got from googling.

      --In Primary
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapw<SID_PRIMARY> password=mypass entries=15 force=y
      
      -- copy the password file to standby site and then
      --In Standby
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapw<SID_STANDBY> password=mypass entries=15 force=y  # Is stanby DB's name going to be different ?
      So, If my DB was standalone
      --In Primary
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod password=mypass entries=15 force=y
      
      -- copy the password file to standby site and then
      
      --In Standby
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod password=mypass entries=15 force=y
      and If my DB was in RAC
      --In Primary Node1
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
      
      --In Standby Node1
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
      
      
      --In Primary Node2
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
      
      --In Standby Node2
      cd $ORACLE_HOME/dbs
      $ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
      Are my above assumptions right?
        • 1. Re: SID name and password file
          Shivananda Rao
          Rename it to standby db_unique_name and not to standby db_name
          • 2. Re: SID name and password file
            CKPT
            I am going to create a Physical standby. My primary database's DB_NAME = jedprod

            From googling , I have learnt that from 11g onwards , instead of creating a separate password file at the standby site , you need to copy the password file from Primary to standby and RENAME it with the standby name ?
            Yes, create in Primary & copy to all of the standby instances.
            But, my Primary and standby database's DB_NAME is going to be same. Right?
            Yes DB_NAME is same but DB_UNIQUE_NAME is different.
            esentially this is what I got from googling.
            --In Primary
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapw<SID_PRIMARY> password=mypass entries=15 force=y
            
            -- copy the password file to standby site and then
            --In Standby
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapw<SID_STANDBY> password=mypass entries=15 force=y  # Is stanby DB's name going to be different ?
            No..
            After copying to the standby rename using
            $mv orapw<SID_PRIMARY> orapw$ORACLE_SID
            Here it will just renamed..timestamp will also wont be changed.
            So, If my DB was standalone
            --In Primary
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod password=mypass entries=15 force=y
            
            -- copy the password file to standby site and then
            
            --In Standby
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod password=mypass entries=15 force=y
            and If my DB was in RAC
            --In Primary Node1
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
            
            --In Standby Node1
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
            
            
            --In Primary Node2
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
            
            --In Standby Node2
            cd $ORACLE_HOME/dbs
            $ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
            Are my above assumptions right?
            No need to create password file again just rename using MV command
            cd $ORACLE_HOME/dbs
            $mv orapwjedprod orapw$ORACLE_SID
            Here ORACLE_SID varies according to instances.
            Hope this clears
            • 3. Re: SID name and password file
              greeny
              CKPT, Shivananda .
              Just didn't think of mv command !!.Thanks CKPT

              Thank you both very much.

              If my DB is in RAC
              Primary database's DB_NAME        = jedprod
              Primary database's DB_UNIQUE_NAME = jedprod  # will be same, I guess
              
              Standby database's DB_NAME        = jedprod
              Standby database's DB_UNIQUE_NAME = jedprodc  
                        If my Primary DB's instance names are jedprod1 and jedprod2. How should I name the password files for my Standby instances ?

              Edited by: greeny on 20-Mar-2012 09:12
              Indented
              • 4. Re: SID name and password file
                Shivananda Rao
                Re-Name it to orapwjedprodc on the standby database
                • 5. Re: SID name and password file
                  CKPT
                  greeny wrote:
                  CKPT, Shivananda .
                  Just didn't think of mv command !!.Thanks CKPT

                  Thank you both very much.

                  If my DB is in RAC
                  Primary database's DB_NAME        = jedprod
                  Primary database's DB_UNIQUE_NAME = jedprod  # will be same, I guess
                  
                  Standby database's DB_NAME        = jedprod
                  Standby database's DB_UNIQUE_NAME = jedprodc  
                            If my Primary DB's instance names are jedprod1 and jedprod2. How should I name the password files for my Standby instances ?

                  Edited by: greeny on 20-Mar-2012 09:12
                  Indented
                  You can use same Password file of primary and rename.
                  So just rename as

                  standby node 1
                  $mv orapwjedprod orapwjedprodb

                  standby node2
                  $mv orapwjedprod orapwjedprodc