Re: How to upgrade a DB from 9.2.0.1 to 9.2.0.7 ???

Did you run the post installation scripts against the database, as listed in the readme for the patch?

--Peter

Charly wrote:
> Dear all,
>
> I've just upgraded my Oracle software to version 9.2.0.7 because it corrects a
> bug found in 9.2.0.1.
>
> OK, now the bug disappeared... but ....
>
> Now I cannot use anymore IMP and EXP. I face the following error :
>
> ------------8<------------------8<------------------
>
> C:\Temp>exp ME/password_at_database file=exp_file owner=ME
>
> Export: Release 9.2.0.7.0 - Production on Tue Oct 4 15:22:06 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
> Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user ME
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions for user ME
> EXP-00008: ORACLE error 942 encountered
> ORA-00942: table or view does not exist
> EXP-00024: Export views not installed, please notify your DBA
> EXP-00000: Export terminated unsuccessfully
>
> ------------8<------------------8<------------------
>
>
> I looked for upgrade scripts/tools/info and the like... localy and on the net
> (metalink, asktom, usenet, etc) without luck so far.
>
> I found CATEXP.SQL and CATPATCH.SQL in %ORA_HOME%\rdbms\admin, but can't tell
> wether this is for 9.2.0.1 or 9.2.0.7...
>
> I also tried, just to mentioned, the "Database Upgrade Assistant", but it tells
> me that my database is already in 9.2 format... Yes I know :-(
>
> I can export & import data from a workstation that still has a 9.2.0.1 client
> installed, so I suspect the problem is quite small, but I'd like to know.
> Perhaps there is other issues that I did not find yet...
>
> Can anyone give me any hints ?
>
> My environment is :
> - Windows 2000 server or Windows XP (databases on both platforms showing the
> same behavior)
> - Oracle 9.2.0.7 patch applied on a 9.2.0.1 server & client software.
>
>
> Thanks in advance,
>
> Charly
Received on Tue Oct 04 2005 - 09:40:06 CDT