Create a New Oracle Instance - Intergraph Smart Engineering Manager - 5.0.1 - Installation & Upgrade - Hexagon

Intergraph Smart Engineering Manager Web API Installation and Configuration

Language
English
Product
Intergraph Smart Engineering Manager
Subproduct
Web API
Search by Category
Installation & Upgrade
Smart Engineering Manager Web Version
5.0

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

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

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

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

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

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

    1. In the Global Database Name box, define the database name, for example, SPEM12cdb.

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

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

    3. Clear the Create as Container database option.

  6. Select Next.

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

  8. Select Next.

  9. On the Database Credentials page, select an option and then in the Password and Confirm Password boxes, enter the password, for example, Oracle12, and then select 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 Specify Fast Recovery Area.

    3. Select Next.

  12. On the Database Options page, on the Database Components tab, clear all the check boxes, and then select 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 select Next.

    After selecting 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, then 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 select Finish.

    The Progress Page is displayed.

  17. On the Finish page, select Close.

  18. Restart the server computer.