Entering Your Database Information
In the Define Settings section, enter your Oracle Database or Microsoft SQL Server connection information, including database authentication credentials.
Oracle
|
Option
|
Default
|
Description
|
|---|---|---|
|
Enable multibyte character set storage check box.
|
A cleared check box is the default, which means English is the default language.
|
Select this checkbox if you are using any language other than English.
|
|
Oracle Home Windows User Password (Required for Oracle 19c)
|
Enter the password for Oracle Home Windows user. This is required for Oracle database 19c.
|
|
|
Oracle Server Installation Directory
|
<ORACLE _HOME> is the default if the variable is not set.
|
Set the ORACLE_HOME system environment variable to the Oracle installation directory.
|
|
Oracle Database DNS Registered Host Name
|
<hostName>.<domain>
|
Defines the fully qualified machine name of the Oracle server.
|
|
Oracle Database Listener Port Number
|
1521
|
Defines the port number the Oracle server listens on.
|
|
Global Database Name (SID) or Service Name
|
wind
|
Defines a name to be given to the database when it is created. SID (Global database name without domain) cannot exceed 8 alphanumeric characters, and must not begin with a numeric digit.
For existing database scenario, this field should contain existing database service name.
|
|
Oracle ’SYSTEM’ Account Password
|
Enter the system password.
|
|
|
Confirm Oracle ’SYSTEM’ Account Password
|
Enter the password a second time to verify the password.
|
|
|
Oracle User Name for Windchill
|
Use the same user name that you used when installing Oracle.
|
|
|
Oracle User Password for Windchill
|
Use the same password that you used when installing the Oracle Configuration.
|
|
|
Confirm Oracle User Password for Windchill
|
Enter the password a second time to verify the password.
|
|
|
Default Tablespace Name
(Both Database settings and Data Loader settings)
|
USERS
|
Use this name if you have installed the Oracle Configuration.
|
|
Temporary Tablespace Name
(Both Database settings and Data Loader settings)
|
TEMP
|
Use this name if you have installed the Oracle Configuration.
|
Oracle Real Application Cluster
|
Option
|
Description
|
|---|---|
|
Oracle RAC Single Client Access Name(SCAN)
|
Enter the Single Client Access Name (SCAN) used for Oracle Real Application Clusters environments that provides a single name for clients to access any Oracle Database running in a cluster.
|
|
Oracle SCAN Port Number
|
Enter the Port number used for Oracle SCAN Listener Service.
|
|
Global Database Name (SID) or Service Name
|
Use the existing name for the Oracle Configuration.
|
|
Oracle User Name for Windchill Installation
|
Enter the database User Name you created for Windchill Application.
|
|
Oracle User Password for Windchill Installation
|
Enter database User Password you created for Windchill Application.
|
Oracle Advanced
Selecting Oracle Advanced while choosing your platform components allows you to connect to your database using different database connection strings. For more information see Choosing the Platform Components.
|
Option
|
Description
|
|---|---|
|
Enable multibyte character set storage
|
Select this checkbox if you are using any language other than English.
|
|
Oracle Database Connection String
|
Enter the database connection string to be used to connect to your database.
|
|
User Name
|
Create a new user name.
|
|
Password
|
Create a new password.
|
SQL Server
Creating a Windchill database user account and database objects remotely is not supported for SQL Server using PSI. To accomplish this option for SQL server, PSI must be run on the SQL Server host and the SQL Server Configuration option must be selected to create a database and user. Then, PSI must be launched again from the Windchill Server host. Select Configure to an existing user on an existing database for SQL Server and fill in the fields with the SQL Server values used during the database creation step on the database host.
 |
Some options do not appear when configuring to an existing user and database.
|
|
Option
|
Description
|
|---|---|
|
Installed SQL Server Installation Name (Named Installation only)
|
The default installation represents the machine on which the SQL server is installed.
|
|
Password for User sa
|
Enter the password for the database administrator user sa.
|
|
SQL Server User Name for Windchill
|
The same user name that you used when installing SQL Server
|
|
SQL Server User Password for Windchill
|
The same password that you used when installing SQL Server
|
|
Confirm SQL Server User Password for Windchill
|
Enter the password again to verify the password.
|
|
|
The password used when creating a new SQL database must be at least 8 characters long and must contain characters from three of the four sets — uppercase letter, lowercase letter, any of the base 10 digits, and symbols. If the password does not meet the required criteria, the installation of the SQL server database fails.
|
|
Option
|
Default
|
Description
|
|---|---|---|
|
SQL Server Installation Directory
|
For a monolithic installation, the PSI should find the correct installation directory for SQL Server based on the machine registry.
|
The same directory you used when installing SQL Server.
|
|
SQL Server Data Files Directory
|
This is populated with the value of the SQL server installation directory.
|
The directory where your SQL server database files reside.
The SQL server user must have the read-write permissions to this directory.
|
|
SQL Server Client Installation Directory
|
The same directory you used when installing SQL Server.
|
|
|
SQL Server DNS Registered Host Name
|
The same name you used when installing SQL Server.
For a multi-tier installation, enter in the correct host name of the machine where the PSI was used to create a Windchill database and user in SQL Server.
|
|
|
Installed SQL Server Instance Name (Named Instance only)
|
The name you used when installing SQL Server.
If you used the default installation during installation of SQL Server, this can be left empty.
|
|
|
TCP Port Number for SQL Server Instance
|
The same port number you used when installing SQL Server.
|
|
|
Password for User sa
|
The password for the master administrator for SQL Server.
|
|
|
SQL Server User Name for Windchill
|
The username that Windchill uses to access SQL Server.
|
|
|
SQL Server User Password for Windchill
|
The password Windchill needs to access the database.
|
|
|
Confirm SQL Server User Password for Windchill
|
Enter the password again to verify the password.
|
|
|
Windchill requires that you use Mixed Authentication mode, since the SA account is utilized when installing Windchill. The installation cannot proceed if the “sa” user cannot connect to the database using the specified TCP port. If SQL Server is configured with Windows Authentication, see http://support.microsoft.com/kb/2028697 and http://msdn.microsoft.com/en-us/library/ms188670.aspx.
|
SQL Server Advanced
Selecting SQL Server Advanced while choosing your platform components allows you to connect to your database using different database connection strings. For more information see Choosing the Platform Components.
|
Option
|
Description
|
|---|---|
|
SQL Server Connection String
|
Enter the database connection string to be used to connect to your database.
|
|
SQL Server User Name
|
Create a new user name.
|
|
SQL Server User Password
|
Create a new password.
|
SQL Server Cluster
|
Option
|
Description
|
|---|---|
|
SQL Server Cluster Network Name
|
Enter Cluster Network Name for existing SQL Server cluster database installation.
|
|
Installed SQL Server Instance Name (Named Instance Only)
|
Enter the name you used when installing SQL Server. If you used the default installation during installation of SQL Server, this can be left empty.
|
|
TCP Port Number for SQL Server Installation
|
Enter the port number assigned to SQL Server cluster installation.
|
|
SQL Server User Name for Windchill
|
Enter the SQL Server database user name you created for Windchill application.
|
|
SQL Server User Password for Windchill Installation
|
Enter SQL Server database user password you created for Windchill application.
|
Azure SQL Server
Select Configure to an existing local installation for Azure SQL server and fill in the fields with the Azure SQL server values used during the database creation step on the database host.
|
Option
|
Description
|
|---|---|
|
Azure SQL Server DNS Registered Host Name
|
The same name you used when installing Azure SQL server.
For a multi-tier installation, enter the correct host name of the machine where the PSI was used to create a Windchill database and user in Azure SQL server.
|
|
TCP Port Number for Azure SQL Server Instance
|
Enter the port number assigned to Azure SQL server installation.
|
|
Azure SQL Server User Name for Windchill Installation
|
Enter the Azure SQL server database user name you created for Windchill application.
|
|
Azure SQL Server User Password for Windchill Installation
|
Enter the Azure SQL server database user password you created for Windchill application.
|