MetaLink article #144804.1 describes the process of migration from Oracle7
to Oracle9i...
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, January 23, 2003 1:13 AM
>
> sorry for not being 'directly relevant'....
>
> But I was just wondering why
> you were upgrading from 7.3.4 to 8.0.6
> (and then having to upgrade to 9.2)
> when Oracle has provided for an upgrade path
> from 7.3.4 to 9.2
>
> Can you please let me know your reason
> for upgrading to 8.0.6
>
> Thanks
>
> Cyril
> On Wed, 22 Jan 2003 Hemant K Chitale wrote :
> >
> >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).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_rediffmail.com
>
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: Tim_at_SageLogix.com
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).
Received on Thu Jan 23 2003 - 07:24:06 CST
