RAC & Failsafe :: Services On Node Automatically Down After Few Minutes?

Jan 4, 2011

I 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].....

View 1 Replies


ADVERTISEMENT

RAC & Failsafe :: 5 Node Database - Services Management

Aug 17, 2012

We 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 Related

RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment

Jan 24, 2011

We 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 Related

RAC & 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).

View 3 Replies View Related

Application Express :: Procedure Automatically Called Again After 5 Minutes?

Jun 13, 2013

Apex 3.2. I have a page with a button. Once the user clicks the button a call is made to a procedure in a package.This procedure acesses a couple more procedures and functions, inorder to import data from one table to another. If the procedure takes more than 5 minutes to complete, the user receives an error message.This is actually the error message the user should get if he tries to do an import while another user’s import is running. Is it possible that if the called procedure doesn’t return in under 5 minutes the page is reloaded and the procedure called again resulting in the above error message. 

View 3 Replies View Related

Disable All The Services For Node D Temporarily?

Dec 28, 2010

There are 4 nodes in a RAC environment A,B,C,D..For instance i want to disable all the services for node D temporarily and hand over the Node D to the system admin guys and after the maintainance is done I want to restart the services again on node D..

View 1 Replies View Related

RAC & Failsafe :: Unable To Communicate With CRS Services

Sep 13, 2010

i have a problem with DATABASE i have 2 nodes where all application on Node2 are tunning properly

[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora....de1.gsd application ONLINE ONLINE node1
ora....de1.ons application ONLINE ONLINE node1
ora....de1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
[code]....

View 3 Replies View Related

Real Application Clusters :: Evenly Distribute Services In RAC On Node Crash

Jul 18, 2012

we have 4 node rac cluster. Node 4 crashed. All the services on node 4 moved to node1.how can I evenly distribute the services instead all services going to node1 ?

for example: i have 10 services on node 4. All went to node 1.i want 3 on node1, 3 on node2, 4 node3 .

View 4 Replies View Related

RAC & Failsafe :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Nov 21, 2012

RAC star crs failed

[root@tyan147 crsd]# /orahome/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

cssd.log

2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1100] GIPC gipcretConnectionRefused (29) gipcConnect(ipc-ipc://GPNPD_tyan147)
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnpm_connect: [at clsgpnpm.c:1101] Result: (48) CLSGPNP_COMM_ERR. Failed to connect to call url "ipc://GPNPD_tyan147"
2012-11-21 11:12:29.312: [ GPnP][3613030480]clsgpnp_getProfileEx: [at clsgpnp.c:546] Result: (13) CLSGPNP_NO_DAEMON. Can't get GPnP service profile from local GPnP daemon
2012-11-21 11:12:29.313: [ default][3613030480]Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).
2012-11-21 11:12:29.313: [ CSSD][3613030480]clsgpnp_getProfile failed, rc(13)

[code]....

View 2 Replies View Related

RAC & Failsafe :: Stopping Oracle 11g R2 Cluster Services In Windows 2008

Jan 22, 2013

I am doing the following steps for stopping the Oracle RAC Services on a 2 node.(OS is Windows 2008 Release 2).

srvctl stop database -d <database_name>

Node 1:
crsctl stop has

Node 2:
crsctl stop has

But i am getting error like Oracle HAS Service not stopped successfully. Finally what i did was stopped the OHAS Service from Windows Services.

which is the right procedure to have a clean stopping of RAC Services in 11g R2.

View 4 Replies View Related

RAC & Failsafe :: Add 3 More RAC Node

Jul 14, 2011

I 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 Related

RAC & Failsafe :: Changing VIP In RAC Node?

Nov 16, 2011

I need to change Virtual IP for one of my RAC node as it is conflicting with another server's IP.

View 1 Replies View Related

RAC & Failsafe :: Sap Backups From Node 207

Aug 11, 2011

I 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.

View 4 Replies View Related

RAC & Failsafe :: Master Node In Oracle 9i

Mar 11, 2013

How to find out which node is master node in oracle 9i RAC database.

View 7 Replies View Related

RAC & Failsafe :: How To Check Which One Is Master Node

Jun 29, 2011

In 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

View 5 Replies View Related

RAC & Failsafe :: 2 Node 11gR2 RAC Running On AIX 6.1

Oct 11, 2011

I 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 Related

RAC & Failsafe :: OCR Data Integrity Failed On Second Node?

Sep 28, 2011

What 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 View Related

RAC & Failsafe :: Enable Audit_trail On 2 Node RAC ENV On Oracle10g

Nov 23, 2011

I 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.

View 4 Replies View Related

RAC & Failsafe :: Can Server (node) Have More Than One Databases In RAC Environment

Feb 7, 2013

Can a server (node) have more than one databases in RAC environment?

View 2 Replies View Related

RAC & Failsafe :: Can Create Directory On Two Node Database

Feb 2, 2013

here 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 Related

RAC & Failsafe :: ASM Instance Not Started On Node 2 In Clusterware

Jan 11, 2011

i 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

View 3 Replies View Related

RAC & Failsafe :: Running Root.sh Script On Second Node

Jun 15, 2011

during 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 Related

RAC & Failsafe :: Check How Many Sessions Connected To Particular Node

May 30, 2013

I 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?

View 9 Replies View Related

RAC & Failsafe :: Single Node - Online / Offline

Dec 5, 2012

I 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...

View 2 Replies View Related

RAC & Failsafe :: ORA-01033 On One Node But Database Is Started

May 23, 2012

we 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.

View 4 Replies View Related

RAC & Failsafe :: Two Node - Configuration On Oracle Virtual Box

Mar 27, 2013

I 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 Related

RAC & Failsafe :: Listener - VIP Doesn't Migrate From One Node To Another

Apr 17, 2012

I 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.

View 5 Replies View Related

RAC & Failsafe :: Multiple Oracle Home Machine On Two Node ENV?

Mar 6, 2012

I 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.

View 1 Replies View Related

RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database

Oct 28, 2010

We 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.

View 7 Replies View Related

RAC & Failsafe :: Why CPU Utilization Is High (99%) On One Server In 2 Node At Every Time

May 28, 2013

why 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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved