Solved

oracle discs used for data storage

Posted on 2014-04-07
13
405 Views
Last Modified: 2014-04-09
Hi everyone,
I have a new oracle 11r2 server on rhel 6.5.
os discs look like this:

/dev/xvda1 ext4 /
/dev/xvdc1 ext3 /tmp
/dev/mapper/vg-u01 ext4 /u01
/dev/mapper/vg2-u02 ext4 /u02

I alos have 3 tb of discs, which will be used with oracleasm that I am unfamiliar with. the data will be imported to those discs which hold all of the existing oracle database records.

My question is how should those discs be formatted, ext4 I assume ?
or does oracleasm handle this, and the discs should be left as raw devices perhaps?

Thank you!
0
Comment
Question by:Peter Kuczynski
  • 8
  • 4
13 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 39983451
I believe that you should do the formatting of the disc, as you create disk groups in asm, for a disk group to create in asm, one of the pre-requisite is to format the disc using the operating system utility

this is a preview of the prerequisites from

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_5008.htm#SQLRF01114

You must have the SYSASM system privilege to issue this statement.

Before issuing this statement, you must format the disks using an operating system format utility. Also ensure that the Oracle Database user has read/write permission and the disks can be discovered using the ASM_DISKSTRING.
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39983504
if I have 12 discs, should I first  format them as primary partitions?

as in
fdisk /dev/sdj
n, e, 1, enter, enter, t, 83 [linux], w
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39983685
Never mind, I answered my own question I made them all primary
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39983687
next I'm labeling all the discs

/etc/init.d/oracleasm createdisk DATA1 /dev/xvdj1
/etc/init.d/oracleasm createdisk DATA2 /dev/xvdk1
/etc/init.d/oracleasm createdisk DATA3 /dev/xvdl1
/etc/init.d/oracleasm createdisk DATA4 /dev/xvdm1
/etc/init.d/oracleasm createdisk DATA5 /dev/xvdn1
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39983914
Now I need to configure RAW devices for RHEL 6.5 and am stuck.

Is this article correct in it's configuration?

http://www.oracleflash.com/7/How-to-configure-Raw-Disks-in-RHEL-5.html
I realize it's for rhel 5 for it seems to be correct in terms of directories....

the other article was this one, but it's depreciated in terms of raw devices..
http://www.oracleflash.com/11/How-to-Configure-ASM-disks-using-ASMLib-or-Raw-Disks.html
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39984002
I may have answered my own question again, if you are going to use asmlib you don't need to do the raw device mappings, the rest of the configuration is done from within oracle. I will update this post in case I find anything different.
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39984007
well its great then.. you are giving questions and answering them on your own.. till i find something for
you..

was just searching the site with steps for asm which you may refer in case of need..

http://www.oracle-wiki.net/startdocshowtoinstalloracle11glinuxasm

http://en.community.dell.com/techcenter/enterprise-solutions/w/oracle_solutions/3336.how-to-deploy-oracle-11gr2-on-rhel6oracle-linux-6.aspx#part_disk

it seems you are going good.. well then ., its my time to log off..!! good luck..!!!
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39984174
LOL, thank you
Here's a very condensed oracle asm lib disk config procedure:
Fdisk all the discs......
fdisk /dev/xvdj
n, p, 1, enter, enter, t, 83 [linux], p, w
Repeat the above step for all disks

/etc/init.d/oracleasm configure
Default user to own the driver interface [oracle]:
Default group to own the driver interface [dba]: <<<<<double check this group may be oinstall
Start Oracle ASM library driver on boot (y/n) [y]:
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]

Label the disks as ASM disks and give then an ASM name.
EXAMPLE
/etc/init.d/oracleasm createdisk DATA1 /dev/xvdj1
Repeat the above step for all disks

Issue a scandisks on all ASM disks.
/etc/init.d/oracleasm scandisks

listsdisks will list all ASM disks. Make sure you see all the disks you configured.

/etc/init.d/oracleasm listdisks

This article is pretty much spot on. You will for oracle asm OR udev, on or the other but not both.

http://www.oracleflash.com/11/How-to-Configure-ASM-disks-using-ASMLib-or-Raw-Disks.html
0
 
LVL 1

Author Comment

by:Peter Kuczynski
ID: 39985088
I've requested that this question be closed as follows:

Accepted answer: 0 points for peter1035's comment #a39984174

for the following reason:

Everyone contributed, thank you.
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39985087
your question was to format the disks or not while doing configuration and I think it was well answered??

though you linked various questions in one question and have answered them own, this doesn't mean that the original one went unanswered..!!

so you cannot close the question accepting your own answer..!!

please close it appropriately..!!
0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 39985090
please close it appropriately..!!

Please see the comment above
0
 
LVL 1

Author Closing Comment

by:Peter Kuczynski
ID: 39988961
thank you
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Choosing CentOS 16 79
Oracle - SQL Parse String 5 33
upgrading Oracle 10g/ 11g / 11g R2 to Oracle 12c 25 54
Oracle function to insert records? 15 36
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question