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:
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:
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.
Step 7. Activating licenses