RE: RE: Upgrade from 7.3.4 to 8.0.6

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" <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: Bowes, Chris
  INET: Chris.Bowes_at_kosa.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).