Oracle Real Application Clusters (RAC) is an option for Oracle Databases. It is a cluster database with a shared cache architecture that increases scalability and availability. Oracle RAC support is included in the Oracle Database Standard Edition and is an extra cost option for Enterprise Edition.
0
votes
0answers
48 views
SYS_CONTEXT INSTANCE changing on failover?
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 ...
1
vote
1answer
1k views
Oracle 11gR2 archive log destinations
I want to add a second archive log destination to an Oracle 11gR2 RAC database with ASM, the idea is that I will then have some redundancy if the primary storage should fail.
Archive log is already ...
3
votes
1answer
293 views
Network design considerations for Oracle Database Appliance
With the introduction of Oracle Engineered Systems the DBA is moved somewhat closer to infrastructure design decisions, and expected to at least have some opinions of the network design requirements ...
3
votes
1answer
775 views
Add an additional listener to Oracle Database Appliance
After deployment of Oracle Database Appliance with OAK 2.3.0 the standard listeners are configured for the public network on bond0. That includes SCAN listeners and one VIP listener per node. This ...
0
votes
0answers
251 views
Uninstalling Oracle 11g RAC from a Windows Server 2008
Trying to uninstall a Oracle 11g RAC from a Windows Server 2008.
Following instructions on:
http://docs.oracle.com/cd/E11882_01/install.112/e25666/rem_orcl.htm
I was able to run batch:
...
1
vote
3answers
2k views
Shutdown one node in RAC
I want to shutdown one node in RAC. I did the following steps:
Shutdown database instance
export ORACLE_SID=mydb1
sqlplus / as sysdba
shutdown immediate;
shutdown ASM instance
. oraenv
+ASM1
...
7
votes
4answers
2k views
SQL Server equivalent to functionality of Oracle RAC?
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write ...
1
vote
2answers
1k views
Setting NLS params in logon trigger don't work in oracle 11g
We have a trigger setup so that when a specific user logs in, their NLS session parameters are modified. This used to work on Oracle 10g. We've just migrated to Oracle 11g RAC, and the session ...
3
votes
0answers
124 views
changing Virtual IP interface names on RAC nodes - how to reconfigure
We are adding an extra interface on our nodes and we are going to bond these so the VIP interface will change from eth5 to bond3.
Can someone point on documentation on what to do to reconfigure the ...
3
votes
1answer
297 views
Oracle RAC on Virtual machine
I have Oracle RAC on the very powerful servers and it can be said that these servers have extra memory,cpu and storage :) ...so my servers are much more powerful than it is needed.
My manager and ...
4
votes
2answers
326 views
Installing oracle RAC 10.2.0.1 install and patch to 10.2.0.5 directly or install CRS ASM and RDBMS then patch?
I'm installing my first RAC and I was wondering if I should install CRS 10.2.0.1 (we are still at 10g for compatibility reasons) then patch to 10.2.0.5 before I install ASM (then patch) and finally ...
5
votes
1answer
2k views
Oracle RAC failover not working correctly
I have Oracle 11gR2 set up on a RAC environment with two nodes. I have SCAN set up, eg: I have two entries on the DNS set up so I can ping the SCAN name and reach either node. I can also ping both ...
2
votes
3answers
158 views
Book for Learning RAC
What is a good book to read to learn about RAC? I am most interested in the practical end rather than the theory behind it.
