RE: Upgrade from 7.3.4 to 8.0.6

So, did you have Replication setup in Oracle7 ? Reading Note:51119.1 "Performing Command Line Migration with MIG80 (Version 7 to 8.0)" .. after opening the database OPEN RESETLOGS and running CAT8000.sql, CATREP8M.sql is to be run ONLY if you previously ran CATREP.sql under Oracle7.

If you did not have the Replication Tabes setup in Oracle7, DO NOT run CATREP8M.sql. If you are planning to setup Replication in Oracle8, run CATREP.sql after completing the migration. Of course, Replication setup should be first done and tested in a test environment. Hemant

• "Bowes, Chris" <Chris.Bowes_at_kosa.com> wrote:

> Hi Hemant,
>
> Thank you for your response. I am calling it directly. I do
> the
> startup nomount, alter database convert, alter database open
> resetlogs.
> Then I fire off the cat8000 and then the catrep8m from svrmgrl.
>
> I think this is a problem in my dictionary in 7.3.4 as when I
> recreate the
> test base and do an export/import and convert the base, it goes
> flawlessly.
> This base has limited downtime available, so I cannot do that to the
> live
> base.
>
> Oracle support has told me to look at offline datafiles, but this is
> in the
> system tablespace, so if that file was offline or needed recovery,
> the base
> would be dead.
>
> Any thoughts?
>
> Thank you again,
>
> --Chris
>
>
> -----Original Message-----
> Sent: Tuesday, January 21, 2003 8:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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_at_Kosa.Com
>
> Hemant K Chitale
> My web site page is : http://hkchital.tripod.com
> <http://hkchital.tripod.com/>
>
> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
> Author:
> Hemant K Chitale INET: hkchital_at_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_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).
>
>

Hemant K Chitale
http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_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_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).