Hello Miachel,
I've the same problem with oracle 8.0.5 Enterprise edition.
When I'm not connected to network i can not connect to local db.
Then i wrote the following entry in the tnsnames.ora and all is ok.
Loc.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL) <<<< this is your sid
)
)
HTH
Günter
Michael schrieb:
> 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 Fri Dec 31 1999 - 10:20:11 CST