Re: setting up to access remote Oracle
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: janine@xxxxxxxxxx
- Date: Sun, 7 Nov 2004 09:54:32 +0000
Using SID is for the same Machine... U need to Use Tnsnames.
U may want to Use two_task setting there ..
On Sat, 6 Nov 2004 23:38:35 -0500, Janine Sisk <janine@xxxxxxxxxx> wrote:
> I hope this isn't too a dumb of a question, but it's been years since I
> last had to do this and Google isn't helping much.
>
> I have Oracle 9i installed on one server and am running sqlplus on
> another. If I type "sqlplus user@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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
