Questions tagged [oracle-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.

Filter by
Sorted by
Tagged with
11
votes
5answers
16k views

SQL Server equivalent to functionality of Oracle RAC? [closed]

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,...
4
votes
1answer
4k views

Specify Server for DBMS_Scheduler Job in Policy Managed RAC

A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
3
votes
1answer
1k views

Oracle Enterprise Manager Jobs Failing Initialization

The Enterprise Manager jobs on our RAC system recently started intermittently failing initialization with the following error: Error evaluating parameter sources/security checks/locks ORA-06508: ...
2
votes
2answers
18k views

How high can I set undo retention on Oracle 11gR2

Is it viable to set a very high undo retention, as to allow flashback queries several weeks back in time? Naturally, enough space must be available in the undo tablespaces to contain the amount of ...
2
votes
1answer
360 views

Split brain scenario - RAC and PXC

Even though split brain scenario occurs in both Oracle RAC and Percona's XtraDB Cluster, a two node cluster is allowed and split brain scenario is resolved in RAC but a two node is not recommended in ...
2
votes
1answer
2k views

Differing results from gv$session

The following query returns no results, yet it seems like it should. SELECT * FROM gv$session where SID = SYS_CONTEXT('USERENV','SID'); In my 11.2.0.2 Standard Edition RAC environment the above ...
2
votes
1answer
6k views

What operating systems are certified for Oracle 11gr2 RAC?

How can this information be found?
2
votes
2answers
7k views

Oracle RAC with single node Data Guard physical standby

Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC. What special considerations would one need to take into account ...
2
votes
1answer
1k views

Oracle 11g database datafile addition to ASM without '+' sign

what will happen, if we miss the '+' sign while adding datafile to ASM in oracle 11g database? Whether datafile added will be ASM based or Non-ASM based?
1
vote
1answer
1k views

Query not showing in dba_hist_active_sess_history

The application team claims there was a statement that took about 30s to execute at about a certain time. I tried to find out what queries had been executed in during this time with the following ...
1
vote
2answers
452 views

Where does SYSTIMESTAMP come from in multi-server Oracle RAC environment?

Where does SYSTIMESTAMP come from in multi-server Oracle RAC environment? I'm hoping that the SYSTIMESTAMP derives from a common location (master node?) as opposed to the server that is currently ...
1
vote
0answers
98 views

RMAN corrupts passwordfile

please, can you clarify this? My configuration is RAC 12c on ASM on SLES 11 SP 4 on SystemZ. The nodes rac11 and rac12 are the server nodes of the primary database, named "primdb", uniq_name is "...
1
vote
0answers
9k views

Database Open but Oracle gives ORA-01033: ORACLE initialization or shutdown in progress

We are using 4 node Oracle 10GR2 RAC in Windows x64. 3 instances of our database crashed today and later started normally. I started them by connecting (Remote Desktop) to individual instances and ...
0
votes
2answers
4k views

Change IP of nodes in Oracle RAC

I have a two node RAC database running in OEL 7 server. If there is a need to change the IP addresses of the already running server to a new one, will that hamper the functioning of the database? ...
0
votes
2answers
947 views

Oracle 19c GI Install on OL7 : ASM disks stamped via AsmLib not getting discovered via GridSetup.sh

I am trying to install GI 19c on Oracle Linux 7 (required for 19c), and have used AsmLib to try to achieve device persistence (owner,group) for ASM devices/disks. Prior to that I used udev rules for ...
0
votes
1answer
434 views

Oracle RAC Maintenance [closed]

Is it possible to keep one node running in 2 node cluster while keeping one node down for Maintenance?.I want to do this as we are planning some hardware upgrades.
0
votes
0answers
3k views

Oracle RAC takes forever dropping tables

We are seeing table drops consistently take tens of seconds on our Oracle 12c RAC. It appears to be spending on its time on reliable message waits. Which I think means that it asks the other node to ...