ArcSDE and DBMS on separate servers: underlying DBMS error (-51)

[RicardoSanabria]

Hi,

I have installed ArcSDE 10 sp1 and Oracle 10g on separate machines and it works fine, I followed the instructions at the web help: http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade...

But I had to migrate my ArcSDE server 10 to another machine, so I thought that I didn't do anything at the DBMS machine, just at the ArcSDE machine, so I did the following.

Summary:
1) I installed ArcSDE 10 at the new server

2) I installed Oracle client at the new server

Like repository is already created I didn't execute sdesetup -o upgrade

3) I tried to execute sdesetup -o update_key -d ORACLE10g -s srxpnsig01 -l "...\xxxx.ecp" -u sde but I get underlying DBMS error (-51)

4) I created the service with sdeservice -o create -d ORACLE,SIG -p xxxxxx -n command, but when I tried to start it, the sde_esri_sde log file says:

-------------------------------------------------------
ArcSDE 10.0  for Oracle10g Build 775 Fri Sep 17 11:45:27  2010
-------------------------------------------------------
DB_open_instance()::db_connect (OCI8) error: 12154
init_DB DB_instance_open_as_dba: -51
DBMS error code: 12154
ORA-12154: TNS:could not resolve the connect identifier specified


Finally, I can connect to DBMS by sqlplus using conn sde/xxxxx command. It means sqlnet.ora and tnsnames are ok.

Some idea? Do I have to do something at the DBMS machine?

Regards,

Ricardo

[VinceAngelo]

There's no need to update the license key (which resides in the database).

Did you follow step 13 to replace the "ORACLE_SID" variable name with "LOCAL"? [You shouldn't
run multiple application servers in the same instance, so the original service should be stopped
when you test, and eventually deleted with 'sdeservice -o delete'.]

Do you have multiple Oracle installs on the same host? If so, is the tnsnames.ora the
same in all ORACLE_HOMEs?

- V

[RicardoSanabria]

Hi,

Yes, I set the LOCAL variable at the dbinit.sde file. At the new ArcSDE server I don't have others ORACLE_HOMEs.

I had stopped sde service but didn't delete, so I deleted it at the old ArcSDE server and created at the new ArcSDE server but I got the same error.

A little bit difference between old ArcSDE Server (32-bit) and the new one (64-bit) is that the new one is a virtual server but ArcSDE is installed in 32-bit.

Regards,

Ricardo

[RicardoSanabria]

Hi,

The problem was  (x86) parenthesesin install path names on the Windows 64-bit operating system.  http://support.esri.com/en/knowledgebase/techarticles/detail/31875

Thank you everyone.

Ricardo

[VinceAngelo]

It's best to avoid Oracle 10.2.0.1 on all platforms.  It is not certified for use with any Esri
software -- Oracle 10.2.0.3 is the minimum stable version. 

I'm allergic to directory paths that contain spaces and other special characters, and try to
avoid install on the C: drive as general policy.

- V