Stack Overflow
Stack Overflow

Questions tagged [oracle-rac]

Oracle Real Application Clusters (RAC)

In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments. Oracle Corporation includes RAC with the Standard Edition of Oracle Database (aka Baby RAC), but makes it an extra-charge option for the Enterprise Edition

Reference :

http://en.wikipedia.org/wiki/Oracle_RAC

42 questions
14
votes
1 answer

Hibernate dialect for Oracle Database 18c?

Is there a Hibernate dialect for Oracle Database 18c? Or should I use the org.hibernate.dialect.Oracle12cDialect that ships with Hibernate? When using Hibernate 5.3 and Oracle 18c RAC is there anything special the application has to take care of?
Chris
  • 15,429
  • 19
  • 72
  • 74
7
votes
4 answers

Is there any way to get information about current session from gv$session in oracle?

Is there any way to uniquely identify current session in GV$SESSION view in Oracle? I've faced with the problem that the following query may return more than one row in case of Oracle RAC configuration: SELECT SID, SERIAL# FROM GV$SESSION WHERE…
Volodymyr Frolov
  • 1,256
  • 5
  • 16
  • 25
4
votes
0 answers

Issues for iscsi setup on Oracle RAC node

I followed this document to setup Oracle RAC with openfiler. I did setup Oracle RAC on rac1, rac2 node and openfiler configuration. After this, I followed the following steps from above document: Installed and configured iscsi services. Followed…
Sudarshan Dhokale
  • 206
  • 1
  • 7
3
votes
2 answers

Spring boot: Oracle RAC DB connection configuration

In Spring boot application, Need to configure Oracle RAC DB URL. Can someone explain how to configure the Oracle RAC URL in…
kishore josyula
  • 31
  • 1
  • 2
3
votes
2 answers

Oracle RAC VIP and SCAN IPs

I've read the Oracle RAC documentation a couple of times but SCAN and VIP are still confusing me. Can someone help me understand how this needs to be configured technically so that I can explain it my network admin. VIP in Oracle RAC, should each…
user501307
  • 59
  • 1
  • 2
  • 9
3
votes
1 answer

Oracle RAC - creating a directory

Having trouble getting an answer to this. On an Oracle RAC how do Oracle logical directories work? E.g. if I run this command CREATE DIRECTORY import_dir AS '/data/oracle/import'; does Oracle create the directory on just one node, or does it create…
TrojanName
  • 4,853
  • 5
  • 29
  • 41
2
votes
1 answer

Database Migration from Oracle RAC to AWS Amazon Aurora

I am working on a task to make a data migration plan to migrate Oracle RAC to AWS Amazon Aurora. The current in-house production database is based on a 10TB, 8 Node Oracle RAC Cluster with single node standby in DR site. The database has 2 main…
Cute Panda
  • 1,468
  • 1
  • 6
  • 11
2
votes
1 answer

Oracle Parallel Query behaviour with IDE tools as SQL Developer or Toad

For a while I've trying to get the time to write this question and explain the issue as best as I can, so forgive me in advance for the long text. My environment: Oracle Database 12.2 running on Red Hat 7 ( R.A.C 2 nodes ) - 16CPU and 64GB RAM per…
Roberto Hernandez
  • 8,231
  • 3
  • 14
  • 43
2
votes
1 answer

Oracle 12c Database V$session values

Why was I seeing more than the active no. of connections in V$SESSION view? I am connected through SQL Developer and EM Express only but in V$SESSION its showing four connections with different SIDs. But after some more time it came to two…
Hamid Ali
  • 43
  • 1
  • 5
1
vote
4 answers

How do we identify a session in Oracle GV$SESSION view?

I am trying to understand what is the minimal set of parameters to uniquely identify a session in GV$SESSION. I have seen a few online examples there AUDSID, SID, and INST_ID are used, I am trying to understand why?
confucius_007
  • 186
  • 1
  • 15
1
vote
1 answer

How to connect to Oracle-RAC using SCAN in python?

I use cx_Oracle module to connect to standalone Oracle server as follows import cx_Oracle CONN_INFO = { 'host': 'xxx.xx.xxx.x', 'port': 12345, 'user': 'user_name', 'psw': 'your_password', 'service': 'abc.xyz.com', } CONN_STR =…
TheBeginner
  • 405
  • 5
  • 23
1
vote
1 answer

Oracle 12C RAC on Solaris 11 - Random Connection Timeout

We are having issue whereby there is random connection timeout from our java application connecting to Oracle 12c R1 RAC. Both are on Solaris 11. Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the…
Annon
  • 85
  • 1
  • 1
  • 8
1
vote
0 answers

tomcat JDBC connection pool minIdle size is different in database

My application is using tomcat jdbc connection pool through hibernate. Database is Oracle RAC. For connection pool, I have MaxActive=75 MinIdle=5,MaxIdle=35, InitialSize=5,testWhileIdle=false,testOnReturn=false While I start my application and look…
sapa
  • 23
  • 3
1
vote
1 answer

Will Oracle ASM add data file to a tablespace automatically?

If a tablespace has 1 data file(limit is 32gb), and the datafile has extended to its maximum, Will ASM automatically handle adding of the datafile or should I manually use the below statement to add a datafile to the tablespace. alter tablespace…
Varun Rao
  • 781
  • 1
  • 10
  • 31
1
vote
1 answer

Read Oracle Cluster name from Oracle RAC using SQL query

I'd like to know what is my RAC cluster name using SQL query. I've found out that it can be retrieved using Oracle tool cemutlo -n or just ocrdump (see http://www.br8dba.com/tag/how-to-display-oracle-cluster-name/). However, it's not possible in…
Greg Witczak
  • 1,634
  • 4
  • 27
  • 56
1
2 3