Installing and Configuring Oracle Server Software - Intergraph Smart 3D - Installation

Intergraph Smart 3D Installation

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Installation
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

Because system configurations and individual company standards vary, use this section as a checklist instead of step-by-step instructions. Please contact support for specific configuration questions. These instructions are for installing Oracle on a computer running the Windows Server operating system. See the Oracle Linux Installation and Configuration guide for instructions on installing Oracle on a computer running Linux.

  • We recommend that you set up the Windows server network before installing Oracle.

  • Oracle recommends a static IP address.

  • You should install the Oracle server software using the local computer administrator account. Do not use a domain user or a user in the local Administrator group. For more information, refer to the Oracle installation documentation.

  • All domain verified user names and passwords must use ASCII7/English characters. Oracle does not support non-ASCII / English characters in domain user names or passwords and will not work. In addition, do not use the @ character in an Oracle password. This limitation applies only to Oracle, not Hexagon PPM.

Oracle Instances

If one server hosts the databases of several products, we recommend that each product database be a separate instance, each of which can host multiple plants.

The advantage of placing each product database in its own instance is that only the affected application will be off-line during backup, performance tuning, and other database maintenance activities. Additionally, global tuning parameters that apply to one instance can be tailored to the specific product requirements.

According to Oracle documentation, the only limit to the number of instances you can have on any machine is the availability of resources. However, the number of instances on one database server should be minimized because each additional instance puts additional load on the server.

Each instance adds redundant tablespaces, rollback segments, background processes, and memory requirements for each System Global Area (SGA). For this reason, you should start by putting the database of one product for several plants into a single instance. Then, when the number of plants increases, or a plant becomes very large, consider separating the database into new instances, adding server memory, or even adding database servers.

  • Oracle recommends that database activity on the database server consume no more than 60 percent of the available memory. Refer to your Oracle documentation for specific requirements.

  • Do not use the @ character in any Oracle passwords.

  • There are Oracle restrictions for the database global name and corresponding database link name (they are required to match). There are three known restrictions on global database names:

    1. No hyphens are allowed.

    2. The computer name cannot start with a number.

    3. There is a maximum of 30 characters for the name.

  • After installing the Oracle server software, you must initialize the Oracle database using either Initialize the Oracle Database or the Initialize the Oracle Database with Minimum Access Privilege procedures.

  • The Molded Forms Copy by Family command should be run by a user with at least Project Administrator access on Oracle. This command will fail if you initialize the Oracle database with Minimum Access Privilege.