RAC & Failsafe :: Rshd And Rexecd?

Jan 28, 2013

Do we need to start rsh and rexec services in oracle 11gR2 RAC database servers? Is it required to setup and run RAC database?

View 1 Replies


ADVERTISEMENT

RAC & Failsafe :: CRS Is Not Starting?

Oct 13, 2011

I am getting problem while starting the CRS. Below is the necessary details:

1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2

2) I have 3 diskgroup named DATA, DATA1, DATA2

3) OCR and voting disks are stored on ASM diskgroup

On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:

ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1

On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:

ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2

note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.

Now I am trying to repair the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.

ocrconfig -repair -replace +DAT2 -replacement +DATA1

but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.

View 4 Replies View Related

RAC & Failsafe :: DB Migration To New SAN?

Apr 30, 2012

We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.

But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.

So is there will be any way to rename this disk path for disk group..

View 1 Replies View Related

RAC & Failsafe :: How To Implement Non-RAC

Jan 12, 2013

We have an Implementation of Non-RAC (Single Instance with Existing ASM-RAC as storage) and below is the Details,

The client have a Real Application Cluster configuration on their AIX Server from there Data Center and they want to implement a Single instance Database that will used ASM as Storage and the storage or Disk that they want to use is the same Disk or Mirror copy of the Disk from their RAC Database.

Scenario:
-The AIX Server that they have is a one-way Hardware Mirroring (PPRC) only and it is not designed to run a 24/7 activity.
-DATAGUARD is not an option.

View 5 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 :: Software Version In RAC

Jul 14, 2013

I heard, in RAC environment both clusterware software and oracle software should have similar version.how to find the version of both softwares ?

View 2 Replies View Related

RAC & Failsafe :: Dynamic Remastering In 11g R2

Jan 2, 2012

finding out which instance is the resource master of a object.Also select * from V$GCSPFMASTER_INFO

returns zero rows.

Does this mean dynamic remastering is disabled???if so which instance will own a object?

View 1 Replies View Related

RAC & Failsafe :: Difference Between RAC And Non-RAC Database

Sep 13, 2012

Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?

View 4 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 :: Cluster In Oracle

Apr 23, 2013

Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?

View 6 Replies View Related

RAC & Failsafe :: RPM For Oracle Installation

Nov 28, 2010

i need to make RAC database setup ,so where can i get the operating system Rpm like bleow

compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386

send me link for the above require rpm for linux AS4.

View 1 Replies View Related

RAC & Failsafe :: Can Just Install CRS Only If OS Crashed

Aug 3, 2012

we have RAC database on two node here on windows server 2008 unfortunately today morning my one my one node os crash its on windows server 2008 my other node its working ok so my database is accessible so i just want to ask if i install again this os on node -1 system so i just want to install only again crs only.because my database is accessible through my other node-2

View 6 Replies View Related

RAC & Failsafe :: Adding New ASM Disk

Dec 23, 2012

I have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.

Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?

View 1 Replies View Related

RAC & Failsafe :: ASM Configuration For Servers?

Jul 8, 2011

I get following error when i'm configuring ASM.

I'm using Enterprise Linux and Oracle 11.1.0.6.0

[U]Note:[/U]
[root@RAC1 ~]# rpm -qa|grep asm
oracleasm-2.6.9-78.0.0.0.1.EL-2.0.3-2
oracleasm-support-2.0.3-2

only these two packages in my server. should i have to install oracleasmlib??

[root@RAC1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [ OK ]
[B]Loading module "oracleasm": Unable to load module "oracleasm"
[FAILED][/B]

I don't have this package in my installation cd, when i searched in the web i could not find

View 2 Replies View Related

RAC & Failsafe :: SCAN IP For Oracle 11g R2?

Sep 1, 2011

I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.

View 6 Replies View Related

RAC & Failsafe :: Upgrade 10g To 11gR2 RAC On AIX?

Aug 26, 2011

Is there any document available for 10g to 11gR2 RAC upgrade on AIX?

View 1 Replies View Related

RAC & Failsafe :: Error While Configuring Css?

Jul 23, 2011

i got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.

operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE

when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information

solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem

View 1 Replies View Related

RAC & Failsafe :: Upgrade From 10g To 11gr2?

Jul 20, 2013

up gradation steps from 10g RAC to 11gr2 RAC.

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 :: FAILOVER In ORACLE 10g

Dec 20, 2012

My application uses below jdbc url for database connectivity. Today one of the db node was down for one hour and FAIL OVER did not happen.

<connection-url>
jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON )(ADDRESS=(PROTOCOL=TCP)(HOST=viphost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=viphost2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serv ice_name)))
</connection-url>

View 5 Replies View Related

RAC & Failsafe :: LUNS Allocation To RAC

Dec 18, 2011

We are planning the RAC installations. We are allocate 3TB on HP SAN Storage to be used to setup rac environment with 2 nodes.

Question.

1. Do we accept one 3 TB from SAN engineers or ( Which RAID)
2. Multiple Luns totality to 3 TB.
3. Remember this is 11g R1 OCR and VOTING DISK cannot be managed by ASM.

View 3 Replies View Related

RAC & Failsafe :: Unable To Configure SSH For RAC

Dec 30, 2010

I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.

Node 1
--------
[oracle@node1 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node1 ~]$ date
Thu Dec 30 05:14:10 IST 2010
[oracle@node1 ~]$
------------
Node2
----------
[oracle@node2 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node2 ~]$ date
Thu Dec 30 05:15:32 IST 2010
[oracle@node2 ~]$
---------
OS
----------
[oracle@node2 .ssh]$ cat /etc/redhat-release
CentOS release 5.4 (Final)
[oracle@node2 .ssh]$ date
---------
Host for both node
--------
[oracle@node2 .ssh]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# Public
10.1.1.10 node1
10.1.1.11 node2
#Private
20.1.1.10 node1-priv
20.1.1.11 node2-priv
#Virtual
10.1.1.21 node1-vip
10.1.1.22 node2-vip
------------------------
I am using the command to configure SSH provide in the link

[URL].......

View 7 Replies View Related

RAC & Failsafe :: RMAN Duplicate DB For RAC

Jan 26, 2004

We have a script which uses the duplicate functionality of RMAN. It was designed for a standalone database. Now I need to make it work for a cluster DB (RAC installation).

1. Does RMAN support this?
2. Do I need to make separate executions for both the nodes of the cluster?

We are currently blocked because we have no way of getting our system running without this!
******************************8
First attempt:

oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW1 -r RCAT -n sys -p sys ->

3808 11:52:49 ----- Starting Cloning Procedure -----
3808 11:52:50 INFO: Client host 'sf25' says, it is 'sf25'.
3808 11:52:51 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
...
3808 RMAN: GROUP 8 ( '/export/home/oracle/dev/ADVFRW/ADVFRW.redo181' ) SIZE 134217728 REUSE
3808 RMAN: DATAFILE
3808 RMAN: '/export/home/oracle/dev/ADVFRW/ADVFRW.system'
3808 RMAN: CHARACTER SET WE8ISO8859P1
[code]....

Second attempt:

oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW -r RCAT -n sys -p sys -c sf25 -s sf04 -g Srv_scl04-backup_DB_grp -l american_america.WE8ISO8859P1

5548 12:27:05 ----- Starting Cloning Procedure -----
5548 12:27:06 INFO: Client host 'sf25' says, it is 'sf25'.
5548 12:27:07 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
5548 12:27:07 Original DB is 'ADVFRW'
5548 12:27:08 INFO: BGROUP=Srv
[code].......

Now we have contrary error messages. Target DB name ADVFRW does not work, because on the target nodes there are configuration files for the node specific DB names (ADVFRW1.ora on first node resp. ADVFRW2.ora on second node). But with the node specific DB name the script fails, because it does not match with the DB name of the source system.

View 10 Replies View Related

RAC & Failsafe :: Service Always Offilne

Oct 26, 2013

OS :
6100-01-09-1015
oralce:
11.2.0.1.0 - 64bit RAC

View 1 Replies View Related

RAC & Failsafe :: Oracle 11gR2 RAC On Unix

Aug 8, 2011

I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?

View 3 Replies View Related

RAC & Failsafe :: Oracle Cluster 10 Installation

Oct 27, 2010

Steps for installing Oracle Cluster 10?

View 9 Replies View Related

RAC & Failsafe :: Startup Sequence 10g RAC Database With ASM?

Dec 28, 2012

I want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again

I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence

1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs

2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs

3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1

4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2

5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1

6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2

7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB

A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?

View 9 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 :: Changing Disk Paths In ASM

Jul 13, 2012

We are about to undertake a storage migration of our RAC environment from EMC to XIV storage.

The migration method we are using means that we will be presented with identical disks post the migration, however the UNIX paths to the disk devices will be changing. Using our migration method it is not possible to present the old and new devices at the same time.

Therefore once the migration is complete i need to update the device configuration to reflect the new paths. I believe this is done using the following techniques but I am unsure as some of the documentation is ambiguous and I have not done this before

Changing path to Voting Disks

crsctl add css votedisk <new_path_to_disk> -force
crsctl delete css votedisk <old_path_to_disk> -force

Changing path to OCR Disks

ocrconfig repair ocr <new_path_to_ocr>
ocrconfig repair ocrmirror <new_path_to_ocrmirror>

Changing paths to ASM disks

alter system set asm_diskstring='<new_device_path>' scope=both;

View 3 Replies View Related

RAC & Failsafe :: DNS Response Time For Nodes

Feb 24, 2011

I'm trying to install 2 nodes oracle RAC 11gR2 on SLES11. I configured DNS for public,virtual, private and scan IPs. when I check with nslookup, everything seems ok. but when I run runcluvfy.sh, it says that:

" PRVF-5636 : The DNS response time for an unreachable node exceeded 15000 ms on following nodes: rac1,rac2"

How can I decrease the response time?

View 4 Replies View Related







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