10G Database Upgrade document

Current Release of database is 10.1.0.5 and the upgrade release should be 10.2.0.4
1. Download the following pre-requisites for Installation.
Software Requirments
10.2.0.2 software on Linux x86
10.2.0.2 companion on Linux x86 CD for ultrasearch
10.2.0.4 patchset Linux x86.
NOTE: No hardware or software level changes may be required for this upgrade at the O/S level.
Steps:
Please move current oraInventory to some other location.
Install 10.2.0.2 Software on a separate home. Follow installation steps.
Don’t create a database, so uncheck that option in the screens of Installation.
Once done it will ask for root.sh to be run. This completes the 10.2.0.2 installation.
After that go to companion software start the installation of that. Only thing to be taken care in that is to specify the ORACLE HOME correctly I,e in this case the new 10.2.0.2 home created. And in the screen select the 2nd option and rest Follow general instructions in that.

Once that completes apply the 10.2.0.4 patchset on the same ORACLE HOME I,e again 10.2.0.4.This completes the 10.2.0.4 Installation.
Once Completed stop the database and listener on 10.2.0.1 ORACLE HOME , and go to 10.2.0.4 ORACLE_HOME/bin.
Run dbua from there and select the database to be upgraded.If the database is not visible in the options check the oratab , if the entries are correct in that , if not update the same.
In the screens to follow uncheck the screens for Flash Recovery Area ,Configure Enterprise Manager and recompile invalid .Once done run utlrp.sql manually to recompile invalids.
Once done with that configure listener using netca or manually copying files from old ORACLE HOME to new ORACLE HOME and change the paths accordingly.
Issue Faced may be ORA-1031 Insufficient privileges
A connection to the database using SQL*Plus fails with same error:
% sqlplus /nolog
SQL> connect / as sysdba
ORA-1031 Insufficient privileges
Resolution
1.add the user oraclep to dba group in /etc/group.
2. add the group I,e dba16 to config.c in rdbms/lib in the 10.2.0.4 ORACLE_HOME.