Dear all,
I m new in Oracle Database Administration and i have a question. My scenerio is that there are 3 diffrent offices locations where is running same oracle application and 1 place is working as database server running Oralce 9i. Now problem is that when db server side is down then other two location stop working becuse of db server unavailable. Kindly tell me a simple solution that the other 2 locations work properly even db server is off.
I have idea that if i install oracle 9i on other two client location and when db server will down, these location store their data locally and when db server will up data should update on main db server. How can i obtain my goal? Thanks in advance

look up dataguard

>> Now problem is that when db server side is down then other two location stop working becuse of db server unavailable.

You have several choices (Data Guard, RAC, or Streams), depending on yout tolerance for unplanned downtime.

http://www.dba-oracle.com/t_oracledataguar...n_failover_.htm

I highly recommend that you get the book "Oracle Replication" for the details:

http://www.rampant-books.com/book_2003_2_replication.htm