Re: RE: RE: Upgrade from 7.3.4 to 8.0.6

[Cyril Thankappan]

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

RE: RE: Upgrade from 7.3.4 to 8.0.6

[Bowes, Chris]

Title: 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-
From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 23, 2003 3:14 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Upgrade from 7.3.4 to 8.0.6




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)

Re: RE: Upgrade from 7.3.4 to 8.0.6

[Tim Gorman]

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
> > > 
> > >
> > > -- 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 

Re: RE: Upgrade from 7.3.4 to 8.0.6

[Cyril Thankappan]

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
> > 
> >
> > -- 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.co