No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Transparent instance failover?
Next thread: Tracing index modifications
Prev thread: After upgrade DB Performance is slow

Message Score Author Date
I have a 2-nodes RAC db, many apps/app servers are...... Alain Bourgeois Feb 08, 2019, 15:52

Follow up by mail Click here


Subject: Transparent instance failover?
Author: Alain Bourgeois, Belgium
Date: Feb 08, 2019, 15:52, 475 days ago
Os info: oracle enterprise linux 6
Oracle info: 12.2.0.1 EE RAC
Message: I have a 2-nodes RAC db, many apps/app servers are connected, many connection types (jdbc, tns, oci, ...). Apps are not aware of TAF. But all apps specify either the scan-name, either all vip's of both servers.

Suppose I type as oracle on node 1:
srvctl disable instance -d dbase -i dbase1

It will disable instance dbase1... But what does it mean about all transactions running on dbase1?

Will they crash?
Will it wait the running transactions to end before disabling the instance?
Will the running transactions continue on another instance?
Is there a way to turn off one node transparently for applications?

Regards

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here