Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [oracle-rac]

22 questions
6
votes
5 answers

How do I know to which node of my Oracle RAC I am connected?

Is there an easy way to determine to which RAC node of an Oracle 11g R2 system I am connected? I am trying to perform some failover tests and I want to make sure my application is correctly connected to one node and upon the shutdown of this node…
Stephan
  • 417
  • 1
  • 5
  • 13
3
votes
1 answer

What better way to configure memory for an Oracle RAC 11g R2?

I'm setting up a new environment in Oracle RAC 11g but I'm wondering how best to use the memory feature. Today I have two servers with 128GB of RAM 1 core CPU with 16 cores. I deployed 64GB of SSD to Swap, as much as possible to be able to install…
Bruno Farias
  • 31
  • 2
3
votes
0 answers

Mirroring on external SCSI and iSCSI disks inside same volume group

On IBM P5 505 (maint level 5300-07) servers there is a concurently accessed external storage, which is connected using external Ultra320 SCSI port (DAS). External storage is detected as hdisk2 which belongs to volume group dbvg. Volume group dbvg…
baltasvejas
  • 131
  • 2
3
votes
1 answer

Oracle SOA repository migration

Does anybody know whether it is possible to migrate Oracle SOA repository from a simple Oracle database to Oracle RAC?
v_ildar
  • 33
  • 2
2
votes
1 answer

DBMS_ALERT slow to trigger on RAC

I asked a question earlier about whether DBMS_ALERT works on the RAC. The answer was yes, and I have set up a VMWare test environment and confirmed it. However, there seems to be a long delay between when the SIGNAL() call is made and the WAITONE()…
ftkalcevic
  • 21
  • 1
2
votes
2 answers

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script for database backup works fine, and is started from…
Predrag Simović
  • 21
  • 1
1
vote
1 answer

Is it possible to have one group or account authenticate locally, bypassing LDAP auth?

We have one RAC cluster of machines where the local UID:GID of a couple users (oracle and grid) do not match the UID:GID of those same users in LDAP. Ultimately we ought to change the UID and GID of these two users on every system in the cluster…
mr.zog
  • 923
  • 3
  • 20
  • 39
1
vote
4 answers

Infiniband for Oracle 11g RAC private interconnect?

We currently have a 2-node Oracle 11g RAC using 1GigE as the private interconnect. At peak update time, the traffic between nodes reaches 35 MByte/second, so we are still doing good in terms of bandwidth capacity. We are considering adding a third…
user17709
1
vote
2 answers

Setting ORACLE_HOME in Oracle RAC 11g

I've got two (2) nodes in an Oracle RAC 11g in Windows Server 2008. Oracle software is installed in C:\app. I realized that the ORACLE_HOME path has not been set.. In System Properties-> Advanced -> Environment Variables, I see that ORACLE_HOME is…
Delmonte
  • 301
  • 1
  • 7
  • 19
1
vote
1 answer

Oracle RAC: Configure instance to depend on VIP

In previous version of Oracle RAC with Oracle clusterware, before 10.0.1 I believe, an instance was dependent on a VIP resource. Once a vip was failed or relocated, the Instance would be stopped. In later versiond, this coupling was broken, as I…
katriel
  • 4,477
  • 23
  • 20
1
vote
4 answers

Red Hat - Oracle RAC and McAfee

Does McAfee virus support Redhat Linux running in an Oracle RAC Cluster? IF so, what is the configuration, best practice?
Rob
  • 11
  • 2
0
votes
1 answer

Does PostGreSQL EDB provide load balancing among nodes, (like Oracle RAC)?

I’m looking for some information about whether PostGreSQL EDB can provide balance between nodes similarly to the way Oracle RAC does this. AFAIK, it does not. The closest question / answer combination I could find to this subject follows:…
Nathan Basanese
  • 341
  • 2
  • 5
  • 19
0
votes
2 answers

Error while using oraenv

I'm using Oracle RAC in RH6, and when i try to use the 'oraenv' utility to set the variables with the user oracle, i get an error: [oracle@vhor12 ~]$ . oraenv /bin/.: Permission denied. Using it in the same way with the root user works normally.…
chesterman
  • 65
  • 1
  • 3
  • 12
0
votes
2 answers

INS-40719 error when Install Oracle RAC?

I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on this setup I add this line to…
Data-Base
  • 185
  • 1
  • 13
0
votes
1 answer

oracle RAC server addition at DR site after DR occurs

DB: Oracle Server: Physical OS: Linux 5.5 The production site contains 3 server nodes and will be clustered using Oracle RAC, database replication will be done with the help of Oracle Data guard. As a minimum, the DR site will have a single…
Bindas
  • 1
1
2