Registering an Oracle repository database

You use the New Registration command to register an Oracle repository database. The registration contains the information to connect to the selected database.

To register an Oracle repository database:

Right-click Repository Registrations in the tree and select the New Registration command. The New Registration dialog opens.
Specify this information:

Name

Specify the name of the new repository registration.

Note: Registrations of the same name are not allowed in Repository Administration.

Configuration

Select the configuration source that will be used to save the repository registration from the drop-down list. You can select the configuration sources User, Computer, Enterprise, or Service.

See Configurations.

Description

Specify the description of the repository registration.

Note:
If the check box Use Computer configuration as default is selected in the Options dialog, new registrations are saved to the configuration source Computer.

See Options.
To configure the database connection, click Edit. The dialog Database Connection opens.
Select Oracle Database Server from the Database type drop-down list.
On the Connection tab, specify this information for the connection to the Oracle database server:

Use existing TNS

Select the alias (Transparent Network Substrate) to access the repository database from the drop-down list. The alias points to a net service name of the configuration file tnsnames.ora that maps net service names to connect descriptors (destination for the network connection). If you configure the database connection manually, select the option Define manually.

Define manually

Select this option, if you configure the connection to the Oracle database server manually.

Server name

Specify the name of the computer, on which the Orcale service is running (only for TCP/IP connections).

Port number

Specify the port number that is used to access the Oracle service. The standard port number for TCP/IP connections is 1521.

Connection type

Select, whether the database works as a Dedicated Server or as a Shared Server. This setting relates to the administration of processes in which database queries are processed. Select Database default value to use the default setting for the database.

Protocol

Select the protocol that is used to establish the connection. By default TCP/IP is selected.

Service name

Specify the name of the Oracle service on your computer.

Service ID

Specify the service ID of the database. The service ID can be used instead of the Oracle service name.
On the Schema tab, specify this information:

User name

Specify the name of the schema user.

Password

Specify the password of the schema user.

Select tablespace

When you register an Oracle repository database, the drop-down list is disabled. An Oracle tablespace is a database storage unit that groups related logical structures together. The database data files are stored in tablespaces. By default, the entry <Default tablespace> is selected.
On the Options tab, you specify additional connection settings of the Oracle database server. These options are standard options for Oracle databases. For detail information about the settings, see the manual of the Oracle Database Server.
To check the specified settings, click Validate. If the test is successful, the message The connection test was successful. is displayed. Click OK to save the settings and to close the dialog.
Specify the log-on information of the Repository administrator:

Authentication

By default, the authentication method that you use for the Repository administrator is Basic.

User name

Specify the user name of the Repository administrator.

Password

Specify the password of the Repository administrator.

Save password

Select this check box to save the password of the Repository administrator.
Click Create to start the creation of the new Repository registration. After the creation, the new Repository registration is displayed underneath the Repository Registrations node.