Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

  7. current community

    your communities

    more stack exchange communities

    company blog
Database Administrators

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.

73 questions
info Newest Frequent Votes Active Unanswered
0
votes
0answers
40 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
33 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
77 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
75 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
vote
1answer
24 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
214 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 ...
0
votes
1answer
589 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 ...
0
votes
1answer
55 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
1k 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
265 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
592 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
593 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
520 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
263 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 ...
0
votes
1answer
150 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 ...
0
votes
1answer
57 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 ...
0
votes
0answers
223 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
51 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 = ...
2
votes
1answer
421 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 ...
0
votes
1answer
124 views

Does EnterpriseDB support Oracle RAC to Postgres replication?

Does EnterpriseDB support Oracle RAC to Postgres replication?
0
votes
1answer
757 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 (...
2
votes
1answer
164 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
0answers
157 views

Error PROT-23, ocr manual backup

Everyday I have a manual backup of ocr in a rac instance 11.2 and It works fine, but this night the backup failed with PROT-23 error. Now I try to execute it and allways fails. I execute with root ...
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
147 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 ...
0
votes
0answers
138 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
3k 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 ...
0
votes
1answer
55 views

Oracle RAC 11g creation

I would like to play with RAC configuration. Using virtual area (VMware or VirtualBox): RAC1 (Windows 2003 Server) RAC2 (Windows 2003 Server) Shared storage (Openfiler) DNS server (for using SCAN ...
0
votes
1answer
681 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 ...
1
vote
1answer
7k 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
3k 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 ...
0
votes
0answers
987 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 ...
1
vote
1answer
167 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 ...
3
votes
2answers
890 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....
0
votes
1answer
1k 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 ...
0
votes
1answer
635 views

Could we delete old database and grid version?

We upgraded rac system and I want to ask, could I delete old grid and database version? [oracle@orcl1 app]$ cd 11.2.0.3/ 12.1.0.2/ Middleware/ oraInventory/ 11.2.0.4/ grid/ ...
0
votes
0answers
4k 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 ...
1
vote
2answers
465 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
803 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

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

Oracle 11gR2 RAC unable to connect to SCAN address [closed]

I'm having a problem with my RAC environment. I am using RedHat 6, Oracle 11.2.0.4 SE. Have a 2 node RAC setup using ASM. When connecting using SQL Developer, i can connect to my service (dev1.xxxx-...
2
votes
1answer
10k 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
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
1answer
3k 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 ...
0
votes
1answer
3k 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
131 views

Oracle 10 RAC VIP returns non-VIP address for client

I am not a DB or even Oracle expert, but I wanted to understand when and why Oracle returns a different non-VIP address to the client, assuming this is correct behaviour? listener.ora LISTENER_DB-A =...
2
votes
0answers
273 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. ...
0
votes
1answer
98 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
1answer
351 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 ...
0
votes
1answer
1k views

RAC, data guard, physical stand by and impdp

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also) We receive the client's data he exports with expdp. We have imported his dump in the primary ...

1 2