| Switching databases [message #367568] |
Thu, 15 October 1998 11:39  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
