2
Configuration Tasks

This chapter describes how to configure Oracle9i Real Application Clusters Guard. It contains the following sections:

Installing Oracle9i Real Application Clusters Guard

The following sections describe how to perform a new Oracle9i Real Application Clusters Guard installation:

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 Configuration File

The Oracle9i Real Application Clusters Guard 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, you must 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 SALES.conf
```
Use any text editor to update the Oracle9i Real Application Clusters Guard configuration file. You must 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 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.

See Also:
For more information on the configuration files, refer to Appendix B, "Configuration Files".

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 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 configuration file as described in "Setting Up the Configuration File". The PFSSETUP utility automatically searches for the $ORACLE_SERVICE.conf file.

Note:

The PFSSETUP utility deploys the Oracle9i Real Application Clusters Guard files on two nodes of a cluster.

Perform the following tasks to run the PFSSETUP utility:

Note:

The following example is from the Sun SPARC Solaris platform.

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 SALES
DB_NAME is set to SALES
Do you wish to continue? [Y/N] Y

Enter Y to continue or enter N to exit the PFSSETUP utility.
Check the values of environment variables displayed.

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 appears:

Note:

The list of affected files for might differ for each platform. The following example shows the list for Sun SPARC Solaris. The following list is the least number of files for Sun SPARC Solaris.

The list of affected files is
 PFS_SALES_hosta.RUN
 PFS_SALES_hostb.RUN
 PFS_SALES_hhosta.HALT
 PFS_SALES_hostb.HALT
 PFS_SALES_User.def
 PFS_SALES_System.def
 listener.ora.ded.pfs
 tnsnames.ora.ded.pfs
 tnsnames.ora.ded.clnt.pfs
 SALES_config1.ded.pfs
 SALES_config2.ded.pfs
 SALES_config.pfs
 init_SALES1_hosta.ora
 init_SALES2_hostb.ora

Do you wish to continue? [Y/N]

Note:

For HP 9000 Series HP-UX systems, the list of files generated also includes:

PFS_SALES_hosta.sh
PFS_SALES_hostb.sh
PFS_SALES_hosta.conf
PFS_SALES_hostb.conf

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.

Note:

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 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 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, you must 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	Dedicated configuration (IS_MTS is set to false) file for the listeners that identifies the Oracle9i Real Application Clusters Guard listener name and service it is listening for.
listener.ora.mts.pfs	Shared Servers configuration (IS_MTS is set to true) file for the listeners that identifies the Oracle9i Real Application Clusters Guard listener name and service it is listening for.
tnsnames.ora.ded.pfs	Dedicated configuration (IS_MTS is set to false) file that contains net service names mapped to connect descriptors.
tnsnames.ora.ded.clnt.pfs	Dedicated client configuration (IS_MTS is set to false) file that contains net service names mapped to connect descriptors.
tnsnames.ora.mts.pfs	Shared Servers configuration (IS_MTS is set to true) file that contains net service names mapped to connect descriptors.
tnsnames.ora.mts.clnt.pfs	Shared Servers client configuration (IS_MTS is set to true) file that contains net service names mapped to connect descriptors.

Dedicated Sessions

The following sections provide information on dedicated sessions.

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

SALES_hosta_LSNR=
(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_SALES_hosta_LSNR=0
CONNECT_TIMEOUT_SALES_hosta_LSNR=10
#TRACE_LEVEL_SALES_hosta_LSNR=SUPPORT

SALES_hostb_LSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_SALES_hostb_LSNR=0
CONNECT_TIMEOUT_SALES_hostb_LSNR=10
#TRACE_LEVEL_SALES_hostb_LSNR=SUPPORT

Example 2-2 Sample Listener Configuration for OEM for Primary and Secondary Nodes

SID_LIST_SALES_hosta_PRIVLSNR=
(SID_LIST=
(SID_DESC=(ORACLE_HOME=/u01/app/oracle/SALES/901)
      (SID_NAME=SALES1)))

SALES_hosta_PRIVLSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.51)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_SALES_hosta_PRIVLSNR=0
CONNECT_TIMEOUT_SALES_hosta_PRIVLSNR=10
#TRACE_LEVEL_SALES_hosta_PRIVLSNR=SUPPORT


SID_LIST_SALES_hostb_PRIVLSNR=
(SID_LIST=
(SID_DESC=(ORACLE_HOME=/u01/app/oracle/SALES/901)
      (SID_NAME=SALES2)))

SALES_hostb_PRIVLSNR=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.52)
(PORT=2024)(QUEUESIZE=1024)))
STARTUP_WAIT_TIME_SALES_hostb_PRIVLSNR=0
CONNECT_TIMEOUT_SALES_hostb_PRIVLSNR=10
#TRACE_LEVEL_SALES_hostb_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

SALES_DED=
 (DESCRIPTION=
   (LOAD_BALANCE=OFF)
   (ADDRESS_LIST=
     (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)(PORT=2024))
     (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)(PORT=2024))
    )
   (CONNECT_DATA=
     (SERVICE_NAME=SALES.oracle.com)
     (SERVER=DEDICATED)
     (INSTANCE_ROLE=PRIMARY)
   )
  )

Example 2-4 Net Service Name for TAF BASIC Connections to Primary Instance

SALES_DED_BASIC=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST=      (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)(PORT=2024))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)(PORT=2024)))
    (CONNECT_DATA=
      (SERVICE_NAME=SALES.oracle.com)
      (SERVER=DEDICATED)
      (INSTANCE_ROLE=PRIMARY)
      (FAILOVER_MODE=
         (BACKUP=SALES_DED_BASIC_BACKUP)
         (TYPE=SELECT)
         (METHOD=BASIC)
         (RETRIES=180)
         (DELAY=5)  )))

SALES_DED_BASIC_BACKUP=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)(PORT=2024))      
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)(PORT=2024)))
    (CONNECT_DATA=
       (SERVICE_NAME=SALES.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=PRIMARY)
       (FAILOVER_MODE=
          (BACKUP=SALES_DED_BASIC)
          (TYPE=SELECT)
          (METHOD=BASIC)
          (RETRIES=180)
          (DELAY=5)  )))

Example 2-5 Net Service Name for Dedicated TAF PRECONNECT Connections

SALES_DED_PRE=
  (DESCRIPTION=
    (LOAD_BALANCE=OFF)
    (FAILOVER=ON)
    (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)(PORT=2024))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)(PORT=2024)))
    (CONNECT_DATA=
       (SERVICE_NAME=SALES.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=PRIMARY)
       (FAILOVER_MODE=
          (BACKUP=SALES_DED_PRE_SECONDARY)
          (TYPE=SELECT)
          (METHOD=PRECONNECT)
          (RETRIES=180)
          (DELAY=5)  )))

SALES_DED_PRE_SECONDARY=
  (DESCRIPTION=
     (LOAD_BALANCE=OFF)
     (FAILOVER=ON)
     (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.22)(PORT=2024)) 
(ADDRESS=(PROTOCOL=TCP)(HOST=192.10.1.21)(PORT=2024))
    (CONNECT_DATA=
       (SERVICE_NAME=SALES.oracle.com)
       (SERVER=DEDICATED)
       (INSTANCE_ROLE=SECONDARY)
       (FAILOVER_MODE=
         (BACKUP=SALES_DED_PRE)
         (TYPE=SELECT)
         (METHOD=PRECONNECT)
         (RETRIES=48)
         (DELAY=900)

2 Configuration Tasks

Installing Oracle9i Real Application Clusters Guard

Installing the Oracle9i Real Application Clusters Guard Files

Setting Up the Configuration File

Running the Setup Utility (PFSSETUP)

Oracle Net Services Configuration

Dedicated Sessions

Net Services for Server

Example 2-1 Sample Oracle9i Real Application Clusters Guard Listener Configuration for Primary and Secondary Nodes

Example 2-2 Sample Listener Configuration for OEM for Primary and Secondary Nodes

Net Services for Clients

Example 2-3 Net Service Name for Connections to Primary Instance

Example 2-4 Net Service Name for TAF BASIC Connections to Primary Instance

Example 2-5 Net Service Name for Dedicated TAF PRECONNECT Connections

2
Configuration Tasks