Create the Site, Catalog, and Schema Databases for Oracle - Intergraph Smart 3D - Installation & Upgrade

Intergraph Smart 3D Installation

Language
English
Product
Intergraph Smart 3D
Search by Category
Installation & Upgrade
Smart 3D Version
11 (2016)

This procedure is for Oracle databases. Site and Catalog database creation requires that you install the Project Management and Server Connectivity components. 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 database are delivered on the server computer to [Product Folder]\3DRefData\DatabaseTemplates. This location must be shared and write permissions given to both the user login used to create the Smart 3D databases and the account on which the Oracle service (OracleService<SID>) is running. For example, NT AUTHORITY\SYSTEM. Before proceeding, verify that the share (with the appropriate permissions) exists on the server computer.

  1. Click Start > All Programs > Intergraph Smart 3D > Database Tools > Database Wizard (Windows 7).

    -OR-

    Click Start > All Apps > Intergraph Smart 3D > Database Wizard (Windows 10).

  2. Select Create a new site, and then click Next.

  3. On the Create Site Database and Schema page, select Oracle from the Database type list.

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

  5. Enter the name of your Site database in the Site database name text box.

    • To better differentiate between one database and another, include the type of database in the name you type. For example, type Model1SiteDB.

    • Do not use a name which starts with a digit as its first character. For example, if you enter a name such as 1ModelSiteDB, Oracle will not create the database.

    • When you name the Site database, the Oracle service (for the Site schema) and Site schema name default to match the Oracle service for the Site database and the Site database name.

  6. Enter the workshare location for the Site database in the Site database workshare location text box. You can use any string that represents your physical location.

    This location is the location of the host Site database and is required even if the host is not going to be replicated for worksharing purposes. During generation of the Site database, the software creates a location object and associates it with the Site database.

  7. Enter a name rule ID in the Name rule ID text box. By default, the software leaves this field blank. You can enter any string identifier, numeric or alpha; however, special characters are not supported.

    The Name Generator Service that runs on the server computer supplies unique names to items placed in the Plant (Model database). In a replicated configuration, there are multiple servers and multiple instances of the Name Generator Service running at each location; consequently, there is no way to ensure unique and sequential naming of placed objects. The value entered in the Name rule ID text box functions as a substring (an internal ID number) that represents the location at which an item is placed into the replicated Plant.

  8. In the Name generator server for site box, type the name of the server computer on which the Name Generator Service is installed.

    A name server must be a valid server running on the Windows domain and one that has been properly configured to run as a name server.

  9. Use the default paths for the site database files in the Data tablespace file name and Index tablespace file name boxes.

  10. Click Browse Browse ... ICON to the right of the Template file to be used to create site schema text box to browse for the name of the dump file (apprepos.dmp) the software uses when creating your Site schema database. The location of the file is on the reference data computer at \\[Server Name]\DatabaseTemplates\[Plant\Marine\MaterialHandling]\apprepos.dmp.

  11. Click Next.

  12. 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.

    • The option control at the top of the page allows you either to create a new Catalog database by restoring a backup or use an existing Catalog database. If you choose to create a new Catalog database using the Restore option, the wizard will restore the .dmp file specified in the Template file to be used to create the Catalog database and schema field. Depending on your model, the selections are catalogdb.dmp, sm_shipcatalogdb.dmp, or mhe_catalog.dmp. The default is to Restore catalog from backup. If you select Use existing catalog, then no further options are available.

    • If you intend to create a custom catalog, you must select the Use existing catalog option and use the Bulkload utility delivered with the product.

      The catalogdb.dmp, sm_shipcatalog.dmp, and mhe_catalogdb.dmp template files contain sample Smart 3D reference data and, while the templates contain many useful examples, they are not certified for production use by Hexagon Asset Lifecycle Intelligence.

  13. Enter 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.

  14. Use the default paths for the catalog database files in the Data tablespace file name and Index tablespace file name boxes.

  15. Click Browse to the right of the Symbol and custom program file folder box to browse for and select the SharedContent share on the Reference Data computer.

    • The SharedContent share must be created after installing Reference Data. For more information, see Configure Network Shares.

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

  16. Click Browse 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, sm_shipcatalogdb.dmp, or mhe_catalog.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 \\[Server Name]\DatabaseTemplates.

    The catalogdb.dmp, sm_shipcatalog.dmp, and mhe_catalogdb.dmp template files contain sample Smart 3D reference data and, while the templates contain many useful examples, they are not certified for production use.

  17. Click Next.

  18. On the Ready to Create Databases page, click Next to create your databases.

  19. When the Database Wizard displays the database names that you entered, click Finish.

  • The software delivers two log files - one for the Site database generation process and one for the Catalog database restore process - on the server computer at the local user %temp% folder.

  • You must name the databases with unique entries.

  • During the Site database creation process for an Oracle plant, the software attempts to connect to the 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. Since 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.

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

See Also

Create Databases