Skip to main content
Skip table of contents

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



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.