Create a New Oracle Instance - 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)

  • Make sure that all passwords, user names, folders, and files of the new instance are different from those of any existing instance.

  • All user names and passwords must use ASCII / English characters. Oracle does not support non-ASCII / English characters in user names or passwords and will not work. This limitation is an Oracle limitation, not Intergraph's.

  1. On the Start menu, click All Programs, locate the Oracle folder and under Configuration and Migration Tools, start the Database Configuration Assistant.

  2. On the Database Operation page, select Create a Database and click Next.

  3. On the Creation Mode page, select Advanced Mode.

  4. On the Database Template page, select Custom Database and click Next.

  5. On the Database Identification page, do the following:

    1. In the Global Database Name box, define the database name, for example, SEL12cdb, PID12cdb, or SI12cdb.

    2. In the SID box, accept or modify the instance name that the software enters automatically as you type the database name.

      SHARED Tip The database name and the instance name do not have to be the same.

  6. Click Next.

  7. On the Management Options page, select an option and enter the required values.

  8. Click Next.

  9. On the Database Credentials page, select an option and then in the Password and Confirm Password boxes, type the password, for example, Oracle12 and then click Next.

    SHARED Tip The following terms are reserved and cannot be used as passwords: manager (reserved for the SYSTEM user) and change_on_install (reserved for the SYS user).

  10. On the Network Configuration page, if required create a new listener.

  11. On the Storage Locations page, do the following:

    1. Select Use Database File Locations from Template.

    2. Clear the Specify Fast Recovery Area check box.

    3. Click Next.

  12. On the Database Options page, on the Database Components tab, clear all the check boxes and click Next.

  13. On the Initialization Parameters page > Memory tab, select the Typical Settings and the Use Automatic Memory Management options.

    Ensure that the memory size does not exceed 40% of total server memory.

  14. Select the Character Sets tab and do the following:

    1. Select the Use Unicode (AL32UTF8) option.

    2. Under National Character Set, select AL16UTF16 (the default)

    • The same database character set and national character set values should also be defined on your server.

    • The Default Language and Default Date Format values will reflect locale-specific information.

  15. On the Creation Options page, select the Create Database check box and then click Next.

    After clicking Next the software performs a check of the parameters selected. If any problems are detected the Prerequisite Checks page opens. You must fix any problems before continuing. If no problems are found the software skips this page and goes straight to the Summary page.

  16. On the Summary page, check that the parameters are correct and then click Finish. The Progress Page is displayed.

  17. On the Finish page click Close.

  18. Restart the server machine.