topic Re: Cannot upgrade version 10 SDE geodatabase to 10.2.2 in Data Management Questions

Cannot upgrade version 10 SDE geodatabase to 10.2.2

JamesStreet1 — Tue, 15 Apr 2014 22:22:55 GMT

I have an SDE Oracle 11g geodatabase running on my server and just uninstalled arcgis desktop 10 and installed version 10.2.2. When performing a direct connect as the sde user and trying to run the upgrade geodatabase tool I get the message "This 10.0 geodatabase matches the ArcGIS release you are currently using" Anyone know what the problem might be?

Re: Cannot upgrade version 10 SDE geodatabase to 10.2.2

AsrujitSengupta — Tue, 15 Apr 2014 23:11:57 GMT

Check the Bit level of the Oracle database. Starting from 10.1 only 64-Bit oracle databases are supported....so you cannot upgrade a 32-Bit oracle database to 10.1/10.2 or later.

SQL to check the Bit level of Oracle db:

Connect in SQLPLUS using a sys user and execute the below query

select
length(addr)*4 || '-bits' word_length
from
v$process
where
ROWNUM =1;

Oracle database requirements for ArcGIS 10.2.x:
http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//01510000006s000000

Re: Cannot upgrade version 10 SDE geodatabase to 10.2.2

JamesStreet1 — Wed, 16 Apr 2014 02:09:10 GMT

Looks like that was the problem thanks Asrujit.

James