Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
AW: [suse-oracle] ASMlib on SLES10

AW: [suse-oracle] ASMlib on SLES10

2006-09-20       - By Frank Westheider

 Back
Reply:     1     2  

Hi !

You can also use the LVM approach.

Create a Volume-Group (ex. vgoraasm) with all of your Oracle-Disks (create 1
Partition with Type LVM on each disk) you want to use in the ASM. The you
can create Logical Volumnes (LV, ex. Lvasmd1) in the VG where every LV is
exactly in 1 Disk (Option in the lvcreate). You need to give oracle:dba the
rights to access the LV (via udev-permissions).

After that you set your ASM-Diskstring to /dev/mapper/vgoraasm* (when using
Device-Mapper) or /dev/vgoraasm/lv* (direct LVM-Usage) and everything's fine
;-)

Works fine for me ;-)

Bye
  Frank

-- --Urspr?ngliche Nachricht-- --
Von: Yann Neuhaus [mailto:Yann.Neuhaus@(protected)]
Gesendet: Mittwoch, 20. September 2006 12:55
An: LOPEZ DIAZ, JORGE; suse-oracle@(protected)
Betreff: RE: [suse-oracle] ASMlib on SLES10

Hi,

I am not sure if raw is mandatory, just set the "ASM_DISKSTRING" parameter
in the ASM spfile and all the matching devices will be ASM candidates.

However ideally with raw, you can create a raw for each device and put the
raw devices in

/dev/oraraw

Then you have ASM_DISKSTRING=/dev/oraraw

i.e :

mkdir -p /dev/oraraw/
rm -f /dev/oraraw/*

mknod /dev/oraraw/raw_vot_1 c 162 1
mknod /dev/oraraw/raw_vot_2 c 162 2
mknod /dev/oraraw/raw_vot_3 c 162 3
mknod /dev/oraraw/raw_ocr_1 c 162 4
mknod /dev/oraraw/raw_ocr_2 c 162 5

raw /dev/oraraw/raw_vot_1 /dev/sde1
raw /dev/oraraw/raw_vot_2 /dev/sdf1
raw /dev/oraraw/raw_vot_3 /dev/sdg1
raw /dev/oraraw/raw_ocr_1 /dev/sdh1
raw /dev/oraraw/raw_ocr_2 /dev/sdi1

Best Regards

Yann.

-- ---- --

Yann Neuhaus

Senior Consultant

IMS-Basel
Trivadis AG
Systems Management
Elisabethenanlage 9
CH-4051 Basel

yann.neuhaus@(protected)

Mobile: +41-79-457 97 56
Tel.  : +41-61-279 97 55
Fax.  : +41-61-279 97 56

MySQL 5.0 certified



-- --Original Message-- --
From: LOPEZ DIAZ, JORGE [mailto:jorge.lopez@(protected)]
Sent: Wed 9/20/2006 12:36
To: suse-oracle@(protected)
Subject: RE: [suse-oracle] ASMlib on SLES10

Hello Fabricio,



Yes, I read about ASMlib is not needed but then I must use raw device, or
not?



__ ____ ____ ____ ____ ____ ____

De: Fabrizio Magni [mailto:fabrizio.magni@(protected)]
Enviado el: mi?rcoles, 20 de septiembre de 2006 12:32
Para: LOPEZ DIAZ, JORGE
CC: suse-oracle@(protected)
Asunto: Re: [suse-oracle] ASMlib on SLES10



Hello Jorge,
I don't think the ASMlib are ready for the SLES10 kernel yet.
However you don't need them for your ASM.

ASMlib are not really necessary (and personally I prefer not to use them).

Regards
Fabrizio

On 9/20/06, LOPEZ DIAZ, JORGE <jorge.lopez@(protected)> wrote:

Hi everyone,



We are installing a RAC cluster of two nodes on SLES 10 hosted in a  Vmware
Server 1.0.1 in a SLES10 linux system.

We have the two nodes ready to start RAC installation and we plan to use ASM
storage for database and quorum file.

How can we configure ASMlib and from where can we download rpm package or
source package? The idea is not to use raw devices.

In OTN I see rpm's for SLES9 but no sources.



Thanks, and excuse my poor english.

Jorge L?pez D?az

Servicio de Gesti?n Inform?tica

Consejer?a de Sanidad de la Regi?n de Murcia.

Espa?a (Spain)







--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting






--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting