473,320 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Offline Database management

29
[FONT=Arial][SIZE=2]Hi all,

I have a Client server application running on Oracle 10 G.

Issue is that the connection with server may get lost or disrupted, but it must not effect the system, so I need to suggest a system that would synchronise the data with the server once the connection is established with server.

So is there any way were can synchronise the data with server after a network downtime, using ORACLE.

or any other approach is required

Any suggestion / Advice

Thanks
Tim
[/SIZE][/FONT]
Jan 28 '09 #1
5 2088
amitpatel66
2,367 Expert 2GB
First thing database needs to be UP and RUNNING for any application to communicate with the database

In case if the network goes down, and you lose database connection, you will need to refresh the application/session or restart the session in order to sync with the database server once the connection is reestablished.
Jan 28 '09 #2
tim007
29
Thanks Amith,
but the situation is we have a client machine, which often has network problems,
if Database connection is lost, we need a work around....Page cannot be refreshed as it would mean re-typing all the the data again... so we need something like storing the data into a different DB , and then once the connection is re-established sync the DB with servers.
so now I need something like this or a better approach

so i need a automated datasynchronisation ... does Oracle support that
Any suggestion ?
Jan 28 '09 #3
amitpatel66
2,367 Expert 2GB
You want another databse set at your client side which should be synched with the DB at server side?
Jan 29 '09 #4
tim007
29
Yes thats right Amith

When network is down Client Data store would be used

and When Network is back to normal then we need to synchronise the data between the Client Data Store and Server data base

Is there any way we could automate this process(data sync) using Oracle 10 g ?
Jan 31 '09 #5
amitpatel66
2,367 Expert 2GB
Do you think this will be feasible to have a database at client machine? Say if you have 100 machines at client side, you will need to install DB in all the client machines and all of them need to be synched with Server DB every time the network is UP. I dont think that having a DB at client side is a practical solution for network problems.
Feb 3 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: NohaKhalifa | last post by:
Dear All ; I have a web site and i made it's administration offline using asp . I want after I fill a data in the offline database, onclick a button this data sent online . The problem is...
1
by: Moti | last post by:
Hello, I am trying to check the integrity of SQL database. The 'problem' with SQL server is that it's fixing the DB automatically after restore so I need a way to do it offline, much like using...
0
by: Zenu | last post by:
Hi, I would like to know what technique is used in an Hierarchical Storage Management (HSM) configuration to allow applications to wait for an offline file that has been migrated through HSM to...
0
by: moko | last post by:
This is a bit long-winded. Can somebody read thru these 2 use cases, and tell me if it is feasible ? :- Use Case : Replication before Offline Synch Scenario 1 : Oracle Server , MSDE client ...
8
by: Amy DBA | last post by:
OK, I'm stumped now. I need help restoring a tablespace that has been marked offline. Here's a little background on the problem: 1) There was a hardware failure that caused the tablespace to...
2
by: Buck Turgidson | last post by:
I have an SAP development system running on Linux. It is not a critical system, but I would like a restore-able backup. I have taken an offline backup, but I am unable to restore it. I am...
3
by: Alex | last post by:
Hello, I am running an Access 2003 database, quite modest in size, that is used by upwards of 5 users. I need to modify the database such that these users can work simultaneously and, in some...
6
by: Senthil | last post by:
Hi All We are having a VB application on SQL. But we need to collect information from persons who will be offline to verify data and insert new data. Generally they will be entering the data in...
2
by: ericthered | last post by:
Hi, I am trying to create an offline database in VB.NET 2005, both the online and offline database use SQL Server 2005. The code I am using seems to run OK with out an exception the DATASET has the...
10
by: Michael Hoffmann | last post by:
Hello, I hope this doesn't come across as totally newbieish, but I've been searching the web and the IBM docs until smoke is coming out of my head. Scenario: We are trying to take primitive...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.