Sample logfile generated by dbupdiag.sql

                          *** Start of LogFile ***

  Oracle Database Upgrade Diagnostic Utility       07-01-2008 12:17:30

===============
Database Uptime
===============

15:16 30-JUN-08

=================
Database Wordsize
=================

This is a 32-bit database

================
Software Verison
================

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

=============
Compatibility
=============

Compatibility is set as 9.2.0.0.0

================
Component Status
================

COMP_ID      COMP_NAME                                STATUS      VERSION    ORG_VERSION PRV_VERSION
------------ ---------------------------------------- ----------- ---------- ----------- -----------
AMD          OLAP Catalog                             VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
APS          OLAP Analytic Workspace                  VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
CATALOG      Oracle Database Catalog Views            VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
CATJAVA      Oracle Database Java Packages            VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
CATPROC      Oracle Database Packages and Types       VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
CONTEXT      Oracle Text                              VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
EM           Oracle Enterprise Manager                VALID       10.2.0.4.0
JAVAVM       JServer JAVA Virtual Machine             VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
ODM          Oracle Data Mining                       VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
ORDIM        Oracle interMedia                        VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
OWM          Oracle Workspace Manager                 VALID       10.2.0.1.0 9.2.0.1.0   9.2.0.1.0
WK           Oracle Ultra Search                      INVALID     9.2.0.7.0  9.2.0.7.0
XDB          Oracle XML Database                      VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0
XML          Oracle XDK                               VALID       10.2.0.4.0 9.2.0.9.0   9.2.0.9.0
XOQ          Oracle OLAP API                          VALID       10.2.0.4.0 9.2.0.7.0   9.2.0.7.0

======================================================
List of Invalid Database Objects Owned by SYS / SYSTEM
======================================================

Number of Invalid Objects
------------------------------------------------------------------
There are no Invalid Objects

DOC>################################################################
DOC>
DOC> If there are no Invalid objects below will result in zero rows.
DOC>
DOC>################################################################
DOC>#

no rows selected

================================
List of Invalid Database Objects
================================

Number of Invalid Objects
------------------------------------------------------------------
There are no Invalid Objects

DOC>################################################################
DOC>
DOC> If there are no Invalid objects below will result in zero rows.
DOC>
DOC>################################################################
DOC>#

no rows selected

==============================================================
Identifying whether a database was created as 32-bit or 64-bit
==============================================================

DOC>###########################################################################
DOC>
DOC> Result referencing the string 'B023' ==> Database was created as 32-bit
DOC> Result referencing the string 'B047' ==> Database was created as 64-bit
DOC> When String results in 'B023' and when upgrading database to 10.2.0.3.0
DOC> (64-bit) , For known issue refer below articles
DOC>
DOC> Note 412271.1 ORA-600 [22635] and ORA-600 [KOKEIIX1] Reported While
DOC>    Upgrading Or Patching Databases To 10.2.0.3
DOC> Note 579523.1 ORA-600 [22635], ORA-600 [KOKEIIX1], ORA-7445 [KOPESIZ] and
DOC>   OCI-21500 [KOXSIHREAD1] Reported While Upgrading To 11.1.0.6
DOC>
DOC>###########################################################################
DOC>#

Metadata Initial DB Creation Info
-------- -----------------------------------
B023     Database was created as 32-bit

===================================================
Number of Duplicate Objects Owned by SYS and SYSTEM
===================================================

Counting duplicate objects ....

  COUNT(1)
----------
         4

=========================================
Duplicate Objects Owned by SYS and SYSTEM
=========================================

Querying duplicate objects ....

OBJECT_NAME                              OBJECT_TYPE
---------------------------------------- ----------------------------------------
AQ$_SCHEDULES                            TABLE
AQ$_SCHEDULES_PRIMARY                    INDEX
DBMS_REPCAT_AUTH                         PACKAGE
DBMS_REPCAT_AUTH                         PACKAGE BODY

DOC>
DOC>################################################################################
DOC>
DOC> If any objects found please follow below article.
DOC> Note 1030426.6 How to Clean Up Duplicate Objects Owned by SYS and SYSTEM schema
DOC> Read the Exceptions carefully before taking actions.
DOC>
DOC>################################################################################
DOC>#

================
JVM Verification
================

JAVAVM - Installed properly

================================================
Checking Existence of Java-Based Users and Roles
================================================

DOC>
DOC>################################################################################
DOC>
DOC> There should not be any Java Based users for database version 9.0.1 and above.
DOC> If any users found, it is faulty JVM.
DOC>
DOC>################################################################################
DOC>#

User Existence
---------------------------
No Java Based Users

DOC>
DOC>###############################################################
DOC>
DOC> Healthy JVM Should contain Six Roles.
DOC> If there are more or less than six role, JVM is inconsistent.
DOC>
DOC>###############################################################
DOC>#

Role
------------------------------
There are 6 JAVA related roles

Roles

ROLE
------------------------------
JAVAUSERPRIV
JAVAIDPRIV
JAVASYSPRIV
JAVADEBUGPRIV
JAVA_ADMIN
JAVA_DEPLOY

=========================================
List of Invalid Java Objects owned by SYS
=========================================

There are no SYS owned invalid JAVA objects

DOC>
DOC>#################################################################
DOC>
DOC> Check the status of the main JVM interface packages DBMS_JAVA
DOC> and INITJVMAUX and make sure it is VALID.
DOC> If there are no Invalid objects below will result in zero rows.
DOC>
DOC>#################################################################
DOC>#

no rows selected

INFO: Below query should succeed with 'foo' as result.

JAVAVM TESTING
---------------
foo

                            *** End of LogFile ***