unable to connect

08-06-2015 11:32 PM
New Contributor III

Hi, I am not able to connect for sde.

However, I am able to connect from oracle sqlplus client command line and also from arcgis desktop 10.1.

Also tested that tnsping works fine.

please suggest...

C:\>sdedbtune -o list -i sde:oracle11g:pmms -k DEFAULTS -u sde -p sde

ArcSDE 10.1  for Oracle11g Build 679 Thu Apr  5 11:43:21  2012
Attribute        Administration Utility

Error: Underlying DBMS error (-51).
Error: Could not create a connection on server JUPIT, for user sde.

Extended DBMS error code: 12154
ORA-12154: TNS:could not resolve the connect identifier specified

No extended error.

0 Kudos
3 Replies
Regular Contributor III

Do you have the Oracle 64-Bit Client installed and being used on the machine where you are executing the sde 10.1 commands.

0 Kudos
New Contributor III

Yes, both 64-bit and 32-bit clients are installed.

There are 5 more geodatabases on oracle and i am able to work with sde commands from same machine.

I am able to connect from arcgis desktop 10.1 and sql client.

But when i use sde command, i get TNS error.

0 Kudos
New Contributor III

I am able work with sde commands on the already existing geodatabases.

This problem is on new geodatabase created.

0 Kudos