Re: Instantclient on *nix

On Jun 13, 7:03 am, Alexander Semke <Alexander.Se..._at_physik.tu- darmstadt.de> wrote:
> Hello,
>
> according to oracle's page the installation and use of the instant client is
> easy:
> 1. Download the appropriate Instant Client packages for your platform. All
> installations REQUIRE the Basic or Basic Lite package.
> 2. Unzip the packages into a single directory such as "instantclient".
> 3. Set the library loading path in your environment to the directory in Step
> 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the
> appropriate environment variable. On Windows, PATH should be used.
> 4. Start your application and enjoy.
>
> So, I set the LD_LIBRARY_PATH to the proper directory. If I start my
> application I get the following error:
> ORA-12162: TNS:net service name is incorrectly specified
>
> The connection settings in my software are (supposed to be) ok. If I point
> with ORACLE_HOME to the directory of the oracle server (also installed on
> the same machine), I can connect to the DB-server and use my software
> without problem. If I understood it correctly, one doesn't need ORACLE_HOME
> anymore, if one uses the instantclient. But somehow it doesn't work for me.
> I've tried it on a linux and on a solaris machine.
> Is there more to do?
> Thanks in advance.
>
> Alexander Semke.

I've had success with David's method. According to the docs, you can also specify connection info directly or from LDAP: http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#sthref4009 I think I've also done it with a direct connect but can't remember exactly, I think because it was so trivially easy.

jg

--
@home.com is bogus.
Those kooky Scots!  http://news.bbc.co.uk/nolpda/ukfs_news/hi/newsid_6714000/6714857.stm