Oracle-L: RE: DB upgrade problems from 8.1.7.3 to 8.1.7.4

From: Daemen, Remco <Remco.Daemen_at_werklinq.nl>
Date: Tue, 11 Jun 2002 07:53:32 -0800
Message-ID: <F001.0047A623.20020611075332@fatcity.com>

Try replacing "?" with your ORACLE_HOME directory ...

HTH, Remco

-----Oorspronkelijk bericht-----

Van: Valdis Erglis [mailto:valdis_at_rt.nl] Verzonden: dinsdag 11 juni 2002 16:43
Aan: Multiple recipients of list ORACLE-L Onderwerp: DB upgrade problems from 8.1.7.3 to 8.1.7.4

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Daemen, Remco
INET: Remco.Daemen_at_werklinq.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