RE: so my boss insists on using oracle on NT sp6

Rachel,

        So basically, if your machine (with the database on it) is not connected to the network you can't connect to it's database, but once you put it on the network you can connect to it? That's definately a strange one, when you log on to the machine without logging on to the network are you logging onto the machine or are you logging on to the domain? Also, I thought SP 6 was not supported by Oracele?

        I think I recall having this problem once myself and it was a strange one. But I believe that you could try and increase the timeout in the client sqlnet file, I believe that was one of the solutions I saw on metalink. I give it some more thought, maybe I can help. have a great day
Sincerely,
Kevin Kostyszyn
Dulcian, Inc

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of WIlliam Thater
Sent: Thursday, December 21, 2000 7:20 AM To: Multiple recipients of list ORACLE-L Subject: Re: so my boss insists on using oracle on NT sp6

Rachel Carmichael wrote:
>
> Kevin,
>
> You have the whole thing..... basically what is happening to Joe's boss on
> NT4 sp6 and to me on NT4 sp5 is that we have Oracle installed on our PCs
and
> when we run the database and listener on the PC without being connected to
a
> network we can't get a connection to the database -- in sqlplus I get a
3113
> end of file on communication channel and can't connect. If I then log on
to
> my network, without shutting down the listener or database, and try to
> connect again, I can connect.
>
> Rachel

does the same thing happen with TWO_TASK set to the local sid in the environemnt? that worked for me at another place, but is was with 7.3.2.

--
Bill Thater      Sr. ORACLE DBA
Telergy, Inc     thaterw_at_telergy.net
----------------------------------------------------------------
"Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former."  -- Albert Einstein
----------------------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: WIlliam Thater
  INET: thaterw_at_telergy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).