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

HTH,  Remco

-----Oorspronkelijk bericht-----
Van: Valdis Erglis [mailto:[EMAIL PROTECTED]]
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


_____________________________________________________________
Sign up for FREE email from RT.NL at http://www.rt.nl/

_____________________________________________________________
Promote your group and strengthen ties to your members with
[EMAIL PROTECTED] by Everyone.net  http://www.everyone.net/?btn=tag
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Valdis Erglis
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to