Re: TNS no listener Oracle10g redhat es

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 09 Jul 2005 01:56:58 GMT
Message-ID: <Xns968DC0C6728B2SunnySD@68.6.19.6>

Frank van Bortel <frank.van.bortel_at_gmail.com> wrote in news:dame6p$cgt$1_at_news5.zwoll1.ov.home.nl:

> IANAL_VISTA wrote:
>

>> 
>> By running on the DB server system with proper evironmental variables
>> set.

>
> And I thought elaborate meant to explain, get into detail.

With *nix all that is needed is to set ORACLE_HOME & ORACLE_SID

If/when they are correct then
sqlplus scott/tiger
will get you into the DB; WITHOUT any listener & without TNSNAMES.ORA file Assuming that two different instances, PROD & DEV, reside on the same box using the same version specific directory tree....

ORACLE_SID=PROD
export ORACLE_SID
-- Will get you connected to PROD

ORACLE_SID=DEV
export ORACLE_SID
-- Will get you connected to DEV Received on Fri Jul 08 2005 - 20:56:58 CDT