Creating an Additional Windchill Risk and Reliability Database

Windchill Risk and Reliability Administrator > Databases > Database How-Tos > Creating an Additional Windchill Risk and Reliability Database

You can create additional Windchill Risk and Reliability databases from the Databases area. The only exception is if you are using Microsoft SQL Server 2017 Express or 2019 Express. They support only one database.

The creation of an additional database requires the presence of your DBA (database administrator) because a DBA username and password must be entered. The DBA username and password are different from the system administrator username and password specified within the Administrator application. The DBA for an Oracle or SQL server database is specified within the security information saved on the server for that database.

Additionally, during the database creation, the DBA must supply the database server name and, in the case of an Oracle database creation, also parameters such as tablespace paths.

1. If the Databases area is not active, click the Databases icon in the shortcut bar.

2. In the Databases pane, do one of the following:

◦ Right-click and select Insert Database.

◦ Select Insert > Database.

The New Database Wizard starts and displays the Database Name and Type page.

3. Complete this page

Option	Description
Database name	The unique name to assign to the Windchill Risk and Reliability database. This default is the name of the initially created Windchill Risk and Reliability database (with a suffix that consists of an underscore and sequential number (such as _1). You can enter any unique name.
Database type	The type of database. This field is display-only. The database type that was selected during installation is the default. Installation information appears in the Windchill Risk and Reliability Enterprise Installation Guide, which you can download from the Reference Documents area on the PTC website.
Server name	The name of the server where this new database is to reside. The format is machine name\database directory. For example, you enter something like this: Quality\sqlserver2017 • When Oracle is the database type, the server name must be a valid Oracle Net Service name. In this case, you are required to specify additional server information on the Specify Oracle Tablespace page. For more information, see the Windchill Risk and Reliability Enterprise Oracle Database Creation solution in the PTC Knowledge Base. • When SQL Server is the database type, the server name must be the name assigned to the server followed by the name of the Windchill Risk and Reliability database. The format is machine name\database name. The SQL database is created using the default properties for that SQL Server database server. If desired, the DBA can change these properties in SQL Server Enterprise Manager. For more information, see the Windchill Risk and Reliability Enterprise SQL Server Database Creation solution in the PTC Knowledge Base.

4. Click Next. The page that appears next depends on the database type.

◦ IfSQL Server is selected, the Database Administrator Login page appears. Go to step 5.

◦ If Oracle is selected, the Specify Oracle Tablespace page appears prior to the Database Administrator Login page. Although the defaults on this page are functional, your DBA may want to make some changes. Once the appropriate parameter values are specified, click Next to go to the Database Administrator Login Required page.

5. On the Database Administrator Login page, supply DBA account information. The following table provides option descriptions.

Option	Description
User name	The DBA user account to use to log in to the database server. This user account must have sufficient privileges to create databases or tablespaces and user accounts (logins).
Password	The password for this DBA user account.

6. Click Next. A window opens while DBA account information is verified. If it is successfully verified, the Windchill Risk and Reliability. Log-in page appears.

7. On this page, supply Windchill Risk and Reliability account information. The following table provides option descriptions.

Option

Description

User name

The Windchill Risk and Reliability user account that is to allow Windchill Risk and Reliability components to access the data in the database. This login is required because all access to the database occurs through this account.

You must assign a unique user name. Although Windchill Risk and Reliability Administrator does not verify that the entered user name is unique, database creation might fail if an existing user name is specified.

Password

The password for this user account. Passwords are case-sensitive.

Verify

The password re-entered in exactly the same way as in the previous option. If the two passwords do not match, the password will not be set.

8. Click Next. The Wizard Complete page appears. It indicates that the wizard has the information needed to create the additional Windchill Risk and Reliability database.

9. Click Finish. The Creating Database window opens, displaying the progress made as the additional database is created.

10. When finished reviewing the information in this window, click Close.

Once the database is created, the presence of the Oracle or SQL Server DBA is no longer required. System administrators can use the Administrator application to create Projects in this database. Additionally, any Windchill Risk and Reliability user designated as a Project administrator can create any additional Project and support files to be used by that Project. For more information, see the help or guide for the desktop application. You can download the latest copy of the guide from the Reference Documents area on the PTC website.