DB upgrade problems from 8.1.7.3 to 8.1.7.4

From: Valdis Erglis <valdis_at_rt.nl>
Date: Mon, 10 Jun 2002 11:21:24 +0300
Message-ID: <ae1nh0$kko$1@milzis.latnet.lv>

Hello!

   We were trying to upgrade from 8.1.7.3 to 8.1.7.4 on AIX (32 bit) and Linux (Intel).
Just software upgrade was o.k. - no problems at all, but attempt to upgrade the database
was unsuccessfull. We followed all steps as described in patch set notes -

• disabling system triggers
• select * from duc$ where PACK='JIS$INTERCEPTOR$' ; -- nothing
• ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';

and after that we should run catalog, catproc and catrep scripts, but after invoking to run catalog script "?/rdbms/admin/catalog.sql" - nothing happens,
system does not returns to SQL prompt, OS is absolutely idle. Normally catalog script very fast compiles
packages and views, and prompts about it like ....
PACKAGE CREATED
VIEW CREATED
...

The same happens trying to upgrade on Linux from 8.1.7.3 to 8.1.7.4 Does anybody else experiencing the same problems? Any suggestions?

Workaround could be to export a DB under 8.1.7.3, upgrade Oracle software, create DB under 8.1.7.4
and import DB from dump, but it is silly way.

Thanks!
Valdis Received on Mon Jun 10 2002 - 03:21:24 CDT