Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When using Oracle RAC with either Fast Connection Failover or TAF (Transparent Application Failover), for a given database connection, is SYS_CONTEXT('USERENV', 'INSTANCE') going to change when there's an automatic failover?

(I can't test right now, not having a RAC instance available on hand.)

share|improve this question
    
Will take me as long as you to setup a test case for it. Sorry! Ask Oracle support. –  Phil Jan 22 '13 at 22:47
    
I'm just asking someone who knows or has the right setup available, no need to downvote just because you're not willing or able to help. –  Florent Guillaume Jan 23 '13 at 8:30
    
And to answer the implicit question, I don't have Oracle licenses or support. I'm developing open source software for Oracle but would like to cover all bases. –  Florent Guillaume Jan 23 '13 at 8:30
    
I would consider it a bug if it didn't change, but I haven't tested it. –  Leigh Riffel Jan 24 '13 at 18:34

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.