Joe,
do you mean change the line in the sqlnet.ora file from
SQLNET.AUTHENTICATION_SERVICES = (NTS)
to
SQLNET.AUTHENTICATION_SERVICES = (NONE)
It still sounds like if the listener is configured with the machine's host
name, and that host name was resolving to the IP address bound to the
network adapter (not a loopback address, e.g. 127.0.0.1)
when the network connection is severed, so is the sql*net connection.
How about using a bequeath connection, instead?
Paul
-------- Original Message --------
Date: Tue, 13 Mar 2001 16:35:50 -0800
Reply-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Leslie, this one messed with ALOT of people for a long time, my boss
over New Years even figurd it out.
check out you sqlnet.ora file, look at the(i think it was)
sqlnet_authentication.services or something like that, he just
commented it out and poof it worked.
Rachel, since I told you about it, do you remember what it was?????
joe
Leslie Lu wrote:
>
> Hi all,
>
> I installed 815 EE on NT 4.0 on a laptop and created a
> testing database (did both while I was on network.) I
> can connect to the database without problem, while
> remain on network. However when I'm off the network,
> I cannot connect to the database. I got:
>
> ora 12570: TNS: packet reader failure
> ora 12571: TNS: packet writer failure
>
> It's a demo project for marketing people, and most
> probably they might not be able to connect to the
> network (in the plan or on the beach). So I really
> need the db to run locally.
>
> Any idea, thanks a lot.
>
> Leslie
>
> __________________________________________________
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).