Re: Distant sites / SQL Net

Hi Sybrand

It's not "my" configuration, it's my client's one... And in fact my question was about a configuration with a modem calling an ISDN router when it detect network traffic. I suppose that the problem raise when the client side is reconnected after a period of innactivity.
So I wonder if a standard configuration can support this kind of states connected-reconnected and how SQL*Net can deal with it.

And for the version, don't panic... we also have clients with 8.1.6 version ;)

Yannick

On Tue, 24 Apr 2001 20:24:37 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>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:53:20 CEST