AnsweredAssumed Answered

Underlying DBMS error when connecting to Geodatabase

Question asked by ARaheem on Jun 21, 2017
Latest reply on Jul 5, 2017 by ARaheem

When executing sdetable command from command prompt I am getting an Underlying DBMS error(-51).

I have Oracle 11g database with ArcSDE 10.1 installed.

 

Following is the sdetable command,

sdetable -o describe -t sites -i sde:oracle11g:mydb -s 10.169.43.22 -u sde -p sde

 

Following is the result:

Error: Underlying DBMS error (-51).

Error: Could not create a connection on server 10.169.43.22, for user sde

Extended DBMS error code: -1
Unknown error
No extended error.

 

Following is the log in sdedc_Oracle.txt:

DB_open_instance()::db_connect (OCI8) error: -1
CAN'T OPEN INSTANCE: sde:oracle11g.
Spatial Engine Connection Failed (-51).
Cannot Get Access to Instance sde:oracle11g

 

Any insight on these type of errors and the probable reasons that could have led this error is appreciated.

Outcomes