Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [rac]

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.

Oracle Real Application Clusters (RAC). Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing a clustered database.

92 questions
12
votes
5 answers

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 transactions, as well as scale-out and high-availability…
SqlRyan
  • 1,206
  • 2
  • 17
  • 24
7
votes
5 answers

Can't drop UNDO TABLESPACE

We have Oracle 11gR1 RAC two instances on two different servers, new undo tablespace UNDOTBS20140508 created 30G, I want to remove the old one UNDOTBSX02, I did the following: CREATE UNDO TABLESPACE UNDOTBS20140508 DATAFILE…
Mohammad Jolani
  • 171
  • 1
  • 1
  • 3
7
votes
1 answer

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 for the database. At least that is the situation I…
Roy
  • 1,060
  • 5
  • 16
  • 39
5
votes
2 answers

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 -vip addresses. In theory, the new SCAN feature…
NullUserException
  • 315
  • 2
  • 11
5
votes
2 answers

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
Rahul Joshi
  • 51
  • 1
  • 1
  • 2
4
votes
2 answers

Two different databases on the same RAC cluster

We have an Oracle 11gR2 RAC cluster with 4 nodes. 2 nodes are dedicated to one database that's devoted one application and 2 nodes are dedicated to a completely separate database that serves a completely different application. They got all put on…
rfusca
  • 1,569
  • 4
  • 17
  • 29
4
votes
1 answer

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 interface name in a RAC? Or simply give a procedure…
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37
4
votes
1 answer

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 rdbms (then patch) or if I should install CRS / ASM…
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37
3
votes
1 answer

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 last one seems to listen on both the public network…
Roy
  • 1,060
  • 5
  • 16
  • 39
3
votes
2 answers

How to increase size of temp tablespace in Oracle 12C RAC with ASM?

I have an Oracle 12c RAC consisting of two nodes (OL6) and ASM. I use it for learning. For some reason I want to increase its temporary tablespace size. It's about 50M now. I've considered it using SELECT * FROM dba_temp_free_space; command. I want…
Gryu
  • 305
  • 2
  • 5
  • 13
3
votes
2 answers

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 parameters are no longer persisting. To explain, I've…
Josh Smeaton
  • 451
  • 1
  • 7
  • 15
3
votes
1 answer

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 other administrators(who do not have enough…
kupa
  • 1,737
  • 14
  • 39
  • 55
3
votes
1 answer

For accessing Oracle 12c RAC database by JDBC to ensure high availability, should I use TAF or FCF?

The case I encounter is that if one of the database on RAC array is suddenly down, the transaction is rolled back and connections between JBoss and Database are broken. What I want is to preserve the JDBC connections and redirect them to another…
Harold Chan
  • 204
  • 2
  • 7
3
votes
1 answer

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the Test environment (about 160 tps), The average…
GregH
  • 279
  • 1
  • 5
  • 11
3
votes
2 answers

Oracle import dmp file: ora exceptions

I'm trying to import a .dmp file to my oracle RAC database using the following command: C:\app\ptmp>impdp [user]/[password]@'DEVRAC-SCAN:1521/DB' DUMPFILE=UPG_E_7d291ff.dmp LOGFILE=UPG_E_7d291ff.log TABLE_EXISTS_ACTION=REPLACE And I get the…
B-M
  • 155
  • 2
  • 8
1
2 3 4 5 6 7