Discrepany Between Log Files Expected And Actually Generated During Database Upgrade To V5.0

(Doc ID 1275927.1)

Last updated on DECEMBER 22, 2010

Applies to:

Oracle Argus Safety - Version: 5.0 and later   [Release: 5.0 and later ]
Information in this document applies to any platform.

Goal

Customer upgraded from Argus Safety 4.2 HF1 to 5.0 and found the following discrepancies in the log files generated:

A. Upgrade from 4.2 HF1 to 4.2 SP1 HF1B:

System displayed saying that the following Log Files are generated as part of this upgrade:

1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)


Found the following discrepancies in the log files generated:

Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)

Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)

B. Upgrade from 4.2 SP1 HF1B to 4.2 SP1 HF2: list of log files generated

System displayed saying that the following Log Files are generated as part of this upgrade:

1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)

Found the following discrepancies in the log files generated:

Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)

Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)


C. Upgrade from 4.2 SP1 HF2 to 5.0: list of log files generated

System displayed saying that the following Log Files are generated as part of this upgrade:

1. CreateUpgradeLog.rtf (Log of DDL and DML scripts)
2. UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
3. UPG_CFG_DUMP_PRE_ESM.LOG (Log of Configuration Tables Dmp for ESM Schema)
4. UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)
5. UPG_CFG_DUMP_PRE_ARG.Log (Dmp of Configuration Tables Dmp for ARGUS Schema)
6. UPG_log_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
7. UPG_log_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)

Found the following discrepancies in the log files generated:

Missing:
UPG_CFG_DUMP_PRE_ESM.DMP (Dmp of Configuration Tables for ESM Schema)
UPG_CFG_DUMP_PRE_ARG.DMP (Dmp of Configuration Tables for ARGUS Schema)

Generated, but difference in name of log file:
UPG_create_lm_cfg_table_bkup.log (File to identify Argus LM+CFG Changes)
UPG_show_LM_CFG_Data_Modified.log (File to identify Argus LM+CFG Changes)

Log files generated but not listed during database Upgrade Execution:
UPG_case_prod_drugs_log.log
UPG_case_product_log.log




Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms