Problem in Upgrading Geodatabase from 9.3.1 to 10.2

HaythamAbdel-Rahman — Mon, 25 Nov 2013 14:34:13 GMT

I have a problem in upgrading ArcSDE 9.3.1 to 10.2, please find below steps that I have done.
1- Original Database was Oracle 9i Enterprise edition release 9.2.0.8.0 64bit, hosted on UNIX, ArcSde version 9.1
2- I performed full database backup for the database
3- Restored the dump file on Oracle 11g Enterprise edition release 11.2.0.2 64bit hosted on Linux Redhat enterprise 64bit
4- Performed ArcSDE 9.3.1 for oracle 10g post install,
a. I selected Custom
b. Selected Repository Setup �??Only�?�, and uncheck all other options
c. I kept default file for GIOMGR.defs, and dbinit.sde
d. I selected Upgrade for DB tune, and regarding Geometry, I selected �??Keep Current default geometry storage�?�
5- Connect using ArcCatalog 9.3.1 and perform Geodatabase upgrade
6- Make direct connection using ArcCatalog 10.2 installed on Windows 7 64bit machine, having oracle 11g client 32bit installed,          using �??SDE�?� user
7- I tried to perform upgrade Geodatabase
        a.First I selected �??Perform prerequisite check�?� only: it passed with the below warning
         �??Connected RDBMS instance is not setup for ST_GEOMETRY configuration. [Unable to determine current version of ST_SHAP          ELIB. Please check the ST_Geometry shape library path on the Oracle server, which is set to "C:\Program Files\ArcGIS\ArcSD         E\ora10gexe\bin\st_shapelib.dll". Refer to the ArcGIS help topics for more details.�?�, I copied the �??libst_shapelib.so�?� to the ora         cle home \lib directory on the database server (Linux), but it didn�??t solve the problem, even by updating the extproc.ora file           as mentioned in the below link
         http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000091000000 , however it was just a warning so I conti         nued to upgrade the database.
         b.I selected �??Upgrade Geodatabase�?� only, I got the same warning of ST_GEOMETRY, then it continue and gives me the
         below error

         Running Pre-Requisite check (C:\Users\hboieth\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\SDE on HAYTHAM.sde).
Instance supports XML type.
Updating server tables and stored procedures.
Could not update server tables and stored procedures.
Refer to upgrade logfiles for more details:
C:\Users\hboieth\AppData\Local\Esri\Desktop10.2\GDBUpgrade.log
C:\Users\hboieth\AppData\Local\Temp\sde_setup.log
Unpaused the database.
Failed to execute (UpgradeGDB).
Failed at Mon Nov 25 20:39:25 2013 (Elapsed Time: 0.97 seconds)

         c.Below the �??sde_setup.log�?�

[Mon Nov 25 19:21:41 2013]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Mon Nov 25 19:21:41 2013] Instance initialized for ((sde)) . . .

[Mon Nov 25 19:21:41 2013] Cannot upgrade a user schema geodatabase
when the master schema geodatabase is at a previous release.
The master schema geodatabase must be upgraded first.
[Mon Nov 25 19:21:41 2013] ERROR: Geodatabase schema object install not completed (-522).

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2

VinceAngelo — Mon, 25 Nov 2013 16:13:19 GMT

Step 4 seems to be wrong -- You needed to use the ArcSDE 9.3.1sp2 for Oracle 11g
post-installer, not the 10g post-installer.

- V

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2

AsrujitSengupta — Mon, 25 Nov 2013 20:17:17 GMT

While creating the connection in Desktop 10.2, did you use the syntax "sde: oracle11g:TNSNAME" ?

If yes, just try creating the connection with "TNSNAME" in the Instance parameter.

http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3

Regards,

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2

HaythamAbdel-Rahman — Tue, 26 Nov 2013 04:59:12 GMT

While creating the connection in Desktop 10.2, did you use the syntax "sde: oracle11g:TNSNAME" ?

If yes, just try creating the connection with "TNSNAME" in the Instance parameter.

http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3

Regards,

Thanks, it worked after updating the instance name to the TNSNAME only

topic Problem in Upgrading Geodatabase from 9.3.1 to 10.2 in Data Management Questions

Problem in Upgrading Geodatabase from 9.3.1 to 10.2

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2

Re: Problem in Upgrading Geodatabase from 9.3.1 to 10.2