Create new site, catalog, and schema database for Oracle - Intergraph Smart 3D - Administration & Configuration

This procedure is for Oracle databases. If you are using Microsoft SQL Server, see Create new site, catalog, and schema databases for SQL.

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

2. On the Create 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. Type 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 Project1SiteDB (where DB stands for database) or Project1_SDB (where SDB stands for site database).

   • Do not use a name which starts with a digit as its first character. For example, if you enter a name such as n, 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.

   • Oracle site database name cannot exceed 21 characters.

5. Type the workshare location for the site database in the Site database workshare location text box. 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. You can use any string that represents your physical location.

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

7. In the Name generator server for site box, type the name of the server computer on which the Name Generator Service is installed. The name server must be a valid computer running on the Windows domain and one that has been properly configured to run as a name server. If you do not have a name generator server set up, see Name Generator Service Setup in the Smart 3D Installation Guide.

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

9. 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 at \\[Server Name]\3DRefData\DatabaseTemplates\<model type>\apprepos.dmp.

10. Click Next to go to the Catalog Database and Schema page.

11. Select Restore catalog from backup. When you choose to create a new catalog database using this option, the wizard restores the .dmp file you specify in the Template to be used to create the Catalog database and schema box.

12. Select the name of the server in the Catalog database server list on which your catalog database will reside.

13. Type the name of your catalog database in the Catalog database name box .Include the type of database in the name that you type. For example, type Project1CatalogDB (where DB stands for database) or Project1_CDB (where CDB stands for catalog database).

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, and browse for and select the SharedContent folder on the Smart 3D server. The path in the Symbol and custom program file folder box must be a UNC path.

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 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]\3DRefData\DatabaseTemplates\<model type> folder.

    The catalogdb.dmp (Plant), sm_shipcatalog.dmp (Marine), and mhe_catalogdb.dmp (Material Handling) template files contain sample reference data. Although the templates contain many useful examples, they are not certified for production use by Smart 3D.

17. Click Next.

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

19. After the the site, catalog, and schema databases are created, the wizard displays a summary page. Click Finish to close the Database Wizard.

• The Name Generator Service that runs on the server computer that you specify in the Name generator server for site box (step 7) 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.

• 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 site and catalog database template names and their respective folder paths must be typed correctly when creating the site and catalog databases.