Install Oracle Instance - Intergraph Smart 3D - Installation & Upgrade - Hexagon PPM

Intergraph Smart 3D Oracle Linux Installation and Configuration

Language
English (United States)
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
13
  1. Open a terminal window, and run the following command:

    mount -t tmpfs shmfs -o size=XXg /dev/shm

    XX is the size of <Memory_Max_Target> + 5g, and XX is less than the physical memory size.

  2. In the terminal window, run the following command to edit the fstab file:

    gedit /etc/fstab

  3. In the file editor, append the line below to the end of the file, and then save the changes:

    shmfs /dev/shm tmpfs size=XXg 0

    XX is the size of <Memory_Max_Target> + 5g, and XX is less than the physical memory size.

  4. In the terminal window, run the following command:

    dbca

    The Database Configuration Assistant window displays.

    If you receive an error about the proxy setting having an incorrect value, run these two commands:

    $ unset https_proxy

    $ unset no_proxy

  5. Select Create Database, and then click Next.

    Create Database

  6. Select Advanced Mode, and then click Next.

    Advanced Mode

  7. Select Custom Database, and then click Next.

    Custom Database

  8. Define the global database name and the Oracle system identifier (SID), and then click Next.

    Define SID

  9. Select Configure Enterprise Manager (EM) Database Express, and then type 5500 in the EM Database Express Port box. Click Next.

    Configure Enterprise Manager

  10. Select Use the Same Administrator Password for All Accounts. Enter and confirm the password, and then click Next.

    Admin Password

  11. Select Create a New Listener. Enter the listener name and port, and then click Next.

    Create a New Listener

  12. Select Use Common Location for All Database Files, and enter the location to use in the File Location box.

  13. Clear the Specify Fast Recovery Area check box.

    Storage Locations

  14. Click OK, and then click Next.

  15. On the Database Components tab, clear all of the check boxes. Click Next.

    Database Components tab

  16. On the Memory tab, select Typical Settings and Use Automatic Memory Management.

    Memory tab

  17. On the Sizing tab, verify that Block Size is set to 8192 and Processes is set to 300.

    Sizing Tab

  18. On the Character Sets tab, select Use Unicode (AL32UTFB).

    Character Sets tab

  19. On the Connection Mode tab, select Dedicated Server Mode, and then click All Initialization Parameters.

    Connection Mode tab

  20. Show the advanced parameters. Set these values.

    Press ENTER after typing the values to display the check mark in the Override Default column.

    Advanced Parameters with check box

  21. Click OK, and then click Next.

  22. Select Create Database, and then click Customize Storage Locations.

    Create Database and Customize Storage Locations

  23. Set the size of the four Redo Log Groups to 500 MB.

    Redo Log Groups

  24. To improve performance, we recommend that you increase the file size of temp and undotbs1 to 200 MB. Set the AUTOEXTEND increment to 100 MB.

    temp file size

    temp increment size

    undotabl file size

    undotbl increment size

  25. Click OK, and then click Next.

  26. Click Finish on the Create Database Summary window.

    Wait for the database to be created.

  27. Click Close.