Re: Select failover ORA-25401 when data is imported from an export on a RAC cluster
Date: Thu, 12 Jun 2008 06:22:59 -0400
The link is http://www.ardentperf.com/pub/services-schneider07.pdf .... outstanding paper!
On 6/12/08, Dan Norris <dannorris_at_dannorris.com> wrote:
> 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
> 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!
> laura pena wrote:
> We were told by consultants that on our production 2 node cluster (64-bit
> RedHat linux, RAW using ASM) database that after importing data into a new
> schema, the select failover was not functioning.
> The data was imported into a new schema in a clustered db instance
> (2nodes). A huge select statement was run and a node was taken down to test
> select failover. Once the node was taken down the select statement issued
> the following message:
> "ORA-25401 can not continue fetches" when selecting from a table from 1
> node, and shutting down node to test
> failover selects.
> The TAF looks like:
> (DESCRIPTION =
> (ADDRESS = (PROTO = TCP)(HOST = oraclea1-vip)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = oraclea2-vip)(PORT = 1521))
> (FAILOVER = yes)
> (LOAD_BALANCE = yes)
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = IUAT_TAF1.ascendanalytics.com<http://iuat_taf1.ascendanalytics.com/>
> (FAILOVER_MODE =
> (TYPE = SELECT)
> (METHOD = BASIC)
> (RETRIES = 180)
> (DELAY = 5))))
> To get this to work, we had to import the data into a temporary schema,
> then from the real schema we want, we did a create table xxx as ... from the
> temp schema we imported the data into.
> Thanks again for any suggestions.
> I also have an attachement of the scr if you are interested. Doesn't look
> like I'm allowed to post attachments.
> Earlier post:
> I have a issue, that I am going to be researching in detail and
> > thought I'd run it by all as to the best way to test or if there is
> > already a solution get it :) We were told by consultants that on our
> > production 2 node cluster (64-bit RedHat linux, RAW using ASM)
> > database that after importing data into a new schema, the select
> > failover was not functioning.
> > Has anyone had this same issue? If so what was your solution?
> > I was planning on creating the user first and skeleton schema then
> > importing only data via one of the nodes not the taf service.
> > Any assistance as always is most welcomed.
> -- http://www.freelists.org/webpage/oracle-l
-- Gus 703 304 5587 (mobile) 540 687 3370 (home) gus.spier_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 12 2008 - 05:22:59 CDT