Problem with lob segments extending in 10.1.0.5
- From: "Allan Nelson" <anelson77388@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Jul 2007 07:26:38 -0500
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
Other related posts:
