ArcSDE 9.2 SP6 upgrade to ArcSDE 10 SP5 upgrade issue

[MilosMilicevic]

Hello,

I am having issues with upgrading to ArcSDE 10 SP5.
My gdb is on ArcSDE 9.2 SP6 on Oracle 10.2.0.3 x32 .I have migrated the data to Oracle 11.2.0.3 x64 (Server 2008 R2 x64), and trying to make a direct connection through ArcCatalog 10, in order to perform the upgrade to ArcSDE 10 SP5.


The problem that I encounter is that the direct connection will not work. It gives all sort of error messages (the most common one is a general DBMS error "underlying DBMS error [Unkonown error.No extended error.]".
We have installed the 32bit Oracle Client (full, not Instant), but avail.
I have followed the instructions on ESRI site, on how to connect without SDE service, eg: sde:oracle11g:<Net service name 32bit>
What is interesting is this: When i try to connect to the new database, from the old server, with ArcCatalog 9.2, it connects and shows all the data, but cannot upgrade, since it has ArcSDE 9.2 installed, and I cannot install a new version since that server still runs as a production server.

Please advise...
tnx in advance.
Regards,
Milos.

[MarcoBoeringa]

Have you edited the PATH environment variable as referred to on this Help page?:
http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000

Also check your connection properties against the options listed for the Instance string in Oracle on this page:
http://resources.arcgis.com/en/help/main/10.1/index.html#/Database_connections_in_ArcGIS_for_Desktop...

And check all steps listed here in the 10.0 Help about upgrading:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p0000000

Also, there are some caveats to take notice of when doing an upgrade from a 32bit to 64bit Oracle version in the same process. See this Help page. To be honest, you may wish to call in ESRI support for an upgrade like this... and it may even not be possible without temporarily making your production database unavailable for maintenance to allow an upgrade of the geodatabase there, if I understand the instructions well on this Help page:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_...

[MilosMilicevic]

Hello Marco, and tnx for replying.
I checked the links You provided and everything seems to be ok. I tried to put the path to the 32bit client first in the PATH variable, and nothing happened. I even found an article about a bug in Desktop v10, since I have been getting this error:

http://support.esri.com/es/knowledgebase/techarticles/detail/31875

Reinstalled the Desktop to c:/ESRI10 and no results.
Also, Regarding the process of the data movement and upgrade, it seems that it went ok, as far as the data, since I can connect to the gdb from my old server, and see the data, and it seems ok.

Now I keep getting error that states that the app cannot load libraries. Found this:

http://support.esri.com/en/knowledgebase/techarticles/detail/36510
It opposes your suggestion, but I tried it also, also no result...

Any other suggestions?
Thanks a lot.
Regards,
M.

[MarcoBoeringa]

Now I keep getting error that states that the app cannot load libraries. Found this:

http://support.esri.com/en/knowledgebase/techarticles/detail/36510
It opposes your suggestion, but I tried it also, also no result...

Any other suggestions?
Thanks a lot.
Regards,
M.

Since you seem to correctly have installed the 32bit version of the Oracle Client on the new machine with ArcGIS for Desktop from which you are trying to upgrade the geodatabase (at least you mention installing 32bit in your first post), I don't think this issue is related to your problems. This issue happens when you install a 64bit version of Oracle Client. ArcGIS for Desktop can not use a 64bit database client (ArcGIS for Server and the ArcSDE Application Server can).

Again, I think this is unrelated.

I think your main issue is that, according to the ESRI documentation in this Help page, you need to upgrade the geodatabase on the existing machine first (in your case your 9.2 production server). It must be upgraded to a 32bit Oracle database, ArcGIS 10.0 SP5 install. After that, you can migrate the upgraded geodatabase to the new server with 64bit Oracle and also ArcGIS 10.0 SP5 geodatabase.

You did not do this, you moved the existing 9.2 geodatabase to the new 64bit Oracle database server, and than attempted to upgrade to 10.0 SP5 using the ArcGIS 10.0 SP5 installed on the new server.

Again, if I understand the Help page well, you will need down time for maintenance on your production server to do the upgrade, unless you are able to create a second, temporary, identical 9.2 server with a copy of the Oracle 32bit database, to do the upgrade to 10.0 SP5 there. You could than migrate the data to the new 64bit server from there, and migrate somehow any data changes on your production server to the new 10.0 SP5 geodatabase on the new server.

[MilosMilicevic]

Hello Marco,

I followed your suggestion.
The prerequisite check went well, but the upgrade did not.
Here is the sde_setup.log file:


[Tue May 07 15:18:18 2013]
ST_Geometry Schema Owner: (SDE) Type Release: 1007
[Tue May 07 15:18:18 2013] Instance initialized for ((sde)) . . .

[Tue May 07 15:18:18 2013] LAYER_STATS table being created...
[Tue May 07 15:18:18 2013] LAYER_STATS table created...
[Tue May 07 15:18:19 2013] Warning: Resetting MAXBLOBSIZE value to remove maximum blobsize restriction (-1). Old value (30000000)
[Tue May 07 15:18:19 2013] DBMS stored procedures being created or updated...
[Tue May 07 15:18:26 2013] DBMS stored procedures created or updated...
[Tue May 07 15:18:27 2013] WARNING: Config parameter "XML_COLUMN_STORAGE" not found in keyword "DEFAULTS".
  Inserting the default values.
[Tue May 07 15:18:27 2013] Error insert/update following data into DBTUNE table:
Config keyword: DEFAULTS
Parameter name: XML_COLUMN_STORAGE
Config String : SDE_XML
[Tue May 07 15:18:27 2013] ERROR in upgrading dbtune table.
Error: -51
[Tue May 07 15:18:27 2013] DBMS error code: 25153
ORA-25153: Temporary Tablespace is Empty


[Tue May 07 15:18:27 2013]
Parameter XML_COLUMN_STORAGE of keyword DEFAULTS failed to load.
[Tue May 07 15:18:27 2013]  Config Keyword: DEFAULTS
[Tue May 07 15:18:27 2013]  Parameter_name: XML_COLUMN_STORAGE
[Tue May 07 15:18:27 2013]  Config_string : SDE_XML

[Tue May 07 15:18:27 2013] SDE release upgrade not completed(-1).
[Tue May 07 15:18:27 2013] ERROR installing/upgrading ArcSDE, Error = -1


Any idea what could be wrong?

Tnx,
M.

[VinceAngelo]

I've never seen an ORA-25153 before.  This is certainly something to
discuss with Tech Support.

You shouldn't need to upgrade the database to 32-bit 11g first, but the
details on how you performed the upgrade will likely be critical in resolving
the error.

- V

[MarcoBoeringa]

It seems you aren't able to edit the DBTUNE table using the account with which you logged in. You might check if this is the case with the tools in the database. Do you have Insert and Update rights on the table.

This Help page also mentions to ensure the ArcSDE administrator has sufficient permissions to do the upgrade (unfortunately, on it isn't mentioned which ones. Undoubtedly documented somewhere else...):

"Grant the ArcSDE administrator the permissions necessary to upgrade a geodatabase."

OK, I think they are listed here:

User permissions for geodatabases in Oracle
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n0000002v000000

Probably wise to contact Tech support like Vince suggested, but here are two links concerning the Oracle error code:

https://forums.oracle.com/forums/thread.jspa?threadID=969107
http://neeraj-dba.blogspot.nl/2011/04/ora-25153-temporary-tablespace-is-empty.html

[MilosMilicevic]

I have granted all the privileges to the sde user...those on the list, and everything else, for the test only.
Now I cannot even connect, so I must restore the gdb from backup.

Should I maybe have done this as a SYS or SYSTEM user?
What should be my next steps?

Tnx.
M.

[MarcoBoeringa]

I have granted all the privileges to the sde user...those on the list, and everything else, for the test only.
Now I cannot even connect, so I must restore the gdb from backup.

Should I maybe have done this as a SYS or SYSTEM user?
What should be my next steps?

Tnx.
M.

Have you checked the temporary tablespace settings, as per the Oracle links I linked in the last post?

Restoring your geodatabase from backup, and contacting ESRI Tech support to guide you through the upgrade is probably the wisest thing at this point. You have a triple set of "upgrades" going on: geodatabase version, oracle version and switch from 32bit to 64bit database. That means a lot of details and points where it may go wrong.

[MilosMilicevic]

You shouldn't need to upgrade the database to 32-bit 11g first, but the
details on how you performed the upgrade will likely be critical in resolving
the error.

- V

I see this just now!
Are you saying that the procedure on this link is not necessary:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_...

Here is what I did, step by step:

• exported production with expdp


• imported to new 64bit oracle - with SKIP option, so that the Oracle system binaries remain intact


• Installed ArcSDE 10 x64 for Oracle 11g


• installed ArcSDE SP5


• Ran the postinstall without creating sde user & tbs / only authorization and service creation


• Installed ArcGIS 10 with SP5


• Stopped on creating direct connect to Oracle through ArcCatalog

Then I saw Marco's post, and tried to upgrade the production GDB, and got the error log posted above...
Could it be that adding all privileges to sde caused the update failure (I gave all Object privileges to sde user before upgrading...)?!

@Marco: I missed the links on the bottom of the page. You were right about the temp space. It has no datafiles. I don't know how this happened, since this is a test instance, and an exact copy of the production. We are now restoring from backup, and will checkk the temp tbs, and then see what happens with the upgrade. If it fails again, we will contact the Tech Support, and get back to you with the status/results.
Thanks a lot.
Milos