My Oracle Support Banner

Discrepany Between Log Files Expected And Actually Generated During Database Upgrade To V5.0 (Doc ID 1275927.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Argus Safety - Version 5.0.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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.