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

I have went through the same upgrade a few times. The invalid objects are nothing to worry about. Run adadmin and choose to recompile the apps schema. Since there are going to be many invalid objects make sure to choose plenty of workers to speed things up.
Since you created a brand new installation you will have to install Reports Runtime 2.5 on the server under the new $ORACLE_HOME directory structure. Use the Designer 2000 CD to do this (this should be part of your CD package). SQL*Forms (2.4) and the CRT utility are on the Applications Installation CD.

JBHill62 wrote:

> 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 Tue Dec 16 1997 - 00:00:00 CST