topic ArcSDE and DBMS on separate servers: underlying DBMS error (-51) in Data Management Questions

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

RicardoSanabria — Thu, 16 Jun 2011 05:52:10 GMT

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_guide/index.html#//00940000000w000000.htm

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

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

VinceAngelo — Thu, 16 Jun 2011 10:32:00 GMT

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

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

RicardoSanabria — Thu, 16 Jun 2011 14:10:47 GMT

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

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

RicardoSanabria — Thu, 16 Jun 2011 22:49:44 GMT

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

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

VinceAngelo — Thu, 16 Jun 2011 23:00:46 GMT

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