{"id":14978,"date":"2023-08-08T13:49:14","date_gmt":"2023-08-08T16:49:14","guid":{"rendered":"https:\/\/dev.dbarj.com.br\/?p=14978"},"modified":"2023-08-08T13:49:14","modified_gmt":"2023-08-08T16:49:14","slug":"oradiff-find-the-differences-between-two-oracle-database-releases","status":"publish","type":"post","link":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/","title":{"rendered":"ORAdiff &#8211; Find the differences between two Oracle Database releases"},"content":{"rendered":"<p>We are happy to announce that <a href=\"https:\/\/oradiff.oracle.com\" target=\"_blank\" rel=\"noopener\">ORAdiff<\/a> is live!<\/p>\n<p>ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles. It reports differences in parameters, privileges, users and roles, reserved words, patch fixes, database homes, objects, and more. It can also be used to obtain an inventory of these items for a particular release!<\/p>\n<p id=\"WahCQZp\"><img loading=\"lazy\" decoding=\"async\" width=\"3072\" height=\"1338\" class=\"alignnone size-full wp-image-14979 \" src=\"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png\" alt=\"\" srcset=\"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png 3072w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-300x131.png 300w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-1024x446.png 1024w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-768x335.png 768w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-1536x669.png 1536w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-2048x892.png 2048w, https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66-870x379.png 870w\" sizes=\"auto, (max-width: 3072px) 100vw, 3072px\" \/><\/p>\n<p>We started developing this with database developers and support engineers in mind, but ORAdiff is meant for everybody who works with Oracle Database. Whether you are just curious about how many bug fixes will add by moving from 19.11.0 to 19.15.0, or whether you program tools in OCI, this tool may be very helpful to you, too.<\/p>\n<h4>Some of the most common questions that ORAdiff can help to answer:<\/h4>\n<ul>\n<li>When was a parameter introduced?<\/li>\n<li>Which patch release changed a default value?<\/li>\n<li>Was a bug fix delivered in a given Release Update?<\/li>\n<li>Which privileges were removed from a default role in a given version?<\/li>\n<li>Which columns were added in 19.13.0 to a specific CDB view?<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4>Why we created ORAdiff?<\/h4>\n<p>We created the system because it helps us learn about changes in our release evolution. Yes, the official documentation is quite helpful! But, comparing documentation from two different versions can be a chore, and with ORAdiff you can now compare releases, or RUs, with just a few mouse clicks on objects or files or fixes or parameters. You can even generate a comprehensive report showing all the differences in the database dictionary between two releases or even release updates.<\/p>\n<h4><strong>How frequently is the ORAdiff database of release information updated?<\/strong><\/h4>\n<p>ORAdiff data is refreshed when a new Release Update is released (every quarter).<\/p>\n<b>Have you enjoyed? Please leave a comment or give a ?!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-14978 jlk' href='javascript:void(0)' data-task='like' data-post_id='14978' data-nonce='b7aaf4ff99' rel='nofollow'><img class='wti-pixel' src='https:\/\/dev.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-14978 lc'>+15<\/span><\/a><\/div><\/div> <div class='status-14978 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>We are happy to announce that ORAdiff is live! ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles. It reports differences in parameters, privileges, users and roles, reserved words, patch fixes, database homes, objects, and more. It can also be used to obtain an inventory &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-14978","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ORAdiff - Find the differences between two Oracle Database releases - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"ORAdiff &#8211; Find the differences between two Oracle Database releases\",\"datePublished\":\"2023-08-08T16:49:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/\"},\"wordCount\":294,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/img_64d270e739b66.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/\",\"name\":\"ORAdiff - Find the differences between two Oracle Database releases - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/img_64d270e739b66.png\",\"datePublished\":\"2023-08-08T16:49:14+00:00\",\"description\":\"ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/img_64d270e739b66.png\",\"contentUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/img_64d270e739b66.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2023\\\/08\\\/oradiff-find-the-differences-between-two-oracle-database-releases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORAdiff - Find the differences between two Oracle Database releases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORAdiff - Find the differences between two Oracle Database releases - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles.","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:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#article","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/"},"author":{"name":"DBA RJ","@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"ORAdiff &#8211; Find the differences between two Oracle Database releases","datePublished":"2023-08-08T16:49:14+00:00","mainEntityOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/"},"wordCount":294,"commentCount":4,"publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/","url":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/","name":"ORAdiff - Find the differences between two Oracle Database releases - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#primaryimage"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#primaryimage"},"thumbnailUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png","datePublished":"2023-08-08T16:49:14+00:00","description":"ORAdiff is an Oracle tool that allows you to compare two Oracle Database releases and optionally incremental patch bundles.","breadcrumb":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#primaryimage","url":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png","contentUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2023\/08\/img_64d270e739b66.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dev.dbarj.com.br\/en\/2023\/08\/oradiff-find-the-differences-between-two-oracle-database-releases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"ORAdiff - Find the differences between two Oracle Database releases"}]},{"@type":"WebSite","@id":"https:\/\/dev.dbarj.com.br\/en\/#website","url":"https:\/\/dev.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=14978"}],"version-history":[{"count":1,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14978\/revisions"}],"predecessor-version":[{"id":14981,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/14978\/revisions\/14981"}],"wp:attachment":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=14978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=14978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=14978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}