Re: Select failover ORA-25401 when data is imported from an export on a RAC cluster

The link is http://www.ardentperf.com/pub/services-schneider07.pdf ....
outstanding paper!

r,

Gus

On 6/12/08, Dan Norris <dannorris@xxxxxxxxxxxxx> 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
> 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:
>
>
> 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.
>
> -Lizz
>
>
> 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@xxxxxxxxx

Other related posts: