Solved

oracle discs used for data storage

Posted on 2014-04-07
13
392 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
 
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now