RAC & Failsafe :: OCR Data Integrity Failed On Second Node?
Sep 28, 2011What could be the reason for Such Errors.?OCR Integrity was Successful on one node and on the cloned node it was failed.
View 8 Replies
ADVERTISEMENT
RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment
Jan 24, 2011We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?
View 3 Replies View RelatedRAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?
Sep 13, 2012 I would like get more details about single node RAC.. What is single Node RAC?..
1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...
is there any advantage using single node rac(other than online upgrade to full RAC).
RAC & Failsafe :: Oracle CRS Failure / Rebooting For Cluster Integrity
Sep 7, 2013I got following error on Oracle 10.2.0.4.0 RAC on solaris 10
Oracle clsomon failed with fatal status 12.
Oracle CRS failure. Rebooting for cluster integrity.
I think this problem in 11g but I am using 10g.
RAC & Failsafe :: Add 3 More RAC Node
Jul 14, 2011I have 2 node 11gR1 running on Unix, I want to add 3 more RAC node to it. What are all the steps involved and should I first add 3rd node and then the 4th node or I should add both at the same time? is there any difference between these two methods?
View 1 Replies View RelatedASM Diskgroup Creation Failed Using Two Node
Mar 19, 2012A am new in RAC configuration.I configuring RAC with ASM diskgroup with the external redundency. So now i am facing problem to mount the ASM diskgroup. I am giving the the RAC configuration description below.
1. using two node rac1 and rac2
2. asm disk configuration 3 drive
/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
on both node
3. and i am using vmware to configure the both node asmdisk group
after configuring the os level and oracle clustring , i run dbca to configure asm disk group..so in the create disk screen i have found my previous create 3 disks
/dev/raw/raw1
/dev/raw/raw2
/dev/raw/raw3
so first two disks
/dev/raw/raw1
/dev/raw/raw2
i named it "dg1" then press ok , when i pressed ok a warring is appear that is "could not mount the diskgroup on remote node on rac2 using the connection service rac2:1521:+ASM2. Ensure that the listener is running on this node and the asm instance is registred to the listener. Receive the following error:
ORA-15032 : not all alterations performed
ORA-15063 : ASM discovered insufficient number of disk for diskgroup "DG1"
as the same way i create another diskgroup "fg" for flash recovery area using disk /dev/raw/raw3
so after creating the two diskgroup i saw the two diskgroup is appere in the "diskgroup appere screen" an saw that only one diskgroup is mounted but not second node i.e. rac2 diskgroup is not mounted . What should i do no .
RAC & Failsafe :: Changing VIP In RAC Node?
Nov 16, 2011I need to change Virtual IP for one of my RAC node as it is conflicting with another server's IP.
View 1 Replies View RelatedRAC & Failsafe :: Sap Backups From Node 207
Aug 11, 2011I am having an issue when trying to run a backup from node 207...Initially When trying to run the backup I got this error.
scrbdefrmr207:orarer 54> brbackup -u / -c force -t online -m all -p initRER_online.sap
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begnlswy.anf 2011-08-11 21.29.08
BR0484I BRBACKUP log file: /oracle/RER/sapbackup/begnlswy.anf
BR0477I Oracle pfile /oracle/RER/102_64/dbs/initRER001.ora created from spfile /oracle/RER/102_64/dbs/spfileRER001.ora
BR0280I BRBACKUP time stamp: 2011-08-11 21.29.13
BR1351I Configuration of database services:
RER001 PREF: RER001 AVAIL:
RER002 PREF: RER002 AVAIL:
DVEBMGS50_scrbdefrmr207 PREF: RER001 AVAIL: RER002
DVEBMGS50_scrbdefrmr208 PREF: RER002 AVAIL: RER001
[code]....
I have many other rac servers and sids setup this way and they all work,,I can login to sqlplus and do any changes .. no issues going into sqlplus in node 207 and node 208..I have checked the directory i.e mesg and teh files are there ..
scrbdefrmr207:orarer 56> pwd
/oracle/RER/102_64/sqlplus/mesg
scrbdefrmr207:orarer 57> ls
cpyus.msb cpyus.msg sp1us.msb sp1us.msg sp2us.msb sp2us.msg
I think the message is decieving as it complains about oracle home and sp1<lang>.msb not found ,, when i tis there.I have also checked my env variables .. they all there i.e
scrbdefrmr207:orarer 58> env |grep ORA
dbms_type=ORA
ORACLE_SID=RER001
ORACLE_HOME=/oracle/RER/102_64
ORACLE_BASE=/oracle
scrbdefrmr207:orarer 59> env | grep LD_
LD_LIBRARY_PATH=/usr/sap/RER/SYS/exe/run:/oracle/RER/102_64/lib
I an run archives log backups perfectly.. So its only when its trying to connect into the db.
RAC & Failsafe :: Master Node In Oracle 9i
Mar 11, 2013How to find out which node is master node in oracle 9i RAC database.
View 7 Replies View RelatedRAC & Failsafe :: How To Check Which One Is Master Node
Jun 29, 2011In case of RAC the node which is up first is master node.
In case of 4 nodes RAC master node itself is down then how to identify which node is master node out of serving nodes
RAC & Failsafe :: 2 Node 11gR2 RAC Running On AIX 6.1
Oct 11, 2011I have 2 node 11gR2 RAC running on AIX 6.1, after I shutdown the database and restart crs using crsctl start crs, ASM instance comes back up but not the database and I had to start the database using srvctl, isn't that the database should come up when I start the crs?
View 4 Replies View RelatedInstall 11gR2 RAC On CentOS 5.5 / Root.sh Failed On First Node
Nov 1, 2010I am trying to install ORACLE 11gR2 RAC on CentOS 5.5 .
when run root.sh on first node. I am gettign 2/3 failed command lines but the end went successful
=======================================================================
ohasd is starting
ADVM/ACFS is not supported on centos-release-5-5.el5.centos
...
add nodeapps -n perflabhp03 -A perflabhp03-vip/255.255.254.0/eth0 on node=perflabhp03 ... failed
...
PRCR-1001 : Resource ora.net1.network does not exist
add scan=perflab-cluster-scan ... failed,
Configure Oracle Grid Infrastructure for a Cluster ... failed
...
'UpdateNodeList' was successful.
=========================================================================
Because of this output, when see the ./crsctl stat res -t , it showing LISTENER offline for perflahp03, and I can not see any status line for "perflabhp03-vip " and "Scan-listener".
Do I need to reinstall the entire cluster setup because of VIP issue?
RAC & Failsafe :: Enable Audit_trail On 2 Node RAC ENV On Oracle10g
Nov 23, 2011I have a production database with 2 node Physical RAC ENV on two separate machines , and we are going to enable audit trail parameter to DB values to capture all failed login attempts on a database.
we have done this on our testing ENV but dont know the procedure to deploy this steps on 2 node RAC ENV . I have done the below steps on our standalone testing ENV
1.Log in as SYS and connect with the SYSDBA privilege.
oUser Name: SYS
oPassword: Enter your password.
oConnect As: SYSDBA
2.To enable audit on DB use below command
SQL>alter system set audit_trail=DB scope=SPFILE;
3.Then restart the database.
4.After successful startup use the below command to capture log
SQL> audit create session whenever not successful;
steps to enable audit_trail to capture failed login attempts on two node RAC ENV.
RAC & Failsafe :: Can Server (node) Have More Than One Databases In RAC Environment
Feb 7, 2013Can a server (node) have more than one databases in RAC environment?
View 2 Replies View RelatedRAC & Failsafe :: Can Create Directory On Two Node Database
Feb 2, 2013here we have san server and rac database two node database.i want to know how can i create directory on rac database. i know how to create directory on single database but i do not know how can i create directory on rac database.
View 3 Replies View RelatedRAC & Failsafe :: ASM Instance Not Started On Node 2 In Clusterware
Jan 11, 2011i am configuring asm on clusterware when i create instance on node1 and node 2 a message screen appear " Cant start asm instance on node 2)When i start asm instance manually on node 2 i found the below error in alert log file.
ORA-27508 IPC error sending a message
ORA-27300 OS system dependent operation:send msg failed with status: 101
ORA-27301 OS failure message: Network is unreachable
ORA-27302 failure occurred at: sskgxpsnd1
RAC & Failsafe :: Running Root.sh Script On Second Node
Jun 15, 2011during installtion of Oracle RAC 11g r1 on Linux using VMware server, all the pre cluster installation was successful, and root.sh on node 1 was successful too, but whenever I run the root.sh script on the second node I get error message "Failure at final check of oracle CRS stack. 10"
View 5 Replies View RelatedRAC & Failsafe :: Services On Node Automatically Down After Few Minutes?
Jan 4, 2011I have installed Oracle 10g RAC crs and asm on CentOS release 5.4. When I am rebooting the nodes and starting crs manually All the services on both nodes starting successfully.
---------------------------------------------------------
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
[code].....
But After a Few time/min few services goes down automatically and its show something like
---------------------------------------------------------
[root@rac1 ~]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE UNKNOWN rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
[code].....
RAC & Failsafe :: Check How Many Sessions Connected To Particular Node
May 30, 2013I have few doubts in rac environment
1.In 2 node rac while adding datafile to tablespace if you forget to mention '+'then what will happen whether it is going to be create or it throws an error if it creates where exactly located and other node users how to work on that tablespace .what all steps to perform that datafile is useful for all node users.
2. In Rac environment how to check how many sessions connected to particular node.
3)In Rac any node is evicted due to network failure then after we rebuild the network .Is there any steps to do manually to access the failure node after rebuilding the network or it will automatically available in cluster group which service is perform this activity.
4.While configuring cluster ware you choose voting disk and ocr disk location and which redundancy you will choose suppose if you go for normal redundancy how many disks you can select for each file either one or two?
RAC & Failsafe :: Single Node - Online / Offline
Dec 5, 2012I have implemented Rac One node with two machine(dbtest01,dbtest02) in 11.2.0.3 Redhat 5.3 one for online another one for offline. i have created TAF also.
dbtest01 is online and create one query
DECLARE
i number(36):=1;
begin
while(i<10000000)
loop
dbms_output.put_line(i);
i:=i+1;
end loop;
end;
i executed above query for test and i made relocate database using srvctl utility to dbtest02 machine.
session is relocated successfully with new session id...above query getting stop in 25000 itself. i want to make it continue that process..also i tried to find Omotion utility in all the path.. couldn't find it... where will it be.. i want to relocate all the session without losing work.
from application i am getting disconnect after relocation.. application server need to restart to get work again...
RAC & Failsafe :: 5 Node Database - Services Management
Aug 17, 2012We have 5 node RAC database. I want to user 2 node for OLTP and 3 for DSS system. Guide now to create service for the requirement.
View 10 Replies View RelatedRAC & Failsafe :: ORA-01033 On One Node But Database Is Started
May 23, 2012we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.
We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.
RAC & Failsafe :: Two Node - Configuration On Oracle Virtual Box
Mar 27, 2013I am configuring two node RAC on oracle virtual box. Did its mandatory to configure DNS on both nodes before Rac installation? Whats the purpose of DNS in RAC. And if its mandatory did i have to configure DNS on each node separately?
View 1 Replies View RelatedRAC & Failsafe :: Listener - VIP Doesn't Migrate From One Node To Another
Apr 17, 2012I have the following problem on a 10.2.0.4 Oracle on AIX 1.6...
I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see the change, and just resolve to the local ip.
The same does not apply in the reverse case, when it drops the node N 1, the listener attends to the fallen VIP node and migrated.The configuration is correct and identical in both nodes, according to the documentation, but I can not find a reasonable answer.
IP node # 1.
scm1or01 192.68.60.11
scm1or01-VIP 192.68.60.13
IP node # 2
scm1or02 192.168.60.12
scm1or01-VIP 192.168.60.14
Below I write as I detect the problem: when scm1or02 is down:
scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46
Copyright © 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
[code]...
Also the listener.ora in scm1or01 starts how LISTENER, but the crsstat says:
scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin>crsstat listener_scm1oro1 ONLINE
I do not understand the reason, I've rebuilt the configuration of the listener, and netmgr netca tools, but the problem persists.
Data Guard :: How To Find Apply Node In RAC Two Node Standby DB
Aug 16, 2013I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?
I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?
RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?
Mar 6, 2012I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.
But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.
RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database
Oct 28, 2010We have to configure Dataguard for our 24x7 critical banking 2 Node RAC database(10.2.0.4). Before proceeding with the configuration we have to make sure what steps we should follow to have minimum or no downtime.
1) Document covering DG setup in RAC environment.
2) We have to perform switchover as well so need its steps too. Either the normal switchover steps would be used or have to stop/start rac services as well.
RAC & Failsafe :: Why CPU Utilization Is High (99%) On One Server In 2 Node At Every Time
May 28, 2013why CPU utilization is high(99%) on one server in 2 node RAC at every time. On the other server it is very low.
View 9 Replies View RelatedRAC & Failsafe :: Root.sh Failed On 11gr2?
Mar 4, 2011I am installing 11gr2 11.2.0.2 grid infrastructure software. while running root.sh on node1 it got failed.
Start of resource "ora.crsd" failed
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
CRS-5017: The resource action "ora.crsd start" encountered the following error:
Start action for daemon aborted
CRS-2674: Start of 'ora.crsd' on 'rac1' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'rac1'
CRS-2681: Clean of 'ora.crsd' on 'rac1' succeeded
CRS-4000: Command Start failed, or completed with errors.
Clusterware exclusive mode start of Clusterware Ready Services failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6475.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed
RAC/ASM Clusterware Installation :: Grid Install And Error (First Node Configuration Failed)?
Jan 26, 2013I'm doing some testes installing grid 11.2.0.3 32bits software on a OEL6 32bits (virtual box environment). The problem appeared where i ran root.sh script on node 1. The following error appeared to me:
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
[code]..