MetaLink article #144804.1 describes the process of migration from Oracle7 to Oracle9i...
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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 > > > [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] 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: > > > [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). > > > > > > > > > > > > > >Hemant K Chitale > >http://hkchital.tripod.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Hemant K Chitale > > INET: [EMAIL PROTECTED] > > > >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: [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.net > -- > Author: Cyril Thankappan > INET: [EMAIL PROTECTED] > > 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: [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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [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).