nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Vind meer berichten getagd met

Accepted answers

All comments

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/019v00000003000000/

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_when_the_existing_DBMS_is_32_bit/002n000000q0000000/

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_when_the_existing_DBMS_is_32_bit/002n000000q0000000/

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

VinceAngelo

I don't see any place in that cookbook where is says to install 32-bit Oracle 11g.
It does say to upgrade the geodatabase before upgrading the database to 64-bit,
and your description doesn't include that step.

I try to avoid in-situ Oracle upgrades, preferring to load the data into a new instance
(prevents the fragmentation that occurs during uprade), but getting the data into the
instance can be a challenge.

- V

MilosMilicevic

I did as you guys suggested.
Did the upgrade to ArcSDE 10, and it wen well. The ORA-25153 was because I had no datafile in my TEMP tbs. After correcting that, the upgrade went smooth.
Now I have created the dump that I will import into Oracle 11g x64. I hope that it will go allright, because I already did this type of migration a few month ago (Oracle 10.2.0.3 x86 to x64).
I created a full export of the x86 Oracle, and after the copy of the .dmp to the server is done I will use impdp to import it into 11g.
Then I will run the postinstall, without creating the SDE tbs and user, only authorization and service creation.

Any suggestions on this?

Tnx,
M.

MarcoBoeringa

Good to hear the upgrade to 10.x on the 32-bit installation went well after correcting the TEMP tablespace issue. Good luck with the migration to the 64-bit server. I haven't got any additional suggestions here, sounds like you are on the right track now, maybe Vince has something to add.

I do see a potential issue with Oracle 11.2.0.1 mentioned here concerning import/export operations, but since you are using 11.2.0.3, this probably doesn't apply, anyway, maybe good to keep this in mind if anything goes wrong:

http://support.esri.com/en/knowledgebase/techarticles/detail/38470

MilosMilicevic

I give up...
this will not work no matter what.
I did the import, all ok, but still cannot connect to Oracle directly, or create a service.
Also I get error, that the authentification key cannot be updated.

MarcoBoeringa

I give up...
this will not work no matter what.
I did the import, all ok, but still cannot connect to Oracle directly, or create a service.
Also I get error, that the authentification key cannot be updated.

Seems to me you are awfully close to solving this, but I guess it may be good to call in some ESRI Help to get this ArcSDE authorization and database connection issue sorted out now you managed to upgrade and move the database to the 64-bit platform.

Anyway, you probably already followed these steps, but have you tested the functioning of the Oracle Net client per the text below from this Help page?

"2. Test that Oracle Net was installed successfully by typing the following at a command prompt on the client machine:

sqlplus <user name>/<password>@<Oracle Net service name>"

MilosMilicevic

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed).
I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from.

I will post results.
Tnx,
M.

MarcoBoeringa

Yes, that was the first thing I did, when the direct connect failed. It works with sqlplus, but in ArcCatalog, it gives me a general error message (Operation failed).
I have found in some forum, that the authentication error like this happens when a database name is changed, and I did change it...Now I will try to delete the database, and create a new 11g db, with the sam name as the 10g I did the upgrade and export from.

I will post results.
Tnx,
M.

Milo, Vince clearly stated in another thread that changing database names is NOT supported on geodatabases. This is because the database name is included in vital stored procedures and triggers etc. in the ArcSDE Repository.

So yes, ensure the database name of the new instance is exactly the same as the old one.

VinceAngelo

Changing database names is not supported with RDBMS software which supports databases.
Oracle does not support multiple databases in a larger instance container, so it is immune
from this possible complication.

I'm not sure what the complication is, but it can't be change of database name.

- V

PS: ArcSDE 10.0 requires a different ECP key than 9.2, so this might be the "authentication key".
See the doc on 'sdesetup -o update_key'.

MilosMilicevic

I have new ECP keys for v10, it can't be that.

VinceAngelo

Yet you reported an error that the authentication key could not be updated. So you should
confirm that the 10.0 key is present in the Oracle instance (and that the 9.2 key is not)
by inspecting the SDE.SERVER_CONFIG table:

sqlplus sde/password@instance
SELECT char_prop_value FROM server_config WHERE prop_name = 'AUTH_KEY';

(Please do not report the results to this thread, just whether the first two elements are
"arcsdeserver,100").

- V

MilosMilicevic

Still no results.
Cannot create a direct connection, nor authenticate.
I tried to run the PostInstallation as an Administrator, as stated here :
http://forums.arcgis.com/threads/2972-ArcSDE-Repository-was-unsuccessfully-completed-empty-error-log but avail.

Does the authentication for v10 write the key to the registry, or into a table in the database (like 9.2, that writes into SDE.SERVER_CONFIG, if I am correct?) ?
I attached the value of the AUTH_KEY that is inside the UPDATED database...it still has old value. I suppose that this is because one of two reasons:

Authorization was not able to update the property inside the SERVER_CONFIG.
Authorization is supposed to write elsewhere - eg. registry.

If it writes to the registry, maybe I could create a registry key with the contents of the .ecp file I received from ESRI?

P.S.
I wrote this before I saw your post, Vince. Seems that we think alike 🙂
As you see, the key doesn't get updated in the db...
P.P.S.
Would an update statement to the SERVER_CONFIG AUTH_KEY make any difference?

Capture.png

MarcoBoeringa

Still no results.
Cannot create a direct connection, nor authenticate.

If, like seems the case here based on your SQL query result, the key still references the old 9.2 one, it isn't strange you can't connect.

Does the authentication for v10 write the key to the registry, or into a table in the database (like 9.2, that writes into SDE.SERVER_CONFIG, if I am correct?) ?

I think you answered this yourself by extracting it from the database using the SQL statement Vince supplied. It is clearly stored in the Server_Config table. I don't know if there is a secondary storage in registry, Vince undoubtedly can tell, but it seems highly unlikely to me to have dual storage here for an option like this.

If it writes to the registry, maybe I could create a registry key with the contents of the .ecp file I received from ESRI?

I think your better shot at this would be to use a SQL UPDATE statement to update the contents of the Server_Config table with the contents of the *.ecp file.

E.g. I expect it to look something like this:

sqlplus sde/password@instance
UPDATE server_config SET char_prop_value='arcsdeserver,100,ecpYOUR_ArcSDE10_CODE,none,YOUR_ArcSDE10_CODE' WHERE prop_name = 'AUTH_KEY';

I am not sure if the "none" is also included with full ArcSDE server licences, or replaced by something else, but my ArcSDE Personal licence that came with my ArcGIS for Home Use licence, displays "none" in between the ecp code and the final code if I look inside the table in SQL Server Management Studio. And yes, all values are concatenated in one comma separated string.

EDIT: I see the "None" is also included in the screenshot you posted of the faulty 9.2 authorization key in the Server_Config table of your installation, so it is also included with full ArcSDE server licences, so you can probably run the statement like above.

MilosMilicevic

That is what I hoped it can be done, but while looking at my .ecp file, I saw that theese licenses are for 10.1 !!!
It seems that out ESRi representative sent me wrong ECP code.
Or not?
Could I use the 10.1 licenses, or must I request new ones?!
Could this be the cause of my trouble!?

Tnx,
M.

P.S. Yes, none is for all licensses...at least the ones I have dealt with.

MarcoBoeringa

Could I use the 10.1 licenses, or must I request new ones?!

Good question, I can't tell. Codes may be - and likely are - tight to specific versions, but only a phone call to ESRI could tell. Clearly, the 9.2 code doesn't work with 10.0, so it probably is version tight and you may need to request a new one.

I don't think it would hurt though to run a SQL UPDATE statement and replace "101" with "100". In addition, if the *.ecp file is text, you might even edit that, and run it through the authorization process in the modified form. At worst, you replaced a bad key with another bad and non functional key.

Could this be the cause of my trouble!?

Well, having "101" where the authorization software maybe expects to read "100", is probably not going to help, although I am not sure if the authorization software even cares to process the ecp file to extract these individual values, or simply tries to run an UPDATE statement against the database (that somehow inexplicably fails than).

MilosMilicevic

I tried replacing the "101" string with the "100" in the license string, and updated the AUTH_KEY. Now I get following error when trying a direct connect:
No ArcSDE server license found.

I still cannot create the service.
When I try to pass the license string from the license file through sdesetup -o update_key, it says " no license found. Not licensed for Workgroup", which is correct, because my licenses are Enterprise Standard and Enterprise Basic.

It looks like that the licenses must be for exact version...
I will call my Esri representative, but I would like Vince's confirmation about this first... 🙂

Tnx,
M.

MarcoBoeringa

Seems to me it is time for that phone call to your ESRI representative to request the correct 10.0 Enterprise Standard key you need to get it up and running...

VinceAngelo

This reminds me of one of my most bizarre client calls:
"Do you remember installing ArcView four months ago?"
"Yes."
"We had a power outage, and now it isn't working. Can you come fix it?"
After confirming the license manager won't start:
"What did you change?"
"Nothing."
An hour is spent working on the lm server...
"You must have changed something!"
"No, nothing."
Two more hours thrashing against the lm server...
"Are you sure you didn't change anything?"
"Positive."
Then someone else pipes up:
"Well, there was the one change, but it was months ago..."
Yup. They edited the license file, changing all 3s to 1s, so they wouldn't
use as many seats. It took that long to find it because the license was
only read on boot and, as a Unix box, the machine hadn't been rebooted
in the intervening months. And the license manager wasn't reporting
an invalid key because they also changed the "3.0" LM version to an
undefined "1.0".

You cannot change anything in the license string without corrupting it. All the
different elements (product, version, expiration,...) are encoded into the key.
If anything is different, the key will not validate. If the license is for the wrong
release, contact Customer Service to get the proper license file.

- V

MarcoBoeringa

This reminds me of one of my most bizarre client calls:
"Do you remember installing ArcView four months ago?"
"Yes."
"We had a power outage, and now it isn't working. Can you come fix it?"
After confirming the license manager won't start:
"What did you change?"
"Nothing."
An hour is spent working on the lm server...
"You must have changed something!"
"No, nothing."
Two more hours thrashing against the lm server...
"Are you sure you didn't change anything?"
"Positive."
Then someone else pipes up:
"Well, there was the one change, but it was months ago..."
Yup. They edited the license file, changing all 3s to 1s, so they wouldn't
use as many seats. It took that long to find it because the license was
only read on boot and, as a Unix box, the machine hadn't been rebooted
in the intervening months. And the license manager wasn't reporting
an invalid key because they also changed the "3.0" LM version to an
undefined "1.0".

:D:D

You cannot change anything in the license string without corrupting it. All the
different elements (product, version, expiration,...) are encoded into the key.
If anything is different, the key will not validate. If the license is for the wrong
release, contact Customer Service to get the proper license file.

- V

Yup, sure, that was what I expected, but since I am neither an ESRI employee knowing all the nitty gritty details like you, nor the one who's handling this problem directly and thus can only give "remote help", you sometimes have to poke a little before you finally get somewhere and find out what is wrong. As you discovered then too after hours...

I hadn't really expected this to work. My last advice was to get that valid licence file from ESRI.

Congrats by the way with your 2000th post here on the forums~! 😉

MilosMilicevic

Got the 10.0 licenses, tried, and nothing changed.
When I try to authorize using sdestup, I get this>
ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup..
What does this mean? Is it possible that they gave me a wrong installation CD (Workgroup instead of Enterprise)?

M.

MarcoBoeringa

Got the 10.0 licenses, tried, and nothing changed.
When I try to authorize using sdestup, I get this>
ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup..
What does this mean? Is it possible that they gave me a wrong installation CD (Workgroup instead of Enterprise)?

M.

Might be, have you ever tried to log-in at the ESRI Customer Care portal? If you log in there with the proper credentials associated with your licences, there should be products available for download. You may be able to download the right version from there:

http://customers.esri.com/

VinceAngelo

You're trying to install Enterprise ArcSDE, right?

Does the new license file have a line that starts with "arcsdeserver,100"?

What tool are you using to apply the new license?
(Hint: It should be "sdesetup -o update_key", and the binary should be
from an SP5-patched ArcSDE 10.0 Oracle 11g 64-bit SDEHOME)

- V

(Marco: Wow. Didn't expect to roll over that soon)

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.