Create Site Database and Schema Page - Intergraph Smart 3D - Administration & Configuration

Intergraph Smart 3D Project Management

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Administration & Configuration
SPFVersion_custom
10
Version_SThreeD_Custom
12.1 (2019)

When you create a new site database, you must identify its server location (for SQL Server databases) or its Oracle net service (for Oracle databases), specify a name, workshare location, a Name rule ID, and the server computer on which the Name Generator Service is configured. You must also select the site schema template file, and identify the schema server location and name.

This page of the Database Wizard is only available as part of the Create a new site database workflow.

Database type

Specifies the type of database. Select MSSQL or Oracle.

Site database server

Sets the server on which the new site database will reside. Only registered SQL Servers appear in the list. After you select a server for the site database, the Site schema server box defaults to match that of the site database server. This option appears only if you select SQL Server in the Database type list.

Oracle service (Site database)

Sets the name of the Oracle net service for the site connection. After you select the Oracle service, the Oracle service box for the site schema defaults to match that of the site. This option appears only if you select Oracle in the Database type list.

Site database name

Specifies a name for the new site database. After you type a name for the site database, the Site schema name field defaults to match the site database name.

Site database workshare location

Specifies a name for the workshare location of the new site database. You can use any string that represents your physical location. The workshare location is the location of the host site database and is required whether or not you intend to replicate the host site database for worksharing purposes. During generation of the site database, the software creates a location object and associates it with the site database.

Name rule ID

Applies a name rule ID for the workshare location. You can type any string identifier, numeric or alpha. However, special characters are not supported. The value typed 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. By default, the software leaves this field blank.

Name generator server for site

Specifies the name of the computer on which the Name Generator Service is configured. A 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. The Name Generator Service that runs on the server computer 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. For more information about installing and configuring the Name Generator Service, see the Installation Guide available from Help > Printable Guides.

Paths for site database files: Physical database

Identifies the location of the physical database. Unless you specify otherwise, the software uses the default SQL Server location. This option appears only if you select SQL Server in the Database type list.

Paths for site database files: Log file

Identifies the location of the log file for the site. Unless you specify otherwise, the software uses the default SQL Server location. This option appears only if you select SQL Server in the Database type list.

Paths for site database files: Data tablespace file name

Identifies the location of the data tablespace for the site. By default, the text in this field is Oracle Managed File, which means that tablespace file name will be placed into a predefined Oracle location. You can edit this field to use an unmanaged file for the tablespace. If ASM is enabled in Oracle, the text in this field is the disk group name, such as +Data1 instead of a tablespace file name. This option appears only if you select Oracle in the Database type list.

Paths for site database files: Index tablespace file name

Specifies the location of the index tablespace for the site. By default, the text in this field is Oracle Managed File, which means that tablespace file name will be placed into a predefined Oracle location. You can edit this field to use an unmanaged file for the tablespace. If ASM is enabled in Oracle, the text in this field is the disk group name, such as +Data1 instead of a tablespace file name. This option appears only if you select Oracle in the Database type list.

Template file to be used to create site schema

Specifies or browses to the location of the template file used to build the site schema database. For SQL Server databases, the template file delivered with the software is on the server computer in [Product Folder]\3DRefData\DatabaseTemplates\ and is called apprepos.dat. For Oracle databases, the template file is apprepos.dmp.

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.

Site schema server

Identifies the server on which the new site schema database will reside. By default, the software displays the server location that you specified in the Site database server box. This option appears only if you select SQL Server in the Database type list.

Oracle service (Site schema)

Sets the name of the Oracle net service for the site schema connection. By default, the software displays the service that you specified in the Oracle service box for the site database. This option appears only if you select Oracle in the Database type list.

Site schema name

Identifies the name of the new site schema. By default, the software appends the name you typed for the site with the word SCHEMA. For example, if you type My_SiteDB as the site database name, the schema name defaults to My_SiteDB_SCHEMA.

Paths for site schema files: Physical database

Identifies the location of the physical database. Unless you specify otherwise, the software uses the default MS SQL Server location. For Oracle databases, this information is read-only.

Paths for site schema files: Log file

Identifies the location of the log file. Unless you specify otherwise, the software uses the default MS SQL Server location. This option appears only if you select SQL Server in the Database type list.

Paths for site schema files: Data tablespace file name

Identifies the location of the data tablespace for the site schema. By default, the text in this field is Oracle Managed File, which means that tablespace file name will be placed into a predefined Oracle location. You can edit this field to use an unmanaged file for the tablespace. If ASM is enabled in Oracle, the text in this field is the disk group name, such as +Data1 instead of a tablespace file name. This option appears only if you select Oracle in the Database type list.

Paths for site schema files: Index tablespace path

Specifies the location of the index tablespace for the site schema. By default, the text in this field is Oracle Managed File, which means that tablespace file name will be placed into a predefined Oracle location. You can edit this field to use an unmanaged file for the tablespace. If ASM is enabled in Oracle, the text in this field is the disk group name, such as +Data1 instead of a tablespace file name. This option appears only if you select Oracle in the Database type list.