Database - RAC/Scalability (MOSC)

MOSC Banner

Does 12cr2 support DML in TAF?

edited Aug 4, 2020 5:00AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi,

It was known app must handle ORA errors if using TAF with DML before 12cr2.  I was told TAF will support DML failover in 12CR2, But it still report ORA-25408 when i test this feature in oracle12.2.0.1.

Is it my config error or the feature still need wait?

Here is my environment.

version:12.2.0.1(server or client)

tnsnames.ora entry:

ORCL_rac =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 193.28.33.5)(PORT = 9581))

    )

    (CONNECT_DATA =

      (service_name = orcl)

      (SERVER = DEDICATED)

      (FAILOVER_MODE =

        (TYPE = TRANSACTION)

        (METHOD = BASIC)

        (RETRIES = 180)

        (DELAY = 5)

    )

  )

  )

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center