Creating and configuring the repository database for Oracle


		< Previous \| TOC \| Index \| Next >

Before running the sfua_db_config script, review the following requirements:

Make sure a disk group exists with at least one volume, which should not be shared. A VxFS file system must be created on the disk group.
The volume must be started and the file system must be mounted.
Obtain an unique virtual IP address for public NIC interface.
Obtain a device name for the public NIC interface (for example : hme0).
Obtain a subnet mask for the public NIC interface.

Note: The volume is used to store the repository database.

Table 2-1 indicates the options available for the sfua_db_config script.

sfua_db_config options

Options	Description
`-ssh`	Use this option in a high availability (HA) configuration. The option indicates that ssh and scp are to be used for communication between systems. Either ssh or rsh should be preconfigured so that you can execute the commands without being prompted for passwords or confirmations. The default is rsh.
-o dropdb	Drops the repository database.
-o unconfig_cluster	Use this option in a high availability (HA) configuration. Unconfigures the repository database from the VCS cluster.
-o dbstatus	Verifies the status of the database and database server.

sfua_db_config options

Option	Description
-o stopserver	Stops the database server.
-o startserver	Starts the database server.
-o serverstatus	Reports the databas server status.
-o stopdb	Detaches the repository database from the database server.
-o startdb	Attaches the repository database to the database server.

To create and configure the repository database

Run the sfua_db_config script:
# /opt/VRTSdbcom/bin/sfua_db_config
The following is an example of configuring SF Oracle RAC:
Welcome to the SFORA configuration script.

This script creates repository for standalone and HA configuration. Please create a Veritas File System on a Veritas Volume and mount it, before starting configuration using this script. This mount point will be used to store repository. The following is required to configure $prod repository for HA solution:

* A mount point of already mounted Veritas Volume on a shared storage, with Veritas File system.

* A public NIC used by each system in the cluster.

* A Virtual IP address and netmask.

Press enter to continue.

Enter Veritas filesystem mount point for SFORA repository: /sfua_rep

Enter the NIC for syste galaxy for HA Repository configuration:hme0

Enter the NIC for system nebula for HA Repository configuration:hme0

Enter the Virtual IP address for repository failover:10.182.186.249

Enter the netmask for public NIC interface:255.255.0.0

Following information will be used for SFORA HA configuration:

Public IP address: 10.182.186.249

Subnet mask: 255.255.0.0

Public interface: galaxy-hme0 nebula-hme0

Mount point: /sfua_rep

Volume Name for mount point: dbed_rep

Diskgroup for mount point: sfua_rep

Is this correct (y/n/q) [y]? y

Repository database configured sucessfully for HA.

If you are upgrading, migrate your old repository information into the new repository. If you are installing or upgrading Veritas Storage Foundation for Oracle RAC, run the dbed_update command.