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

Intergraph Smart Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2018 (12.0)

  • 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 Smart Instrumentation database in a given Oracle instance.

  1. In the folder where you installed Intergraph Smart Instrumentation locate the dbsetup.exe file and double-click the icon to open the 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.

    SHARED Tip If you want to change the DBMS parameter, make sure it is compatible with Smart Instrumentation.  See For more details about all compatible combinations of Oracle and Smart Instrumentation versions. See Checking Database Version Compatibility (see ) .

  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 login name field, type your spi_login user name.

  7. In the System Administrator logon password field, type your spi_login password.

    SHARED Tip If you cannot connect to the Oracle database server using your password, contact your Oracle Database Administrator, who has rights to create a new Smart 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 must 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 must 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.

  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.

For more information, see Defining Domain Tablespaces in Oracle in the Smart Instrumentation Administration Help.

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.

For more information, see Defining Domain Tablespaces in Oracle in the Smart Instrumentation Administration Help.

  • If you want to create more than four Smart 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 Smart 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.ddti' size 15M autoextend on next 10M maxsize 3000M;

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

    2. Temporary tablespace:

      Create Temporary tablespace ZED007temp tempfile 'ZED007temp.ddti' 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.ddti' size 20M autoextend on next 10M maxsize 3000M;

    2. Create tablespace ZED007demoi datafile 'ZED007demoi.ddti' 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.

For more information, see Defining Domain Tablespaces in Oracle in the Smart Instrumentation Administration Help.

  • 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.