Looks like you have a 32-bit version of oracle. 4GB is a typical number
to hit.
On 2003.07.11 16:59, Jessica Mao wrote:
> maybe nobody cares. but anyway, more experiments show as long as striped raw
> LV is bigger than 4092MB (4K block size), oracle datafile size could only be
> several MB or something, not even close to 1000MB. seems like there's some
> kind of overflow here.
>
> problem went away after loaded 9.2.0.3.
> again there was no problem w/ 8.1.7.0 either.
> so i think there's a bug in 8.1.7.4.
>
> -----Original Message-----
> Sent: Thursday, July 10, 2003 1:45 PM
> To: Multiple recipients of list ORACLE-L
> HPUX
>
>
> can anyone please help?
>
> errors like below when any of the redo or rollback raw LVs are created using
> stripe:
>
> CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE
> AUTOEXTEND OFF MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K
> MINEXTENTS 8 MAXEXTENTS UNLIMITED )
> *
> ORA-01119: error in creating database file '/dev/vgrbs/rrbs01.dbf'
> ORA-27042: not enough space on raw partition to fullfill request
> Additional information: 2
>
> same statement got processed when LVs were recreated w/o stripe. didn't
> change size settings.
>
> 8.1.7.0 did take striped raw LVs for redo and rollback.
> user tablespaces can ALWAYS be created using striped raw LVs.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jessica Mao
> INET: jmao_at_portal.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jessica Mao
> INET: jmao_at_portal.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 11 2003 - 18:34:26 CDT
