Data server installation
Description
The IFConneX data server runs within the Windchill method servers and uses its own database tables in the Windchill database. Among other things, the data server is responsible for managing user sessions and settings.
Linux
Windows
Carry out the installation depending on the used database (MSSQL or Oracle).
Determine the database used
Windchill Shell
xconfmanager -d wt.db.dataStore
MSSQL
Info
Installation via ant command, if sqlcmd client is available.
If the sqlcmd client is not available, you will find the relevant information on downloading and installing sqlcmd in the Microsoft SQL documentation.
Windchill Shell
ant dataserver_install_mssql
Carry out the installation depending on the used database (MSSQL or Oracle).
Determine the database used
Windchill Shell
xconfmanager -d wt.db.dataStore
MSSQL
Info
Installation via ant command, if sqlcmd client is available.
If the sqlcmd client is not available, you will find the relevant information on downloading and installing sqlcmd in the Microsoft SQL documentation.
Windchill Shell
ant dataserver_install_mssql
Info
To create the Dataserver tables when no sqlcmd client is available on the Windchill system, the following SQL script can be executed directly on the Windchill database instance using any client:
innoface-wc-project-999999-12.0.2.0-1.0/dataserver/dataserver_sqlserver.sql
Oracle
Info
Installation via ant command, if sqlplus client is available.
If the environment variable ORACLE_HOME is not set, it must be set. An example of this is:
Windchill Shell
export ORACLE_HOME=/opt/oracle/product/19c/
The exact directory and subdirectory depends on the Oracle version!
Windchill Shell
ant dataserver_install_oracle
If the environment variable ORACLE_HOME is not set, it must be set. An example of this is:
Windchill Shell
set ORACLE_HOME=C:\ptc\Windchill_12.0\oracle\product\1210\client
The exact directory and subdirectory depends on the Oracle version!
Windchill Shell
ant dataserver_install_oracle
Info
To create the Dataserver tables when no sqlcmd client is available on the Windchill system, the following SQL script can be executed directly on the Windchill database instance using any client:
innoface-wc-project-999999-12.0.2.0-1.0/dataserver/dataserver_sqlserver.sql
Known issues:
If the script encounters an error message stating that the value for the COMPATIBLE
parameter must be 12.0.0.0.0 or higher, the corresponding system parameter can be changed to fulfill the requirements.
The parameter must be adjusted under the user sysdba
.
sqlplus sys/windchill@WIND AS SYSDBA
SQL> shutdown immediate
SQL> startup mount
SQL> alter system set compatible='12.0.0.0.0' scope=SPFILE;
SQL> shutdown immediate;
SQL> startup