Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Server INVALID status after Manual upgrade from 11.1.0.7 to 12.1.0.2

chijarMay 27 2019 — edited May 28 2019

Hi fellows,

I have recently upgraded from 11107 to 12102 my Oracle db. After running @?/rdbms/admin/utlu121s.sql the results look like this:

Oracle Database 12.1 Post-Upgrade Status Tool           05-27-2019 12:23:25

Component                               Current         Version  Elapsed Time

Name                                    Status          Number   HH:MM:SS

Oracle Server                           INVALID      12.1.0.2.0  00:08:14

JServer JAVA Virtual Machine              VALID      12.1.0.2.0  00:01:14

Oracle Workspace Manager                  VALID      12.1.0.2.0  00:00:34

OLAP Analytic Workspace                   VALID      12.1.0.2.0  00:00:13

Oracle XDK                              REMOVED      12.1.0.2.0  00:01:03

Oracle Text                               VALID      12.1.0.2.0  00:00:32

Oracle XML Database                       VALID      12.1.0.2.0  00:01:29

Oracle Database Java Packages             VALID      12.1.0.2.0  00:00:07

Oracle Multimedia                       INVALID      12.1.0.2.0  00:02:16

Spatial                                 INVALID      12.1.0.2.0  00:02:57

Final Actions                                                    00:00:45

Post Upgrade                                                     00:00:07

Total Upgrade Time: 00:20:16

Why and how can I fix the "Oracle Server" item???

About the other components, we don't have a problem because we have never used and dropped before the upgrade.

I have searched on Metalink but there is no document for my issue. Only has this one:

Take in count I have run the utlrp.sql script twice or 3 times also.

Oracle 12cR1 Upgrade: Why utlu121s.sql reports "Oracle Server" component status as "UPGRADED" instead of "VALID" after Manual Upgrade? (Doc ID 1572878.1)

fActs:

- Linux 6.5

- Oracle single instance without archive logs and without ASM

- Oracle entrprise edition

Please, your kindly help.

Thanks in advance

Comments
Post Details
Added on May 27 2019
1 comment
3,506 views