Creating an Oracle Database

About this task

When using Oracle Server, use the default ORCL instance, or create an instance specifically for Trading Manager. The minimum disk space required for the instance is 100 MB. If you expect heavy transaction volume, use the auto-expand feature of Oracle.

If any part of this step needs to be repeated, use oradropnn.sql to delete all Partner Manager tables and data in the database. Use caution as oradropnn.sql cannot be reversed and should be used only if these steps must be repeated.

To run Oracle SQL scripts, perform the following steps:

Procedure

Log on to the desired Oracle instance in SQL*PLUS.
Create a spool output by entering the following (you can change this file name, or if available on your version of SQL*PLUS, use the File Spool option to set it):
```
spool C:\temp\inst.log
```
Process orainst82.sql (the path for the SQL files are in the directory where you installed Partner Manager, for example):
install_dir\tmgr_vn.n\pmgr\sql\orainstnn.sql
Execute oraupdate82to821.sql.
When complete, shut off spooling with spool off, or use the File Spool option, if available.
Check the spool file created in Step 2 for errors. Resolve any errors before proceeding.
If there are no errors, enter commit in SQL*PLUS to save the changes.
Create another spool output by entering:
```
spool C:\temp\load.log
```
Process oraloadnn.sql:
install_dir\tmgr_vn.n\pmgr\sql\oraloadnn.sql
When complete, shut off spooling with spool off or use the File Spool option, if available.
Check the spool file created in Step 8 for errors. Resolve any errors before proceeding.
If there are no errors, enter commit into SQL*PLUS to save the changes.
Exit SQL*PLUS.