v$version shows old version though patch upgarde doen
577162Jul 12 2010 — edited Jul 13 2010Hi all,
one of my friend is trying to apply patch, so that my database (9.2.0.6 & 32-bit) moves to (9.2.0.8 & 64-bit).
After upgrade, he could see the components of the database is 9.2.0.8 version from dba_registry view, but the database version is still 9.2.0.6 in v$version for that QA database.
Please let me know which is blocking the database version not to change after upgrade or how can upgrade the version?
As a trail & error he did, same steps to upgrade a testdb and it worked (the version and the bit upgraded to 9.2.0.8 and 64-bit respectively)
These are the below steps he followed, please let me know if you have any suggestions.
Older Oracle_home 9i32bit (9.2.0.6 s/w and 32-bit) ---source
New Oracle_home 9208patch (9.2.0.8 s/w and 64-bit) --destination
Run the 9.2.0.8profile
export ORACLE_HOME
export ORACLE_SID
startup migrate
@?ORACLE_HOME/rdbms/admin/catpatch.sql
….
---
The components are upgraded but version is still the older one.
Thanks in advance.