Configuration Tasks

Installing the Oracle9i Real Application Clusters Guard Files

To install Oracle9i Real Application Clusters Guard:

Perform an installation of Oracle9i, choosing the Oracle9i Real Application Clusters option. Refer to the Oracle9i Installation Guide for UNIX Systems for complete instructions about installing Oracle9i Real Application Clusters.
After this installation is complete, the Oracle9i Real Application Clusters Guard software files are located in the $ORACLE_HOME/pfs directory.
Ensure that the pfs directory and all of its contents have been copied to all nodes of the cluster where Oracle9i Real Application Clusters Guard is running.

Setting Up the Installation Configuration File for Oracle9i RAC Guard

The Oracle9i Real Application Clusters Guard installation configuration file contains the following parameter settings:

Host names
IP addresses
Preferred primary and preferred secondary node
Instance names
ORACLE_SID settings for the Oracle9i Real Application Clusters Guard environment

The information in this file corresponds to a single Oracle9i Real Application Clusters database. If you intend to use Oracle9i Real Application Clusters Guard with multiple databases, create a separate configuration file for each database. The parameters in the Oracle9i Real Application Clusters Guard configuration file are used to create the Oracle9i Real Application Clusters Guard packs and environment.
The $ORACLE_HOME/pfs/setup/conf/savsetup.dat file contains a template for the Oracle9i Real Application Clusters Guard configuration file.
To create a separate configuration file:
Change to the $ORACLE_HOME/pfs/setup/conf/ directory:
$ cd $ORACLE_HOME/pfs/setup/conf
	
Copy the savsetup.dat file to ORACLE_SERVICE.conf, where ORACLE_SERVICE is the value of the ORACLE_SERVICE environment variable:
$ cp savsetup.dat prod.conf
Use any text editor to update the Oracle9i Real Application Clusters Guard installation configuration file. Set all of the parameters in the configuration file. You can use the default values if those values are acceptable.

There are six sections in the Oracle9i Real Application Clusters installation configuration file. Each section has been categorized based on the Oracle9i Real Application Clusters Guard parameters. If you need to modify an Oracle9i Real Application Clusters Guard parameter, modify it using the Oracle9i Real Application Clusters Guard Setup utility (PFSSETUP). Depending on the parameter, different files and areas of the Oracle9i Real Application Clusters Guard environment are affected. Each section heading in the configuration file identifies the requirements for changing the parameters in that section. For example, changing the ORACLE_SERVICE parameter affects all the Oracle9i Real Application Clusters Guard files, and therefore all files must be regenerated and redeployed using Oracle9i Real Application Clusters Guard Setup.
For a detailed description of the the parameters in the Oracle9i Real Application Clusters Guard installation configuration parameter file, refer to the Oracle9i Real Application Clusters Guard Administration and Reference Guide.
Running the Oracle9i Real Application Clusters Setup Utility (PFSSETUP)

This section describes how to configure Oracle9i Real Application Clusters Guard using the Oracle9i Real Application Clusters Guard PFSSETUP utility. The PFSSETUP utility uses the Oracle9i Real Application Clusters Guard installation configuration file as described in "Setting Up the Installation Configuration File for Oracle9i RAC Guard". The PFSSETUP utility automatically searches for the $ORACLE_SERVICE.conf file.

The PFSSETUP utility sets up Oracle9i Real Application Clusters Guard on two nodes of a cluster.
Perform the following tasks to run the PFSSETUP utility:
Set the ORACLE_SERVICE and DB_NAME environment variables. For example:
$ export ORACLE_SERVICE=SALES
$ export DB_NAME=sales
Change to the $ORACLE_HOME/pfs/setup directory and run the pfssetup script:
$ cd $ORACLE_HOME/pfs/setup"
$ ./pfssetup 
The PFSSETUP utility version information is displayed:
PFS_SETUP for Solaris: Version 9.0.1.0_0 on Mon Mar 19 10:35:53 PST 2001
(c) Copyright 2001 Oracle Corporation.  All rights reserved.
Confirm the ORACLE_SERVICE and DB_NAME settings when prompted, as follows:
ORACLE_SERVICE is set to prod
DB_NAME is set to prod
Do you wish to continue? [Y/N] Y
Enter Y to continue or enter N to exit the PFSSETUP utility.
Check the environment variables.

The Oracle9i Real Application Clusters Guard Setup main menu appears:
Choose the set of files from the following:
1] User definitions file
2] ORACLE Real Application Clusters Guard files
3] ORACLE network files
4] ORACLE instance files
5] ORACLE network and instance files
6] All the files
7] Quit

PFS_SETUP> 
For options 1 to 5 in the preceeding menu, the option you choose sets up only the files included in the option. For example, if you choose option 3, then only the ORACLE network files are set up.
To create all of the Oracle9i Real Application Clusters Guard setup files, enter option 6 at the prompt. The following menu appears:
Choose an operation on the selected files:
1] Generate only
2] Deploy only
3] Generate and deploy
4] Deinstall
5] List the affected files
6] Return to Main Menu

PFS_SETUP> 
To generate and deploy the setup files, enter option 3 at the prompt.

The list of affected files is generated:
The list of affected files is
 PFS_prod_hasun1.RUN
 PFS_prod_hasun2.RUN
 PFS_prod_hasun1.HALT
 PFS_prod_hasun2.HALT
 PFS_prod_User.def
 PFS_prod_System.def
 listener.ora.ded.pfs
 tnsnames.ora.ded.pfs
 tnsnames.ora.ded.clnt.pfs
 prod_config1.ded.pfs
 prod_config2.ded.pfs
 prod_config.pfs
 init_prod1_hasun1.ora
 init_prod2_hasun2.ora

Do you wish to continue? [Y/N]
Enter Y to continue.

The PFSSETUP utility generates and deploys the files to each node in the cluster.
When this process is complete, the menu shown in step 4 reappears.
Enter 6 to return to the main menu.

Enter 7 to exit.

Do not start the Oracle9i Real Application Clusters Guard packs until you have created the Oracle9i Real Application Clusters database. For more information, refer to Chapter 3, "Post-installation Tasks".
Oracle Net Services Configuration

A description of how to configure the Oracle network is beyond the scope of this guide and is covered in detail in the Oracle Net Services Administrator's Guide and in Oracle9i Real Application Clusters Concepts. However, to configure a minimal network before exploring the features in Oracle9i Real Application Clusters Guard, verify that multiple copies of the tnsnames.ora, sqlnet.ora, and listener.ora files do not exist.
The PFSSETUP utility creates the required Oracle Net Services configuration files for the Oracle9i Real Application Clusters Guard environment, based on the information entered in the Oracle9i Real Application Clusters Guard installation configuration file. During the deployment phase, the Oracle9i Real Application Clusters Guard setup utility automatically copies the generated Oracle Net Services files (tnsnames.ora and listener.ora) appended with a descriptive name and .pfs extension, into the $TNS_ADMIN directory. The path for the $TNS_ADMIN directory is specified in the Oracle9i Real Application Clusters Guard installation configuration file. The default setting for the TNS_ADMIN environment variable is $ORACLE_HOME/network/admin.
To avoid interference with a currently running Oracle9i Real Application Clusters environment, the PFSSETUP utility does not automatically replace or install newly generated network files. Before you can use Oracle9i Real Application Clusters Guard, append the files generated by the PFSSETUP utility to the current Oracle Net Services configuration files. See Chapter 3 for more information on using the Oracle9i Real Application Clusters Guard files.
The following Oracle Net Services files are generated by the PFSSETUP utility:

File Description
listener.ora.ded.pfs The host A and host B listener.ora file for dedicated Net Services sessions without Shared Servers configurations.
listener.ora.mts.pfs The host A and host B listener.ora file for Shared Servers configurations.
tnsnames.ora.ded.pfs The host A and host B tnsnames.ora file for dedicated Net Services sessions for without Shared Servers configurations.
This information is used by the Oracle9i Real Application Clusters Guard packs for connecting to the Oracle instance.
tnsnames.ora.ded.clnt.pfs The clients tnsnames.ora file for dedicated Net Services sessions for without Shared Servers configurations.
tnsnames.ora.mts.pfs The host A and host B tnsnames.ora file for Shared Servers configurations.
This information is used by the Oracle9i Real Application Clusters Guard packs for connecting to the Oracle instance.
tnsnames.ora.mts.clnt.pfs The clients tnsnames.ora file for Shared Servers configurations.

Net Services for Server

During the Oracle9i Real Application Clusters Guard setup, a listener.ora.ded.pfs file for the server nodes is ceated in the $TNS_ADMIN directory if TNS_ADMIN is defined, or in the $ORACLE_HOME/network/admin directory if TNS_ADMIN is not defined.
The following examples show sample listener configurations generated by the PFSSETUP utility:

Example 2-1 Sample Oracle9i Real Application Clusters Guard Listener Configuration for Primary and Secondary Nodes
prod_hasun1_LSNR=
(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_prod_hasun1_LSNR=0
CONNECT_TIMEOUT_prod_hasun1_LSNR=10
#TRACE_LEVEL_prod_hasun1_LSNR=SUPPORT

prod_hasun2_LSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_prod_hasun2_LSNR=0
CONNECT_TIMEOUT_prod_hasun2_LSNR=10
#TRACE_LEVEL_prod_hasun2_LSNR=SUPPORT 
Example 2-2 Sample Listener Configuration for OEM for Primary and Secondary Nodes
SID_LIST_prod_hasun1_PRIVLSNR=
(SID_LIST=
(SID_DESC=(ORACLE_HOME=/u01/app/oracle/prod/901)
      (SID_NAME=prod1)))

prod_hasun1_PRIVLSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.70)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_prod_hasun1_PRIVLSNR=0
CONNECT_TIMEOUT_prod_hasun1_PRIVLSNR=10
#TRACE_LEVEL_prod_hasun1_PRIVLSNR=SUPPORT


SID_LIST_prod_hasun2_PRIVLSNR=
(SID_LIST=
(SID_DESC=(ORACLE_HOME=/u01/app/oracle/prod/901)
      (SID_NAME=prod2)))

prod_hasun2_PRIVLSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.71)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_prod_hasun2_PRIVLSNR=0
CONNECT_TIMEOUT_prod_hasun2_PRIVLSNR=10
#TRACE_LEVEL_prod_hasun2_PRIVLSNR=SUPPORT   
Net Services for Clients

During the Oracle9i Real Application Clusters Guard setup, a tnsnames.ora.ded.clnt.pfs file for the client is created in the $TNS_ADMIN directory if TNS_ADMIN is defined, or in the $ORACLE_HOME/network/admin directory if TNS_ADMIN is not defined.
The following examples show sample service aliases in the client tnsnames.ora.ded.clnt file generated by the PFSSETUP utility:

Example 2-3 Net Service Name for Connections to Primary Instance
prod_DED=
 (DESCRIPTION=
   (LOAD_BALANCE=OFF)
   (ADDRESS_LIST=
     (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=2024))
     (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=2024))
    )
   (CONNECT_DATA=
     (SERVICE_NAME=prod.oracle.com)
     (SERVER=DEDICATED)
     (INSTANCE_ROLE=PRIMARY)
   )
  )
Example 2-4 Net Service Name for TAF BASIC Connections to Primary Instance
prod_DED_BASIC=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=2024))
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=2024)))
    (CONNECT_DATA=
      (SERVICE_NAME=prod.oracle.com)
      (SERVER=DEDICATED)
      (INSTANCE_ROLE=PRIMARY)
      (FAILOVER_MODE=
         (BACKUP=prod_DED_BASIC_BACKUP)
         (TYPE=SELECT)
         (METHOD=BASIC)
         (RETRIES=180)
         (DELAY=5)  )))

prod_DED_BASIC_BACKUP=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=2024))      
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=2024)))
    (CONNECT_DATA=
       (SERVICE_NAME=prod.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=PRIMARY)
       (FAILOVER_MODE=
          (BACKUP=prod_DED_BASIC)
          (TYPE=SELECT)
          (METHOD=BASIC)
          (RETRIES=180)
          (DELAY=5)  )))
Example 2-5 Net Service Name for Dedicated TAF PRECONNECT Connections
prod_DED_PRE=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=2024))
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=2024)))
    (CONNECT_DATA=
       (SERVICE_NAME=prod.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=PRIMARY)
       (FAILOVER_MODE=
          (BACKUP=prod_DED_PRE_SECONDARY)
          (TYPE=SELECT)
          (METHOD=PRECONNECT)
          (RETRIES=180)
          (DELAY=5)  )))

prod_DED_PRE_SECONDARY=
  (DESCRIPTION=
     (LOAD_BALANCE=OFF)
     (FAILOVER=ON)
     (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=2024)) 
(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=2024))
    (CONNECT_DATA=
       (SERVICE_NAME=prod.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=SECONDARY)
       (FAILOVER_MODE=
         (BACKUP=prod_DED_PRE)
         (TYPE=SELECT)
         (METHOD=PRECONNECT)
         (RETRIES=48)
         (DELAY=900) 

File	Description
listener.ora.ded.pfs	The host A and host B listener.ora file for dedicated Net Services sessions without Shared Servers configurations.
listener.ora.mts.pfs	The host A and host B listener.ora file for Shared Servers configurations.
tnsnames.ora.ded.pfs	The host A and host B tnsnames.ora file for dedicated Net Services sessions for without Shared Servers configurations. This information is used by the Oracle9i Real Application Clusters Guard packs for connecting to the Oracle instance.
tnsnames.ora.ded.clnt.pfs	The clients tnsnames.ora file for dedicated Net Services sessions for without Shared Servers configurations.
tnsnames.ora.mts.pfs	The host A and host B tnsnames.ora file for Shared Servers configurations. This information is used by the Oracle9i Real Application Clusters Guard packs for connecting to the Oracle instance.
tnsnames.ora.mts.clnt.pfs	The clients tnsnames.ora file for Shared Servers configurations.