Re: TNS no listener Oracle10g redhat es

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 10 Jul 2005 10:52:56 +0200
Message-ID: <daqna4$t4h$1@news5.zwoll1.ov.home.nl>

IANAL_VISTA wrote:
> 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
>
>

Right - BEQueth connections. No tns aliases provided in connect string. Now try again, and read the thread before answering questions that were not asked.

Same protocol, by the way - can be configured in tnsnames.ora, as described, so you *can* use an alias in the connect string. Even when on a different software tree.

-- 
Regards,
Frank van Bortel

Received on Sun Jul 10 2005 - 03:52:56 CDT