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 | ||
|---|---|---|---|
• > • > | 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.
| ||
• > • > • > | 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. | ||
• > • > | 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. | ||
• > • > • > | 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. | ||
• > • > | 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. |
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/19C/lib:$SHLIB_PATH
LIBPATH=/u01/app/oracle/product/19C/lib:$LIB_PATH
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/19C/lib:$SHLIB_PATH
LIBPATH=/u01/app/oracle/product/19C/lib:$LIB_PATH