Upg_mgr.pl -s Utility Shows Error Msg In Pre_upg_sanity_chk1.sql.log And Pre_upg_sanity_chk2.sql.
(Doc ID 2194372.1)
Last updated on FEBRUARY 24, 2021
Applies to:
Oracle Communications Billing and Revenue Management - Version 6.7.0.0.0 to 7.3.0.0.0 [Release 6.7.0 to 7.3.0]Information in this document applies to any platform.
Goal
On : 6.7.0.0.0 version, Upgrade
After installing "7.3_PortalBase_Upgrade_67_73_solaris_32_opt.bin" package in /opt/portal/upgrade/67_73/ folder
While running the below, got error in log files.
----------------------------------------------------------------------------------------
1) In pre_upg_sanity_chk1.sql.tmp :
============================================
The error messages is:
STOP:: Unsupported version of Oracle.
Please upgrade to a supported version of Oracle (9i or higher) before starting
the
database upgrade.
STOP:: rollback segment specified in the upgrade.cfg file () does not exist
PL/SQL procedure successfully completed.
============================================
Even after using the database version is 11g, above error occured ,
----------------------------------------------------------------------------------------
2) In pre_upg_sanity_chk2.sql.log :
============================================
The error msg is:
WARNING
The following tables have statistics. Upgrade scripts use rule based optimizer
to get predictable behaviour. So delete the statistics to disable the cost based
optimizer.
ACCOUNT_BALANCES_T
ACCOUNT_NAMEINFO_T
ACCOUNT_PHONES_T
ACCOUNT_PRODUCTS_T
CHANNEL_CONSUMERS_T
CHANNEL_SUPPLIERS_T
CHANNEL_T
CONFIG_ADJUSTMENT_EVENTS_T
CONFIG_BEID_BALANCES_T
CONFIG_CURRENCY_EMU_MEMBERS_T
============================================
Qn1: One can neglect the issue of unsupported oracle version or need to handle?
Qn2: Since, in 11g oracle does not support the rollback segments feature instead of that Oracle is supporting undo table spaces and rollback segments has to be automated?
Qn3: Also In 11g, only cost based optimized is there and the rule based optimizer is not supported now. So one can neglect the issue of rule based optimized or need to delete the table statistics?
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 |
| References |