Create a new catalog in the active site Oracle database - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13

This procedure is for Oracle. You must have the appropriate server components from Oracle server software installed on the server computer in order to create the databases.

  • The dump files used to create the site and catalog databases are delivered on the reference data computer to the [Product Folder]\3DRefData\DatabaseTemplates folder. This location must be shared and write permissions given to both the user logon used to create the Smart 3D databases and the account on which the Oracle service (OracleService<SID>) is running. Before proceeding, verify that the share (with the appropriate permissions) exists on the server computer.

  • If you are running Oracle on Linux, the database dump file must be on the Linux computer where the Oracle service is running. The account used for the Oracle service must have access to the folder. The Browse feature is not available for navigating to Linux folder locations.

  1. Open the Database Wizard, click Create a new catalog, select name generator server for site, or select existing site, and then click Next.

  2. On the Select Site Database and Schema page, select Oracle from the Database type list.

  3. In the Oracle service list, select the name of the Oracle net service for the site database connection.

  4. In the Site database name list box, select the site database to activate. The software populates the Site database workshare location, Name rule ID, and Site database name server boxes with information as it was defined during the initial creation of the site database you select for activation. Because the Name Generator Service can be configured on multiple server computers, you can specify (optionally) an alternative name server in the Site database name server box. The other two boxes are read-only.

  5. Select the name of the Oracle net service for the site schema database connection in the Oracle service list.

  6. In the Site schema name list box, select the site schema database you want to activate.

  7. Click Next.

  8. On the Catalog Database and Schema page, select the name of the Oracle net service for the catalog database connection in the Oracle service list.

  9. Type the name of your catalog database in the Catalog database name box. This step also automatically populates the name of the catalog schema database in the Catalog schema name text box.

  10. Use the default paths for the catalog database files in the Physical database box.

  11. Click the Browse button to the right of the Symbol and custom program file folder box to browse for and select the SharedContent folder on the reference data server (usually the database server). However, if you are running Oracle on Linux, the SharedContent folder must be on a Windows-based computer.

    • The SharedContent folder is created automatically on the server during the Smart 3D Reference Data installation.

    • The path in the Symbol and custom program file folder box must be a UNC path. To obtain a UNC path, click the Browse button, and browse under My Network Places, not under My Computer.

  12. Click the Browse button to the right of the Template file to be used to create catalog database and schema text box to browse for the name of the dump file (catalogdb.dmp) you want the software to use when creating your catalog and schema databases. The location of the file is on the reference data computer at [Product Folder]\3DRefData\DatabaseTemplates\<model type>\catalogdb.dmp.

    If you are running Oracle on Linux, the catalogdb.dmp file must be on the Linux computer where the Oracle service is running. The Oracle service user account must have access to the folder. Remember that Linux is a case sensitive environment. The folder path and file name must be typed using the correct case. The Browse feature is not available for navigating to Linux folder locations.

  13. Click Next.

  14. On the Ready to Load Databases page, click Finish.

  15. When processing completes, click Close.

  • During the site database creation process for an Oracle model, the software attempts to connect to site database to create the user interface prior to generating the views, resulting in a "table or view does not exist" error being reported in the various log files. Because views are generated after the user interface is created, these errors cannot be avoided. Additionally, these errors do not have any negative impact on using the software and can be disregarded when reviewing the log files.

  • You use the New Model Command to create a new model database. Part of the process includes selecting the catalog database you want to associate with the new model. See Create a new model (Oracle database).