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.

[MilosMilicevic]

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

That vas my reply.
The file contains the line that starts with arcsdeserver, only it is not a new line, but it only continues the line end of the previous feature (eg. svrstandard,100,ecp....arcsdeserver,100,ecp....).

I have asked them to give me the credentials, but they refused saying it will lead me to them again...

What annoys me the most is that I cannot do a direct connect... Through sqlplus it works from several machines, but through arccatalog it does not...I tried one more machine, but it will not connect the damn thing.

[MarcoBoeringa]

That was my reply.
The file contains the line that starts with arcsdeserver, only it is not a new line, but it only continues the line end of the previous feature (eg. svrstandard,100,ecp....arcsdeserver,100,ecp....).

Sorry, overlooked that one, you had confirmed it before. This thread is starting to become a bit long.

I have asked them to give me the credentials, but they refused saying it will lead me to them again...

Weird, I only have an ArcGIS for Home Use licence currently available with ArcSDE Personal, and I can simply login using my ESRI Global Account credentials. Even better, if I am already logged in here on the Forums using my Global Account, and switch to Customer Care, it automatically detects me and allows access. It gives me access to all the downloads and licencing information for my Home Use licence, I downloaded 10.1 from there without issue.

I guess it won't be different for big enterprise clients... Are you the only one involved in the ESRI licencing at your organization, and the only one having a Global Account?

What annoys me the most is that I cannot do a direct connect... Through sqlplus it works from several machines, but through arccatalog it does not...I tried one more machine, but it will not connect the damn thing.

If the licence process is not successfully finished, I think that is no surprise.

One thing though: are you absolutely sure you are using the right 32-bit Oracle Client when connecting? If ArcGIS somehow tries to use any 64-bit Oracle Client libraries to connect, it will fail. ArcGIS for Desktop is 32-bit and needs the 32-bit Oracle Client. Uninstall any 64-bit Oracle Client libraries if necessary to be sure it doesn't interfere (Leave them on the server, as ArcGIS for Server is 64-bit).

[MilosMilicevic]

Well I guess it is the right one, since I set the path to it in the Path variable...is there another way to ensure that?
I am a support engineer, a consultant, and my account has no connection to theese licenses...my colegues from the company that I work for as a consultant, do not have the ESRi accounts... I dont know how to get a customer number....
Regarding the Client, I suspect that is the problem, but dont know how to deal with it...

If i set the first path in the PATH variable to be to the 32bit client, shouldn't it be enough to point to ArcCatalog which service name to use?

M.

[MarcoBoeringa]

Milo, now you seem to have valid 10.0 licence keys, maybe trying to manually update the keys in the "server_config" table using:

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';

might be an option. I hope Vince can confirm this as a valid operation or not.

[VinceAngelo]

If you are deploying this for a customer, then you should be using the customer's
user number and support resouces.  If it's a legal copy with current maintenance,
they'll have the Customer Service contact information.

License files sometimes only have newlines, not {CR}{LF} pairs, which depending
on the editor, may seem like one line.

The UPDATE statement should work, though sometimes I've gotten a bad key file
and needed to have it re-issued.

- V

[MarcoBoeringa]

Milo,

Have you ever tried to run the post installation with the specific right-click menu option "Run as Administrator"?

It may be a long shot, but sometimes, even when your logged on as Administrator, you still need "Run as Administrator" to get something to work, especially with legacy software.

Marco

[MilosMilicevic]

Vince,
I have tried to request access to the customers portal using my customer's customer number, but someone from ESRi forwarded me to my local esri dealer, as they already told me it would happen. So that is off...

Did the update, and tried to create the service with sdeservice -o create.... but avail.
Marco,

I tried tthe Run as administrator, since I found a topic on the forum...no results.

So, as the things are going badly, this is how it is going to be:
Since the ArcGIS Desktop is here used as a base form some Utillity Extension, I will create a new empty gdb, create new SDE user and repository, and use the extensions tools to export/upgrade the data and then bulk load it back to the ArcSDE.
I do not see any other solution.
There is something very wrong in the way upgrades are ment to be performed, or in the software configuration that was asked from the extension manufacturer, or maybe in the position of the stars for the past two weeks that I have lost doing this. 🙂
I suspect that the Oracle client refuses connection to database, or ArcCatalog cannot connect to it, even though they are both x86.

I just give up, since I have an alternative...not a better one, but an usable one.

Thanks for your help guys, you were great.
Best regards.
Milos

[MarcoBoeringa]

So, as the things are going badly, this is how it is going to be:
Since the ArcGIS Desktop is here used as a base form some Utillity Extension, I will create a new empty gdb, create new SDE user and repository, and use the extensions tools to export/upgrade the data and then bulk load it back to the ArcSDE.
I do not see any other solution.

...

I just give up, since I have an alternative...not a better one, but an usable one.

Milos,

Sorry to hear that, but you are probably right it is now the best way to go. I am out of ideas of helping you "remotely"... If you can solve your issues this way, than by all means go for it and don't waste any more time on the impossible "upgrade path".

There is something very wrong in the way upgrades are ment to be performed, or in the software configuration that was asked from the extension manufacturer, or maybe in the position of the stars for the past two weeks that I have lost doing this. 🙂

Yeh, I guess the stars didn't align up well... 😉

Good luck with rebuilding and loading the data.

Marco

[VinceAngelo]

Rather than giving up, I'd recommend you create a new database instance, and try
installing a new 10.1 geodatabase in that 11g instance.  If this works, you can copy
the data from the old instance to the new.  If it doesn't, maybe that will help you
determine why there has been so much difficulty (I've never had an ArcSDE for
Oracle upgrade fail, and I've been doing them since Oracle 7 and SDE 2.0).

- V

[JimRisley]

Hi Milos,

Have you logged a support request with your local distributor?  If not, please do so.  Our team in International Support in the US work closely with our international distributors to troubleshoot issues such as these, and the distributor can and will involve us as necessary.  You can find contact information for your local distributor here:

http://www.esri.com/about-esri/contact

Thanks,

Jim R.
Int'l Support