I have 50 users in location A. Then i have 10 users in location B. Location A and B users accessed the database name PSDB thru network.
My problem is, when location B have problem on their connection ( means cannot access the network because of line problem) but users on this location wants to access the database continously, how can i solve this?
Any recommendation ?
I am using oracle8.0.4 on solaris2.6 (unix) . My database is in NOARCHIVELOG mode.
Is replication can solve this problem or a standby database? Please advise and if possible i need a step by step procedure.
Replication is good and tnsnames can be set up to failover to the replicated database ... Oracle Enterprise Edition has Multimaster Replication where you have 2 or more MASTER databases. Oracle std
edition only allows for SNAPSHOT replication.
Keep in mind that if you are using sequences, these are not replicated and therefore could cause problems. You must understand how the data and tables are inserted and their primary keys. If you have a "sequential numbering" system of some sort, you must take that into consideration ... (if the connection is lost and users are "failed over" to the secondary database, the data entered cannot be of the such that will cause "duplicate key" issues upon "resyncing".