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.

Filter by
Sorted by
Tagged with
12
votes
5answers
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,...
7
votes
5answers
16k views

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 ...
7
votes
1answer
4k 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 ...
5
votes
2answers
9k 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 -...
5
votes
2answers
16k views

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
4
votes
2answers
2k views

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 ...
4
votes
1answer
1k 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 ...
4
votes
1answer
725 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 ...
3
votes
1answer
2k 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 ...
3
votes
1answer
560 views

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 ...
3
votes
2answers
9k 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
1answer
379 views

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 ...
3
votes
2answers
1k views

Oracle import dmp file: ora exceptions [closed]

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....
3
votes
1answer
12k 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 ...
2
votes
2answers
12k views

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 ...
2
votes
3answers
940 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.
2
votes
1answer
22k 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 ...
2
votes
0answers
329 views

Should an SCN obtained from one RAC node be immediately usable on other RAC nodes?

I'm seeing ORA-08181: specified number is not a valid system change number and don't understand why. The error happens around once a month from a process that runs every few minutes - so very rarely. ...
1
vote
3answers
2k views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a pre-...
1
vote
3answers
47k 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 ...
1
vote
1answer
262 views

Oracle RAC: Can two transactions share an SCN?

Under what conditions (if any) can two transactions share an SCN? To put another way, is there a guarantee that if several DML statements share an SCN they are guaranteed to be part of the same ...
1
vote
2answers
15k views

oracle active sessions waiting for scheduler

Load on my 11g RAC looks like this: and I don't understand how to get insight into what this "scheduler" wait class is. It seems like "scheduler" that it refers to is the process that runs scheduled ...
1
vote
2answers
3k views

oracle tablespace extending

While under massive write (insert and create table as) load, when Oracle RAC needs to extend tablespace, all write activity gets blocked for however long it takes it to finish extending (tens of ...
1
vote
1answer
9k views

What does node eviction mean in the Oracle RAC world?

Software environment: Oracle 12c with RAC running on RHEL The question might sound rather banal, but I wasn't able to find any word on this in the Oracle documentation I read thus far. By searching ...
1
vote
1answer
550 views

Oracle RAC concept

This might be a dump question, but I've been reading so much different things, that I'm not sure anymore. I tried to understand the concept of the Oracle RAC, so I've been reading the datasheet form ...
1
vote
2answers
4k 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
1answer
1k views

What are the events that EVMd process in Oracle RAC distributes across cluster?

I am new to Oracle RAC. I was studying about Oracle RAC background processes, in which I came across EVMd process which distributes the event message across other nodes in the cluster. Could you ...
1
vote
1answer
5k views

Connect to Oracle RAC from SQL Developer?

We have set up RAC database on server. We can connect to database from sqlplus on the server using SCAN address. However, if I try to connect to RAC using SQL developer from client machine using SCAN ...
1
vote
1answer
5k views

SCAN listener redirects connection to another port

I have setup RAC. I have two listeners LISTENER and LISTENER_DG. LISTENER is listening port 1521 LISTENER_DG is listening 1530 When client connects to the database using SHARED connection mode even ...
1
vote
2answers
646 views

Oracle RAC VIP issue

I have a two node RAC setup where my scan ips are registered in DNS and my public Ips are also registered in the dns. Now while connecting from my windows machine through oracle client in sql ...
1
vote
1answer
1k views

Oracle Rac With Scan Error

I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1. I have 2 node in my plan and all of them are active. I set scan in my DNS server but I can not connect to ...
1
vote
1answer
5k views

cluster_database TRUE/FALSE what does it mean in Oracle RAC?

I have 3 databases on an Oracle RAC (two nodes) one database which is running with CLUSTER_DATABASE=TRUE on both nodes, the other two runs on each node with CLUSTER_DATABASE=FALSE what does it mean ...
1
vote
1answer
2k views

Oracle RAC 11g R2 DB silent install: parameter needed for system class

I'm installing Oracle RAC DB 11gR2 using response file and silent mode. The installation is failing with the error message: [INS-35421] This options installs a single instance database only You ...
1
vote
1answer
27 views

Oracle Real cluster application?

My application is working in Real cluster application(RAC)in production. I am new to RAC and gone through this video . My understanding after reading this RAC uses more than one node only for ...
1
vote
0answers
566 views

Error CRS-5014 when runing RAC 11gr2 on Redhat 6

My database using RAC 11gr2 with two node on Redhat 6. My system running fine, but after some time about 3-4 days. Process "ora.LISTENER.lsnr" change status Online to INTERMEDIATE and then pedding, ...
1
vote
1answer
1k views

Query on SCAN in RAC

I have a two node RAC (Oracle 12c) on linux. I have 5 SCAN listeners configured. Currently, if I do a srvctl config scan I notice that out of the 5 scan listeners, one scan is running in one node ...
1
vote
1answer
6k views

Oracle RAC, unable to connect to node vip [closed]

I have a new oracle RAC installation running 11.2.0.4 on redhat 6. I can connect to sqlplus from a client using the node name but it is timing out when i use the node vip eg. first one works, second ...
1
vote
3answers
42k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
0
votes
1answer
4k views

determine redo log size, number of redo log files

Having 2 node RAC instance using ASM Log switches happening are too high about 100 per hour causing db to hang for few minutes sometimes GROUP# THREAD# MEMBER ...
0
votes
1answer
155 views

Why do we still need VIP when using SCAN?

When we are using Single Client Access Name (SCAN), the clients connect to the database through the SCAN name in DNS or GNS like in the example below: stackdb = (DESCRIPTION = (ADDRESS = (...
0
votes
1answer
3k views

oracle 12c rac switch from mounted to open

How to open an RAC database correctly(version 12.1) from "mounted" state? Earlier, nodes #01 and #02 were opened manually by the command alter database open. Now, the database in this state: SQL>...
0
votes
1answer
1k views

Oracle - Scan listener and multiple databases

I have a two node RAC database server hosting 8 databases. I have 3 scan listeners running. 2 in node 1 and one in the 2nd node. All the 8 databases are running for different applications. Are these ...
0
votes
1answer
1k views

Is catclust.sql really required? What is the importance

We are in a process of upgrading RAC Databases, and when validating the installed components, we saw that some of the databases aren't displaying the RAC component, but still the RAC works normally ...
0
votes
1answer
5k views

Oracle: Am I on a RAC?

What query can I perform to determine if I am running on a RAC system? If I'm on a RAC, I need to query from GV$* rather than V$*.
0
votes
1answer
111 views

Starting oracle rac node2 error: ORA-29701: unable to connect to Cluster Synchronization Service

I have a oracle RAC /12c/. I got these error when I try start the base from node2. ```ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/mydborcl/...
0
votes
1answer
46 views

Oracle RAC 18c Patching - datapatch

After patching GI Home and DB Home simultaneously using command: .oraenv +ASM1 opatchauto apply /patchlocation Should i run ./datapatch from DB home or GI home? Or it doesn't matter from which home? ...
0
votes
1answer
301 views

Oracle 18c opatch util cleanup not working

System: [oracle@hostname:/opt/oraclegrid/18]$ uname -a SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v Database: Oracle 18c 18.10 (April 2020 patch), RacOneNode setup Opatch OPatch Version: 12.2....
0
votes
1answer
391 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
1answer
165 views

PDB state in Oracle 12c RAC

Installed two node Oracle RAC. On node 1 opened pdb1 and shows open mode as read and write but on node 2 it's still in mounted state?. On Node1 rlwrap sqlplus / as sysdba SQL*Plus: ...
0
votes
1answer
2k views

Oracle: Save PDB state for all instances in RAC environment

I found out the following two contradicting statements in the Oracle DBA guide. For an Oracle RAC CDB, you can use the instances clause in the pdb_save_or_discard_state clause to specify the ...