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.
Hi Abdul,
From my experience, there are quite a few potential culprits to the connection issue / error you are experiencing. Do you have 10.1 (or newer) ArcGIS Desktop to test out a direct connection to that database? Can you connect through SQLplus using sde / sde as credentials as noted in the above example? I'd say we first need to verify that connection to that Oracle database is possible and then we can begin to isolate where the point of failure is. Possible points of failure include but aren't limited to:
These are just a few areas that come to mind. If you could verify the ability to connect outside of command line to this database that would be helpful in narrowing down the cause. I hope this helps!
Best,
Rex R