Thanks for your reply. Now I know whom to contact..for upgrades :)
Cyril On Thu, 23 Jan 2003 Bowes, Chris wrote : >A valid question. With a pseudo-valid answer, which is: Because >there is no >8i for hp-ux 10.20. We have been asking for upgrades and all for >the last >4+ years and the management answer is "do nothing until SAP is >completed". >SAP was started in 1996 and is still not complete and will >probably not be >until February of 2039. I only received permission for the 8.0 >upgrade >because 8i requires 2 upgrades: hpux (since "sap may replace the >hp-ux >boxes" I cannot get that conversion done) and oracle. 8.0.6 only >requires >oracle. Right now, I only have permission to convert 2 bases. >The other 6 >have to stay on 7.3.4, because "SAP may do away with that system, >so don't >do any requests on it or spend any real time on it..." > >"They don't call this place the resume stain for nothing" >(Dilbert). > >--Chris > > >-----Original Message----- >Sent: Thursday, January 23, 2003 3:14 AM >To: Multiple recipients of list ORACLE-L > > > >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: 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).
