Create a new site database for Oracle - Intergraph Smart 3D - Administration & Configuration - Hexagon

This procedure is for Oracle. If you are using Microsoft SQL Server, see Create a new site database for SQL.

1. Open the Database Wizard, select Create a new site, and then 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 Browse 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.

3. Click Next.

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

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

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

• 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 a 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.

• The Name Generator Service that runs on the server computer you specify in the Name generator server for site box supplies unique names to items placed in the 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 you type 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 model.