how to assert Oracle installation correctness ?

Giganews Newsgroups
Subject: how to assert Oracle installation correctness ?
Posted by:  Giovanni Azua (braveg…
Date: Fri, 7 Oct 2005

Hi all,

When we migrate the database instances "to catpatch it" after
applying patchsets, chances are that we get a final report
that looks like the following:

COMP_NAME                          STATUS      VERSION
Oracle9i Catalog Views                VALID
Oracle9i Packages and Types        VALID
Oracle Workspace Manager          VALID
JServer JAVA Virtual Machine      VALID
Oracle XDK for Java                    VALID
Oracle9i Java Packages                  VALID
Oracle interMedia                          VALID
Spatial                                            VALID
Oracle Text                                    VALID
Oracle XML Database                  VALID
Oracle Ultra Search                        VALID

COMP_NAME                          STATUS      VERSION
Oracle Data Mining                        VALID
OLAP Analytic Workspace    UPGRADED
Oracle OLAP API                  UPGRADED
OLAP Catalog                              VALID

But in the very worse case, despite the fact that all components
appear really O.K. we might still miss critical errors somewhere
during execution of catpatch e.g.

(taken from one problematic installation)
begin if initjvmaux.startstep('CREATE_JAVA_SYSTEM') then
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
ORA-06512: at "SYS.INITJVMAUX", line 15
ORA-06512: at line 5

ERROR at line 1:
ORA-20000: JServer has not been correctly loaded into the database.
ORA-06512: at line 3

My question is:

How can I assert the total correctness of any Oracle installation
(including patchsets and migration) without ending up in many core
dumps or extremelly hard to diagnose e.g. strange behavior of the
optimizer or bizzarre errors etc?

I have found lack of *correct* installation of catpatch by receiving:

- Invalid behavior of the optimizer e.g. full table scans where
  it must use indexes (all CBO prerequisites ok e.g. statistics etc).
- Components unable to be installed e.g. Oracle Workflow.
- Major core dumps executing innocuous queries.

All of the above are symptoms for me to diagnose lack of correct
Oracle installation.

I would really appreciate to be pointed to some diagnosing package
for this purpose and I will then probably make my applications to
have the precondition of "Oracle installation OK".

Many thanks in advance,
Best Regards,