Creating and registering an Oracle repository database

Right-click in the tree and select the command. The dialog Create Repository 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 create the database and to configure the database connection, click Edit. The dialog Create Repository Database opens.

Select the database server type Oracle Database Server from the Database type drop-down list. You can select one of these options:

Microsoft SQL Server
Oracle Database Server
PostgreSQL Server

Note: The connection settings are different for a Microsoft SQL server, an Oracle database server, or a PostgreSQL server.

On the Connection tab, specify this information:

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.
Enter a system user: A system user must have the permission to create a new schema user and a new tablespace. This is required to create a new Repository database. By default, the check box is selected.
User name: Specify the name of the system user that is used to log in to the Repository database.
Password: Specify the password of the system user.

On the Schema tab, specify this information:

Create new schema user: Select this option, if you create a new schema user. Specify a user name and password. By default, this option is selected.
Use existing schema user: Select this option, if you use an existing user as schema user.
Use system user as schema user: Select this check box, if you use the system user that you have specified on the Connection tab as schema user. You do not have to specify a user name and password.
User name: Specify the name of the new schema user.
Password: Specify the password of the new schema user.
Confirm password: Confirm the password that you specified.
New tablespace: Specify the name of the new tablespace. 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 option is selected.
Existing tablespace: Select this option, if you create the schema in an existing tablespace. Select the tablespace from the drop-down list.

Note: We recommend that you use separate accounts for the system user and the schema user in case of Oracle repository databases. If you use the option Use system user as schema user and remove an Oracle repository database, the user-dependent database objects and tablespaces of the system user are removed as well.

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:

User name: By default, the user name of the Repository administrator is "Admin".
Password: Specify the password of the Repository administrator.
Confirm password: Confirm 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 database and registration. If successful, the message The Repository <Repository Name> has been created successfully. is displayed. Click OK. After the creation, the new Repository registration is displayed underneath the node.