Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: setting up to access remote Oracle

Re: setting up to access remote Oracle

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Sun, 07 Nov 2004 14:50:41 +0100
Message-Id: <1099835440.8074.49.camel@dbalert199.dbalert.nl>


set TWO_TASK in your environment to the correct connect-string alias. It is not a fall-back thing, it simply directs the connect to use the specified connect-string.
Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2004-11-07 at 05:38, Janine Sisk wrote:

> If I type "sqlplus user_at_SID" it works, but I'd like to be
> able to drop the @SID part. I have a vague, quite possibly incorrect
> memory that if you have ORACLE_SID set (which I do) SQL*Net will use it
> when the local connect fails, but I haven't been able to get it to
> work.
>
> Is it possible to do this, and if so, can anyone provide an example?
>
> Thanks,
>
> janine
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 07 2004 - 06:44:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US