Error upgrading ArcSDE 9.1 -> 9.3.1

[ElenaGuandalini]

We are trying to upgrade an existing ArcSDE 9.1 to 9.3 running on Oracle 9.2.0.8 on Windows 2003 server.
Both we use postinstallation process or we run the 'sdesetup -o upgrade' command, we get the following error:

[Tue Jun 22 10:54:19 2010] SQL Stmt: <drop package SDE.st_geometry_shapelib_pkg>
[Tue Jun 22 10:54:19 2010] ERROR in creating system stored procedures.
Error: -51
[Tue Jun 22 10:54:19 2010] DBMS error code: 4043
ORA-04043: object ST_GEOMETRY_SHAPELIB_PKG does not exist


[Tue Jun 22 10:54:19 2010] SDE release upgrade not completed(-1).
[Tue Jun 22 10:54:19 2010] ERROR installing/upgrading ArcSDE, Error = -1


We know there is a bug, this is the post
http://resources.arcgis.com/content/nimbus-bug?bugID=TklNMDQzOTg4
but another application run on Oracle server, so we can't uninstall the patch (CPUOct2008).

Are there other solution or workaround to this problem? And are there known issues with ST_GEOMETRY library after installation?

Thank you.

Elena

[VinceAngelo]

The only option I can see is creating a new 9.2.0.8 instance *without* the problematic
CPU, upgrading there, then using exp/imp to re-integrate.  Ugly, but it might work.

Keep in mind that Oracle 9.2 is no longer supported by Oracle (in fact 10gR2 is now
in limbo as well), and ArcSDE 9.3 is the last ESRI release to support 9iR2 (ArcSDE 10
only supports 10gR2 and 11g [32- and 64-bit]).  You may need to consider moving your
GIS data to a more modern database, and rigging some backward export mechanism
to support the 9i-bound application until you can transition it.

- V

[ElenaGuandalini]

Thank you for the reply.
We will try your solution and we have another question about it.

In Oracle database there are 3 schemas: SDE schema, a schema for vector data and another for raster data. When we create the new instance (9.2.0.8 without patches), where we upgrade, should we only export/import SDE schema or all schemas? Specifically, the upgrade process after the installation updates only the schema structure/data on SDE schema? Or also raster or vector data of the other schemas?

Regards,
Elena

[VinceAngelo]

The three user schemas are all bound to a single instance; you need to move everything.

- V

[ElenaGuandalini]

Sorry, I meant this.
We export schemas and import them into a new Oracle instance on a different server. After upgrading we reimport them in the old Oracle instance. It's similar to what you have proposed. Might it work? And in this way can we move only SDE schema or should we move all schemas because upgrade process going to manipulate vector and raster data?

Elena

[VinceAngelo]

You can't do a partial upgrade.  You need to upgrade all schemas, SDE first, before
extracting into CPUed server.

- V