Re: Select failover ORA-25401 when data is imported from an export on a RAC cluster
From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 11 Jun 2008 22:20:34 -0600
Message-ID: <4850A412.3020904@dannorris.com>
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:
Date: Wed, 11 Jun 2008 22:20:34 -0600
Message-ID: <4850A412.3020904@dannorris.com>
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:
-- http://www.freelists.org/webpage/oracle-l Received on Wed Jun 11 2008 - 23:20:34 CDTThe 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)
(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.-LizzEarlier 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.
>