Setting Up a Database for Oracle Common Tasks - Intergraph Smart Instrumentation - Installation & Upgrade - Hexagon PPM

SmartPlant Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2016 SP1 (11.0.1)

The following tasks allow the System Administrator to create and configure a SmartPlant Instrumentation database for Oracle by running the DB Setup Utility, supplied with SmartPlant Instrumentation.  You can create one SmartPlant Instrumentation database per database setup session.  After a successful database setup session, you can log on to the Administration module of SmartPlant Instrumentation as System Administrator and initialize SmartPlant Instrumentation domains in your database.  For a complete list of tasks, click the appropriate topic on the Contents tab and then click the procedure that you want.

Set Up a SmartPlant Instrumentation Database for Oracle

Use this procedure to run SmartPlant Instrumentation database setup in your Oracle database server.  You define tablespaces and other parameters required for the SmartPlant 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 SmartPlant 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 SmartPlant 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.