Oracle Switch TP1996-9.2.2.1A 用户手册
Chapter 1
Defining the psupgrade.properties Parameters
Parameter
Value Definition
pcm.jdbc.url
The JDBC connection string to the Product Cost Management database. The format is
jdbc:oracle:thin@<SOURCE_DB_HOST_NAME>:<PORT>:<SID> where
SOURCE_DB_HOST_NAME is the hostname of the Product Cost Management database,
SOURCE_DB_HOST_NAME is the hostname of the Product Cost Management database,
PORT is the listener port of the database (1521 is the default), and SID is the database
instance.
pcm.jdbc.driver
The database driver of the Product Cost Management database. The default is
oracle.jdbc.driver.OracleDriver.
pcm.db.user
The database user of the Product Cost Management database.
pcm.db.password
The encrypted database password of the Product Cost Management database. Use the
encryptpwd utility located in the $AUT_HOME\bin directory to encrypt the password.
pcm.tns.name
The TNS entry name in the Oracle Home of the source database.
pcm.oracle.home
The Oracle Home of the Product Cost Management 8.5 database.
Note
Use either double back slashes or a forward slash for
directory separation, for example, d:/oracle/ora92.
directory separation, for example, d:/oracle/ora92.
generate.pcm.reports
Set this parameter to true to generate a report about the data contained in the Product Cost
Management database before migration. The report will display data matching the following
rules:
1.
Update firstname, lastname, and user organization for the matched
user login ID, if you set the update.matched.user.data parameter to true.
2.
Migrate the Product Cost Management Items not found in Agile 8.5,
if you set the migrate.pcm.items.not.found.in.pc parameter to true.
3.
Convert all manufacturer names to uppercase, if you set the
convert.mfrName.to.upperCase parameter to true.
4.
Update all Agile 8.5 manufacturer data with the Product Cost
Management manufacturer data for the same manufacturer, if you set the
update.matched.mfr.data parameter to true.
update.matched.mfr.data parameter to true.
5.
Migrate Product Cost Management manufacturer parts not found in
Agile 8.5, if you set the migrate.pcm.mpns.not.found.in.pc to true.
If you set this parameter to false, migration will proceed without a report being generated.
If you choose to have a report generated, AUT will stop. After viewing the report and you
are satisfied with the results, change this parameter to false and run AUT again.
report.folder.location Location
where
you want the report to be generated.
update.matched.user.data
If set to true, the firstname, lastname, and user organization are updated based on
matching users in the Agile 8.5 database.
Page - 15