Set Up a SmartPlant Instrumentation Database for Oracle - Intergraph Smart Instrumentation - Installation & Upgrade - Hexagon PPM

• Paths you specify in this procedure refer to the database server local folders (non-network folders).  Do not use network drives or network server names in the paths.

• Make sure you have an available Oracle instance.  It is not possible to set up more than one SmartPlant Instrumentation database in a given Oracle instance.

1. On your Windows Start menu, navigate to the Intergraph SmartPlant Instrumentation program icons and click DB Setup Utility.

2. On the Oracle Server Connection dialog box, from the Oracle version list, select the version of your Oracle server.

3. Under DBMS identifier in the INtools.ini file, accept or change the displayed compatible DBMS parameter for the Oracle server version that you selected from the Oracle version list.

   If you want to change the DBMS parameter, make sure it is compatible with SmartPlant Instrumentation.  For more details about all compatible combinations of Oracle and SmartPlant Instrumentation versions, see SmartPlant Configuration and Maintenance Guide, Compatibility of Oracle and SmartPlant Instrumentation Versions.

4. In the Oracle database name box, do one of the following:

   • Accept displayed database name.

   • Change the displayed value if it does not match the value you defined for the DB_NAME parameter in the Oracle Instance Configuration file.

5. In the Server name box, accept or modify the displayed Oracle server connection string.

6. In the System Administrator logon password box, accept the given default value manager (the password is masked), or type the appropriate password.

   If you cannot connect to the Oracle database server using the default password, contact your Oracle Database Administrator, who has rights to create a new SmartPlant Instrumentation System Administrator logon password for connection to the Oracle database server.

Database Creation - Tablespaces Creation Modes

The user now creates the database and tablespaces for the Admin and the Domain or Domains. The user may use existing tablespaces or create new ones. To create tablespaces the user has the following modes:

Automatic – The tablespaces for the administration and domain or domains are created automatically. You define the tablespaces for the Domain or Domains.

Customized – You configure the tablespace name, data file name and path, and the tablespace size of the Admin schema data, Admin schema indexes, and Temporary tablespaces. The user then has to define the tablespaces for the Domain or Domains.

Predefined – You predefine a list of tablespaces as needed, then select the Admin schema data from the predefined list. The Temporary tablespaces names, data file name and path, and the tablespace size are created automatically. You then have to define the tablespaces for the Domain or Domains.

1. In DBSetup, click Connect to connect to your Oracle database server.

   

2. Accept the default Administration schema login name and Administration schema login password values in_dbamn.

   If you want to modify the login name or password, verify that the login name is unique in the Oracle database server. The login name and password can only start with a letter and contain no spaces. You can use an underscore instead of a space. If you wish to encrypt the password, see Encrypt the Admin Schema Logon Password.

3. Continue to either the Automatic, or Customized, options as described in the Automatic mode of tablespaces creation and Customized mode of tablespaces creation. Else, if the Predefined mode is required, continue to Predefined mode of tablespaces creation.

Automatic mode of tablespaces creation

1. On the New Database Definitions dialog box, from the Tablespaces options, select Automatic, and click Create.

2. Continue to section Defining Domain Tablespaces in Oracle (see ).

Customized mode of Tablespaces creation

1. On the New Database Definitions dialog box, from the Tablespaces options, select Customize, and click Create.

   

2. Under Administration schema data, do the following:

   1. From the Tablespace name list, select the tablespace name.

   2. In the Data file name and path field, insert the path details.

   3. In the Tablespace size field, insert the tablespace size.

3. Under Administration schema indexes, do the following:

   1. Accept the Tablespace name or type in a tablespace name.

   2. In the Data file name and path field, insert the path details.

   3. In the Tablespace size field, insert the tablespace size.

4. Under Temporary Tablespaces, do the following:

   1. Accept the Tablespace name or type in a tablespace name.

   2. In the Data file name and path field, insert the path details.

   3. In the Tablespace size field, insert the tablespace size.

5. Click Create.

6. Continue to section Defining Domain Tablespaces in Oracle (see ).

   

   • If you want to create more than four SmartPlant Instrumentation domains, for the Admin data tablespace, specify a size larger than 25 MB, and for the Admin index tablespace, specify a size larger than 10 MB.

   • If you change the default tablespace definitions when, for better performance, it is highly recommended that you locate the data tablespaces and index tablespaces on different physical disks.  You can also locate the system file, database tables and the index data on different physical drives to speed up your work in the Oracle Database.  See your Oracle User Guide for more information.

   • Each of the file names must be a legal name.

   • Each tablespace name must be unique within your database.

   • If you want to create more than four SmartPlant Instrumentation domains, for the Admin index tablespace, you need to specify a size larger than 10 MB.

Predefined mode of tablespaces creation

Create the following:

• For the Administration Schema - Admin data, Admin indexes and Temporary tablespaces.

  1. Administration data tablespace:

     1. Create tablespace ZED007 datafile 'ZED007.db' size 15M autoextend on next 10M maxsize 3000M;

     2. Create tablespace ZED007i datafile 'ZED007i.db' size 15M autoextend on next 10M maxsize 3000M;

  2. Temporary tablespace:

     Create Temporary tablespace ZED007temp tempfile 'ZED007temp.db' size 2M autoextend on next 2M maxsize 3000M;

• For each Domain - Two tablespaces for the domain data and domain indexes.

  1. Create tablespace ZED007demo datafile 'ZED007demo.db' size 20M autoextend on next 10M maxsize 3000M;

  2. Create tablespace ZED007demoi datafile 'ZED007demoi.db' size 20M autoextend on next 10M maxsize 3000M;

     Create the above tablespaces for each domain schema as necessary.

Use the following procedure to create each of the tablespaces listed above.

1. On the New Database Definitions dialog box, from the Tablespaces options, select Predefined, and click Create.

   

2. Under Administration schema data, from the Tablespace name list, select the tablespace name.

3. Under Administration schema indexes, from the Tablespace name drop-down list, select the tablespace name.

4. Under Temporary Tablespaces, from the Tablespace name drop-down list, select the tablespace name.

5. Click Create.

6. The user may, continue to section Defining Domain Tablespaces in Oracle (see ).

• Each domain requires two tablespaces.

• Once “predefined tablespaces” is selected in Dbsetup.exe, Init will work with predefined tablespaces by default. This is controlled through the “predefinedtablespaces” flag in the License table.

See Also

Setting Up a Database for Oracle Common Tasks
SmartPlant Instrumentation Database Setup for Oracle
Oracle Database Server Tablespaces for SmartPlant Instrumentation