Oracle Initial Setup

To set up the infrastructure in the Data Virtualization Module, do the following procedure:

1. Oracle Initial Setup | Self service deployment for Oracle RMAN

2. Oracle Initial Setup | To add a source host:

3. Oracle Initial Setup | To create a test data environment:

4. Oracle Initial Setup | To add a target host:

5. Oracle Initial Setup | To add a DB Home:

6. Oracle Initial Setup | To create and start a VDB.

Self-service deployment for Oracle RMAN

You can use a self-service deploy wizard to define your first Oracle RMAN golden image of a production database and to create your first VDB. The following operations can be done with the self-service deploy wizard:

• Configure source host

• Configure target host

• Configure source database

• Configure target database

• Provision your first VDB

With the self-service deploy wizard, you can configure the source and target Accelario agents, validate the host name and agent port, and automatically discover the source and target databases. The wizard will also deploy the Oracle RMAN Golden Image, load it with an initial set of data, provision the first VDB, and permit you to start to work immediately. This can be done without assistance from a third-party vendor or technical support team. Additionally, you can set up additional test data environments.

To deploy an Oracle RMAN with the Self-service Deploy wizard:

1. Click the Self-service Deploy app on the taskbar

2. Do all the steps in the procedure.

3. Enter all the required parameters.

4. Click Next to go to the VDB Management window.

To add a source host:

1. On the navigation bar, click Source.

Open

2. Click Add Source Host.

3. Enter the source host details.

Open

4. Enter the Advanced Parameters if necessary.

5. Click Add.

The Source Management window displays the source host(s) that have been added to the system.

To create a test data environment:

1. On the navigation bar, click Source.

2. Click Create Test Data Environment.

3. Select DB type.

4. Enter a Name.

5. Click Next.

To create a test data environment from a LIVE GI:

1. Enter the test data environment details.
   Make sure to enable “Force creation”

2. Click Next.

3. Enter the Source DB Parameters. Although the database is not yet existing, the details will be used in the future.

4. Click Create.

5. Continue to Oracle Source Management | Live GI

To create a test data environment from a RMAN GI:

1. Enter the test data environment details.

2. The application runs an automatic discovery of all running Oracle databases and presents them in a list. More details on how discovery works

3. You may choose from the list or enter the details manually:

4. Click Test Connection to verify that the connection to the database is valid.

5. Click Done.

Ignore some errors when building GI

When GI is built, Accelario Virtualization checks automatically all the logs and searches for errors. The errors have a known template: ORA-99999, RMAN-99999, etc... If any error is found the GI process is accounted to be failed. However, it is possible to configure some errors to be ignored. In order to do it:

1. Goto GI agent directory on the source server

2. Edit file gi-agent-excluded-error-codes.properties

3. Add error code - one per line.

4. Restart the GI agent

To create a test data environment from a RMAN STANDBY GI:

1. Enter the test data environment details.

2. Click Next.

3. Enter the Source DB Parameters.

4. Click Test Connection to verify that the connection to the database is valid.

5. Click Done.

To create a test data environment from a AWS RDS Oracle GI:

Follow the explanations here

To add a target host:

1. On the navigation bar, click Target.
   The Target Management window appears.

2. Click Add Target Host.

3. Enter the target host details.

4. Enter the Advanced Parameters if necessary.

In case of Linux or AIX targets, the mount options configuration will be available. These options are used in the mount command. The default value is optimized according to Oracle’s recommendations.

For Linux it is :

-t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,nolock

For AIX it is :

-o rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144

5. Click Add.

To add a DB Home:

1. Click Add DB Home.

2. Select a DB type.

3. The application runs an automatic discovery of all installed Oracle database software and presents them in a list. More details on how discovery works . Pay attention: the discovery is based on running Oracle databases.

4. You may choose from the list or enter the details manually:

4. Click Add.

To create and start a VDB.

To create a VDB:

1. On the navigation bar, click VDB.

To select a GI:

1. In the VDB Management window, select a Test Data Environment.

2. Select the GI.

Adding a snapshot:

1. Select the source.

2. Click Add Snapshot.

3. Enter a Name.

4. Click Add.

To create a VDB from a snapshot:

1. Select a snapshot.

2. Click Create VDB.

3. Enter the VDB parameters.

4. Enter the Advanced Parameters, if necessary.

5. Click Create. Otherwise, click Cancel to exit without creating a VDB.

The VDB Management window displays the VDB that has been created.

The following icons display information about a VDB: