Using the Create Database Tool

Create OSM Database

This database tool can perform a set of operations to create an OSM database.

• Check boxes are not selectable but are used to indicate which operations/steps that have been performed.

• Button in lower right corner will change its name according to the different steps.

  

Set the Working folder

It is required to set Working folder before performing any steps. This is the folder that the tool will look in for create or upgrade scripts.

Working folder is the top-level folder where the scripts reside that will be used by OSM Database Tools.

Select the version number of OSM Database as being created or upgraded.

Set the working folder

1. Select the Browse (...) button and then navigate to the folder for correct database version.

   

2. Click OK.

   

Steps

Following steps are possible.

Step 1. Connect to OSM database

This step is mandatory since any of the other steps requires a database connection. When the database is being created, the database user must be Oracle sys user — because OSM accounts are not created yet. For more information, see About the Oracle SYS user.

The user name is preset to sys and cannot be changed.

3. Enter Oracle SID, user password, host name, and port number. You can view the password in clear text by clicking the eye icon.

4. Select Connect to establish the connection.

   

Step 2. Create tablespaces

This step will create tablespaces used by OSM DB.

• It is not possible to change name or size of tablespace.

• It will be possible to change path for datafiles for each of OSM tablespaces. Path can either by a path used for a Windows server/PC or a Unix server.

• Name of datafiles cannot be changed.

• By selecting a check box, a default path can be set for all tablespaces.

Step 3. Create Oracle users

This step will create the standard OSM database users.

The following users will be created:

• cow_owner

• cow_read

• cow_user

For more information, see Standard Oracle System Users .

Step 4. Load system privileges

This step will load system privileges into the database. These privileges are required for the database user cow_owner.

Step 5. Create OSM database objects

This step will create all OSM database objects and cow_owner will be the owner of all objects.

Objects that are created will be tables, indexes, and constraints.

Step 6. Create Oracle sequences

This step will create sequences used by the OSM database.

Step 7. Load OSM program units

Note: This operation requires access to PowerShell execution.

This step will load all OSM program units into database.

Program units are packages, triggers, and object types.

In addition, some standard data will be inserted to some tables.

Database will be set in upgrade mode during this step.

Step 8. Run OSM privileges

This step will run the necessary scripts for adding/creating privileges that are required for database users cow_owner, cow_read, and cow_user.