Create a New Oracle Instance - Intergraph Smart Electrical - 2019 (9.0) - Installation & Upgrade - Hexagon

Intergraph Smart Electrical Installation and Upgrade

Language
English
Product
Intergraph Smart Electrical
Search by Category
Installation & Upgrade
Smart Electrical Version
2019 (9.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, start the Database Configuration Assistant.

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

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

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

  5. On the Database Identification page, in the Global Database Name box, define the database name, for example, SEL12cdb, PID12cdb, or SI12cdb.

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

  7. Select Next.

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

  9. Select Next.

  10. 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 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).

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

  12. On the Storage Locations page, select Use Database File Locations from Template.

  13. Clear the Specify Fast Recovery Area check box.

  14. Select Next.

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

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

  17. Select the Character Sets tab and then select the Use Unicode (AL32UTF8) option.

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

  19. 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 the software skips this page and goes straight to the Summary page.

  20. On the Summary page, check that the parameters are correct and then select Finish.

    The Progress Page is displayed.

  21. On the Finish page select Close.

  22. Restart the server computer.