Oracle 11g Direct Connect to SDE

[BradErickson]

I am attempting to Direct Connect to an SDE Oracle service.

Using sde : oracle11g for the service string just stopped working as of today.
I get error "Server library could not be loaded"

I have 4 Oracle homes on my machine, only one of which is 11g. (11g Client, the others are 10g)

I am guessing it is b/c of my other Oracle homes on my machine.
Using oracle10g works.


Anyone run into this?

Oracle RDBMS: 11.1
SDE Version: 9.3.1
ArcGIS Version: 9.3
My OS: Win XP 32-bit, 4GB RAM, SP3

[VinceAngelo]

If it stopped working today, what changes have been made to the system since
it last worked?

What does your PATH variable look like?

- V

[BradErickson]

No changes except windows updates that were pushed my PC.

I put the OraClient11g_home1 first in my path variable, but it didn't work.

C:\Oracle\product\11.2.0\client_1\bin;

[H__KorayGUNDUZ]

Hi Brad

Using

sde : oracle11g:/;LOCAL=TNSNAME


Regard