Upgrade from 9i to 10gR2 .... Running the 10gR2 Pre-Upgrade Checks Script "utlu102i.sql"

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 26 Oct 2006 20:05:27 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302001FCE179@BLRKECMSG11.ad.infosys.com>

Mark, Folks  

When Running the 10gR2 Pre-Upgrade Checks Script "<10gR2 ORACLE_HOME>/rdbms/admin/utlu102i.sql", got the following Output:-  

---

Miscellaneous Warnings

---

WARNING: --> Database contains stale optimizer statistics.

.... Refer to the 10g Upgrade Guide for instructions to update

.... statistics prior to upgrading the database.

.... Component Schemas with stale statistics:

.... SYS
  Qs Will the following script Update the Statistics of SYS Objects?

exec dbms_stats.gather_schema_stats('SYS',options=>'GATHER', -

                        estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,

-

                        method_opt => 'FOR ALL COLUMNS SIZE AUTO',

cascade => TRUE);    

WARNING: --> Database contains INVALID objects prior to upgrade.

.... USER PERFSTAT has 1 INVALID objects.

.... USER SYS has 3 INVALID objects.

.... USER SYSTEM has 5 INVALID objects.
 

Select * from sys.dba_objects

                     WHERE status = 'INVALID' AND

                           object_name NOT LIKE 'BIN$%'

and owner in ('SYS','SYSTEM','PERFSTAT');

Output of above included these 2 Objects - SYS.DBA_LOCK_RAC & Procedure PERFSTAT. GATHER_POOLSTAT, Others been created erroneously by Users.

Qs Are the Above 2 "Standard" Data Dictionary Objects OR have they been also created by a User?

Qs If NO action is taken for these INVALID Objects, what might be the implications?  

WARNING: --> Passwords exist in some database links.

.... Passwords will be encrypted during the upgrade.

.... Downgrade of database links with passwords is not supported.
 

Qs What Action is needed for this? Does the "Create Database Link ... SQL script" need to be RE-Run after the Upgrade?    

WARNING: --> Deprecated CONNECT role granted to some user/roles.

.... CONNECT role after upgrade has only CREATE SESSION privilege.
 

Qs Is Any Action needed for this?  

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 26 2006 - 09:35:27 CDT