Logo Help Center

Step 6. Creating the Enterprise tables

Step 6. Creating the Enterprise tables


This is step 6 of performing a full installation of Enterprise Server 9. (See a list of all steps)


Purpose of this step

By following this step, tables are created in the database that was installed during Step 1. Setting up the database.

Steps to follow

Use the following steps to create tables in your installed database for storing data relating to using Enterprise.

Step 1. Enter the following address in a Web browser:

http://<server URL>/Enterprise/server/admin/dbadmin.php

Note: It is assumed here that the folder of your Enterprise Server is named "Enterprise".

Replace <your server URL> by the URL for your server. For example:

http://localhost/Enterprise/admin/dbadmin.php

The Database - Installation / Upgrade page appears (also referred to as the dbadmin page).

Note: Enterprise will automatically detect the current status of the installation and will list the necessary scripts to run.

Step 2. Review the settings on the page.

Step 3. Click Install Database.

The scripts are executed and Enterprise tables are created and populated with initial values. On completion, a message is shown whether the action was performed successfully or not.

When using separate Oracle users

When two separate Oracle users are used (root/WoodWing) perform the following steps:

Step 1. Connect to the database as a user root (by using SQL Developer or Enterprise Manager).

Step 2. Open the SQL Worksheet.

Step 3. From the /Enterprise/server/dbscripts/ folder, open the file scent9xx.ora.sys.sql in a text editor.

Step 4. Copy the SQL statements into the SQL Worksheet.

Step 5. Execute the statements.

Step 6. Logout from the database.

Step 7. Connect to the database as user WoodWing (by using SQL Developer or Enterprise Manager)

Step 8. Open the SQL Worksheet.

Step 9. From the /Enterprise/server/dbscripts/ folder, open the file scent9xx.ora.trx.sql in a text editor.

Step 10. Copy the SQL statements into the SQL Worksheet.

Step 11. Execute the statements.

Step 12. Log out.

Next step

Step 7. Activating licenses

Was this article helpful?
0 out of 0 found this helpful / Created: / Updated:
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.