we are upgarding oracle from 126.96.36.199 to 10.2.0.2.
our system configuration :
Oracle : 188.8.131.52
OS - HP-UX 11.23
Hardware : HP Itanium server
We are upgrading oracle 184.108.40.206 to 10.2.0.2.
as a first step ( upgrade guide as on 21/02/2007)
i have upgraded from 220.127.116.11 to 18.104.22.168 and it is successfull.
it showed me 22.214.171.124. 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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
so it means until now it is in 10.2.0.1
and the version is
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
SQL> select version from v$instance;
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