Oracle-L: DB upgrade problems from 8.1.7.3 to 8.1.7.4

From: Valdis Erglis <valdis_at_rt.nl>
Date: Tue, 11 Jun 2002 06:43:22 -0800
Message-ID: <F001.0047A3AE.20020611064322@fatcity.com>

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 a silly way.

Thanks!
Valdis

Promote your group and strengthen ties to your members with email@yourgroup.org by Everyone.net http://www.everyone.net/?btn=tag

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Valdis Erglis
  INET: valdis_at_rt.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 11 2002 - 09:43:22 CDT