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.

33 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
374 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 ...
2
votes
0answers
327 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
0answers
551 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 ...
0
votes
0answers
27 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
31 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 ...
0
votes
1answer
88 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). ...
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
75 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 ...
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
409 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
0answers
732 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
88 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 ...
0
votes
0answers
169 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*...
0
votes
1answer
42 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
492 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
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
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
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
138 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
647 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
216 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
0answers
404 views

Issue with RAC connection using service

I have a two node RAC database. I have created a server side service as below: srvctl config service -d test -s testsrv Service name: test Server pool: Cardinality: 2 Disconnect: false Service role: ...
0
votes
1answer
1k 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 (...
0
votes
0answers
214 views

Changing database parameters after removing a node from RAC oracle

Oracle 11.2.0.3 on SunOS 5.1 i have a client who is running a 2 node RAC environment but has shutdown the instance on one of the nodes. I was wondering whether after doing this they should change the ...
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
0answers
6k views

Oracle Grid installation failing on all nodes other than node where installation is started from

[Please forgive the untidy ctrl+v here as i am not able to preserve the formatting when i paste it here ) Folks, Any clues what I am doing wrong here ? Trying to install a 2-node RAC and as a ...
0
votes
0answers
108 views

10.2.0.5 RAC instance running on Linux-64 recieved KEWRRFC: Remote Flush slave Failed, return code: 2

Last Friday one of two instances in our 10.2.0.5 RAC cluster was non-responsive after logging the following messages. We ended up rebooting the node and it came up successfully. While I will likely ...
0
votes
0answers
87 views

How to forwarding connection between 2 Oracle Database?

I have 2 Databases on independent 2 Linux server. I'm using Oracle 10G and 11G. I have this stage: client -> connect to Server A -> check Database A (check specific tablespace or database A is down)...
0
votes
0answers
124 views

SYS_CONTEXT INSTANCE changing on failover?

When using Oracle RAC with either Fast Connection Failover or TAF (Transparent Application Failover), for a given database connection, is SYS_CONTEXT('USERENV', 'INSTANCE') going to change when there'...
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
276 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
votes
1answer
1k views

Slowness after migration to RAC 11gr2

we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...