Re: Can't connect locally

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 09 Jan 2002 01:09:44 GMT
Message-ID: <Xns9190AE952136FSunnySD@24.0.3.73>

blah_at_blah.com (blah) wrote in news:a1g0lf$oe04_at_inetbws1.citec.com.au:

> Hi All,
>
> If my 8.1.7 listener looks like this, how do I connect to the database
> using @<dbname>
>
> For example,
> sqlpus username/password@<what goes here>
>
> (SID_DESC =
> (GLOBAL_DBNAME= fairsun1_tasprd)
> (ORACLE_HOME= /u01/app/oracle/product/8.1.7)
> (SID_NAME = TASPRD)
> )
>
> Thanks,
> Chris
>

You needs to be MORE exact/correct in your terminology. When you "connect locally" you have NO need for a listener or SQL*Net and do NOT use "@<dbname>". Just set TWO_TASK to match ORACLE_SID.

HTH & YMMV HAND! Received on Tue Jan 08 2002 - 19:09:44 CST