In this scenario Oracle Enterprise Linux 5 (currently known as Oracle Linux) U6 will be upgraded from 10.2.0.1 to 10.2.0.5.0.
Open https://support.oracle.com and log on to the system with a username and a password. (As a customer, i.e. Oracle Partner, this account should be provided to your organization).
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit
PL/SQL Release 10.2.0.1.0 – Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 – Production
NLSRTL Version 10.2.0.1.0 – Production
As can be seen in the previous output, the database is on version 10.2.0.1.0.
The database can be upgraded without having to shutdown and restart, however it would require finding and shutting down any locked processes. This is why a shutdown is preferred.
Log on as an Oracle user and open the files.
Run the root.sh script as a root user.
So far only the binaries have been updated. Now the database (oradata) needs to be updated, to do this we run the following command:
Check to see the latest versions.
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit
PL/SQL Release 10.2.0.5.0 – Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 – Production
NLSRTL Version 10.2.0.5.0 – Production