Cannot Direct Connect To Oracle SDE DB With 10

Discussion created by rcoodey on Jun 25, 2010
Latest reply on Oct 30, 2019 by LantharDalton

Like • Show 0 Likes0
Comment • 16

I have two workstations, one with 9.3.1 and the other with 10 Pre-Release. The 9.3.1 can do a direct connect to our Oracle Database running SDE 9.3.1 on it just fine. But when trying to direct connect on the other PC with 10, I get "Failed to connect to the specified server. Server library could not be loaded"...

Things I have tried:
- Installed Oracle Full Client (had lite)
- Created environment variables, ARCHOME, ARCGISHOME, ARCSDE
- Verified "C:\Program Files\ArcGIS\Desktop10.0\bin\gsrvrora10g100.dll" exists

Is there some other config file or registry value maybe not set right? I wish I could have 9.3.1 installed simultaneously with 10 to see if it works in there...

Thanks a lot!!!

Outcomes

16 Replies

dlaw-esristaff Jul 8, 2010 8:47 AM
Hi Ryan,

Due to the internal geodatabase schema changes at ArcGIS 10, earlier release clients (i.e., pre-ArcGIS 10) cannot connect to, nor access ArcGIS 10 geodatabases.

FYI,

Product Compatibility Matrix for Clients and Servers of ArcSDE technology in ArcGIS Server

Hope this helps,
Like • Show 0 Likes0
Actions
rcoodey Jul 8, 2010 8:52 AM
Derek,

Thanks a lot!

My problem is exactly the opposite though, I cannot connect from ArcGIS 10 Desktop to an ArcGIS 9.3.1 geodatabase... That article you posted says that should work: "ArcGIS 10 can make direct connects to ArcSDE 9.3.1, 9.3, and 9.2 geodatabases. "

Thanks!!!
Like • Show 0 Likes0
Actions
dlaw-esristaff Jul 9, 2010 1:02 PM
Hi Ryan,

Apologies for the oversight of mis-interpreting your original post.

Q1) Are you using an ArcGIS 10 Direct Connect driver?
Q2) When you specify the direct connect string for the Service parameter, are you using "sde93: oracle10g:<SQL_Net_alias>" or "sde: oracle10g:<SQL_Net_alias>"?

FYI, specifying the release number after â??sdeâ?� is no longer supported.

Another thing to check, if you had another version of ArcSDE installed on the client machine: verify that you don't have another SDEHOME path listed in the client machine's PATH environment variable.

Direct connect compatibility between clients and ArcSDE geodatabases

Hope this helps,
Like • Show 0 Likes0
Actions
rcoodey Jul 12, 2010 7:41 AM

Q1) Are you using an ArcGIS 10 Direct Connect driver?

I assume so, isn't it installed with ArcGIS 10? I know with 9.3 the drivers for older versions was a seperate install, but I thought with 10 it was bundled in.

Q2) When you specify the direct connect string for the Service parameter, are you using "sde93: oracle10g:<SQL_Net_alias>" or "sde: oracle10g:<SQL_Net_alias>"?

I have always specified it as "sde: oracle10g" in past versions and thats what I am trying in this. I have never specified the <SQL_Net_alias> before, but tried adding the db instance name there with the same results.
if you had another version of ArcSDE installed on the client machine

I have never had ArcSDE installed on this machine.

Thanks a lot for the help so far!
Like • Show 0 Likes0
Actions
chrismorganlynx Aug 25, 2010 4:00 AM
Did you ever work out what the problem is here?
I am getting the same error message. I have ArcGIS Desktop 10, and am trying a direct connect to
Oracle/SDE database. Connection via SDE works OK, but direct connect does not.
Direct connect from Desktop 9.3.1 clients works fine.

cheers,

Chris
Like • Show 0 Likes0
Actions
rcoodey Aug 25, 2010 6:43 AM
Did you ever work out what the problem is here?
I am getting the same error message. I have ArcGIS Desktop 10, and am trying a direct connect to
Oracle/SDE database. Connection via SDE works OK, but direct connect does not.
Direct connect from Desktop 9.3.1 clients works fine.

cheers,

Chris

Chris, I still never got this working :(. I just got 10 final installed the other day and it is still having this issue too. Sorry.
Like • Show 0 Likes0
Actions
chrismorganlynx Aug 25, 2010 1:27 PM
OK, thanks anyway.
I'll investigate further.

cheers,

Chris
Like • Show 0 Likes0
Actions
chrismorganlynx Aug 26, 2010 6:47 AM
I have worked it out - the problem is caused by the version of the oracle client software that you have installed.
It appears that ArcGIS 10 desktop does not recognise the oracle 9 client.
I had the oracle 9 client installed for backward compatibility with other apps, which do not
function well with the oracle 11 client.

Our server is oracle 11g 64-bit.

The direct connection params I used previously with the oracle 9 client, in ArcGIS 9.3.1 were:

Service: sde:oracle9i
Username: <username>
Password: <password>@<oracle_net_alias>

This would successfully connect to the oracle 11g database.

For ArcGIS 10, I had to install the oracle 11 client, then change the connection settings to
Service: sde:oracle11g
username and password as before

Hope this helps someone else.
Like • Show 0 Likes0
Actions
rcoodey Sep 20, 2010 2:45 PM
Thanks Chris... still not working for me though.

We have a 10g database running ArcSDE 9.3.1 and I am using the 10g light client. I also tried installing the 11g light client and same error with it :(.
Like • Show 0 Likes0
Actions
chrismorganlynx Sep 21, 2010 12:16 AM
Oracle's light client doesn't work with a lot of stuff - you may well have to install the full client.
It sets environment variables and registry entries and puts config files in the locations expected.

cheers,

Chris
Like • Show 0 Likes0
Actions
rcoodey Sep 21, 2010 12:38 PM
Thanks a lot for the reply Chris, got it working...

I uninstalled the 10g and 11g lite clients and installed the 10g full... The first time I just installed the "InstantClient" and it had the same issue (btw, I�??m not a big Oracle DBA guy so not sure what the difference is between Instant and Light). So then I uninstalled that and did a custom install with everything checked... IT WORKED! Well, minus the "ORA-12541: TNS:no listener" error. So I pointed it to the proper tnsnames.ora file and connected right up. I didn't like having to install "everything" though, so I uninstalled again and pinpointed it to needing one of the following four:
- Oracle Objects for OLE 10.2.0.1.0
- Oracle ODBC Driver 10.2.0.1.0
- Oracle Provider for OLE DB 10.2.0.1.0
- Oracle Data Provider for .NET 10.2.0.1.0

Kind of odd that it worked fine with the lite client in 9.3.1 but now in 10 its not. I don't know that pushing out the full client to all our users is even feasable... but I guess really only me and my few GIS co-workers need to install the full client, and then also on the ArcGIS Server so that we can publish services with direct connect.

Thanks a ton for all the help!!!
Like • Show 0 Likes0
Actions
johannwmeyer Mar 29, 2011 10:26 AM
OK I ran into the same problem. I have a ArcGIS 10 Client and an Oracle 10g client. We have a Oracle 9i SDE9.2 database.
So rather than using the
```
sde:oracle9i:<SQL_Net_alias>
```
which did not work and got the Server Library was not loaded error.

I used the
```
sde:oracle10g:<SQL_Net_alias>
```
and it did work. ( in retrospect... Connecting_to_ArcSDE_geodatabase)

Q2) When you specify the direct connect string for the Service parameter, are you using "sde93: oracle10g:<SQL_Net_alias>" or "sde: oracle10g:<SQL_Net_alias>"?
Like • Show 0 Likes0
Actions
craygo Mar 30, 2011 10:28 AM
I have had success using the instant client. Instant client is a very small install compared to the full client install. The key to using instant client is in the environment variables. You need to add the path to the instant client in your path variable then also add an environment variable called "TNS_ADMIN" TNS_ADMIN is not there by default so it needs to be created. Also if you want to test it out without having to restart (environment variables do not take effect until restart) you can use a command prompt to add the variables for the current session. If you have vista or Windows 7 you need to run cmd as administrator.

example of my install

instant client location C:\oracle\client10g
At command prompt you can type
set PATH=%PATH%;c:\oracle\client10g
TNS names location c:\oracle\client10g\network\admin
add TNS_ADMIN variable with the above location to your environment and at command prompt type
set TNS_ADMIN=C:\oracle\client10g\network\admin

If you don't want to mess with the command prompt you can just restart. After restart just run a tnsping at command prompt to test

Ray
Like • Show 1 Like1
Actions
suresh738 May 10, 2011 6:30 AM
I was able to fix this by installing ArcGIS Desktop in a different directory other than Program Files (x86). Hope this helps.
Like • Show 0 Likes0
Actions
saadat2930 Mar 9, 2018 2:34 AM
Hi!
I think its pretty late to answer but here is how i fixed mine.
I had Arcgis 9.2 installed on 1 server, ArcSDE 9.2 on another Server and Oracle 10g on 3rd Server.
Follow the steps when you are connecting to Oracle/SDE on Remote Server.

On the server on which oracle is installed, Go to the services and check what instance of DB (SID) is running. You can only make connection through that service Name.

Install the ARCSDE on another server, by using sys user, which is default, enter the instance password and Give Net Service Name. NET Service Name is the your instance running on the other Server. You can check it also in TNSNAMES.ora file on the server on which Oracle is installed.

Click next if you have entered everything correct you will probably donot get any error. Go with next create default tablespace without changing anything. Login with SDE user and password in the next window. and in the end give license file of ARCSDE.... At this stage when licensing is done, You will be popped up with a new window, POST INSTALLATION WIZARD. This is the window which creates the service on which you can connect to you oracle Database from any system.

Close this window, if you have to use ARCSDE from a remote server or in simple if you dont want to use arcmap on that system.

Create SDEHOME variable, Point this to the arcsde bin folder. and then add %SDEHOME% in Path Variable.

Now open CMD, We will create our service from here.
Type this command in your cmd and press enter.

sdeservice -o create -p sdepasswd -d ORACLE9I,<ORACLE_SID> -n -i esri_sde.

Suppose
sdepassword = Saadat
Oracle 10 g is installed,
SID = SAADATDB
Service Name you want to create: esri_sde
Then type like this and press enter:

sdeservice -o create -p Saadat -d ORACLE10g,SAADATDB -n -i esri_sde

This will create a service with name of esri_sde....
Go to run , Type, Services.msc and press enter. You can check there, it will be like
ESRI SDE SERVICE (esri_sde)

If try to run it, it will most probably give you an error.

Now,
Go to Services.sde in arcsde installation directory.

Enter the line below there.
esri_sde 5151 #Service for Oracle
Then,
Go to Services in C:\Windows\System32\drivers\Services
It is a file format, it will open with notepad.
Add this line in the end.

esri_sde   5151   #Service for Oracle

Next is,
Go to ARCSDE installation directory and search for dbinit.sde.
open it with notepad.
Now this is very important
you have add this line.

set LOCAL = ServerName/Oracle SID
Where Server Name = The Name of computer/Server on which Oracle is installed, And instance is the NET Service Name we used before.
if ServerName = SaadatPC
and Oracle SID = SaadatDB
Then you have to write like this,

set LOCAL = SaadatPC/SaadatDB

Now restart your Server on which you made all of these changes. Go to Services and check the esri_sde service will be running.

If you face any issue regarding this, You may comment here.

Referencces: How To: Install ArcSDE on a machine that is remote from the Oracle RDBMS
#ARCSDE
#REMOTE #SERVER
#ORACLE
Like • Show 0 Likes0
Actions
LantharDalton Oct 30, 2019 8:23 AM
An additional note for those who upgrade things, and everything is fine for sde connection files, but your sde command line tools gives error of "Bad Login User (-9)."

If you have moved up to the 10.2 command line sde binaries, you must change syntax of old commands for direct connect from this:
J:\Apps\ArcSDE102\ArcSDE\ora11gexe\bin>.\sdetable -o describe -i sde:oracle11g:<database instance> -s <database.server.host.com> -u USERID -p <PASSWORD> -t "TABLENAME"
Error: Bad login user (-9).
Error: Could not create a connection on server <database.server.host.com>, for user USERID

To this, moving the database SID / instance name:
J:\Apps\ArcSDE102\ArcSDE\ora11gexe\bin>.\sdetable -o describe -i sde:oracle11g -s <database.server.host.com> -u USERID -p <PASSWORD>@<database instance> -t "TABLENAME"
ArcSDE 10.2
Attribute Administration Utility
-----------------------------------------------------
Table TABLENAME:
...
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Cannot Direct Connect To Oracle SDE DB With 10

Outcomes

Related Content

Recommended Content