Standby Database Ready - Need some help [message #61651] |
Thu, 13 May 2004 10:13 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
Hi,
I have successfully created a standby database on Oracle 9i. They are failing over fine , no issues at all. I am new to this, so I just need some final clarifications. We have about 100 users using the database (client -server type application) with service names configured on tnsnames.ora on each client. When the failover takes place, how do the client tnsnames.ora point to the standby database? I believe that some kind of special configuration should be done in the tnsnames.ora to indicate that that particular service name has a standby server. But how do I indicate it? Please give me a sample tnsnames entry for clients.
Thanks
|
|
|
|