Re: Connectivity Problems - Oracle 8i Personal Edition

Definitely they need to log into their own machine domain. They will not connect to the network, not have an IP address etc. The hostname in tnsnames.ora should equal the computer name.

Hth,

--
Sybrand Bakker, Oracle DBA
Michael <Michael.Wrobel_at_unisys.com> wrote in message news:84gfdm$54$1_at_mail.pl.unisys.com...
> Hi,
>
> I have users who use Oracle 8i Personal edition. These users access
> personal databases for testing and a remote database on an NT Network.
>
> When the users are not connected to the network, they have problems even
> connecting to their local system database.
>
> I have made sure the Oracle Services were running on their machines. I
> checked the tnsnames.ora file (nothing had changed since the working
> connection so it probably isn't there). I am thinking that in the
TNSNAMES
> file the HOST is referenced by the computer name on the network. Should
> this be referenced by IP address? If so, would having users log into
their
> workstation rather than the domain when not connecting to the network
(given
> their workstation name is the same as their recognized name on the
network)?
>
> When using the machines off of the network, they wll not have an IP
address
> and do not access a PDC (Primary Domain Controller)
>
>
> We get some TNS errors
>
> 12560
> 12570
> 12571
>
> ORA-12560: TNS:protocol adapter error
>
> Cause: A generic protocol adapter error occurred.
>
> ORA-12570: TNS:packet reader failure
>
> Cause: An error occurred during a data receive.
>
> ORA-12571: TNS:packet writer failure
>
> Cause: An error occurred during a data send.
>
> Remember, these users are connecting successfully while on the network. I
> run Enterprise Edition of Oracle on my laptop. I do not have any of these
> problems. Has anyone else encountered this problem or is there something
I
> am missing about Personal Edition?
>
> Thanks :-)
>
> Mike
>
>
Received on Thu Dec 30 1999 - 14:52:02 CST