Verifying access to the Oracle database


Verifying access to the Oracle database
Prev	Installing and configuring Oracle	Next

You can verify access to the database by running an SQL query. Depending on the location of your $ORACLE_HOME, perform one of the following procedures.

Upon completion, the Oracle database is started from the node in the cluster that you last performed this procedure.

To verify access to the Oracle database

Depending on the location of your $ORACLE_HOME, perform one of the following procedures:

For $ORACLE_HOME on shared disks, start the Oracle database.

Verify that you can access the shared database from each node. Perform the steps from each node that would be a part of the Oracle cluster.

To start the Oracle database (for $ORACLE_HOME on shared disks)

If the Oracle binaries are mounted on any other node, unmount it.
If the data files on shared disk are mounted on any node, unmount it.
Mount the Oracle binaries and data files.
Start the database.

For $ORACLE_HOME on local disks, start the Oracle database.

Verify that you can access the database individually on each node that would be a part of the Oracle cluster.

To start the Oracle database (for $ORACLE_HOME on local disks)

Make sure you have installed Oracle binaries on the node.
If the data files on shared disk are mounted on any node, unmount it.
Mount the data files.
Start the database.

For ASM, the $ORACLE_HOME is on local disks and the database is configured on ASM disk groups.

Start the ASM-managed Oracle database.

Verify that you can access the database individually on each node that would be a part of the Oracle cluster.

To start the Oracle database (for $ORACLE_HOME on local disks)

Make sure you have installed Oracle binaries on the node.
If you use VxVM disks as ASM disks, do the following:
- If the ASM disk groups are mounted on any node, do the following:
  - Unmount the ASM disk groups from the ASM instance.
  - Stop the ASM instance.
  - Stop the VxVM volumes.
  - Deport the VxVM disk groups.
- Import the VxVM disk groups on this node and start the volumes.
- Start the ASM instance.
- Mount the ASM disk groups.
If you use CVM volumes for ASM, do the following:
- Unmount the ASM disk group from the ASM instance on the node where the disk group is mounted.
- Mount the ASM disk groups on the other node.
If you use raw disks as ASM disks, do the following:
- If the ASM disk groups are mounted on any node, unmount it.
- If the ASM instance is not running on this node, then start the ASM instance.
- Mount the ASM disk groups.
Start the database.

Prev	Up	Next
Copying the Oracle ASM initialization parameter file	Home	Installing and removing the agent for Oracle