Data server installation

Description

The IFConneX data server runs within the Windchill method servers and uses its 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

XML

xconfmanager -d wt.db.dataStore

MSSQL

Info

Installation via ant command if sqlcmd client is available.

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

XML

xconfmanager -d wt.db.dataStore

MSSQL

Info

Installation via ant command if sqlcmd client is available.

Windchill Shell

CODE

ant dataserver_install_mssql

Info

If no sqlcmd client is available on the Windchill system, the following SQL script:

innoface-wc-project-999999-R11.0-M030-1.0/dataserver/dataserver_sqlserver.sql

can be executed directly with any client on the Windchill database instance in order to create the data server tables.

Oracle

Info

Installation via ant command if sqlplus client is used.

If the environment variable ORACLE_HOME is not set, it must be set, e.g.

Windchill Shell

CODE

export ORACLE_HOME=/opt/oracle/product/18C/dbhome_1/

Windchill Shell

CODE

ant dataserver_install_oracle

If the environment variable ORACLE_HOME is not set, it must be set, e.g.

Windchill Shell

CODE

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

Windchill Shell

CODE

ant dataserver_install_oracle

Info

If no sqlplus client is available on the Windchill system, the following SQL script:

innoface-wc-project-999999-R11.0-M030-1.0/dataserver/dataserver_sqlserver.sql

can be executed directly with any client on the Windchill database instance in order to create the data server tables.

Known issue:

If the script encounters an error message stating that the value for the COMPATIBLE parameter must be 12.0.0.0 or higher, the corresponding system parameter can be changed to meet the necessary requirements.

To adjust the parameter, one must connect to the database as sysdba:

XML

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