Re: Connect w/o Listener

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Fri, 29 Sep 2006 06:26:59 GMT
Message-Id: <pan.2006.09.29.06.27.01.324380@verizon.net>

On Thu, 28 Sep 2006 21:14:30 -0700, ivl5 wrote:

>
> Mladen Gogala wrote:

>> On Thu, 28 Sep 2006 22:08:32 -0400, hberry wrote:
>>
>> > 10g
>> >
>> > How to connect to a local DB (localhost) without needing to start & go thru
>> > the Listener ?
>> >
>> > thx
>>
>> Define ORACLE_HOME, ORACLE_SID, PATH and LD_LIBRARY_PATH.

>
> Define and export ORACLE_HOME, ORACLE_SID, PATH.
>
> AFAIK no need to define LD_LIBRARY_PATH any more. Unless one moved
> ORACLE_HOME to a different location and didn't relink binaries that's
> it. Default LD_LIBRARY_PATH is embedded into binaries and includes
> relevant directories under $ORACLE_HOME.
> Igor

There have been quite a few bugs, resolved by explicitly defining LD_LIBRARY_PATH. I would keep it as a good custom.

-- 
http://www.mladen-gogala.com

Received on Fri Sep 29 2006 - 01:26:59 CDT