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 NOVEMBER 27, 2016

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

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