Create the Oracle 12c Database - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Installation & Upgrade
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

These steps guide you through the database creation process. You must log on to the server as a local administrator to create the Oracle database.

  1. On the Start menu, open the Oracle Database Configuration Assistant wizard as an administrator.

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

  3. On the Creation Mode page, select Advanced Mode, and click Next.

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

  5. On the Database Identification page, enter the Global Database Name and the SID for the database. These names are generally identical and can be no longer than eight characters.

  6. If you want to create a container database, select Create As Container Database.

  7. Enter the Global Database Name and SID. Clear the Create As Container Database option. Smart 3D does not support pluggable databases. Click Next.

  8. On the Storage Locations page, select File System and Use Common Location for All Database Files. Browse to and select the appropriate file location.

  9. On the Fast Recovery page:

    • If the database will be not used in a Global Workshare Configuration, select Specify Fast Recovery Area in the Recovery Configuration screen, and click Next.

    • If the database will be used in a Global Workshare Configuration, select Enable Archiving, and click Edit Archive Mode Parameters.

  10. Select Automatic Archiving to specify the location of the archive log files. Click OK.

  11. Click Next.

  12. On the Network Configuration page, select Create a New Listener, and enter a name and port number. Click Next.

  13. On the Database Options page, clear all database component selections under the Database Components tab. Click Next.

    All the database components are selected by default if you are creating a container instance. Leave them all selected if that is the case.

  14. On the Specify Configuration page, select the Memory tab.

  15. Select the Typical Settings option. The percentage of memory allowed for an instance of Oracle should not exceed 40%. If you have more than one Oracle instance on this server, the allocated memory should not exceed 40% of the system memory.