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

From RAC to Standby RAC With Active Dataguard

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these ...
0
votes
1answer
222 views

Oracle RAC and DataGuard configuration

We have deployed an Oracle RAC cluster which consists of three Oracle instances. As we are considering the HA issue, and as far as I know, the only way of Oracle HA is DataGuard. So is it possible ...
0
votes
1answer
102 views

ORACLE ASM present one or more LUNs?

I have the following question regarding the allocation of disks or LUNs to ASM in Oracle, specifically, I have an Oracle 18c DB in Cluster and I have created several diskgroups, now, I need to ...
-1
votes
0answers
37 views

What's the history behind Oracle RAC? [closed]

I'm investigating about Oracle RAC for a University course's project. I've been reading a lot about it, but I'm still curious about a solid timeline on why it was conceived as a product and how it ...
0
votes
1answer
106 views

Oraagent many SYSRAC processes open

I see in my 19c Cluster database a lot of sessions (over 350) with SYSRAC user and status INACTIVE with oraagent.bin TNS V1. They can consume my connection pool (how can I make this bigger number). ...
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 ...
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 ...
0
votes
1answer
6k views

RAC database fails to start

I encountered the below errors when i am trying to start the RAC DB/instances. The Cluster/CRS is up but could not bring up the RAC DB instances. Environment: 2 Node RAC (12cr2) on Linux 7.3 [...
0
votes
1answer
2k views

Oracle ASM: Freeing up space

Oracle RAC 11.2 with asm storage, all type = EXTERN redundancy. I've been cleaning up some tablespaces and shrinking datafiles back down to sizes that they're not likely to grow much larger than (...
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 ...
0
votes
1answer
114 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
669 views

PRKP-1001 : Error starting instance,CRS-0215 : could not start resource

We have 3-node Oracle 10g R2 RAC database. Following is the status of various RAC components:- ora....b2.inst application ONLINE OFFLINE ora....db2.srv application ONLINE ONLINE ...
0
votes
1answer
514 views

Load balancing on oracle (12r2) 2 node RAC is not working

Any help/pointers would be greatly appreciated. I have a 2 node RAC (Oracle 12r2) on linux, CRS and all its services are up. Both the RAC instances are up. scan listener resolves to 3 ip's. But ...
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
0answers
40 views

Oracle 19c standby - redo transport errors

I have a 19c RAC Standby database on RHEL6 using dataguard, however, I’m currently getting a “ORA-16737 redo transport device dir standby has an error” msg. I’ve tried recreating the password file and ...
0
votes
1answer
33 views

How to combine Oracle RAC with in-memory database to isloate OLAP from OLTP

I am going through a document https://www.oracle.com/technetwork/database/options/database-in-memory-data-sheet-2338744.pdf There is a thing written "Oracle Real Application Clusters (RAC) can be ...
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 ...
0
votes
0answers
29 views

Application connection pooling load balancing the transactions on 18c RAC

Application connecting a 2 node 18c RAC. JVMs are using connection pool and transactions are routed to the nodes via the connections in the pool. So the initial load across the nodes are distributed ...
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
0answers
17 views

Oracle - How to find out ADVM file system type?

Is there some built-in command from Oracle to find out ADVM file system type? I was looking for it in advmutil command or acfsutil command. But I don't find anything. In Linux usually I use file -s [...
0
votes
0answers
463 views

ASM filter drive not starting automatically

After migrate from asmlib to asm filter drive using the Doc ID 2172754.1 the ASM Filter drive not start automatically and I always need configure again using asmcmd afd_configure command to start it ...
0
votes
1answer
157 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
0answers
808 views

What is SYSRAC SESSION?

In my environment (oracle 19c) I can see several SYSRAC sessions. What is the purpose of this session? SQL> select username,status from gv$session where type <> 'BACKGROUND'; USERNAME ...
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 ...
-1
votes
1answer
222 views

The best way to patch Oracle Rac One Node [closed]

what is the best way (best practice) to patch Oracle Rac One Node (2 nodes - node1 and node2, every node has own database home and GRID home = 4 homes)? Thank you System: Oracle Solaris 11 DB: ...
0
votes
2answers
1k views

Problems connecting remotely to a RAC DB via sqlplus

When I create a user in an 11204 single instance DB and afterwards grant the sysdba privilege to that user I can connect remotely without any problems using: sqlplus testuser/testuserpwd@testdb as ...
0
votes
1answer
97 views

On a 12c R2 RAC DB, Oracle instance information on crsctl is shown incorrectly

crsctl status output is showing incorrect information for ora.***.db. Instance 1 and 2 are running on Node1 and Node2 respectively but crsctl status shows as below As we can see below, its showing ...
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
0
votes
0answers
180 views

Randomly getting ora-01017

I have an Oracle RAC (12.1.0.2) installed on ESXi 6.5. RAC nodes are hosted on different physical servers and there is a storage hosting their shared disk. Here is my problem: Trying on Toad, SQL*...
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

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

Can Oracle SE2 RAC works with only a single instance? Is it recommended?

I've got a client with an Oracle DB 12 SE2 RAC with two instances. One of the instances is giving too much problems. He wants just to remove it, and therefore leaving Oracle RAC running in only with ...
0
votes
1answer
7k views

Oracle 12c RAC Cluster / CRS fails to start after reboot

Could someone shed some light to help fix the cluster/CRS startup failure 1) /oragrid/app/grid_home/bin/crsctl start crs CRS-4640: Oracle High Availability Services is already active CRS-4000: ...
-1
votes
1answer
277 views

ASM Query - Oracle 11gR2

I have two node RAC servers hosting 4 databases running on 11.2.0.3 version in RHEL OS. The underlying LUNs assigned to the ASM is not currently multipathed, meaning the disk sequence would change ...
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-...
0
votes
1answer
166 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
42 views

Oracle 11g RAC - PSU

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough? Thank you in advance
0
votes
1answer
114 views

Connecting to Standalone/RAC

I would like to know if SERVICE_NAME is always configured for a Oracle standalone and RAC setup or it's optional to set up. In my code I would like to connect to Database using SERVICE_NAME. But if ...
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
0answers
45 views

oracle load estimates

Our 11g RAC cluster has two nodes, each with 8 CPU cores and a memory target of 16GB. System RAM is 64GB (don't ask me why the memory target is just 16GB, I wasn't there when that choice was made). ...
0
votes
0answers
141 views

RAC DB Slowness - AWR Report

While going through the AWR report found that the row lock waits on indexes and buffer busy waits are more (rest of the stats look normal). Could someone tell me if we can interpret by the below if ...
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 ...
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 ...
0
votes
1answer
729 views

ASMCA(ASM Configuration Assistant) GUI is not rendering properly

Hi Gurus, While running ASMCA utility on OEL 7.5, Oracle is not able to render the GUI of the tool. I clicked on exit button and next screen comes as a vertical line (Screen attached above).No option ...
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 ...
0
votes
1answer
108 views

Configuring Oracle 11gR2 RAC on Virtual Machine [closed]

I am working in a small company and interested to understand the RAC configuration. I have read many documents.. I found that we need three IPs for each node on a RAC. Public IP , Private IP , and ...
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>...
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, ...
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 ...
0
votes
1answer
2k views

Unable to connect to specific instance of Oracle RAC

I did several operations by connecting successfully to all 4 instances but suddenly during one of the jobs, it failed with a TNS error. I checked the connect from SQL and one of the nodes is giving an ...