Create site database from an existing catalog for Oracle - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

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

This procedure is for Oracle. 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. For more information about installing Oracle, see Smart 3D Installation.

  1. Open the Database Wizard, select Create a new site, and click Next.

  2. On the Create Site Database and Schema page, do the following:

    1. Select Oracle from the Database type list.

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

    3. Type the name of your site database in the Site database name text box. Include the type of database in the name you type. For example, type Model1SiteDB.

    4. Type the workshare location for the site database in the Site database workshare location box. You can use any string that represents your physical location.

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

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

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

    8. Click the Browse button 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 in the [Product Folder]\\3DRefData\DatabaseTemplates\<model type> folder.

      If you are running Oracle on Linux, then the database templates must be on the Linux computer where the Oracle service is running. Linux is case sensitive environment. The database template name apprepos.dmp and the folder path must be typed correctly when creating the database. The Browse feature is not available for navigating to Linux folder locations.

  3. Click Next.

  4. On the Catalog Database and Schema page, select Use existing catalog and click Next.

  5. On the Ready to Create Databases page, click Create DB to create your databases.

  6. When the Database Wizard displays the site database names that you typed, click Finish.