Problem with lob segments extending in 10.1.0.5

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

--
http://www.freelists.org/webpage/oracle-l