Creating and configuring the repository database for DB2 and Oracle


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

Creating and configuring the repository database for DB2 and Oracle

After installing Veritas Storage Foundation for DB2 or Veritas Storage Foundation for Oracle, you must create and configure the repository database using the sfua_db_config script.

The script detects whether your system is running in a stand-alone or HA configuration and then automatically configures the repository database.

Before running the script, review the following requirements:

In a stand-alone configuration

You must have a mount point mounted on a VxVM volume with a VxFS file system.
The mount point is used to store the repository database.

In an HA configuration

Create a separate, non-shared disk group on shared storage. Create a VxVM volume and a VxFS file system and mount the volume.
It is recommended that you have a separate disk group for the repository volume so that any failovers are independent of other service groups.
The mount point is used to store the repository database.
Obtain an unique virtual IP address for public NIC interface.
Obtain the device names for the public NIC interface (for example: hme0 / eth0 /) for all systems in the cluster.
Obtain a subnet mask for the public NIC interface.
Make sure VCS is not in read-write (-rw) mode. To make sure VCS is in read-only mode, use the following command:
# haconf -dump -makero

sfua_db_config options indicates the options available for the sfua_db_config script.

sfua_db_config options

Option	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.
-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.
-o stopserver	Stops the database server.
-o startserver	Starts the database server.
`-o serverstatus`	Reports the database 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 as follows:
# /opt/VRTSdbcom/bin/sfua_db_config

The following is an example of configuring Veritas Storage Foundation for Oracle:

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 SFORA 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.

Are you ready to configure SFORA repository (y/n/q) [y]?

filesystem mount point for SFORA repository: /sfua_rep

Discovering public NIC on host1 ....eth0

Enter the NIC for system host1 for HA Repository configuration: [eth0]

Discovering public NIC on host2 ....eth0

Enter the NIC for system host2 for HA Repository configuration: [eth0]

Enter the Virtual IP address for repository failover: xx.xxx.xxx.xxx

Enter the netmask for public NIC interface: [xxx.xxx.xxx.x]

Following information will be used for SFORA HA configuration:

Public IP address: xx.xxx.xxx.xxx

Subnet mask: xxx.xxx.xxx.x

Public interface: host1 -> eth0,host2 -> eth0

Mount point: /sfua_rep

Volume Name for mount point: dbed_rep

Diskgroup for mount point: sfua_rep

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

Adding repository information in VCS (HA) configuration...

Added repository information successfully in VCS (HA) configuration.

Repository configuration completed successfully for HA environment.

Verify that the repository was configured.
If you are installing in a high availability configuration:

# /opt/VRTS/bin/hagrp -state

#Group Attribute System Value

Sfua_Base State guan |ONLINE|

Sfua_Base State plover |OFFLINE|

Note: Sfua_Base group should be online on one node in the cluster.

If you are installing in a stand-alone configuration:

# /opt/VRTSdbcom/bin/sfua_db_config -o dbstatus

Database 'dbed_db' is alive and well on server 'VERITAS_DBMS3_host'.


^ Return to Top	< Previous \| TOC \| Index \| Next >