Home » RDBMS Server » Networking and Gateways » Switching databases
Switching databases [message #367568] Thu, 15 October 1998 11:39 Go to next message
Rajeeva
Messages: 20
Registered: October 1998
Junior Member
have two database. They are replicated. The backup database is used as a failover database and generally users don't connect to it.

How can I make users connect autometically to the backup database when the main site database goes down.

My database/Listener is on Solaris and the users are on WIN/97 clients.

Can I do this with SQL*Net/Listener/TNSNAMES alone or do I need to write some scripts on the PC and/or on the Server.

Thanks

Rajeeva Thambugala
Re: Switching databases [message #367573 is a reply to message #367568] Fri, 13 November 1998 13:39 Go to previous message
Bruce
Messages: 21
Registered: November 1998
Junior Member
Rajeeva,

Option 1) Consider Oracle Names. By altering the connection parameters in the NAMES database, you can cause future connections to be redirected to which ever instance you wish.

Option 2) Alter TNSNAMES. This job is much easier if your clients pick up TNSNAMES from a central location. Much harder if the file is distributed.

Bruce
Previous Topic: LISTENER hangup
Next Topic: Network load
Goto Forum:
  


Current Time: Thu Feb 22 00:22:24 CST 2024