4
Upgrading to Oracle9i Real Application Clusters Guard I

This chapter describes how to upgrade to this release of Oracle9i Real Application Clusters Guard. Specifically, this chapter describes:

• Upgrading from Oracle9i Real Application Clusters Guard Release 9.0.x

• Upgrading from Oracle9i Real Application Clusters Guard Release 9.0.1.x and Oracle Parallel Fail Safe 8.1.7.2

• Troubleshooting Tips

If an upgrade path is not described in this chapter then that upgrade path is not supported in this release.

Note: This release of Oracle9i Real Application Clusters Guard requires Sun Cluster 3.0 on Sun Solaris systems. If you need to upgrade the version of Sun Cluster, you must follow the instructions in this chapter.

Upgrading from Oracle9i Real Application Clusters Guard Release 9.0.x

This section describes how to upgrade to Oracle9i Real Application Clusters Guard Release 2 (9.2.0.1.0) if you currently use any of the following releases on Sun Cluster 2.2:

• Oracle9i Real Application Clusters Guard Release 9.0.1.0

• Oracle9i Real Application Clusters Guard Release 9.0.1.1

• Oracle9i Real Application Clusters Guard Release 9.0.1.2

Perform the following steps:

1. Back up all Oracle configuration files.

   Remember to back up files in the $ORACLE_HOME/network and $ORACLE_HOME/dbs directories. If you perform OFA compliant installations, also make backups as follows:

   1. Back up and remove all user-specific files by removing the following directories:

      $ORACLE_HOME/pfs
      $ORACLE_BASE/admin/DB_NAME/pfs
      $ORACLE_BASE/admin/DB_NAME/pfile
      $ORACLE_BASE/admin/DB_NAME/network
      
      

   2. Back up the Oracle Service configuration file as follows:

      $ cd $ORACLE_HOME/pfs/setup/conf 
      $ cp $ORACLE_SERVICE.conf $ORACLE_SERVICE.conf.BACKUP92010
      
      

2. Use the pfsctl utility to stop the Oracle9i Real Application Clusters Guard software:
   1. Ensure that the following environment variables are set correctly:

   • ORACLE_SERVICE

   • PFS_HOME

   • DB_NAME

   • Stop the Oracle9i Real Application Clusters Guard software:

     $ pfsctl
     PFSCTL> pfshalt
     
     

3. Use the PFSSETUP utility to delete the old Oracle9i Real Application Clusters Guard Pack files:
   1. Run the pfssetup utility:

      $ pfssetup
      
      

   2. Choose option 6 - All the files

   3. Choose option 4 - Deinstall

      Note that this step does not remove the software files.

   4. Log in as the root user.

   5. Run the deletepacks command to de-register the packs from the cluster framework:

      # cd $ORACLE_HOME/pfs/setup
      # ./deletepacks
      
      

4. Upgrade the cluster software from Sun Cluster 2.2 to Sun Cluster 3.0.

   Refer to the Sun Cluster 3.0 documentation for instructions on this procedure. For additional information, contact Sun support.

5. Test the Real Applications Clusters environment:
   1. Boot both nodes into cluster mode.

   2. Run Real Applications Clusters on both nodes.

   Make sure that Real Applications Clusters and associated databases operate correctly on Sun Cluster 3.0 indepentently of Oracle9i Real Application Clusters Guard before continuing.

6. Install Oracle9i Real Application Clusters Guard Release 2 (9.2.0.1.0) using the instructions in the "Installing the Oracle9i Real Application Clusters Guard Files" section in Chapter 2 of this guide.

7. Test the Real Application Clusters environment, again, by running Real Applications Clusters and testing that the database is operating correctly.

8. Configure Oracle9i Real Application Clusters Guard:
   1. Shut down both instances.

   2. Copy the savsetup.dat file to $ORACLE_SERVICE.conf:

      $ cd $ORACLE_HOME/pfs/setup/conf
      $ cp savsetup.dat $ORACLE_SERVICE.conf
      
      

   3. Update the $ORACLE_SERVICE.conf file using the configuration information from the $ORACLE_SERVICE.conf.BACKUP92010 file you saved in step 1.

   4. Run the pfssetup utility:

      $ pfssetup
      
      

   5. Choose option 6 - All the files

   6. Choose option 1 - Generate Only

   7. Choose option 6 - All the files

   8. Choose option 2 - Deploy Only

   9. Log in as the root user.

   10. Run the createpacks command to register the packs from the cluster framework:

       # cd $ORACLE_HOME/pfs/setup
       # ./createpacks
       
       

9. Complete the installation:
   1. Modify the appropriate database initialization (init.ora) files to include the required Real Application Clusters Guard parameters as described in Chapter 3.

   2. Update the Real Application Clusters Guard generated listener.ora and tnsnames.ora files as described in Chapter 3.

   3. Test the Real Application Clusters environment, again, by running Real Applications Clusters and testing that the database is operating correctly.

   4. Ensure that the following environment variables are set correctly:

   • ORACLE_SERVICE

   • PFS_HOME

   • DB_NAME

   • Start the Oracle9i Real Application Clusters Guard software:

     $ pfsctl
     PFSCTL> pfsboot
     
     

   • Check the $ORACLE_HOME/pfs/setup/PFS_Setup.log file for messages. Messages that begin with ORA- and PFS- might help you resolve any problems you encounter.

Upgrading from Oracle9i Real Application Clusters Guard Release 9.0.1.x and Oracle Parallel Fail Safe 8.1.7.2

This section describes how to upgrade to Oracle9i Real Application Clusters Guard Release 2 (9.2.0.1.0) if you currently use any of the following releases:

• Oracle9i Real Application Clusters Guard Release 9.0.1.3

• Oracle Parallel Fail Safe 8.1.7.2

Perform the following steps:

1. Back up all Oracle configuration files.

   Remember to back up files in the $ORACLE_HOME/network and $ORACLE_HOME/dbs directories. If you perform OFA compliant installations, also make backups as follows:

   1. Back up and remove all user-specific files by removing the following directories:

      $ORACLE_HOME/pfs
      $ORACLE_BASE/admin/DB_NAME/pfs
      $ORACLE_BASE/admin/DB_NAME/pfile
      $ORACLE_BASE/admin/DB_NAME/network
      
      

   2. Back up the Oracle Service configuration file as follows:

      $ cd $ORACLE_HOME/pfs/setup/conf 
      $ cp $ORACLE_SERVICE.conf $ORACLE_SERVICE.conf.BACKUP92010
      
      

2. Use the pfsctl utility to stop the Oracle9i Real Application Clusters Guard or Oracle Parallel Fail Safe software:
   1. Ensure that the following environment variables are set correctly:

   • ORACLE_SERVICE

   • PFS_HOME

   • DB_NAME

   • Stop the Oracle9i Real Application Clusters Guard software:

     $ pfsctl
     PFSCTL> pfshalt
     
     

3. Use the pfssetup utility to delete the old Oracle9i Real Application Clusters Guard Pack files:
   1. Run the pfssetup utility:

      $ pfssetup
      
      

   2. Choose option 6 - All the files

   3. Choose option 4 - Deinstall

      Note that this step does not remove the software files.

   4. Log in as the root user.

   5. Run the deletepacks command to de-register the packs from the cluster framework:

      # cd $ORACLE_HOME/pfs/setup
      # ./deletepacks
      
      

4. Upgrade the Oracle Server to Oracle9i release 9.2.0.1. Following the instructions for migrating the Oracle Database in the Oracle9i Migration documentation. This step installs the Oracle9i Real Application Clusters Guard files.

5. Test the Real Applications Clusters environment:
   1. Boot both nodes into cluster mode.

   2. Run Real Applications Clusters on both nodes.

   Make sure that Real Applications Clusters and associated databases operate correctly independently of Oracle9i Real Application Clusters Guard before continuing.

6. Configure Oracle9i Real Application Clusters Guard:
   1. Shut down both instances.

   2. Copy the savsetup.dat file to $ORACLE_SERVICE.conf:

      $ cd $ORACLE_HOME/pfs/setup/conf
      $ cp savsetup.dat $ORACLE_SERVICE.conf
      
      

   3. Update the $ORACLE_SERVICE.conf file using the configuration information from the $ORACLE_SERVICE.conf.BACKUP92010 file you saved in step one.

   4. Run the pfssetup utility:

      $ pfssetup
      
      

   5. Choose option 6 - All the files

   6. Choose option 1 - Generate Only

   7. Choose option 6 - All the files

   8. Choose option 2 - Deploy Only

   9. Log in as the root user.

   10. Run the createpacks command to register the packs from the cluster framework:

       # cd $ORACLE_HOME/pfs/setup
       # ./createpacks
       
       

7. Complete the installation:
   1. Modify the appropriate database initialization (init.ora) files to include the required Real Application Clusters Guard parameters as described in Chapter 3.

   2. Update the Real Application Clusters Guard generated listener.ora and tnsnames.ora files as described in Chapter 3.

   3. Test the Real Application Clusters environment, again, by running Real Applications Clusters and testing that the database is operating correctly.

   4. Ensure that the following environment variables are set correctly:

   • ORACLE_SERVICE

   • PFS_HOME

   • DB_NAME

   • Start the Oracle9i Real Application Clusters Guard software:

     $ pfsctl
     PFSCTL> pfsboot
     
     

   • Check the $ORACLE_HOME/pfs/setup/PFS_Setup.log file for messages. Messages that begin with ORA- and PFS- might help you resolve any problems you encounter.

Troubleshooting Tips

Consider the following points while troubleshooting an upgrade problem:

• The following message might appear if the $ORACLE_HOME/pfs/setup/output/$ORACLE_SERVICE/packs directory is not empty:

  Alert: could not generate file properly - Packs files
  
  

• When performing an OFA compliant installation, user-specific configuration files might conflict with the new Real Application Clusters Guard files. Back up and remove these file to ensure a sucessful upgrade.

• If the pfshalt or haltone commands fail while using the pfsctl utility, consider the following:
  • Check the associated Real Application Clusters Guard log files, Oracle log files, network log files, and system log files for errors.

  • Check the Real Application Clusters Guard Pack state using the scstat command. If a Real Application Clusters Guard is in a STOP_FAILED state, investigate and correct the error before clearing the STOP_FAILED state and restarting the pack.

  The following conditions might put the Real Application Clusters Guard in a STOP_FAILED state:

  • The Oracle instance cannot be stopped.

  • The relocatable IP cannot be disabled.

  • A timeout occurs.

  After correcting the condition and clearing the STOP_FAILED state, run the the pfshalt or haltone command again. These commands ensure that the system clears any processes, shared memory segments or other resources.

  For information on clearing the STOP_FAILED flag, refer to the section "Administering Data-Service Resources" in the Sun Cluster 3.0 U1 Data Services, Installation and Configuration Guide.