The database setup stage involves configuring Smart 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 Smart 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 Smart Instrumentation database schemas containing logon information required for connection to the Oracle database server.
-
Creates database objects in the Admin schema of Smart Instrumentation and fills these objects with data that appears in the IN_TEMPL.DDTI file, 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.
-
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 Smart 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 Smart Instrumentation Installation and Upgrade Guide, make sure the Oracle database parameters comply with the parameters required to
use Smart Instrumentation. See Oracle Installation and Configuration.
The following special characters cannot be used in passwords, database names, file names, and so forth:
|
/ |
\ |
[ |
] |
= |
|
; |
# |
: |
" |
! |