Re: differenece in DOS SQL*Plus vs. GUI?

Paul Murphy <pmurphy3_at_twcny.rr.com> wrote:

>I was working on an Oracle 8i database on Windows 2000. Remote clients
>(SQL*Plus and TOAD) can connect fine to all the databases on the
>machine. On the db server itself, I can connect to any of the databases
>using the management console (DBA Studio). I can also use a SET
>LOCAL=database command then start SQL*PLus from a command line and
>connect to any of the databases. Here's the weird part. When I use the
>GUI version of SQL*Plus I can't connect to any of the databases. I
>created a TNS_ADMIN environment variable and set it to the correct
>TNSNAMES.ORA file that works fine on all the remote computers. I tried
>modifying the host name to localhost in the TNSNAMES.ORA file...nothing
>worked. Any ideas? Thanks! -Paul Murphy

How are you attempting to connect?
Are you using the
 user.pass_at_tnsnameentry

What error do you get? Received on Mon Oct 06 2003 - 09:08:44 CDT