Re: Oracle 7.3 on HPUX 10.01 - any results yet?

In article <4u8ojl$r7c_at_main.dscga.com>, Bolen Coogler <bcoogler_at_dscga.com> writes
>pjackson_at_prairienet.org (Paul C. Jackson) wrote:
>
>
>>Has anyone taken the leap to 7.3 yet? If
>>so, how is it working? Any bugs?
 

>>We are very apprehensive since our last upgrade attempt.
 

>>Any insight would be appreciated.
 

>>Thanks,
 

>>pjackson_at_prairienet.org
>>--
>
>During a benchmark, we installed Oracle 7.3.2 on an HP T520 running
>HPUX 10.01, then ran an import from an Oracle 7.2.3. instance. At
>first, everything seemed find. Then, when we shut down 7.3 and
>restarted, SQLPLUS would abort. After putting in a call to Oracle,
>their suggestion was to re-run CATPROC (from SVRMGRL) and try again.
>It worked. SQLPLUS ran find... until the next time we shut down
>Oracle. We found ourselves having to re-run CATPROC after every
>startup.
>
>Another suggested work-around was to use the 7.2 version of SQLPLUS
>with 7.3. We decided to stick with Oracle 7.2.3 for the time being.
>
>This is a known problem, and only effects customers migrating from
>Oracle 7.2 to 7.3. At last check, there is a current bug fix in the
>works. Unfortunately, the pad I wrote the bug number on got left
>behind at the benchmark site--it's gone with the TAR. Oh well.
>
> --Bolen Coogler
>

That's an interesting one. I assume you did a complete database import. If you create the user(s) and then just import by user then you should not have this problem.

I have successfully upgraded from 7.1.4 and 7.2.2 to 7.3.2 using the upgrade scripts without any problems.

-- 
Chris Dipple
Production DBA, Royal Bank of Scotland