Migrating ArcSDE 9.3 under Oracle 10G r2 to ArcSDE 9.3.1 under Oracle 110G r2

[SufianKhader]

Dear All,

We have this project of migrating ArcSDE Repository and spatial data to a new better Server:

Source: ArcSDE 9.3, Oracle 10G r2, Solaris 10 64 SPARC
Destination:  ArcSDE 9.3.1, Oracle 11G r2, Solaris 10 64 SPARC

We had some issues while working, but we managed to solve most of them, here is a summary of what we have done so far:

1- Install Oracle 11G r2 software, and create a Database on the new Server.
2- Install the ArcSDE 9.3.1 Software on the same Server
3- Take a databump file of the SDE user, Data Owner, and all the other business users from destination.
4- Import the Databump file on the new Server.
5- upgrading the ArcSDE Repository on the new Server, but this step didn't work! giving us the following error:

[Sun Jun 23 15:06:22 2013]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Sun Jun 23 15:06:22 2013] Instance initialized for ((sde)) . . .

[Sun Jun 23 15:06:22 2013] ArcSde is already at an acceptable release:
        9.3.0
[Sun Jun 23 15:06:22 2013] ERROR in creating index on  TABLE_LOCKS.
Error: -51
[Sun Jun 23 15:06:22 2013] DBMS error code: 2158
ORA-02158: \330\256\331\212\330\247\330\261 CREATE INDEX \330\272\331\212\330\261 \330\265\330\247\331\204\330\255


[Sun Jun 23 15:06:22 2013] SDE release upgrade not completed(-51).
[Sun Jun 23 15:06:22 2013] ERROR installing/upgrading ArcSDE, Error = -51


Any ideas, your help are appreciated.

Best Regards
Sufian Khader

[VinceAngelo]

First off, you should make sure SP2 has been applied -- If you're going to upgrade
to old software, you should be running the terminal release.  I think there were 
several post-SP2 patches, they should be applied as well. This will have the side-
effect of putting you in a supported configuration (9.3.1 SP1 was the first release
to support Oracle 11gR2).

Then, if you're still having issues, you'll need to look at the contents of the DBTUNE
table, to see if there's something breaking the CREATE INDEX directive.

- V

[SufianKhader]

Thank you Angelo for the update, actually I have applied SP1 for ArcSDE 9.3.1 successfully, but the problem is in the upgrade stage. Also I want to mention that the result of the following select statement on the destination Server:

Select * from sed.version;

Giving us the following output, although it is a 9.3.1 on an Oracle 11G Server .

Major     Minor    Bug_Fix     Database
9              3               0             ORACLE10GR2

Regards

[SufianKhader]

Hi Guys Any updates??

Is the problem in the dbtune table (create index directive) ? If so, which directive exactly is used for creating an Index on the TABLE_LOCKS table?

Regards