Setting Up Database

About Setting up the Database

  • Before performing any task on a database, you must set up all the environment variables necessary to access the database.

  • You must define this setup information for each database. Before using CES, you need to have at least one setup entry defined.

  • After creating database setup entries, select your database profile using the Database Selection page.

This task explains how to set up the database:
  1. From the menu bar, select Options > Setup.

    The Database Setup window appears.

This table describes the fields described in the Database Selection page:

Fields Description

Setup Name

The identifier for a database setup.

ORACLE_SID

This is the system identifier for the database. The length cannot be more than 8 characters. It should start with an alphabet. We recommend that you use capital letters.

ORACLE_HOME

The directory in which Oracle is installed.

ORACLE_DATA

The default directory in which the Oracle datafiles are stored.

NLS_LANG

This variable is used to set the language, territory and character set used by the database for both the server session and the client application. If you specify an incorrect value here, EDM operations might fail.

TNS Listener Port

The TNS Listener Port number.

Adding New Setup

 If you using ENOVIA/CES Database Server for the first time, you might need to add a new database setup.

This task explains how to add a new database setup:
  1. In the Database Setup dialog box, click New.

  2. Type the appropriate values.

  3. Click OK to save the values.

Making Copy of Existing Setup

After you have setup the database, you can make a copy of the database profile.

This task explains how to make a copy of the database setup:
  1. From the menu bar, select Options > Setup.

    The Database Setup window appears.

  2. In the Available Database Profiles table, select the database, and then click Duplicate.

    The database selection details appear with a copy of the existing setup details.

  3. Make changes to the profile, and then click OK to save the changes.

Deleting Existing Setup

After you have setup the database, you can delete the database setup.
This task explains how to make a delete database setup:
  1. In the Database Setup dialog box, select the setup.

  2. Click Delete.

    The selected database set up is deleted.

  3. Click OK to return to the CES main window.

Make sure that any directory names (including ORACLE_HOME) you specify while using CES do not have any white spaces.