Re: Help: Upgrade DB from 7.3.2 to 7.3.3 apps stay at 10.7

Have you reinstalled SQL*Reports yet?
Look in you're old $ORACLE_HOME/reports or $ORACLE_HOME/patch directories for the install or patch upgrade script for this software and reinstall it in you're new oracle home. Also look for forms.install and crt.install in you're old oracle home and reinstall them. For instructions on installing them see your Oracle Applications 10.7 installation manual.
PS I agree that the 16.1 upgrade CD should include SQL*Reports, CRT utility and Forms2.4 but for some strange reason, eventhough they are required, it doesn't.

Leigh.

Boroskie wrote:
>
> The easiest way to port a 7.3.2 to a 7.3.3 is to create a new data base
> including all table spaces of the existing data base. Do a full export
> of the existing data base as system with everything. Do a full import
> and select the ignore create object errors. This should do it.
>
> Best Regards, Boroskie(boroskie_at_ix.netcom.com)
>
> In article <19971217035001.WAA17272_at_ladder02.news.aol.com>,
> jbhill62_at_aol.com says...
> >
> >
> >
> >The current apps is at 10.7 with RDBMS 7.3.2 and I need to upgrade the
 database
> >to 7.3.3.3.
> >After the server is upgraded the SmartClient with go to Rel 16.1. This
 is the
> >reason for the upgrade.
> >
> >I already made an attempt and failed miserably.
> >
> >These are the steps I followed.
> >
> >I log on as Oracle.
> >1) I made cold backups .....
> >2) I shutdown the Applmgr, the tns listerner and all database
 intances..
> >3) I installed 7.3.3 on a new oracle_home without creating a
> >database..including SQL*Net v2
> >4) I choose to relink
> >5) The 7.3.3 CD-ROM did not include CRT, SQL*Reports or SQL*Forms (any
 hints on
> >how to re-installed these products easily?
> >6) I log off and log on as root
> >7) I ran root.sh
> >8) I log off and log on as oracle
> >5) I copied the init<sid>.ora to the new $ORACLE_HOME/dbs directory and
 changed
> >enviroment variables for $ORACLE_HOME and $PATH.
> >6) I started the svrmmgrl and connected internal
> >7) I ran the scripts cat7303.sql, catalog.sql, catproc.sql to update
 the
> >database objects.
> >8) I start the database with no problems
> >
> >Status after all these...
> >
> >I can log on to the database, I can select, I can connect via sql*net
 from a
> >PC-Client, and the SmartClient can also connect but....
> >I can't run reports from the client, and many, MANY of the objects have
 become
> >invalid..
> >
> >What have I done wrong, what did I missed...?
> >
Received on Sun Jan 04 1998 - 00:00:00 CST