{"id":10808,"date":"2018-02-06T21:32:19","date_gmt":"2018-02-06T20:32:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/"},"modified":"2018-02-06T21:32:19","modified_gmt":"2018-02-06T20:32:19","slug":"jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/","title":{"rendered":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nIf you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the names have changed and can be misleading: PSU for 11.2.0.4 (no Proactive Bundle Patch except for Engineered Systems). 12.1.0.2 can have SPU, PSU, or Proactive BP but the latest is highly recommended, especially now that it includes the adaptive statistics patches. 12.2.0.1 introduce the new RUR and RU, the latest one being the one recommended.<\/p>\n

To get things clear, there’s also the Master Note for Database Proactive Patch Program, with reference to one note per release. This blog post is my master note to link directly to the recommended updates for Oracle Database.
\n
\nMaster Note for Database Proactive Patch Program (Doc ID 756671.1)
\nhttps:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=756671.1<\/a><\/p>\n

11.2.0.4 – PSU<\/h3>\n

Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1)
\nhttps:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2285559.1<\/a>
\nParagraph ->\u00a011.2.0.4 Database Patch Set Update<\/p>\n

Latest as of Q1 2018 ->\u00a016-Jan-2018 11.2.0.4.180116 (Jan 2018) Database Patch Set Update (DB PSU)\u00a026925576<\/a>\u00a0(Windows:\u00a026925576<\/a>)<\/p>\n

12.1.0.2\u00a0 – ProactiveBP<\/h3>\n

Database 12.1.0.2 Proactive Patch Information (Doc ID 2285558.1)
\nhttps:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2285558.1<\/a>
\nParagraph\u00a0-> 12.1.0.2 Database Proactive Bundle Patches (DBBP)<\/p>\n

Latest as of Q1 2018\u00a0-> 16-Jan-2018 12.1.0.2.180116 Database Proactive Bundle Patch (Jan 2018) 12.1.0.2.180116\u00a027010930<\/a><\/p>\n

12.2.0.1 – RU<\/h3>\n

Database 12.2.0.1 Proactive Patch Information (Doc ID 2285557.1)
\nhttps:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2285557.1<\/a>
\nParagraph\u00a0-> 12.2.0.1 Database Release Update (Update)<\/p>\n

Latest as of Q1 2018\u00a0->\u00a016-Jan-2018 12.2.0.1.180116 (Jan 2018) Database Release Update\u00a027105253<\/a>\u00a0(Windows: 12.2.0.1.180116 WIN DB BP\u00a027162931<\/a>)
\n <\/p>\n

Don’t forget SQL Developer<\/h3>\n

In the 12c<\/i> Oracle Home SQL Developer is installed, but you should update it to the latest version.
\nDownload the following from http:\/\/www.oracle.com\/technetwork\/developer-tools\/sql-developer\/downloads\/index.html<\/a>
\n– The SQL Developer zip for ‘Other Platforms’, currently 17.4<\/a>
\n– The SQLcl zip for ‘All Platforms’, currently 17.4<\/a><\/p>\n

On the server, remove, or rename the original directory:<\/p>\n

mv $ORACLE_HOME\/sqldeveloper $ORACLE_HOME\/sqldeveloper.orig \n<\/code><\/pre>\n
Unzip what you have downloaded:<\/p>\n
unzip -d $ORACLE_HOME\/ sqldeveloper-*-no-jre.zip\nunzip -d $ORACLE_HOME\/sqldeveloper sqlcl-*-no-jre.zip<\/code><\/pre>\n
I suggest to have a login.sql which sets the beautiful ansiconsole for SQLcl:<\/p>\n
echo \"set sqlformat ansiconsole\" > $ORACLE_HOME\/sqldeveloper\/sqlcl\/login.sql\n<\/code><\/pre>\n
On 12.2 you can run SQLcl just with ‘sql’ (and same arguments as sqlplus: \/ as sysdba or \/nolog,…) because this is what is defined in $ORACLE_HOME\/bin.
\nHowever, it sets the current working directory and i prefer to keep the current one as it is probably were I want to run scripts from. <\/p>\n
Then I add the following aliases in .bashrc<\/p>\n
alias sqlcl='JAVA_HOME=$ORACLE_HOME\/jdk SQLPATH=$ORACLE_HOME\/sqldeveloper\/sqlcl bash $ORACLE_HOME\/sqldeveloper\/sqlcl\/bin\/sql'\nalias sqldev='$ORACLE_HOME\/sqldeveloper\/sqldeveloper.sh'<\/code><\/pre>\n
When running SQL Developer for the first time you can create automatically a ‘\/ as sysdba’ connection (but remember this is not a good practice to connect like this) and a connection for each user declared in the database: Right click on Connections and Create Local Connections<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[96,1276],"type_dbi":[],"class_list":["post-10808","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-updates"],"acf":[],"yoast_head":"\nJAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-06T20:32:19+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU\",\"datePublished\":\"2018-02-06T20:32:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\"},\"wordCount\":471,\"commentCount\":0,\"keywords\":[\"Oracle\",\"Updates\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\",\"name\":\"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-02-06T20:32:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/","og_locale":"en_US","og_type":"article","og_title":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU","og_description":"By Franck Pachot . If you want to apply the latest patches (and you should), you can go to the My Oracle Support Recommended Patch Advisor. But sometimes it is not up-todate. For example, for 12.1.0.2 only the PSU is displayed and not the Proactive Bundle Patch, which is highly recommended. And across releases, the […]","og_url":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/","og_site_name":"dbi Blog","article_published_time":"2018-02-06T20:32:19+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU","datePublished":"2018-02-06T20:32:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/"},"wordCount":471,"commentCount":0,"keywords":["Oracle","Updates"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/","url":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/","name":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-02-06T20:32:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/jan18-database-11gr2-psu-12cr1-proactivebp-12cr2-ru\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"JAN18: Database 11gR2 PSU, 12cR1 ProactiveBP, 12cR2 RU"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10808"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10808\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10808"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}