ArcSDE 9.2 SP6 upgrade to ArcSDE 10 SP5 upgrade issue

MilosMilicevic · ‎05-07-2013

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.

VinceAngelo · ‎05-10-2013

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)

MilosMilicevic · ‎05-12-2013

@Marco: I don't have the username and password for customer care...
@Vince: Yes, it contains the line...

My SDEHOME environment variable points to the only one ArcSDE home, in x64 Program Files.
I just type sdesetup -o update_key -d ORACLE11G -l '...' -p SDEpass... Also, when I use the postinstall tool, it fails with a general error :
Error: Operation Failed (-1).
Error upgrading authorization key.

P.S. How do I find out which version of SDE is installed (workgroup, Enterprise... ) ?
P.P.S. I am thinking just now and this came to me:

I did the ArcSDE Geodatabase upgrade using a direct connection to the old 10g Oracle server from my new test server, through ArcCAtalog v10. But, I did not uninstall the old ArcSDE on the old server before I did the upgrade! Could this be a problem?!

MarcoBoeringa · ‎05-13-2013

@Marco: I don't have the username and password for customer care...

Than I recommend you to get those. I guess your ESRI representative should be able to give them without issues. It could well be that you, as I presume you are the geodatabase administrator, are already registered for the Customer Care portal. Otherwise someone else at your organization who is responsible for buying the licences of ArcGIS.

P.S. How do I find out which version of SDE is installed (workgroup, Enterprise... ) ?
P.P.S. I am thinking just now and this came to me:

I don't know. Maybe you can find it in the Windows Registry, Vince undoubtedly has better instructions.

I did the ArcSDE Geodatabase upgrade using a direct connection to the old 10g Oracle server from my new test server, through ArcCAtalog v10. But, I did not uninstall the old ArcSDE on the old server before I did the upgrade! Could this be a problem?!

Well, according to the instructions here, you are supposed to uninstall the old ArcSDE before upgrading the geodatabase. But that is also a situation where you intend to install ArcSDE on the same machine again, whereas your situation is different: you want to install the upgraded geodatabase and ArcSDE on a different machine.

Maybe, in your case, simply shutting down any running ArcSDE Application Server, is enough to allow a good upgrade of the geodatabase. And, as long as you don't attempt to run the old 9.2 AS again against the geodatabase, it might be good.

I think you reported the upgrade finished well with no error? Might be an indication that the actual upgrade of the geodatabase tables / schema went well.

Vince can probably give more specific input here.

From the Help page:

12.Uninstall the old release of ArcSDE. See either Uninstalling ArcSDE from Windows or Uninstalling ArcSDE from Linux or UNIX for instructions.
13.In Windows, you are prompted to delete the ArcSDE services during the uninstallation process if any are running. Click Yes to delete the service if you are installing a new release of ArcSDE. If you are installing a service pack or patch, you can click No and reuse the service unless the service pack or patch instructions specify that you must re-create the service. (For example, if the service pack or patch fixes something in the service functionality, you most likely need to re-create it.)
14.Install the new release of ArcSDE.
On Windows operating systems, do not run the Post Installation wizard. The Post Installation wizard is for new installations only.

If installing ArcSDE 10 on Linux, apply service pack 1.

MarcoBoeringa · ‎05-13-2013

I do think contacting your ESRI representative to find out if you have the right licence files and ArcSDE installation, and getting them if not, is now important.

Also find out the Customer Care login so you can see what is there, maybe you can download the right install there. If not, you are not properly registered at ESRI and your ESRI representative should change that.

MilosMilicevic · ‎05-13-2013

hm...the trouble with ESRi here is that they don't care or don't know how to help me.
I am already trying to solve this with them, but none of their suggestions helped me so far...so my best chance to solve this is with you guys 🙂
Also, on my question, is the CD they gave me Enterprise or Workgroup, they said : "That is the only SDE install CD we have, so it must be correct. " 🙂 🙂

Yes, the log had no errors or warnings and it said that it finished succesfully. Also I tried to connect using ArcCatalog 9.2 and it said that it cannot access the later ArcSDE from an older release of ArcCatalog (or something like that). And the old server SDE service cannot start, so I think that the upgrade went ok.

MarcoBoeringa · ‎05-13-2013

Also, on my question, is the CD they gave me Enterprise or Workgroup, they said : "That is the only SDE install CD we have, so it must be correct. " 🙂 🙂

😞

Well, actually, I don't know if there are actually any differences in installation, so they might be right in the end. To be honest, it is quite a while I had to install ArcSDE myself.

Yes, the log had no errors or warnings and it said that it finished succesfully. Also I tried to connect using ArcCatalog 9.2 and it said that it cannot access the later ArcSDE from an older release of ArcCatalog (or something like that). And the old server SDE service cannot start, so I think that the upgrade went ok.

It sounds so... I think you may be OK as far as the geodatabase upgrade concerns. That still leaves you with the question to get valid licence files. If the files are wrong, nothing you do or we suggest will help and you really do need to get new *.ecp licence files for your 10.0 ArcSDE Enterprise Standard licence.

P.S. On this page:
http://www.esri.com/software/arcgis/arcgisserver/features/enterprise-workgroup
it says (note this is 10.1, but I guess this hasn't changed), that Workgroup edition ArcGIS for Server comes shipped with SQL Server Express 2008 R2, limited to 10GB databases.

Was that installation included on your DVDs? Might be an indication as to what installation you have.

MilosMilicevic · ‎05-13-2013

I killed the server...reinstalled the Windows and now starting everything from scratch, so I could eliminate the registry, Oracle RDBMS itself, etc as an issue.
Afterwards, I will do the whole process again, from the import and so on...

Marco, I looked at my install DVD and could not find the installation of SQL Server Express, only ArcSDE for SQL Server... Does this mean, that I have the Enterprise DVD?

M.

MarcoBoeringa · ‎05-13-2013

Marco, I looked at my install DVD and could not find the installation of SQL Server Express, only ArcSDE for SQL Server... Does this mean, that I have the Enterprise DVD?

M.

I can't say for sure, but it looks like it. Although this error message you posted still bothers me:

ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup..

As you correctly wondered, why this error about SdeWorkGroup?

Anyway, have you now requested the proper licence files from ESRI?

MilosMilicevic · ‎05-13-2013

Yes, I have asked them to check version they gave me with the licenses.
They say it is ok...

I have reinstalled the server, Installed everything from the start, and still cannot do a direct connect.
Also, the license update will not pass no matter what I try. The errors are all the same...
This is useless!

M.

MarcoBoeringa · ‎05-13-2013

Yes, I have asked them to check version they gave me with the licenses.
They say it is ok...

I have reinstalled the server, Installed everything from the start, and still cannot do a direct connect.
Also, the license update will not pass no matter what I try. The errors are all the same...
This is useless!

M.

Milo, you have not answered Vince's question that will also answer whether your ESRI representatives are right with "...it is ok...":

See this text by Vince in one of the post above:

"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)"

If your licence file doesn't start with the arcsdeserver,100, it is almost a certainty they gave you the wrong licence files, no matter what they are saying to you.

Again, if you do get the credentials for the Customer Care portal, you no longer rely on your local representatives, you can than access your downloads and licences directly (if they are properly registered at ESRI USA).