Re: asm & smallfile limitation

hm....

i got this on metalink...and this is match with my oracle version except OS.

Bug No.         6281407
Filed   27-JUL-2007     Updated         30-AUG-2007
Product         Oracle Server - Enterprise Edition      Product Version         
10.2.0.3
Platform        Solaris Operating System (SPARC 64-bit)         Platform 
Version        10
Database Version        10.2.0.3        Affects Platforms       Generic
Severity        Minimal Loss of Service         Status  Code Bug 
(Response/Resolution)
Base Bug        N/A     Fixed in Product Version        No Data

Problem statement:

GOT ORA-1688 TABLESPACE HAS AUTOEXTEND ENABLED WITH DISKSPACE AVAILABLE

btw thanks for the respons.

regards
ujang


On 10/30/07, Frits Hoogland <frits.hoogland@xxxxxxxxx> wrote:
> unhvsperft01:/oracle/client/9.2.0.4/bin$ ./oerr ora 1691
> 01691, 00000, "unable to extend lob segment %s.%s by %s in tablespace %s"
> // *Cause:  Failed to allocate an extent for lob segment in tablespace.
>  // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
> //         files to the tablespace indicated.
>
> your session is unable to allocate an extent for the lobsegment in the
> tablespace, because the tablespace has ran out of space. make more space
> available by adding a datafile.
>
> frits
>
>
> On 10/30/07, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote:
> > peter,
> >
> > this is the error
> >
> >
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 8192 in tablespace
>             AUDITEXTENDEDINFO_TABLOB
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 128 in tablespace
>            AUDITEXTENDEDINFO_TABLOB
> >
> > ORA-1691: unable to extend lobsegment
> AUDITTRAIL.SYS_LOB0000059312C00003$$ by 8192 in tablespace
>             AUDITEXTENDEDINFO_TABLOB
> >
> >
> > --
> >
> > ..ujang
> > "There are four types of lies - lies, damn lies, statistics and average"
> > http://ujang-id.blogspot.com
> >
> >
> >
> > On 10/29/07, Peter van Rijn <petervanrijn@xxxxxxxxx > wrote:
> > > Which *exact* error message did you get?
> > > There can be numerous reasons why it is unable to extent.
> > >
> > > Peter
> > >
> > >
> > > 2007/10/29, Ujang Jaenudin < ujang.jaenudin@xxxxxxxxx >:
> > >
> > > > all,
> > > >
> > > > I have this machine:
> > > > solaris 10
> > > > oracle 10.2.0.3 rac 2 nodes
> > > > asm
> > > >
> > > > a smallfile tablespace with 5 datafiles, each 32GB.
> > > >
> > > > but when datafiles rech 20GB, oracle complaint that unable to extent
> on that
> > > > tablespace....
> > > > does anyone have the experience? or have metalink note?
> > > >
> > > > --
> > > > regards
> > > > ujang
--
http://www.freelists.org/webpage/oracle-l

Other related posts: