yeppers thats the one, and yes ur correct about the listener thing. :)
Joe
Paul Drake wrote:
>
> 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
> >
> > __________________________________________________
> >
> --
>
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
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).
