RAC/ASM Clusterware Installation :: Resize LUN And Disk Group
Jan 7, 2013
I have a small problem resizing an ASM disk group . I've had a lun with size 50G and added on it an asm disk called LUN1D1. Then I have created a DISK GROUP called data1 (external) witch contain LUN1D1. DATA1 was then made asm volume. So I have an asm volume with size 50G and I need it to be 100G.
Now I have increased the size of the lun with 50G (100G in total). I have rescanned the LUN and os see the new size. The problem is I can not re size DISK GROUP data1 or disk LUN1D1.
Orale Database 11.2.0.3.0 x64
View 6 Replies
ADVERTISEMENT
Jan 4, 2013
I am installing Oracle Grid Infratructure 11.2.0.3 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'
[code]....
View 3 Replies
View Related
Jul 9, 2012
I've installed GI 11.2.0.3 on AIX 7.1.And today I noticed strange ASM's behavior:
-bash-3.2$ getconf DISK_SIZE /dev/rhdisk2
*2285768*
-bash-3.2$ asmcmd
ASMCMD> lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path
*188616* 68204 *188616* DATA_0000 DATA_0000 REGULAR System UNKNOWN /dev/rhdisk2
I guessed that was because of LUN size (it was exceed 2 TB)After that I dinamically shrinked LUN size on our external storage, rebooted and perfomed cfgmgr command on both nodes. But I still have no enough free space.
-bash-3.2$ getconf DISK_SIZE /dev/rhdisk2
*1992294*
-bash-3.2$ asmcmd
ASMCMD> lsdsk -k
Total_MB Free_MB OS_MB Name Failgroup Failgroup_Type Library Label UDID Product Redund Path
*188616* 68204 *1992294* DATA_0000 DATA_0000 REGULAR System UNKNOWN /dev/rhdisk2
View 2 Replies
View Related
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
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
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
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;
GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
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
May 9, 2011
Is there any way to add one disk group space to another disk group. Because One of my disk group is full i want to add space in to that group.
View 1 Replies
View Related
Mar 20, 2012
I want to re-size redo log group on my production database .i have 10 redo log groups of 50mb each having 2 members.i want 4 redo groups to be of 250 mb each having 2 members and then i will drop that old 10 redo log group(50 mb ) , so that i will have only 4 redo log group of 250MB each having 2 members.But i have physical standby and logical standby configured on production database .
find attached file for redo log configuration of production database(CBSPROD),Logical standby database(CBSMIS), Physical standby database(CBSDR).
View 1 Replies
View Related
Oct 1, 2013
I am setting up a RAC cluster in Oracle 11.2.0.3 on two Windows 2008R2 nodes.I have completed all the pre-installation tasks would like to verify this by running:cluvfy comp sys -p database -n allusing the standalone download of cluvfy - I haven't installed any Oracle software as yet. This completes successfully on the remote node but fails on the local node (whichever one I run it from).
There is a lot of output but these seem to be the key problems: [1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [WindowsSystem.deleteService:876] _WS_ deleteService2: node PRDAT217 Service OracleRemExecService result: 0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:91] NativeResult: The String obtained is0|Access is denied.[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:99] The status string is: 0[1852@PRDAT217] [Worker 3] [ 2013-10-01 14:44:45.190 BST ] [NativeResult.<init>:112]
[code]...
View 6 Replies
View Related
Jun 7, 2013
I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
View 0 Replies
View Related
Dec 6, 2012
I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.
View 1 Replies
View Related
Aug 28, 2013
I am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
View 15 Replies
View Related
Nov 17, 2013
We're trying to utilize Oracle RAC 11.2. We want to have two servers in our grid. These two server are installed on a VM using Hyper-V software.
common storage for asm is also developed on a VM using FreeNAS software.Now, when we try to install Grid Infrastructure the disk that is recognized as a extra drive in both servers are disabled and we can't select it as ASM storage. The OS we're using is Windows Server 2008 R2.I have to say the IP requirements are considered and the servers have two IPs.
View 0 Replies
View Related
Jul 11, 2013
I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
View 2 Replies
View Related
Sep 16, 2013
Am planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
View 4 Replies
View Related
Apr 6, 2012
I was setting up disks groups and I accidentally created one group (DATA) with "NORMAL" redundancy but wanted it to be "EXTERNAL". I tried using asmca to remove disks from the group, drop the group, change the redundancy..... All of this failed because there was an spfile on the disk group.
I finally got it to work with using this procedure:
sqlplus '/ as sysasm'
SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 5 08:58:19 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> drop diskgroup DATA;
drop diskgroup DATA
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15053: diskgroup "DATA" contains existing files
[code]....
In summary, I am not sure why changing the redundancy would be so difficult if there is data on the disk group.
View 4 Replies
View Related
Oct 3, 2013
One of my collegues created an ASM disk group with normal redundancy using 2 disks. But the disks are not of same size, one disk is 100GB and another one is 10GB. Now the usable space out of diskgroup is showing 55GB. When I checked the diskgroup properties it is showing 2 fail groups one is DATA1_ 0000 with 10GB and other is DATA_0001 with 100GB. My question is why it is showing 55GB as usable space? My assumption is as it is having 2 fail groups with different disks of different sizes. For the failgroup 2 even it is of 100GB size, in order to maintain the redundancy with other small FG(10G) it will consider only 10GB out of 100GB. So, the 2nd FG size also should be 10GB. So that the usable space should show as 10GB as opposed to 55GB (not (100+10)/2).
View 12 Replies
View Related
Jul 8, 2013
i am trying to identify the pro's/con's of using multiple ASM Diskgroup. I understand oracle recommends/best practice is to have 2 DG (one data and one flash) and you can place multiple copies of control files/online redo logs(and thats the way i want to go). But would that same be true if i use different set of DISK. For example we have multiple RAID 10 devices and multiple of SSD devices for us that we can use for this ASM instance. And i was thinking to create 2 more Disk group (call it DG_SYS1 and DG_SYS2) and use that to put my online redo logs, control file and temp and system table space there. i understand in a standalone system(where regular file system is being used), they(online redo/ control file) are usually on there own drives, but with ASM when i am already using external RAID 10 config + ASM striping i assume the IO would faster or am i better of using the SSD that i can have for my redo/control? What would be the pro's/cons of it (besides managing multiple DG)..
View 7 Replies
View Related
Dec 3, 2012
I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies
View Related
Jun 19, 2012
I have 11.1.0.7 instance running and got more 300G of storage available for the database. I would like to know what are the steps to add these disks/storage to the existing DATA asm disk group?
View 5 Replies
View Related
Jan 21, 2013
Db : 11.2.0.3
Os :Aix
We have 3 database under an ASM on same machine.Each db has 2 disk group's.
Db Name :DT6
DT6_DATAGROUP01/
DT6_REDOGROUP01/
Db Name :DT7
DT7_DATAGROUP01/
DT7_REDOGROUP01/
Db Name :DT8
DT8_DATAGROUP01/
DT8_REDOGROUP01/
How these database instance correctly identify the disk group? Can we use two database instance for One disk group?
View 6 Replies
View Related
Jul 9, 2012
Is it possible to upgrade GI 11.2.0.1 Enterprise Edition version to 11.2.0.3 STANDARD EDITION?
We have 2 Node RAC with 10.2 DB SE. Last time I think by mistake or not knowing the licensing information GI was upgraded to EE 11.2.0.1 by somebody or may be whatever version of GI is used, it has nothing to do with the license?
I have heard that I can upgrade Grid Infrastructure, but to Standard Edition. Does GI also comes with SE and also just want to know that can I perform this upgrade?
View 11 Replies
View Related
Jul 4, 2012
2 Node RAC Prod. GI= 11.2..0.1 , DB = 10.2.0.4 SE
I want to upgrade (out of place) Grid Infrastructure to latest version of 11.2.0.3 and then PSU on top of that.
GI HOME and DB HOME are separated. Database I want to upgrade later on, not with this clusterware upgrade. I have download p10404530_112030_Linux-x86-64_3of7.zip from MOS for upgrading GI.
grid@db1p [rec]: /home/grid > crsctl query crs softwareversion
Oracle Clusterware version on node [db1p] is [11.2.0.1.0]
grid@db1p [rec]: /home/grid > crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]grid@db1px [ec]: /home/grid > sqlplus / as sysasm
[code]....
1) Is this the correct p10404530_112030_Linux-x86-64_3of7.zip to upgrade GI from 11.2.0.1 to 11.2.03?
2) Do I need a COMPLETE DOWNTIME to upgrade GI on 2 node RAC where DB is STANDARD EDITION but Clusterware is 11.2 as you have seen above..
3) Will this ASM version will also be upgraded along with GI upgrade installer or it must be upgrades separately after GI Upgrade?
View 4 Replies
View Related
Dec 27, 2012
When I use 'ONSCTL PING' to test the ons status, it says: configure localport and remoteport directives and attempt to start ONS server again.ons is not running.The content of D:app11.2.0gridopmnconfons.config is:
localport=6100 # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200 # line added by Agent
nodes=rac1:6200,rac2:6200 # line added by Agent
The content of D:app11.2.0gridopmnconfons.config.rac2 is:
localport=6100 # line added by Agent
allowgroup=true
usesharedinstall=true
remoteport=6200 # line added by Agent
nodes=rac1:6200,rac2:6200 # line added by Agent
The configuration file is almost the same in rac1.But the output of 'srvctl status nodeapps' is :
ons is enabled
ons is running on node1:rac1
ons is running on node2:rac2
View 2 Replies
View Related
Oct 13, 2013
tried to mount a big endian asm disk (AIX for example) on little endian env (linux x86)? I have a disk that KFED is able to read but ASM is unable to mount it due to endianess incompatibility.
from the KFED read: kfbh.endian: 0 ; 0x000: 0x00kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: blk=0kfbh.block.obj: 128 ; 0x008: file=128kfbh.check: 1999209486 ; 0x00c: 0x7729840ekfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014:
[code]...
View 8 Replies
View Related
Jun 15, 2013
We try to upgrade the 10g to 11g oracle instance and asm instance.Below steps we r done;
1)First we are install the 11.2.0.3 database and grid infrastructure in separate home.
2)after that i try to upgrade asm instance so i drop old 10g asm localconfig cd $ORACLE10g_HOME./localconfig deletecd $ORACLE11g_HOME./localconfig add but here i can not find localconfig Note:database and grid installed without error....
3)Even we are try dbua but it run 10g dbua we are not able to run dbua for 11g
4)inventory is corrupted how to recreate inventory
5)provide the steps for upgrade 10g asm to 11g asm
View 3 Replies
View Related
Mar 22, 2013
Can I use 64 bit OS (Solaris x86) in my PC with VMware. As many software available in 64 bit but not in 32bit.
If I install 64 bit OS , Oracle DB whether it can crash the system or not
View 4 Replies
View Related
Aug 15, 2012
I'm a long time Oracle DBA but have only recently started with RAC and have never done any patching or upgrades in a RAC environment.
My environment consists of a 2 node RAC cluster, and 2 physical standbys at separate remote locations.
The database, GI, ASM, and clusterware are all at version 11.2.0.1.
I want to upgrade all components to the latest patchset which is 11.2.0.3. Eventually I also want to apply the latest PSU.
Can I do this without down time? It is a mission critical database where downtime could conceivably endanger lives. If it can't be done with zero downtime, then downtime must be kept to an absolute minimum (minutes, not hours).
I suspect the clusterware needs to be patched first and I do not know whether I can do it on one node at a time.
View 2 Replies
View Related
Sep 24, 2012
I need some professional article about how to configure DNS for using Oracle GNS with explanation.
I want to understand the role of DNS server for GNS.
I tried to search but what I found is not enough or they are not written with accuracy.
View 2 Replies
View Related
