Database Tuning (MOSC)

MOSC Banner

invalid status of db after upgrade

edited Feb 15, 2010 1:56AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi,
I have upgraded oracle database from 9.2.07 to 10.2.0.4 and applied psu patch 2 before upgrade.sql and then i ran psu ..sql script and I am getting below status when I am trying to run utlu102s.sql:--

SQL> @?/rdbms/admin/utlu102s.sql
.
Oracle Database 10.2 Upgrade Status Utility           02-13-2010 14:17:55
.
Component                                Status         Version  HH:MM S
Oracle Database Server                  INVALID      10.2.0.4.0  00:10:49
Oracle Real Application Clusters        INVALID      10.2.0.4.0  00:00:01
.
Total Upgrade Time: 00:11:41

PL/SQL procedure successfully completed.


DBA_REGISTRY ouSQL> select comp_id,status from dba_registry;

COMP_ID                        STATUS
------------------------------ -----------
CATALOG                        VALID
CATPROC                        VALID
RAC                            INVALID
tput is below:

Thanks,
MK

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center