The database setup stage involves configuring SmartPlant Instrumentation database for your Oracle database server by adding the database schemas, INTOOLS_ENGINEER role, logon information, and associated database objects into the Oracle database.
You perform the database setup procedure after you finish installing the Oracle database server, Oracle client, and SmartPlant Instrumentation for Oracle.
The DB Setup Utility performs the following operations (in the indicated order):
-
Creates Oracle database server tablespaces.
-
Creates the INTOOLS_ENGINEER role and SmartPlant Instrumentation database schemas containing logon information required for connection to the Oracle database server.
-
Creates database objects in the Admin schema of SmartPlant Instrumentation and fills these objects with data that appears in the IN_TEMPL template database, supplied with SmartPlant Instrumentation.
During the database setup, the INTOOLS_ENGINEER role receives system privileges and
privileges for database objects included in the Admin schema. These objects are shared
for all domains you initialize. When initializing a new domain, other database schemas
of SmartPlant Instrumentation receive the INTOOLS_ENGINEER role.
If you use an existing Oracle server (where you intend to keep your database) which
was not installed according to the instructions in the SmartPlant Instrumentation Installation and Upgrade Guide, make sure the Oracle database parameters comply with the parameters required to
use SmartPlant Instrumentation. See Oracle Database Server Installation in the SmartPlant Instrumentation Installation and Upgrade Guide for additional information about the required Oracle server parameters.
The following special characters cannot be used in passwords, database names, file names, and so forth:
|
/ |
\ |
[ |
] |
= |
|
; |
# |
: |
" |
! |