Operating System - HP-UX
1748022 Members
5077 Online
108757 Solutions
New Discussion юеВ

Oracle upgrade problem u0800060.sql

 
SOLVED
Go to solution
Gino Castoldi_2
Honored Contributor

Oracle upgrade problem u0800060.sql

Hi,

HP-UX 11.0 Oracle 8.0.6 VPO 6.14.

We are in the process of upgrading Oracle database from release 8.0.6 to 8.1.7.

We're at the point where we need to run the upgrade script
"u0800060.sql". I cd'ed to the
$ORACLE_HOME_rdbms/admin - directory as user oracle -
($ORACLE_HOME=$ORACLE_BASE/product/8.1.7).

I logged into SVRMGRL and did a "connect internal".
The problem is when I run the script "u0800060.sql" it does not run.
SVRMGR> u0800060.sql
2>
3> ;
u0800060.sql
*
ORA-00900: invalid SQL statement
SVRMGR> quit

Any ideas as to what is wrong?

10 points to any good answer.
Thank you
Gino


2 REPLIES 2
A. Clay Stephenson
Acclaimed Contributor
Solution

Re: Oracle upgrade problem u0800060.sql

Unless this is a typo, you left off the '@'.
u0800060.sql
should be @u08000060.sql

If it ain't broke, I can fix that.
Gino Castoldi_2
Honored Contributor

Re: Oracle upgrade problem u0800060.sql

Hi Clay,

That did the trick!

Thank you again.