Installation and Upgrade > Installation and Configuration Guide > Using the PTC Solution Installer > Installing Windchill Solutions > Launching the PTC Solution Installer > Database Configuration
  
Database Configuration
The database configuration screen allows you to configure the database for your Windchill solution:
Select whether to Create or Use Existing for the Database and the Database Installation User and whether to Create the Database Application User.
• Select the Create options for a monolithic installation.
• Select the Use Existing options if there is a separately hosted database that was already installed as described in Configuring a Remote SQL Server Database to Work with the Windchill Server.
The following options are available:
Selected Options
Resulting Configuration
• Create > Database
• Create > Database Installation User
The PSI creates a database and installation user. The database installation user will be used to create the database schema, load required data, and execute transactions from Windchill. After selecting these options, click Next.
* 
When creating an Oracle database using PSI, you can launch PSI as the user that installed the database software, or as root user.
• Create > Database
• Create > Database Installation User
• Create > Database Application User
The PSI creates a database, installation user, and application user. The database installation user will be used to create the database schema and load required data. The database application user will be used to execute transactions from Windchill. After selecting these options, click Next. If you do not create an application database user you may need to do so later, as certain modules require one. For more information see Configuring a Database Application User.
• Use Existing > Database
• Create > Database Installation User
The PSI creates a database Installation user. The database installation user will be used to create the database schema, load required data, and execute transactions from Windchill. After selecting these options, click Next.
• Use Existing > Database
• Create > Database Installation User
• Create > Database Application User
The PSI creates a database installation user and application user. The database installation user will be used to create the database schema and load required data. The database application user will be used to execute transactions from Windchill. After selecting these options, click Next.
• Use Existing > Database
• Use Existing > Database Installation User
The PSI will use an existing database installation user to create the database schema, load required data, and execute transactions from Windchill. After selecting these options, click Next. The user has the option to configure Windchill with a database application user using the instructions in the section titled Manually Configuring a Database Application User.
Create Windchill Business Reporting User
This option is only available if you chose to install Windchill Business Reporting.
Setting Oracle Configuration Utility Environment Variables
You must update the Oracle user profile so that the following environment variables are set automatically when launching a sh shell.
ORACLE_HOME= ORACLE_HOME_LOCATION
PATH=/usr/bin:/usr/local/bin:/usr/sbin:/sbin:/usr/local/sbin:/usr/ucb:/usr/ccs/bin:
$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$
LD_LIBRARY_PATH
SHLIB_PATH=/u01/app/oracle/product/18C/lib:$SHLIB_PATH
LIBPATH=/u01/app/oracle/product/18C/lib:$LIB_PATH