|
Property Name
|
Description
|
Valid Values
|
Default Value
|
Validation
|
Example
|
|
# Windchill related DB properties
|
|||||
|
DBSoftware.Oracle
|
Indicates if using Oracle database
|
true or false
|
true
|
DBSoftware.Oracle=true
|
|
|
DBSoftware.PostgreSQL
|
Indicates if using a PostgreSQL database.
|
true or false
|
false
|
DBSoftware.PostgreSQL=true
|
|
|
DBConfiguration.newDB
|
Represents the option to 1) create a *new* database and 2) create new users.
|
true or false
|
false
|
||
|
DBConfiguration.newUser
|
Represents the option to 1) Use an *existing* database, and 2) create *new* users on the existing DB. Not needed for PTC Arbortext Content Delivery Offline installations.
|
true or false
|
false
|
||
|
DBConfiguration.existing
|
Represents configuring to an existing database and existing users. Not needed for PTC Arbortext Content Delivery Offline installations.
|
true or false
|
false
|
||
|
WC_PROMPTED.ig.databaseSettings.OCUORACLEHOME
|
Path to oracle home, used for OEM only. Not needed if configuring to an existing database. For example, not needed if DBConfiguration.newUser=true or if DBConfiguration.existing=true.
|
empty string
|
|||
|
DBConfiguration.loadSchemaAndData
|
Indicates if database schema should be created and the base data should be loaded.
|
true or false
|
false
|
DBConfiguration.loadSchemaAndData=true
|
|
|
WC_PROMPTED.pcu.dbHost
|
The machine that hosts the PostgreSQL database.
|
||||
|
WC_PROMPTED.pcu.dbPort
|
The port to use to connect to the PostgreSQL database.
|
||||
|
WC_PROMPTED.pcu.dbSAPwd
|
PostGreSQL System Administrator Password
|
||||
|
WC_PROMPTED.pcu.dbSARePwd
|
PostGreSQL System Administrator Password re-type
|
||||
|
WC_PROMPTED.pcu.dbUser
|
PostGreSQL Windchill database user
|
||||
|
WC_PROMPTED.pcu.dbPassword
|
PostGreSQL Windchill database user password
|
||||
|
WC_PROMPTED.pcu.dbRePassword
|
PostGreSQL Windchill database user password re-type
|
||||
|
db.credential.prefix.select
|
True implies that the installer will generate (default) credentials and apply the prefix contained in db.credential.prefix property to the CMI, E3C, TITAN, TITAN2, and WINDCHILL "base" user names when creating users.
|
true or false
|
true
|
db.credential.prefix.select=false
|
|
|
db.credential.prefix
|
A prefix to use to prepend to the CMI, E3C, TITAN, TITAN2, and WINDCHILL "base" user names when creating the users if db.credentials.prefix.select=true
|
Valid DB user name characters, not empty field
|
PTC_
|
||
|
wt.pom.jdbc.host
|
The machine that hosts the oracle database software
|
wt.pom.jdbc.host=bl-w08-64-in5
|
|||
|
wt.pom.jdbc.port
|
The port of the oracle database service
|
1521
|
wt.pom.jdbc.port=5432
|
||
|
wt.pom.jdbc.service
|
The oracle database SID or service name
|
wind
|
wt.pom.jdbc.service=wind
|
||
|
wt.pom.SysDbPassword
|
The oracle database System Account password [not needed for if configuring to an existing database *and* configuring to existing users, that is if DBConfiguration.existing=true]
|
wt.pom.SysDbPassword=system
|
|||
|
wt.pom.ReSysDbPassword
|
The oracle database System Account password re-type [not needed if configuring to an existing database *and* configuring to existing users, that is if DBConfiguration.existing=true ]
|
wt.pom.ReSysDbPassword=system
|
|||
|
wt.pom.dbUser
|
Oracle Windchill Database user
|
PTC_WINDCHILL
|
wt.pom.dbUser=windchillc010
|
||
|
wt.pom.dbPassword
|
Oracle Windchill Database user password
|
wt.pom.dbPassword=windchillc010
|
|||
|
wt.pom.dbRePassword
|
Oracle Windchill database user password re-type
|
wt.pom.dbRePassword=windchillc010
|
|||
|
user_CMIDB
|
CMI DB user
|
Valid DB user name chars
|
PTC_CMI
|
user_CMIDB=cmic010
|
|
|
password_CMIDB
|
CMI DB user password
|
password_CMIDB=cmic010
|
|||
|
rePasswordCMI
|
CMI DB user password re-type
|
rePasswordCMI=cmic010
|
|||
|
user_3CDB
|
E3C DB user
|
PTC_E2C
|
user_3CDB=e3cc010
|
||
|
password_3CDB
|
E3C DB user password
|
password_3CDB=e3cc010
|
|||
|
rePassworde3cdb
|
E3C DB user password re-type
|
rePassworde3cdb=e3cc010
|
|||
|
user_TitanDB
|
Titan DB User
|
PTC_TITAN
|
user_TitanDB=titandbc010
|
||
|
password_TitanDB
|
Titan DB user password
|
password_TitanDB=titandbc010
|
|||
|
rePasswordTitanDB
|
Titan DB user password re-type
|
rePasswordTitanDB=titandbc010
|
|||
|
user_TitanDB2
|
Titan2 DB user
|
PTC_TITAN2
|
user_TitanDB2=titandb2c010
|
||
|
password_TitanDB2
|
Titan2 DB user password
|
password_TitanDB2=titandb2c010
|
|||
|
rePasswordTitanDB2
|
Titan2 DB user password re-type
|
rePasswordTitanDB2=titandb2c010
|
|||
|
hostname
|
Indicates the host name of the Database
|
hostname=pwdcsv-insora13.ptcnet.ptc.com
|
|||
|
port
|
Indicates the port of Database
|
port=1521
|
|||
|
sid
|
Indicates the sid of database
|
sid=rama
|
|||
|
enableEnigmaSchemaAndDataLoad
|
Indicates to enable the enigma dataload
|
enableEnigmaSchemaAndDataLoad=true
|
|||
|
enabledInp.ig.dataLoaderSettings.loadSchema
|
Indicates the dataLoaderSettings is enables
|
enabledInp.ig.dataLoaderSettings.loadSchema=1
|
|||
|
WC_PROMPTED.ig.dataLoaderSettings.loadSchema
|
WC_PROMPTED.ig.dataLoaderSettings.loadSchema=1
|
||||
|
enabledInp.ig.dataLoaderSettings.loadBaseData
|
enabledInp.ig.dataLoaderSettings.loadBaseData=1
|
||||
|
WC_PROMPTED.ig.dataLoaderSettings.loadBaseData
|
WC_PROMPTED.ig.dataLoaderSettings.loadBaseData=1
|
||||
|
WC_PROMPTED.ie.installedAsUser
|
WC_PROMPTED.ie.installedAsUser=pscqa
|