Setting up the Oracle database for use in Enterprise Server 9

Note: It is assumed here that the Oracle installation has been successfully performed.

1. Creating the database

Start the Oracle Database Configuration Assistant and follow the instructions.

Note: The following steps refer to the step number in the main window.

Step 1. Select Create a Database.

Step 2. Select General Purpose.

Step 3. In the Global Database Name box, enter a name for the database.

This is typically in the form [name].[domain].

Example: ENT9.COMPUTERNAME.

Notes: The maximum number of characters that can be entered for the database name is limited to 8. The SID (Oracle System ID) is automatically generated from the full name.

Step 4. Management Options: no changes necessary.

Step 5. Enter passwords for the database administrators.

Step 6. Choose the Storage mechanism, such as the default File System.

For more information, see About file storage.

Step 7. Select the Database File Locations:

Step 7a. Select Use Common Locations for all Database Files.

Step 7b. Select a directory where the data should be stored.

Step 8. Recovery configuration: no changes necessary.

Step 9. Database content: no changes necessary.

Step 10. Initialization parameters:

• Memory tab: no changes necessary
• Sizing tab: no changes necessary
• Character Sets tab: select Use Unicode (AL32UTF8) and select “UTF8 - ...” as the National Character Set.

Step 11. Database Storage: no changes necessary.

Step 12. Creation options: click Finish and wait for the database to be created (this may take a while).

2. Creating the table space

Step 1. Access the Oracle Enterprise Manager by choosing All Programs > Oracle > Database Control - ENT9.

Notes: “ENT9” is an example of the name that was specified as part of creating the database (see above).

Step 2. Log in by connecting as "SYSDBA" and using username "SYS".

You are now logged in to Database Instance ENT9.COMPUTERNAME (or whatever name you specified when creating the database).

Step 3. Select the Administration tab followed by Table Spaces.

Step 4. Click Create.

Step 5. Enter a new table space name, preferably using the same name as the database, in this example ENT9.

Step 6. Click Add.

Step 7. Enter a file name for the table space.

Step 8. Click Continue.

Step 9. Click OK.

The table space is created.

3. Creating the database users

Choose between creating a combined user or creating separate users.

Creating one combined user (root user)

Step 1. (Optional, if not logged in yet.) Log in to the appropriate Oracle Enterprise Manager with user name SYS and connect as SYSDBA.

Step 2. Select the Administration tab and create a new user.

Step 3. Enter Root as the name.

Step 4. Enter a password (twice).

Step 5. Choose the name of the created table space (in our example ENT9) as the default table space.

Step 6. Choose TEMP as temporary table space.

Step 7. In the Role tab, add the following roles:

• CONNECT
• SELECT_CATALOG_ROLE
• DBA
• CTXAPP

Step 8. In the System tab, add the following system privileges:

• CREATE PROCEDURE
• CREATE TRIGGER
• CREATE TYPE
• EXECUTE ANY PROCEDURE
• EXECUTE ANY TYPE
• SELECT ANY DICTIONARY
• SELECT ANY TABLE
• UNLIMITED TABLESPACE

Step 9. Click OK to add the user.

Creating separate users

Choose between creating a WoodWing user or a root user.

WoodWing user (a user who has limited database access and who cannot alter tables)

Step 1. (Optional, if not logged in yet.) Log in to the Oracle Enterprise Manager with user name SYS and connect as SYSDBA.

Step 2. Select the Administration tab.

Step 3. Select Users.

Step 4. Click Create.

Step 5. Enter WoodWing as the name.

Step 6. Enter a password (twice).

Step 7. Choose the name of the created table space (in our example ENT9) as the default table space.

Step 8. Choose TEMP as temporary table space.

Step 9. In the Role tab, add the role CONNECT (if not already added.)

Step 10. In the System tab, add the system privilege CREATE SYNONYM.

Step 11. Click OK to add the user.

Root user (one combined user)

See "Creating one combined user (root user)" above.

Note: Normal users of the system will typically use the WoodWing account to log in to the Oracle database. The Root account is needed for users who will do maintenance, especially for creating custom properties.