The following tasks allow the System Administrator to create and configure a Smart Instrumentation database for Oracle by running the DB Setup Utility, supplied with Smart Instrumentation.
The DB setup application (.exe) is found in the folder where you installed Smart Instrumentation.
By default that is; C:\Program Files (x86)\SmartPlant\Instrumentation.
You can create one Smart Instrumentation database per database setup session. After a successful database setup session, you can log on to the Administration module of Smart Instrumentation as System Administrator and initialize Smart Instrumentation domains in your database.
Set Up a Smart Instrumentation Database for Oracle
Use this procedure to run Smart Instrumentation database setup in your Oracle database server. You define tablespaces and other parameters required for the Smart Instrumentation database. The setup provides default parameters and values that you can accept or modify. The default tablespace sizes are recommended as initial values. When connecting to the Oracle database, you provide a logon name and a logon password. This logon information is different from the logon information required to log on to Smart Instrumentation. You define the Oracle database server logon information during this procedure. For more information, see Set Up a Smart Instrumentation Database for Oracle.
Clean Up the Oracle Database
Use this procedure to clean up the Oracle database by deleting Smart Instrumentation database objects created during a specific database setup session. You must perform this procedure if a database setup did not complete successfully and you want to run the same setup again. You clean up the database using Oracle tools. For more information, see Clean Up the Oracle Database.