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
0 votes
1 answer
22 views

Oracle Clusterware - What is the difference between Votedisk, quorum disk and quorum failure group?

Some references say quorum disk and vote disk are the same, but "quorum disk" name was used in older versions. But Oracle 19c documentation still use both the names, so I think there is a ...
user avatar
  • 508
0 votes
1 answer
207 views

Upgrade Oracle RAC to version 19c - runcluvfy not passed because of missing patches - but they are applied!

Good morning all, I hope anyone can help me with this. I am trying to upgrade an Oracle RAC of two nodes from version 12.2 to 19c. As part of the prerequirements, I have applied the patch 28553832 in ...
user avatar
1 vote
1 answer
108 views

What is the difference between start and enable in the Oracle RAC srvctl?

In the Oracle 12c documentation it was not clear what is the difference between the srvctl start and srvctl enable commands for services associated with a database. In the view dba_service a database ...
user avatar
  • 401
0 votes
1 answer
218 views

Java application not using Transparent Application failover in Oracle database

I have a customer that have a RAC environment (2 nodes, database version is 11gR2). Clusterware version: [grid@server2 ~]$ crsctl query crs releaseversion Oracle High Availability Services release ...
user avatar
  • 508
0 votes
1 answer
716 views

ASM trying to mount droped diskgroup

In my envoriment I am getting the following erro: ORA-15032: not all alterations performed ORA-15017: diskgroup "OCR" cannot be mounted ORA-15040: diskgroup is incomplete The problem is: I already ...
user avatar
  • 508
1 vote
2 answers
5k 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 ...
user avatar
  • 11
1 vote
0 answers
136 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 "...
user avatar
  • 21
2 votes
1 answer
3k 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?
user avatar
2 votes
1 answer
2k 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 ...
user avatar
  • 165
0 votes
1 answer
951 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.
user avatar
  • 1
0 votes
2 answers
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? ...
user avatar
  • 1,814
1 vote
2 answers
579 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 ...
user avatar
2 votes
1 answer
452 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 ...
user avatar
  • 1,814
0 votes
0 answers
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 ...
user avatar
  • 451
1 vote
0 answers
9k views

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

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 ...
user avatar
  • 1,427
4 votes
1 answer
5k 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 ...
user avatar
  • 23.5k
2 votes
2 answers
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 ...
user avatar
  • 1,060
2 votes
2 answers
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 ...
user avatar
  • 1,060
12 votes
5 answers
17k 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,...
user avatar
  • 1,218
3 votes
1 answer
2k 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: ...
user avatar
  • 23.5k
2 votes
1 answer
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 ...
user avatar
  • 23.5k
2 votes
1 answer
6k views

What operating systems are certified for Oracle 11gr2 RAC?

How can this information be found?
user avatar
  • 123