Install Oracle Database 11g Release 2 Server Software (11.2.0.2) - CADWorx - Installation & Upgrade

CADWorx Structure Installation Guide

PPMProduct
CADWorx
PPMCategory_custom
Installation & Upgrade
Version_CAESAR
12
Version_CADWorx
20.0 (2020)
Version_CADWorxStructure
2020(4.0)

This section will guide you through the installation process for Oracle 11g R2 (11.2.0.2) server software with Patch 22.

  1. Open the hosts file and enter the IPv4 address and server host name. The hosts file is located in C:\windows\system32\drivers\etc\hosts.

  2. Add the environment variable ORACLE_HOSTNAME=<server name> in the System Environment Variables.

  3. Run setup.exe from the install disk or folder while logged in as a local administrator.

  4. Enter your security update information in the Configure Security Updates screen, and click Next.

  5. Select Skip software updates, and click Next.

  6. Select Create and configure a database in the Select Installation Option screen, and click Next.

  7. Select Server Class in the System Class screen, and click Next.

  8. Select Single instance database installation in the Grid Installation Options screen, and click Next.

  9. Select Advanced install in the Select Install Type screen, and click Next.

  10. Select the installation language in the Select Product Languages screen, and click Next.

  11. Select Enterprise Edition or Standard Edition in the Select Database Edition screen, and click Next.

  12. Specify the Oracle Base location for the base folder and the Software Location for the home folder by browsing to the location, and click Next.

  13. Select General Purpose / Transaction Processing in the Select Configuration Type screen, and click Next.

  14. Specify the Global database name and Oracle Service Identifier (SID) values in the Specify Database Identifiers screen, and click Next.

  15. Select the Memory tab on the Specify Configuration Options screen, and select the Enable Automatic Memory Management 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.

  16. Select the Character sets tab on the Specify Configuration Options screen and select the Use Unicode (AL32UTF8) option.

    • All products in SmartPlant Enterprise that participate in integration should set their encodings to Use Unicode (AL32UTF8) for the Database Character Set option, and to AL16UTF16 - Unicode UTF-16 Universal character set for the National Character Set option.

    • For more information about the Character sets option, see your Oracle installation documentation.

  17. Select the Security tab on the Specify Configuration Options screen, and choose your security settings option.

  18. Select the Sample Schemas tab on the Specify Configuration Options screen, and select the Create database with sample schemas option. Click Next.

  19. Select the Use Database Control for database management option on the Specify Management Options screen. You can also enable notifications through email with this option.

  20. Select File System in the Specify Database Storage Options screen and specify a database file location. Click Next.

  21. Specify your recovery options in the Specify Recovery Options screen, and click Next.

    Do not enable Automated backups.

  22. Specify your schema passwords in the Specify Schema Passwords screen, and click Next. You must choose either the Use different passwords for these accounts or Use the same password for all accounts option.

    The software checks that all prerequisite software is installed on the computer.

  23. Click Finish in the Summary screen.

  24. Click Close after the installation process is finished.

See Also

Delete the Default Oracle Database
Install and Configure Oracle Server Software