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.
23
questions
12
votes
5
answers
18k
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
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 ...
3
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 ...
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:
...
2
votes
2
answers
19k
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
1
answer
510
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
1
answer
6k
views
What operating systems are certified for Oracle 11gr2 RAC?
How can this information be found?
2
votes
1
answer
3k
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 ...
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 ...
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?
1
vote
1
answer
86
views
oracle 19c rac cluster nodes show in different time zones
working on an oracle 19c 2-node rac cluster. we were running awr reports when we noted in sys.dba_hist_snapshot that the cluster nodes were in different time zones. We have validated that our ...
1
vote
1
answer
562
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 ...
1
vote
2
answers
7k
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 ...
1
vote
2
answers
650
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
0
answers
151
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
0
answers
10k
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 ...
0
votes
2
answers
5k
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
1
answer
439
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 ...
0
votes
1
answer
668
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 ...
0
votes
1
answer
2k
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 ...
0
votes
1
answer
2k
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
1
answer
35
views
"Unconfigure" oracle database
I have an Oracle 11g RAC installation which I want to "unconfigure".
This is a cloned machine which has an Oracle 11g RAC installation. I want to "reset" it (drop databases, ...
0
votes
1
answer
560
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 ...