Database - RAC/Scalability (MOSC)

MOSC Banner

Is it posible maintain session characteristics after a Failover?

edited Oct 5, 2010 12:23AM in Database - RAC/Scalability (MOSC) 1 commentAnswered
Hello, I have a cluster database (11.1.0.7) with two nodes. I have implemented FAILOVER in tnsnames but I am not using LOAD_BALANCE. I have a question. When I establish the session, I alter my session (nls_language), when we have a problem in the instance and the session change to the other instance I lose this alter. Is it posible maintain this session characteristics?

I show the tnsnames.ora failover parameters:

POLUX_NET.********.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (FAILOVER=ON)
    (LOAD_BALANCE = OFF)
      (ADDRESS = (PROTOCOL = TCP)(HOST = ****-vip)(PORT = 1527))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ****-vip)(PORT = 1527))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BBACK)
        (FAILOVER_MODE=

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