Re: 10gR2 for solaris (64bit), AIX and HP released

On 8/31/05, Magni Fabrizio <Fabrizio.Magni_at_rasnet.it> wrote:
>
>
> > Plan on identifying issues in your test upgrades in your test
> > environment, opening iTARs as necessary and waiting for
> > fixes. We've hit 4 different errors upgrading from 9.2. to
> > 10.1 - some had workarounds, some didn't. Your schedule
> > should be appropriately unaggressive.
> >
> > I'm not saying that 10.1.0.4 <http://10.1.0.4> is buggy.
> > I'm saying that upgrading from 9.2.0.5.x or 9.2.0.6 <http://9.2.0.6> to
> > 10.1.0.4 <http://10.1.0.4> is less than perfect.
> > (lets just say that its not a state function - its path
> > dependent and there be dragons along that path).
> >
> > exp/imp into a clean db if you can.
> >
>
> Hi Paul,
> as you mentioned 10g is not bugfree. I met some issues too:
>
> ORA-600 when importing from 8.1.7.0 <http://8.1.7.0> (during index
> creation),
> crash of the migration assistant from 9.2.0.4 <http://9.2.0.4> to 10.1.0.4<http://10.1.0.4>(minor issue
> since I was able to use the sql scripts),
> listener in 10.1.0.4 <http://10.1.0.4> sometimes freezes due to a problem
> in ONS
> registration (this is critical but a workaround does exist).

Fabrizio,

Hit something similar on win32.
The workaround was to disable dynamic registration of the instance with the listener (no biggie).

Plus some minor issues.
>
> My new tests on 10gR2 are not so good. Several issues with datapump.
> ORA-600 for unknow reasons (TARs still open) and problem with buffer
> locks.

Sure - I've seen issues with expdp and exp after a 9.2 to 10.1 upgrade. exp - too many rows returned - see Note:4283703.8. easily handled. I don't recall the note for the expdp issue, but upgrading workspace manager from 10.1.0.2 <http://10.1.0.2> to 10.1.0.5 <http://10.1.0.5> took care of it (other work-around was to uninstall it).

The showstopper bug that was encountered was not being able to exec dbms_stats.
Again, identified in testing so no sleep lost there.

Good luck.
Hopefully the issues you encounter will have already been posted by someone else in Metalink and solutions have been provided without waits for backports from 10.2.

Paul

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.

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