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

CODE

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

CODE

ant dataserver_install_mssql

Carry out the installation depending on the used database (MSSQL or Oracle).

Determine the database used

Windchill Shell

CODE

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

CODE

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

CODE

export ORACLE_HOME=/opt/oracle/product/19c/

The exact directory and subdirectory depends on the Oracle version!

Windchill Shell

CODE

ant dataserver_install_oracle

If the environment variable ORACLE_HOME is not set, it must be set. An example of this is:

Windchill Shell

CODE

set ORACLE_HOME=C:\ptc\Windchill_12.0\oracle\product\1210\client

The exact directory and subdirectory depends on the Oracle version!

Windchill Shell

CODE

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.

CODE

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