Well, on Unix the following works and I am wondering if you could get it to
work on W2K? I seem to recall doing this before on NT a while back. It has
been a while so I could be mistaken, but I think I did the environment
setting and sqlplus in a DOS window...
- Set the environment variable ORACLE_SID=the-database-sid
- Then, just connect without specifying any connect-info/"tnsnames"-alias .
For example, with sqlplus or exp/imp, I specified just username and password
to connect.
On Unix, I use to (probably better to use the startup restrict) do this to
restrict access and yet still work in the database while logged on the
database from the database server machine. I would first stop the listener.
--
"Alain Migeon" <agm_at_dk.rovsing> wrote in message
news:MPG.19b976d39ff3d58a989682_at_news.cybercity.dk...
> Hi
>
> I have, on a Win2000 machine, an Oracle database, version 8.1.7. On the
> same machine, I have a server connecting to this database.
>
> I start my server which connect at start up to Oracle. Everything is
> working fine, and then if some network problems occur (I just unplug the
> network cable to reproduce the error), I got the ORA-12571 error
> (TNS:packet writer failure), followed by the ORA-03114 (not connected to
> ORACLE).
>
> Since my database and my server are on the same machine, why do I get
> this error?
>
> Thanks in advance.
>
> Alain
>
>
Received on Sun Aug 31 2003 - 01:45:16 CDT
