Networks

Ask something
Question Locked

oracle 10g over satellite

0 helpful
7 replies

by xavi792002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi all
i have a new project to connect different sits to HQ through satellite links i am afraid it will not work because of the big delay (600 ms), i am thinking to use TCP Accelerator may be it can help, maybe someone can help and tell me about the type of connection between client and server in 10g ?

regards

7 replies

by robo_dev

While Oracle sessions will not timeout for as long as 30 seconds, a database session over a sat link would not be acceptable to any users.

10G client is very similar to most DB client-server connections...a dedicated port (1521) and a 'listener' process that runs on the server.

Your better architecture would be to do some sort of terminal-server style remote access, or do offline database replication.

by xavi792002

thanks ROBO_dev

if the port is TCP 1521 maybe i can use TCP accelerator, i think may be it help in this situation better than using f terminal-server style remote access or database replication

what do u think ?

by robo_dev

but the whole concept of TCP acceleration involves techniques like local acknowlegement, and lots of buffering to make up for packet loss.

My gut feeling is that all this TCP tuning might make database reads work, but would be very likely to result in data corruption for database writes.

I've worked with Oracle databases over slow (150ms) cross-ocean links, with mixed results.

You should invest in a network latency simulator to test with.

by xavi792002

i am asking too much robo_dev i wish i am not annoying u with my Qs
how database acts with this delay.
b4 i tried TCP accelerator with FTP it works perfect , in this project i have active directory servers in each site connect to HQ plus mail server in HQ and the users in remote sites all via satellite link

by robo_dev

Oracle is not.

the main issue I would see would be that real-time access by multiple users would result in dead-lock after dead-lock,and the database crawls to a halt.

If your application can make use of database replication or synchronization, that would be the best approach.

Note that even doing SQL database replication over satellite is a big deal:

"Noteworthy is that Gencentric was one of the first companies in the world to succeed in doing SQL replication over satellite."
http://www.gencentric.co.za/Tech_SQLServer.aspx

Here is a link to some test tools to simulate latency:
http://www.networktesttools.com/anue/satellite_communication.html

by xavi792002

many thanks robo_dev
really your are awesome
you look u are interested with satellite communication

This discussion is closed to new replies.