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.
99
questions
0
votes
0
answers
21
views
Some easy way to list OS disks used by ASM without use asmcmd or sqlplus?
For example: I can list the disks with kfod:
[root@rac1 bin]# ./kfod op=disks status=true disks=all dscvgroup=true
--------------------------------------------------------------------------------
...
- 508
0
votes
2
answers
281
views
How to connect to Oracle RAC from HOST
For a college project, I have to set up a RAC Instance and an application, I already managed to configure my RAC lab by using virtual machines by using this video guide, now I just need to program an ...
- 103
0
votes
1
answer
102
views
Oracle 12c - Logon Trigger According To Machine Information
I want to create a logon trigger. Trigger will do the following:
It will block access to the database based on certain users and
certain machine information. Then it will give an information message
...
- 29
0
votes
0
answers
94
views
Oracle: ASM password file on RAC DB to create standby, how make it work?
In 19c I have a RAC DB with its pwd file located on +DATA/DBUNAME/orapwfilealias pointing to +DATA/DBUNAME/PASSWORD/orapwdbuname.356.1186610343 (as a result of command 'orapwd file=+DATA/...').
I've ...
- 31
0
votes
0
answers
367
views
Problem whit instalatión of GridInsfrastructure DNS/NIS name service
When trying to install the Grid Infrastructure 12, I have the following problem:
This is the description of error:
DNS/NIS name service - This test verifies that the Name Service lookups for the ...
- 13
0
votes
1
answer
570
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/...
- 1
0
votes
1
answer
83
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? ...
- 54
0
votes
1
answer
47
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 ...
- 23
0
votes
1
answer
356
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
0
answers
63
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
1
answer
615
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....
- 54
0
votes
1
answer
254
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 ...
- 125
0
votes
0
answers
1k
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 ...
- 508
0
votes
1
answer
746
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 = (...
- 508
0
votes
0
answers
2k
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 ...
- 508
0
votes
1
answer
741
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 ...
- 508
-1
votes
1
answer
322
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: ...
- 1
0
votes
1
answer
221
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
0
answers
244
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
1
answer
48
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 ...
- 659
1
vote
1
answer
715
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 ...
- 37
0
votes
1
answer
8k
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
[...
- 37
0
votes
1
answer
10k
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: ...
- 37
3
votes
2
answers
22k
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 ...
- 273
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 ...
- 11
0
votes
1
answer
283
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: ...
user168186
0
votes
1
answer
44
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
0
answers
50
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). ...
- 23
0
votes
0
answers
155
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 ...
- 37
1
vote
1
answer
825
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 ...
- 11
0
votes
1
answer
279
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 ...
- 1
1
vote
1
answer
28
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 ...
- 165
0
votes
1
answer
946
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 ...
- 185
0
votes
1
answer
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 ...
- 123
0
votes
1
answer
111
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 ...
- 69
0
votes
1
answer
4k
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
0
answers
672
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, ...
- 13
1
vote
1
answer
2k
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 ...
- 185
1
vote
1
answer
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,814
0
votes
2
answers
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 ...
- 41
0
votes
1
answer
684
views
ORACLE RAC Installation : Why there is a need to create a symbolic links for asm disk
By reading the note 1538626.1 from MOS Meta Link, I know that we should use udev to change the ownership of some device for the further installation of oracle real application cluster:
I met a lot of ...
- 75
0
votes
1
answer
245
views
Application Continuity on Single instance
I recently was going through Application Continuity in Oracle 12c. As I read through the Oracle link which I understand when used in RAC, will be able to replay the transaction (DDL/DML) in the event ...
- 1,814
0
votes
1
answer
78
views
AC with Oracle 12c
I'm thinking of configuring Application Continuity for my 2 node RAC (12c) database where my application is running on Weblogic server. Before I proceed with the setup of AC, I need to clarify/confirm ...
- 1,814
0
votes
0
answers
435
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: ...
- 1,814
0
votes
1
answer
63
views
Failover query in RAC
Say I have the following tnsnames.ora in my two node RAC database,
DIVTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DIVTEST-scan.DIVCORP.com)(PORT = 1721))
(CONNECT_DATA =
(SERVER = ...
- 1,814
3
votes
1
answer
589
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 ...
- 204
0
votes
1
answer
194
views
Does EnterpriseDB support Oracle RAC to Postgres replication?
Does EnterpriseDB support Oracle RAC to Postgres replication?
0
votes
1
answer
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,529
3
votes
1
answer
417
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 ...
- 261
0
votes
1
answer
2k
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 ...
- 1,814