Re: How did this happen

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1123040132.490542_at_yasure...
> joe bayer wrote:
>> I am assigned to a database 9206 on Window server 2003, the database
>> seems working fine, but have 2000 invalid objects after re-compile.
>> Registry is like this
>>
>> COMP_ID VERSION STATUS
>> ---------- -------------------- -----------
>> CATALOG 9.2.0.6.0 INVALID
>> CATPROC 9.2.0.6.0 VALID
>> OWM 9.2.0.1.0 VALID
>> JAVAVM 9.2.0.1.0 VALID
>> XML 9.2.0.2.0 VALID
>> CATJAVA 9.2.0.1.0 VALID
>> ORDIM 9.2.0.1.0 LOADED
>> SDO 9.2.0.1.0 LOADED
>> CONTEXT 9.2.0.1.0 VALID
>> XDB 9.2.0.1.0 INVALID
>> WK 9.2.0.1.0 VALID
>> ODM 9.2.0.1.0 LOADED
>> How could I fix the problem?Thanks for your help
>
>
> SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
>
> Substitute in your ORACLE_HOME for the environment variable.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

Daniel,
I guess he already tried this - "2000 invalid objects after re-compile". Joe,
Maybe you could try re-installing the 9.2.0.6.0 patch set. The database will go offline then of course, and do take a full back-up before the upgrade.

Matthias Received on Wed Aug 03 2005 - 05:25:32 CDT