Create the Smart 3D Oracle 11g Database - 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)

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

  1. From the Start menu, select All Programs > Oracle > Configuration and Migration Tools > Database Configuration Assistant.

  2. In the Database Configuration Assistant screen, select Create a Database, and click Next.

  3. In the Database Template screen, select the Custom Database option, and click Next.

  4. Enter the name of the new database in the Database Identification screen. Generally, the Global Database Name and the SID are identical. These names can be no longer than eight characters.

  5. In the Management Options screen, click Next without changing the default selections. Configure Enterprise Manager and Configure Database Control for local management are the default options.

  6. In the Database Credentials screen, select a security option and provide the appropriate information. Click Next.

  7. On the Database File Locations screen, select File System and Use Common Location for All Database Files. Browse to the appropriate files location, and click OK.

    A subfolder is created in the folder you choose and is named with the SID you provided earlier in step 4.

  8. Click Next.

  9. If the database will not be used in a Global Workshare Configuration, select Specify Flash 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. Select Automatic Archiving to specify the location of the archive log files.

  10. In the Database Content screen, select the Enterprise Manager Repository option and click Next.

  11. Select the Memory tab on the Initialization Parameters screen and select the Typical 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.

  12. On the Sizing tab, configure the Processes option based on this formula.

    Processes ยป (Maximum Number of Users * 10) + (Number of Oracle System Processes)

    The number of Oracle system processes can vary based on the number of background processes that are running. This number is a high estimate. Overestimate the number to ensure it will only use the number of processes that the instance needs.

  13. Select the Character Sets tab, 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 Set options, see your Oracle installation documentation.

  14. Select the Connection Mode tab, and select Dedicated Server Mode.

  15. In the Connection Mode tab, select All Initialization Parameters.

  16. Click Show Advanced Parameters.

    The parameters required by CADWorx in are listed below:

    Name

    Value

    db_files

    1000

    distributed_lock_timeout

    180

    open_cursors

    3000

    os_authent_prefix

    ""

    processes

    200

    undo_retention

    3600

  17. Click Close after the changes have been made, and click Next on the Database Configuration dialog box.

    The control files should be divided among multiple physical hard drives. This file is needed by the database to start.

  18. Verify that the path in the Tablespaces folder is correct for SYSAUX, SYSTEM, TEMP, UNDOTBS1, and USERS.

    The information in the Datafiles and Redo Log Groups folders can retain the default settings as long as the folder path does not need updating.

  19. Create an additional Redo log file, and set the Redo log file size for each group to 512000 K.

  20. Click Next.

    The Creation Options screen allows you to save your database configuration as a template file, and also allows you to generate database creation scripts.

    Not every setting is preserved in the template file. If you re-use template files, check the parameters carefully to verify the settings are correct.

  21. When you have finished configuring the database, click Finish.

    The first 15% of the creation process validates the configuration settings. After the first 15% of the process has successfully passed, the database creation succeeds without any errors.

  22. After the Database Configuration Assistant completes the database creation, click Exit.

See Also

Oracle Post-Installation Requirements
Install and Configure Oracle Server Software
Appendix: Install and Configure Oracle Software