Post installation got failes on QA during Oracle patch upgrade

[Former Member]

Dear all,

Oracle patch has been upgraded from 10.2.0.2 to 10.2.0.4 .

i got below error during post upgrade .

ROOT@SAPDEVQA:/#su - orairq

SAPDEVQA:orairq 1> sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 10 22:51:22 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> STARTUP UPGRADE

ORACLE instance started.

Total System Global Area 4513071104 bytes

Fixed Size 2089960 bytes

Variable Size 2264927256 bytes

Database Buffers 2231369728 bytes

Redo Buffers 14684160 bytes

Database mounted.

Database opened.

SQL> SPOOL upgrade_info.log

SQL> @/rdbms/admin/utlu102i.sql

SP2-0310: unable to open file "/rdbms/admin/utlu102i.sql"

SQL> @/rdbms/admin/utlu102i.sql

Kindly suggets...

[Former Member]

Issue has been resolved after follow the below steps

Start the database in the UPGRADE mode:

SQL> STARTUP UPGRADE

Set the system to spool results to a log file for later analysis:

SQL> SPOOL upgrade_info.log

Run the Pre-Upgrade Information Tool:

SQL> @/rdbms/admin/utlu102i.sql

Turn off the spooling of script results to the log file:

SQL> SPOOL OFF

[Former Member]

Have you checked whether user is able to open the file? I mean does user have the suff permissions to open the below file?

rdbms/admin/utlu102i.sql

Regards,

Nick Loy

[volker_borowski2]

> SQL> @/rdbms/admin/utlu102i.sql

Hi,

ORACLE_HOME is missing, which is the questionmark.

So it is

 @?/rdbms/admin/utlu102i.sql

Volker