How to resolve ORA-01096 Program Version incompatible with instance error
Hello Guru's:
I was in the process of executing a manual upgrade of an Oracle DB from 10.1.0.2 to 10.2.0.5
The 10.2.0.1 DB had been shutdown.
I had successfully installed the 10.2.0.5 patchset over the 10.2.0.1 installation.
Following the Readme.html documentation, I executed the startup upgrade command from sqlplus. I was suprised to get the message that ORACLE was already running and had to be shutdown first.
So I tried to shutdown the DB and that is when I encountered the ORA-01096 error.
I observed that the sqlplus version that started was 10.2.0.5 which I expected since this 10.2.0.5 patchset was supposed to be installed over the 10.2.0.1 installation.