Hi Laura, Good info here. I'm assuming this is 10.2. The first issue is that in 10.2, the server-side service-level settings will override the client-side settings. So, you'll need to consult the DBA_SERVICES view (specifically the FAILOVER_TYPE column) to determine if the IUAT_TAF1.ascentanalytics.com service is configured for SELECT failover. If you need to modify the service, consult DBMS_SERVICE.MODIFY_SERVICE. I'd also highly recommend reviewing an excellent whitepaper all about services, failover, and more by Jeremy Schneider. It is at http://www.ardentperf.com/publications/ under the title "Unleashing Oracle Services..." (about 6th down from the top). It's a lot of information, but all goodness and (as Jeremy usually does) tested thoroughly. For lighter reading, the presentation "Oracle Services on RAC" is also helpful. Jeremy (if you're following)--where's the whitepaper for that presentation? Good luck--you're almost there! Dan laura pena wrote: -- //www.freelists.org/webpage/oracle-l |