Re: Distant sites / SQL Net

[Quoted] Comments embedded

Regards,

Sybrand Bakker, Oracle DBA

"Yannick Kermabon" <y.kermabon_at_tegelog.fr> wrote in message news:3ae54943.494837558_at_news.fr.uu.net...
> Hi
>
> I'd like to know if it's necessary to use particular parameters when
> you have distant sites, connected to a central server with ISDN modems
> and routers.
>
No, not at all, and Oracle doesn't have provisions for it.

> I currently have a client who use client-server configuration. Local
> workstations work without problem but distant workstation have
> frequent messages like ORA-12571 : tns packet failure or ORA-03114 not
> connected to Oracle.
>
> I suppose that the networking is responsible of that.
>
Oracle can't make up for shitty connections.

> Server run Novel Netware 4.2 and 7.3.2 Database.
> Clients use 7.3.4 Oracle client part, under Windows 9X.
>
Let me understand this correctly: are you still living in the stone age? Novell 4.2 and Oracle 7.3.2, desupported in 1998 and 7.3.4 client, desupported in 2000?

You'r just living in a dead ally, as Oracle 7 is dead, and Oracle is going to desupport Netware soon.

>
> Thanx for any help.
> Y. Kermabon
>
>
>
> Tnsnames client :
> BASE.CLIENT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP.CLIENT)
> (PROTOCOL = TCP)
> (Host = 7.0.0.9)
> (Port = 1526)
> )
> )
> (CONNECT_DATA =
> (SID = BASE)
> (GLOBAL_NAME = BASE.CLIENT)
> )
> )
>
> Listener server :
>
> USE_PLUG_AND_PLAY_LISTENER = OFF
> USE_CKPFILE_LISTENER = OFF
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP.CLIENT)
> (PROTOCOL = TCP)
> (Host = 7.0.0.9)
> (Port = 1526)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = BASE.CLIENT)
> (SID_NAME = BASE)
> (ORACLE_HOME = vol01:\ORANW732)
> (PRESPAWN_MAX = 10)
> )
> )
>
>
Received on Tue Apr 24 2001 - 20:24:37 CEST