Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Problem with lob segments extending in 10.1.0.5

Allan Nelson

2007-07-18

Replies:

Hello All,

I'm working on upgrading our E-Business suite database from 9.2.0.8 to 10.1.0.5 on HP-UX 11.11.  I was trying to convert to native plsql compilation and ran into a problem with extending LOB segments in SYSTEM.  More specifically: ORA-1691: unable to extend lobsegment SYS.SYS_LOB0001772641C00003$$ by 311072 in tablespace SYSTEM. 

Things went from bad to worse with: ORA-00600: internal error code, arguments: [17069], [0xC0000005B06FFDA0], [], [], [], [], [], []  This ora600 is known to Metalink as "Failed to pin library cache object after 50 attempts."  Distressing.

My question involves the logsegment error.  I tried adding a 2GB data file which had no effect.  I then turned on autoextend on one of the datafiles and Hey Presto!  the lobsegment errors went away although not the ORA-0600 errors.  Has anyone seen this before?  Is it a bug or a feature?

BTW, because of time constraints I went back to interpreted mode and got on with the upgrade.

Allan

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.