Installation and Upgrade > Installation and Configuration Guide > Database Installation > Installing Oracle Database > Post-Installation Activities
  
Post-Installation Activities
After installing the Oracle software, perform the following activities as needed to ensure that your system is ready to proceed with database creation (for Oracle server) and Windchill installation.
Checking Environment Variables
After the Oracle installation is complete, verify that the PATH environment variable includes the correct Oracle directory path.
For example:
Windows
For Oracle 18.3.0.0.0:
c:\oracle\18C\dbhome_1\bin
UNIX
For Oracle 18.3.0.0.0:
/u01/app/oracle/product/18C/dbhome_1/bin
When Oracle is installed, it typically places two Java Runtime Environments at the beginning of the PATH variable. This placement interferes with Windchill installers, which rely on the JDK. After installing Oracle, make sure that your JDK (version 11 and above) is positioned in your PATH variable before any JREs the Oracle installer may have added.
Configuring for Multi-byte Character Sets
If you are using multi-byte character sets on the Oracle server, then on the Windchill server machine (where the Oracle client is installed), the NLS_LANG environment variable must be set to match the operating system language setting.
For example, on a Japanese Windows client, set the NLS_LANG variable to the following:
JAPANESE_JAPAN.JA16SJIS
For additional information about language setting options, see the Oracle installation documentation.
Configuring the Oracle Net Services Environments
Before Windchill can access a remote Oracle server as an Oracle client, you must configure a net service name. Both of these tasks are performed using the Oracle Net Configuration Assistant.
The Oracle Net Configuration Assistant is normally launched automatically at the end of an Oracle installation session. In the event you need to manually start the Oracle Net Configuration Assistant, perform the procedure appropriate for your operating system from the following:
Windows
Click Start and search for Net Configuration Assistant.
Unix
At the command prompt enter the following:
<ORACLE_HOME>/bin/netca
where <ORACLE_HOME> is the directory location where you installed Oracle.
Perform the net services configuration procedure appropriate to an Oracle server or client, as described in the sections Installing Oracle Server Software and Installing Oracle Client Software.
For additional information about this configuration assistant, refer to the Oracle Database Installation Guide.
Configuring a Remote Oracle Database to Work with the Windchill Server
If your Oracle database is on a separate server from your Windchill server, you must perform this additional procedure before installing your Windchill solution. This section provides an overview of the actions you must perform with the PTC Solution Installer (PSI) on the Oracle server before you install the Windchill solution on your Windchill server.
* 
This section assumes you have installed Oracle on your database server as described in this chapter.
For detailed descriptions of each screen and option, see Installing a Standalone Product or Component.
Perform the following on the Oracle database server:
1. Launch the PTC Solution Installer. For more information, see Launching the PTC Solution Installer.
2. Select the Solution Installation type and click Next. For more information on installation types, see Selecting the Installation Type.
3. Select the Standalone Product or Component and click Next.
4. Select Oracle Configuration.
5. Under Oracle Configuration, select Create Database. In addition, you can select Create Windchill Installation Database User Account. The latter can be done during your Windchill installation on the Windchill server, but the database must be created on the Oracle server now. For more information, see Installing a Standalone Product or Component.
6. Complete the PSI installation as normal.
You can now continue installing your Windchill solution on the Windchill server.