Oracle database on raw devices 2004-03-24 - By Frank Westheider
HI !
You have to create character-special-devices for the LVM-Devices.
Please take a look in /etc/rawdevices or /etc/sysconfig/rawdevices and on
the raw-command.
I think, these are mentioned in the Oracle-Whitepapers too :-)
Bye
Frank
-- -- Original Message -- --
From: "Rolf Walter" <rolf_a_walter@(protected)>
To: <suse-oracle@(protected)>
Sent: Wednesday, March 24, 2004 9:22 AM
Subject: [suse-oracle] Oracle database on raw devices
> I created raw devives using the LVM:
>
> oracle@(protected):/home/oracle> ls -la /dev/system
> total 93
> dr-xr-xr-x 2 root root 584 2004-03-24
> 09:14 .
> drwxr-xr-x 30 root root 94768 2004-03-24
> 09:14 ..
> brw-rw---- 1 root disk 58, 16 2004-03-24
> 09:14 APS_CNTL1
> brw-rw---- 1 root disk 58, 6 2004-03-24
> 09:14 APS_DATA01
> brw-rw---- 1 root disk 58, 7 2004-03-24
> 09:14 APS_DATA02
> brw-rw---- 1 root disk 58, 8 2004-03-24
> 09:14 APS_DATA03
> brw-rw---- 1 root disk 58, 9 2004-03-24
> 09:14 APS_DATA04
> brw-rw---- 1 root disk 58, 10 2004-03-24
> 09:14 APS_DATA05
> brw-rw---- 1 root disk 58, 11 2004-03-24
> 09:14 APS_INDEX01
> brw-rw---- 1 root disk 58, 12 2004-03-24
> 09:14 APS_INDEX02
> brw-rw---- 1 root disk 58, 13 2004-03-24
> 09:14 APS_INDEX03
> brw-rw---- 1 root disk 58, 14 2004-03-24
> 09:14 APS_INDEX04
> brw-rw---- 1 root disk 58, 15 2004-03-24
> 09:14 APS_INDEX05
> brw-rw---- 1 root disk 58, 2 2004-03-24
> 09:14 APS_LOG1
> brw-rw---- 1 root disk 58, 3 2004-03-24
> 09:14 APS_LOG2
> brw-rw---- 1 root disk 58, 0 2004-03-24
> 09:14 APS_SYSTEM
> brw-rw---- 1 root disk 58, 4 2004-03-24
> 09:14 APS_TEMP
> brw-rw---- 1 root disk 58, 5 2004-03-24
> 09:14 APS_UNDO
>
> I tried to create an oracle database:
>
> SQL> create database APS
> 2 logfile group 1 '/dev/system/APS_LOG1' size 51M
> reuse,
> 3 group 2 '/dev/system/APS_LOG2' size 51M
> reuse
> 4 datafile '/dev/system/APS_SYSTEM' size 499M
> reuse
> 5 undo tablespace RBSEG01 datafile
> '/dev/system/APS_ROLL' size 2047 M reuse
>
> 6 default temporary tablespace TEMP tempfile
> '/dev/system/APS_TEMP' size 20
> 47 M reuse
> 7 noarchivelog
> 8 exclusive
> 9 character set WE8ISO8859P1;
> create database APS
> *
> ERROR at line 1:
> ORA-01501 (See ORA-01501.ora-code.com): CREATE DATABASE failed
> ORA-00301 (See ORA-00301.ora-code.com): error in adding log file
> '/dev/system/APS_LOG1' - file cannot be
> created
> ORA-27056 (See ORA-27056.ora-code.com): skgfrdel: could not delete file
> Linux Error: 13: Permission denied
>
> On AIX there would have been 2 entries for each
> raw device (block/char), but on Linux I only find
> the block devices, and that doesn't work.
>
> Can anybody help me?
>
> Regards Rolf
>
>
>
>
> Mit schönen Grüßen von Yahoo! Mail - http://mail.yahoo.de
>
> --
> 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
|
|
