DBUA is what mostly used for for upgrade specially on windows. That is good and oracle recommended option. But for some reason I chose to do a manual upgrade on windows.
Starting with that I had database 10.2.0.3 running on windows server.
First of all I need to have all the details of current state of database. Below is what all I checked.
set ORACLE_SID=TJAIN
sqlplus ‘/ as sysdba’
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string G:\ORACLE\PRODUCT\10.2.0\DB_1\
DATABASE\SPFILETJAIN.ORA
