{"id":2763,"date":"2019-03-13T13:44:13","date_gmt":"2019-03-13T10:44:13","guid":{"rendered":"https:\/\/sysdba.org\/?p=2763"},"modified":"2025-07-02T06:58:06","modified_gmt":"2025-07-02T06:58:06","slug":"installing-oracle-patchset-10-2-0-1-10-2-0-5","status":"publish","type":"post","link":"https:\/\/sysdba.org\/en\/installing-oracle-patchset-10-2-0-1-10-2-0-5\/","title":{"rendered":"Installing Oracle Patchset 10.2.0.1 – 10.2.0.5"},"content":{"rendered":"

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.<\/p>\n

 <\/p>\n

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).<\/p>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

[crayon]select * from v$version ;<\/p>\n

BANNER<\/p>\n

—————————————————————-<\/p>\n

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit<\/p>\n

PL\/SQL Release 10.2.0.1.0 – Production<\/p>\n

CORE 10.2.0.1.0 Production<\/p>\n

TNS for Linux: Version 10.2.0.1.0 – Production<\/p>\n

NLSRTL Version 10.2.0.1.0 – Production[\/crayon]
\nAs can be seen in the previous output, the database is on version 10.2.0.1.0.
\n[crayon]sql>shutdown immediate<\/p>\n

# reboot[\/crayon]
\nThe 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.<\/p>\n

 <\/p>\n

Log on as an Oracle user and open the files.
\n[crayon]$unzip p8202632_10205_Linux-x86-64.zip<\/p>\n

$cd Disk1
\n[\/crayon]<\/p>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

\"Installing<\/a>

Installing Oracle Patchset<\/p><\/div>\n

[crayon]
\n$sh runInstaller[\/crayon]
\n\"Installing<\/a><\/p>\n

 <\/p>\n

Run the root.sh script<\/strong> as a root user.<\/p>\n

 <\/p>\n

So far only the binaries have been updated. Now the database (oradata) needs to be updated, to do this we run the following command:
\n[crayon]$dbua[\/crayon]
\n\"Installing<\/a><\/p>\n

\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a>\u00a0\"Installing<\/a> \"Installing<\/a><\/p>\n

Check to see the latest versions.
\n[crayon]SQL> select * from v$version ;<\/p>\n

BANNER<\/p>\n

—————————————————————-<\/p>\n

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit<\/p>\n

PL\/SQL Release 10.2.0.5.0 – Production<\/p>\n

CORE 10.2.0.5.0 Production<\/p>\n

TNS for Linux: Version 10.2.0.5.0 – Production<\/p>\n

NLSRTL Version 10.2.0.5.0 – Production[\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":"

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.<\/p>\n","protected":false},"author":1,"featured_media":2766,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[384],"tags":[],"class_list":["post-2763","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-upgrade"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2763"}],"version-history":[{"count":2,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2763\/revisions"}],"predecessor-version":[{"id":4847,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2763\/revisions\/4847"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}