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).
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
select * from v$version ; BANNER ---------------------------------------------------------------- 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.
1 2 3 |
sql>shutdown immediate # reboot |
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.
1 2 3 |
$unzip p8202632_10205_Linux-x86-64.zip $cd Disk1 |
1 |
$sh runInstaller |
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:
1 |
$dbua |
Check to see the latest versions.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> select * from v$version ; BANNER ---------------------------------------------------------------- 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 |
Using RMAN for...
12 March 2019