Oracle 10g Upgrade error

26 Views

Hi experts

we are upgarding oracle from 9.2.0.6 to 10.2.0.2.

our system configuration :

Oracle : 9.2.0.6

OS - HP-UX 11.23

Hardware : HP Itanium server

We are upgrading oracle 9.2.0.6 to 10.2.0.2.

as a first step ( upgrade guide as on 21/02/2007)

i have upgraded from 9.2.0.6 to 9.2.0.8 and it is successfull.

it showed me 9.2.0.8. and then we dumped the oracle software

of 10.2 of HP-UX itanium (from DVD) to the server and installed the

software and it is succesfull , while installing it showed 10.2.0.1. adn then

i have applied 10.2.0.2 patchset to the software that also successful and the final complaetion is showed as "10.2.0.2 patschset 1 was successfully installed".

and then by dbua command we triggered the upgradation and then also it succesful.

but when we try to query the version from the oracle it showed me 10.2.0.1 and then logged in sqlplus it showed as

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 21 00:15:52 2007

Connected to an idle instance.

so it means until now it is in 10.2.0.1

and the version is

SQL> startup

ORACLE instance started.

Total System Global Area 910163968 bytes

Fixed Size 1994984 bytes

Variable Size 521408280 bytes

Database Buffers 384565248 bytes

Redo Buffers 2195456 bytes

Database mounted.

Database opened.

SQL> select version from v$instance;

VERSION

-

10.2.0.1.0

what to do. I have installed and the 10.2.0.1 software also upgraded and the database is also upgraded by the dbua. then how it shows this version

PLease help

regards

bala