Connecting to an Oracle Database Server

Verify the following:

Database type and version

Verify that OpenText Application Quality Management supports your database type and version.

Note: For the most up-to-date supported environments, see the Support Matrix.

Database server name Verify the name of the database server.
Database user permissions Verify that you have the database permissions required to install OpenText Application Quality Management on the Oracle database server. For a list of required permissions, see User Permissions for Connecting to an Oracle Database Server.
Site Administration database schema

To install on an existing Site Administration database schema (second node or upgrade), you must have:

  • The existing database schema name and the database administrator permissions required to connect to the database server.

  • Full read/write permissions on the existing repository.

  • OpenText Application Quality Management must have access to the previous Site Administration schema repository path.

  • Full read/write permissions for the OpenText Application Quality Management user to the previous schema repository path.

  • The Confidential Data Passphrase that was used to create the existing schema.

For schema name and password considerations, see Site Administration Database Schema Considerations: Oracle.

Database tablespace name and size
  • Verify the name of the database server, and check the connection to the database server. Ping the database server machine name to test DNS resolution.
  • Verify you have the tablespace names (default and temporary) and the minimum tablespace sizes for storing the Site Administration database schema.
  • Verify that the tablespace is not locked.
Database Column Length Semantics For Unicode databases, ensure that column length (NLS_LENGTH_SEMANTICS) is defined according to characters (CHAR), and not according to bytes (BYTE, the default option).

See also: