RAC & Failsafe :: Oracle 11g - Voting Disk Location

Nov 4, 2011

Tell me that in Oracle 11g, information regarding voting disk location is stored in which file ?

I know that we can use "crsctl query css votedisk" to see the location of voting disk, but from which file or place this command pick the information ?

View 6 Replies


How To Create Ocr Disk Or Voting Disk On Windows Server 2008

Feb 17, 2011

I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.

In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Adding Voting Disk Fails On

Jan 4, 2013

I am installing Oracle Grid Infratructure on OEL 6.3...I reached the final step, running the root.sh on node 1. It succsessfully started the services but then I got this error:

Failed to create voting files on disk group OCR_VOTING.
Change to configuration failed, but was successfully rolled back.
CRS-4000: Command Replace failed, or completed with errors.

Voting file add failed
Failed to add voting disks at /opt/oracle/11.2.0/grid/crs/install/crsconfig_lib.pm line 6780.
+/opt/oracle/11.2.0/grid/perl/bin/perl -I/opt/oracle/11.2.0/grid/perl/lib -I/opt/oracle/11.2.0/grid/crs/install /opt/oracle/11.2.0/grid/crs/install/rootcrs.pl execution failed+

OCR_VOTING Diskgroup is configured using oracleasm:

oracleasm createdisk OCR_VOTING /dev/sdb1/dev/sdb1 is a partition and has been created ot the LUN /dev/sdb using fdisk.

Here is part of logfile of the root.sh - tool. Meanwhile I tried deinstalling the clusterware and cleaning up, then I verified the server configuration with cluvfy and all was OK.

+2013-01-04 00:24:26: Start of resource "ora.crsd" Succeeded+
+2013-01-04 00:24:26: Creating voting files+
2013-01-04 00:24:26: Creating voting files in ASM diskgroup OCR_VOTING
2013-01-04 00:24:26: Executing crsctl replace votedisk '+OCR_VOTING'
2013-01-04 00:24:26: Executing /opt/oracle/11.2.0/grid/bin/crsctl replace votedisk '+OCR_VOTING'
2013-01-04 00:24:26: Executing cmd: /opt/oracle/11.2.0/grid/bin/crsctl replace votedisk '+OCR_VOTING'

View 3 Replies View Related

Express Edition (XE) :: Why Maximum Number Of Voting Disk Is Even Number (32)

Oct 3, 2013

I gone through many forums and found that the number of voting disks should be always in odd number. Then why the maximum number of voting disk is 32?

View 1 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 :: How To Prevent VIP Transfer Back To Its Original Node Location

Nov 11, 2012

Normally if node fails, VIP & resources are transferred to another node (clients need to failover).

if node is back again CRS detect this, make it as 'family member' and try transfer VIP & resources back to this node (clients will force to failover again).

this failover (despite of failover method I use) make each uncommitted transaction to be rolled back. client need to be disconnected from the service and VIP through they are connected to this service and they need reconnect to the new node - during this stage all DMLs modifications are gone, and need to be re execute.

View 11 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 :: ORA-15080 / Synchronous I / O Operation To A Disk Failed

Aug 1, 2013

I am getting below errors on one of the node of my RAC server while starting the database. how to get the rsolution.

ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Solaris-AMD64 Error: 5: I/O error
Additional information: 4
Additional information: 331776
Additional information: -1
Thu Aug 1 22:29:42 2013
Errors in file /software/oracle/admin/dixie/udump/dixie1_ora_23644.trc:
ORA-00202: control file: '+DGDIXIE/dixie/controlfile/current.265.647198019'


View 4 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

Adding ASM Disk With Header Status MEMBER To Existing Disk Group

Aug 26, 2010

We have a Production Oracle 10g R2 RAC on HP-UX v2 IA64 servers.We have Two Disk Groups one for Archive (ARC_DISK - 100 GB) and other for Database(DATA_DISK - 1 TB]. We wanted to add more space to the DATA_DISK disk group.Unix admin configured 200 GB from SAN and changed the ownership of the Disk to oracle and permissions to 775 on 1st Node.I opended DBCA from 1st Node and was able to see the disk in 'Show Candidate'.

I added this disk to the DATA_DISK disk group and clicked OK but got ORA- error with some message like some operations could not be performed. I exited DBCA.We realized that we had forgotten to change the ownerhip and permission from the 2nd Node.Unix admin changed the ownership of the Disk to oracle and permissions to 775 on the 2nd Node.

I opened DBCA again from 1st Node and selected the DATA_DISK disk group but could not find the Disk in 'Show Candiate' open. I clicked on 'Show All' and this disk was shown with Header_Status - MEMBER but not allocated to DATA_DISKGROUP. When I clicked the 'Show Member' option, this disk is not shown for DATA_DISK disk group. I exited DBCA at this point.As this is a critcal Production database I didnt proceed any further and exited DBCA.

Now I need to add this Disk to the DATA_DISK disk group but not sure which option to select. I got one reply from another forum to run DBCA select the DATA_DISK Disk Group and then click 'Show All' and select this Disk (which already has MEMBER as Header Status) and select Force Option and click OK to continue.

View 4 Replies View Related

Server Administration :: Disk Group With Two Disk For Normal Redundancy

Jan 16, 2013

I Configured an ASM instance and a disk group with two disk for normal redundancy.

> Here .. each disk is 2gb

The disk group has two disks...

SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;

------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898

as the group has two way mirroring (Normal redundancy) How much data (2 GB or 4 GB) can i keep in the disk group? My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)

View 3 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 Replies View Related

Automatic Storage Management :: Place Voting Files In Quorum Or Regular Failgroup?

Oct 29, 2013

About the concept of quorum failgroup ORACLE says:QUORUM disks, or disks in quorum failure groups, cannot contain any database files,the Oracle Cluster Registry (OCR), or dynamic volumes. However, QUORUM diskscan contain the voting file for Cluster Synchronization Services (CSS). Oracle ASMuses quorum disks or disks in quorum failure groups for voting files wheneverpossible.

To sum up, i think the different between a regular failgroup and a quorum failgroup is a quorum failgroup can only contain vote files and a regular one can contains multiple kinds of files.So i didn't see any advantage to place voting files on a quorum failgroup than on a regular one. Why Oracle introduce the concept of quorum failgroup?

View 2 Replies View Related

Is Oracle Client Install On Network Location Supported

Nov 29, 2010

I've looked in several places, OTN, Google, various DBA forums to figure out if the way we have a client installed on a network drive is supported by Oracle - short of asking them if it's supported.

The configuration we have is a full 10g R2 client installed on a network drive, and the various environment variables (Oracle_Home, TNS_ADMIN, etc.) point to that network location for use by client machines (I'm also trying to see if the Instant client is supported on a network location as well.) We've had this set up for years which has served us well.

A co-worker remembers years ago that this set up wasn't supported, Oracle 8 or so was his thought as to what version was used then. Another coworker at an Oracle conference asked this same question and was told that it was supported, however we can't find any documentation to that effect.

Now the question arises as to whether or not using a client installed on a networked drive is a supported configuration for 10g R2 or higher, and if so, where it would be documented.

We are in the process of changing network topology and are reviewing whether this configuration is still the right thing for us or if clients should be installed locally to where they are used.

View 2 Replies View Related

Forms :: Oracle 6i For Windows 7 64 Bit / Can't Find Exact Location From Google

Sep 20, 2012

i want to download form 6i and report 6i for window 7 64bit. from where i can download it. i can't find exact location from google.

View 6 Replies View Related

Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies View Related

Oracle Solid State Disk

Feb 1, 2013

I understand the architecture of solid state drives favor different types of I/O. Oracle 11g introduced the database flash cache which allows flash storage to be used as a secondary cache. With database flash cache serving as a secondary cache to my Oracle buffer cache.

My understanding is I need to config two database parameters DB_FLASH_CACHE_FILE and DB_FLASH_CACHE_SIZE. If i want to have certain tables/indexes to take advantage of this extra cache I would set the value KEEP within the parameter.

Is there anything that needs to be done to the tablespaces / datafiles.

View 1 Replies View Related

Query To Check Disk Space Usage For Oracle

Apr 21, 2010

What is the query to check disk space usage for oracle 10g ? What is the query to check percent of disk space usage for oracle 10g ?

View 1 Replies View Related

Calculate Total Disk Space Used By Oracle Databases Across Whole Company?

Oct 18, 2013

If we want to know the number of instances, number of RAC databases  and whole total disk space used by oracle (not file system size),1. Any script can be ran from OEM grid control against all instances/databases? or2. we have a repository unix server which has all tnsnames of whole databases, any script we can run from there?

View 5 Replies View Related

How Much Block Will Be Read From Disk When A Single Oracle Io Call Occurs

Jul 10, 2012

The block size of my db(10gr2) is 8k, and the db is on the raw device file system on a aix machine.

OS block size is 512k.

How much block will be read from disk when a single oracle io call occurs? Which one is currect, 8K or 512K?

If the block size for a single io call depends on the os block size (512k), I think os block size need to be tuned for oracle block size (8k). If we use raw device file system, os level block size has no meaning?

View 1 Replies View Related

Automatic Storage Management :: Oracle ASM Create-disk Failed?

Oct 25, 2012

I am using on RHEL 5.4ASM is properly working on my machine. database is running from ASM. I want to configure additional oracleasm devices.command fails saying:

$ oracleasm createdisk ASMDISK08 /dev/xvd8
Writing disk header: done
Instantiating disk: failed
Clearing disk header: done

I am creating asm diskgroup on loopback devicesHere are the configured loopback devices.

[root@host1 ~]# ls -l /dev/loop[1-9]
brw-rw-rw- 1 oracle oinstall 7, 1 Oct 25 14:42 /dev/loop1
brw-rw-rw- 1 oracle oinstall 7, 2 Oct 25 14:42 /dev/loop2
brw-rw-rw- 1 oracle oinstall 7, 3 Oct 25 14:42 /dev/loop3
brw-rw-rw- 1 oracle oinstall 7, 4 Oct 25 14:42 /dev/loop4


I am unable to understand where is the problem.

View 11 Replies View Related

RAC/ASM Clusterware Installation :: Adding New OCFS Disk To Oracle Cluster On Windows

Oct 17, 2013

We have 2 servers running Oracle 11gR2 Window server 2008 64 bit  RAC. Today I  add new shared disk visible from both servers. All our data placed on ASM partitions, but we need Windows volume for exchanging some data between servers & users;Actions:then i have prepare disk on shared storage from 1st node, run diskmfmt.msc & rescan disks when windows recognizes new hdd, initialize it.create an Extended partition & Logical drive & Assign drive letter. from another nodes, make sure no drive letter is assigned.

Sometimes Windows automatically assign drive letter. If drive letter is assigned, right click & Change drive letter & Remove. from 1st node, format this logical drive using ocfsFormat.exe after execute below scripts i have face some issues  

 E:app11.2.0gridcfs>ocfsformat /m P: /c 1024 /v DATA /f /d /aReg Get Cluster Name(): Reg Query ValueEx for CFS_CLUSTER_NAME failed with error 203

This indicates that the Cluster Name has not been configured on this node for OCFSThe volume formatted in this condition will be seen by all nodes running OCFS. 

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Oracle Cloud Storage For 3rd Vote Disk For Extended RAC 11gR2

Dec 11, 2012

I am having 2 data centers within 1/2 km distance. And we kept each vote disk in once site. In case of site failure, the cluster needs a 3rd set. We don't have 3rd site.

Last open world, Oracle announced that oracle storage on cloud as announced. If I get the small space on the cloud, can i put my 3rd vote disk on the cloud?

View 1 Replies View Related

Automatic Storage Management :: Disk Is Not Displaying - Install Oracle Grid Infrastructure 11r2?

Jul 1, 2012

i try to install oracle grid infrastructure 11r2 on cent OS 4.8 on vmware workstation 8.0.2..ASM disk is not showing ,i had also change disk discovery path to 'ORCL:*'i had already configure ASM disk using /etc/init.d/oracleasm createdisk...successfully..

View 8 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


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

View 1 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 :: 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.


View 5 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

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