Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Upgrade from 7.3.4 to 8.0.6

Re: Upgrade from 7.3.4 to 8.0.6

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 21 Jan 2003 05:54:46 -0800
Message-ID: <F001.00535C1D.20030121055446@fatcity.com>



Are you calling the catrep8m script directly ?  Or is it being called
from some other script [eg catproc.sql ?].
Are you using Advanced Replication ?
Hemant
At 02:28 PM 20-01-03 -0800, you wrote:

Hi everyone!

     Has anyone seen this and know a solution?  I am upgrading a base from 7.3.4 to 8.0.6.  Everything appears to go fine until the catrep8m script.  In that script I get several errors:

Statement processed.
                        (P.delivery_order < C.cscn)))))
                           *
ORA-00904: invalid column name
grant select on defcalldest to select_catalog_role
                *
ORA-00942: table or view does not exist
comment on table DEFCALLDEST is
                 *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.CALLNO is
                  *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DEFERRED_TRAN_ID is
                  *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DBLINK is
                  *
ORA-00942: table or view does not exist
DROP PUBLIC SYNONYM defcalldest
                    *
ORA-01432: public synonym to be dropped does not exist
Statement processed.
                              OR (P.delivery_order < C.cscn))))
                                    *
ORA-00904: invalid column name
Statement processed.
Statement processed.
Statement processed.

This then forces several dictionary packages invalid and they wont' recompile.

I have tried rebuilding the dictionary before I upgrade and rebuilding after I upgrade.   Neither one seems to work.  When I rebuild, the catrep script gives that same error.

So far Oracle hasn't been able to find it.  Has anyone seen this and know the fix?

Thanks in advance.

--Chris
Chris.Bowes@Kosa.Com

Hemant K Chitale
My web site page is :  http://hkchital.tripod.com

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: hkchital@singnet.com.sg Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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 Jan 21 2003 - 07:54:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US