Create the Model and Reports Databases for Oracle - Intergraph Smart 3D - Installation & Upgrade - Hexagon

Model and Reports database creation requires that the Project Management and Server Connectivity options be installed.

The name generator service must be running on the Windows domain computer before you can create a model database. For more information about installing and configuring the Name Generator service, see the Name Generator Service Setup.

• You must have administrator privileges on the site database to create a new model.

• The computer on which you create the new model must have Project Management and Server Connectivity options installed.

• For Oracle 19.3.0, run OraProvCfg.exe to load the Oracle.DataAccess.dll into the Global Assembly Cache (GAC).

• If you are running Oracle on Linux, you must configure Database Authentication.
  

1. Open Project Management.

   If Project Management does not point to the appropriate database, errors result when you open that database. To correct this problem, close Project Management, and use Modify Database and Schema Location to change the site database that the task is viewing.

2. Select the Models root in the Project Management tree.

   

3. Click Database > New > Model to open the New Model Dialog.

4. On the General tab, type a value for Name. Optionally, type values for Description, Site, and Owner.

5. Select the type of model to create: Plant, Marine, Platform, or Material Handling.

6. Specify a purpose for the model.

   The default Model Purpose setting is Standard. However, if you intend to use the SDx integration commands such as assigning As-Built projects or synchronizing Smart Interop Object data between Smart 3D and SDx, you must set Model Purpose to Change Management.On the first row of the Databases tab, define the following values for Catalog:

   1. Service - Select the Oracle net service for the catalog database.

   2. Name - Select the catalog database with which to associate the new model.

7. On the second row, select Oracle net service for the new model.

   The software automatically populates the Name field with the value you typed on the General tab. In the third row, the software assigns the same service to Reports, and populates the Name field.

8. In the Name generator server for model box, type the name of the server on which the name generator service is installed.

9. In the Physical database and Index table space path boxes, specify the path for the location of the model database files and model index table space.

10. Click OK to create the new Oracle model.

    When processing completes, the software adds an icon for the new model in the Project Management tree. As with the new catalog database, the software creates a default permission group folder and default permission group. An icon for the Interference Detection Service () also displays in the tree view.

    

• The specific icon that displays in the Project Management tree for the new model depends on the Model Type setting (Marine, Material Handling, Plant, or Platform) and Model Purpose setting (Standard or Change Management). See Hierarchy icons.

• After you create a new Oracle model, you must run the Oracle Role Creation Utility to create the necessary schemas, users, and roles that are used to run the software. See Create Oracle roles.

• To view and change descriptive information about the model, including giving it a different name or modifying access permissions, use the Properties Command .

• Although the reports and reports schema databases are created automatically during the model generation process, they do not appear in the tree view of the model hierarchy. Reports database information can only be accessed via the Databases tab of the Model Properties Dialog.

We recommend that you increase and/or redefine initial tablespace values based on the expected scope of your projects. For more information, see your Oracle documentation.