| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Fail over database
James,
I've added an additional address to my alias in the tnsnames.ora file to let it fall through to the other address. The only issue is with the lag time due to TCPIP, but it will fall through and connect to the second address.
Take a look at the following document. I think it should do the trick.
Durinda Jones
Yellow Technologies
Bookmark Fixed font Go to End
Doc ID: Note:1015057.4
Subject: DOES SQL*NET SUPPORT REDUNDANT ALIASES?
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 25-JUN-1996
Last Revision Date: 17-JUL-1996
Language: USAENG
Problem Description:
Can SQL*Net have the same alias twice in the TNSNAMES.ORA with the first connecting to the primary host, and if that is not available, it switches to
the other host.
Solution: SQL*NET DOES NOT SUPPORT REDUNDANT ALIASES
Solution Description:
SQL*Net does not support redundant aliases. It will try the first alias and
ignore the second alias.
SQL*Net does support multiple addresses in one alias. If the first address fails, it will try the second. Example follows:
alias.world =
(description=
(address_list =
(address =
(protocol = SPX)
(service = <service_name>)
)
(address =
(protocol = TCP)
(host = <host_name>)
(port = ####)
)
(connect_data =
(sid = <sid>)
)
)
-----Original Message-----
From: James Nailos [mailto:nails41175_at_yahoo.com]
Sent: Thursday, June 08, 2000 9:52 AM
To: oracledba
Subject: RE: Fail over database
Unfortunately using a standby database is not going to work for us. We are using Vignette Story Server, which has machine specific information on a couple of it's tables. So, those tables must be maintained separately on each machine. From what I understand it is not possible to maintain separate tables on a standby database. Does anyone have any suggestions to how I would switch to another database without using a standby database or load balancing? Basically, I need someway to detect that our production database is not accessible, and then switch the alias in my tnsnames to point to the backup database (or something to the effect of this). We are using Solaris machines, so I know that I can set up a daemon to do this. But, I was wondering if there was an easier way to do it through Oracle.
Thanks,
Jim
 |
 |