Solved

oracle discs used for data storage

Posted on 2014-04-07
13
412 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linux Mailserver setup & redundancy 2 75
The better OS Architecture 13 85
Toad 12.10 Enterprise visual interface 4 31
setting local variables in a cursor block 3 27
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

679 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