The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem.<\/p>\n
You probably plan to upgrade some old databases to the latest engine, at least those still running on 11.2. As you may know, 11.2\u00a0 is no more supported with premier support since January 2015: it’s time to think about an upgrade. Note that premier support for 12.1 will end in July 2018. Actually, running 11.2 and 12.1 databases will need extended support this year. And this extended support is not free, as you can imagine. There is still an exception for 11.2.0.4, Oracle is offering extended support to his customers until the end of 2018.<\/p>\n
<\/p>\n
Database upgrades have always been a lot of work, and often paired with a platform change. You need to recreate the databases, the tablespaces, export and import the data with datapump, correct the problems, and so on. Sometimes you can restore the old database to the new server with RMAN, but it’s only possible if the old engine is supported on your brand new server\/OS combination.<\/p>\n
As ODA is a longer term platform, you can think about ugrading the database directly on the appliance. Few years ago you should have been using dbua or catupgr, but now latest ODA package is including a tool for one command database upgrade. Let’s try it!<\/p>\n
odacli, the ODA Client Line Interface, has a new option: upgrade-database. Parameters are very limited:<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli upgrade-database -h\nUsage: upgrade-database [options]\nOptions:\n--databaseids, -i\nDatabase IDs to be upgraded\nDefault: []\n* --destDbHomeId, -to\nDB HOME ID of the destination\n--help, -h\nget help\n--json, -j\njson output\n--sourceDbHomeId, -from\nDB HOME ID of the source<\/pre>\nYou need to provide the database identifier (ODA stores a repository of all databases, db homes, jobs in a JavaDB\/DerbyDB database) and the destination db home identifier you want to upgrade to. The source db home id is optional as Oracle can determine it quite easily. There is no other option (for the moment): no pre-backup (advised) and no storage migration (switch between acfs and ASM) for example.<\/p>\n
Imagine you have an 11.2.0.4 database you want to upgrade to 12.2.0.1. Look for the id of your database ODAWS11:<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli list-databases\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n45ce9de7-3115-45b0-97b0-1384b8401e69 ODAWS Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\na948a32c-1cf2-42c8-88c6-88fd9463b297 DBTEST1 Si 12.2.0.1 false OLTP odb1s ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\nde281792-1904-4536-b42c-8a55df489b73 ODAWS11 Si 11.2.0.4 false OLTP odb2 ACFS Configured 72023166-a39c-4a93-98b7-d552029b2eeaodacli create-dbhome -v 12.1.0.2.171017<\/pre>\nNote that this database is configured with acfs, as 11.2 databases cannot be stored directly in an ASM 12c.<\/p>\n
You can upgrade this database to an existing db home only: if you want to upgrade it to a new home, just create this new home, for example:<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli create-dbhome -v 12.1.0.2.171017<\/pre>\nIf you want to use an existing home, just pick the db home id, for example here the one used by ODAWS database.<\/p>\n
Let’s do the upgrade:<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli upgrade-database -i de281792-1904-4536-b42c-8a55df489b73 -to 1ca87df9-4691-47ed-90a9-2a794128539d\n\n{\n\"jobId\" : \"782e65fd-8b2b-4d16-a542-1f5b2b78d308\",\n\"status\" : \"Created\",\n\"message\" : null,\n\"reports\" : [ ],\n\"createTimestamp\" : \"February 19, 2018 17:40:58 PM CET\",\n\"resourceList\" : [ ],\n\"description\" : \"Database service upgrade with db ids: [de281792-1904-4536-b42c-8a55df489b73]\",\n\"updatedTime\" : \"February 19, 2018 17:40:58 PM CET\"\n}<\/pre>\nodacli will schedule a job for that, as for other operations. You can follow the job with describe-job:<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli describe-job -i 782e65fd-8b2b-4d16-a542-1f5b2b78d308\n\nJob details\n----------------------------------------------------------------\nID: 782e65fd-8b2b-4d16-a542-1f5b2b78d308\nDescription: Database service upgrade with db ids: [de281792-1904-4536-b42c-8a55df489b73]\nStatus: Running\nCreated: February 19, 2018 5:40:58 PM CET\nMessage:\n\nTask Name Start Time End Time Status\n-------------------------------------------------- ----------------------------------- ----------------------------------- ----------\nSetting up ssh equivalance February 19, 2018 5:40:58 PM CET February 19, 2018 5:40:58 PM CET Success\nDatabase Upgrade February 19, 2018 5:40:58 PM CET February 19, 2018 5:40:58 PM CET Running<\/pre>\nYou can also look at the database alert.log file during the operation.<\/p>\n
Be patient! Database upgrade is taking time, at least 20 minutes for an empty database. And it seems that other jobs planned during the upgrade are in waiting state (like a create-database for example).<\/p>\n
[root@oda-dbi01 2018-02-19]# odacli describe-job -i 782e65fd-8b2b-4d16-a542-1f5b2b78d308\n\nJob details\n----------------------------------------------------------------\nID: 782e65fd-8b2b-4d16-a542-1f5b2b78d308\nDescription: Database service upgrade with db ids: [de281792-1904-4536-b42c-8a55df489b73]\nStatus: Running\nCreated: February 19, 2018 5:40:58 PM CET\nMessage:\n\nTask Name Start Time End Time Status\n-------------------------------------------------- ----------------------------------- ----------------------------------- ----------\nSetting up ssh equivalance February 19, 2018 5:40:58 PM CET February 19, 2018 5:40:58 PM CET Success\nDatabase Upgrade February 19, 2018 5:40:58 PM CET February 19, 2018 6:01:37 PM CET Success<\/pre>\nNow the upgrade seems OK, let’s check that:<\/p>\n
su - oracle\n. oraenv <<< ODAWS11\noracle@oda-dbi01:\/home\/oracle\/ # sqlplus \/ as sysdba\nSQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 19 18:01:49 2018\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL> select instance_name, version from v$instance;\n\nINSTANCE_NAME VERSION\n---------------- -----------------\nODAWS11 12.2.0.1.0\n\nsho parameter spfile\n\nNAME TYPE VALUE\n-------------------- -------- ---------------------------------------------------------------\nspfile string \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/dbs\/spfileODAWS11.ora<\/pre>\nEven the spfile has been moved to new home, quite nice.<\/p>\n
Let’s check the repository:<\/p>\n
[root@oda-dbi01 ~]# odacli list-databases\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n45ce9de7-3115-45b0-97b0-1384b8401e69 ODAWS Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\na948a32c-1cf2-42c8-88c6-88fd9463b297 DBTEST1 Si 12.2.0.1 false OLTP odb1s ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\nde281792-1904-4536-b42c-8a55df489b73 ODAWS11 Si 12.2.0.1 false OLTP odb2 ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\n\n<\/pre>\nEverything looks fine!<\/p>\n
Now let’s test the upgrade with a 12.1 database, ODAWS12. This one is using ASM storage:<\/p>\n
[root@oda-dbi01 ~]# odacli list-databases\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n45ce9de7-3115-45b0-97b0-1384b8401e69 ODAWS Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\na948a32c-1cf2-42c8-88c6-88fd9463b297 DBTEST1 Si 12.2.0.1 false OLTP odb1s ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\nde281792-1904-4536-b42c-8a55df489b73 ODAWS11 Si 12.2.0.1 false OLTP odb2 ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\n0276326c-cb6d-4246-9943-8289d29d6a4f DBTEST2 Si 12.2.0.1 false OLTP odb1s ACFS Configured 7d2bbaa0-da3c-4455-abee-6bf4ff2d2630\n24821a48-7474-4a8b-8f36-afca399b6def ODAWS12 Si 12.1.0.2 false OLTP odb2 ASM Configured 520167d7-59c8-4732-80a6-cc32ef745cec\n\n[root@oda-dbi01 2018-02-19]# odacli upgrade-database -i 24821a48-7474-4a8b-8f36-afca399b6def -to 1ca87df9-4691-47ed-90a9-2a794128539d\n{\n\"jobId\" : \"10a2a304-4e8e-4b82-acdc-e4c0aa8b21be\",\n\"status\" : \"Created\",\n\"message\" : null,\n\"reports\" : [ ],\n\"createTimestamp\" : \"February 19, 2018 18:36:17 PM CET\",\n\"resourceList\" : [ ],\n\"description\" : \"Database service upgrade with db ids: [24821a48-7474-4a8b-8f36-afca399b6def]\",\n\"updatedTime\" : \"February 19, 2018 18:36:17 PM CET\"\n}\n\n[root@oda-dbi01 ~]# odacli list-databases\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n45ce9de7-3115-45b0-97b0-1384b8401e69 ODAWS Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\na948a32c-1cf2-42c8-88c6-88fd9463b297 DBTEST1 Si 12.2.0.1 false OLTP odb1s ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\nde281792-1904-4536-b42c-8a55df489b73 ODAWS11 Si 12.2.0.1 false OLTP odb2 ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\n0276326c-cb6d-4246-9943-8289d29d6a4f DBTEST2 Si 12.2.0.1 false OLTP odb1s ACFS Configured 7d2bbaa0-da3c-4455-abee-6bf4ff2d2630\n24821a48-7474-4a8b-8f36-afca399b6def ODAWS12 Si 12.1.0.2 false OLTP odb2 ASM Updating 520167d7-59c8-4732-80a6-cc32ef745cec\n\n[root@oda-dbi01 2018-02-19]# odacli describe-job -i 10a2a304-4e8e-4b82-acdc-e4c0aa8b21be\n\nJob details\n----------------------------------------------------------------\nID: 10a2a304-4e8e-4b82-acdc-e4c0aa8b21be\nDescription: Database service upgrade with db ids: [24821a48-7474-4a8b-8f36-afca399b6def]\nStatus: Running\nCreated: February 19, 2018 6:36:17 PM CET\nMessage:\n\nTask Name Start Time End Time Status\n-------------------------------------------------- ----------------------------------- ----------------------------------- ----------\nSetting up ssh equivalance February 19, 2018 6:36:17 PM CET February 19, 2018 6:36:17 PM CET Success\nDatabase Upgrade February 19, 2018 6:36:17 PM CET February 19, 2018 6:58:05 PM CET Success\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID\n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n45ce9de7-3115-45b0-97b0-1384b8401e69 ODAWS Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\na948a32c-1cf2-42c8-88c6-88fd9463b297 DBTEST1 Si 12.2.0.1 false OLTP odb1s ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\nde281792-1904-4536-b42c-8a55df489b73 ODAWS11 Si 12.2.0.1 false OLTP odb2 ACFS Configured 1ca87df9-4691-47ed-90a9-2a794128539d\n0276326c-cb6d-4246-9943-8289d29d6a4f DBTEST2 Si 12.2.0.1 false OLTP odb1s ACFS Configured 7d2bbaa0-da3c-4455-abee-6bf4ff2d2630\n24821a48-7474-4a8b-8f36-afca399b6def ODAWS12 Si 12.2.0.1 false OLTP odb2 ASM Configured 1ca87df9-4691-47ed-90a9-2a794128539d\n\nsu - oracle\n. oraenv <<< ODAWS12\noracle@oda-dbi01:\/home\/oracle\/ # sqlplus \/ as sysdba\nSQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 19 18:59:08 2018\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\n\nSQL> select instance_name, version from v$instance;\n\nINSTANCE_NAME VERSION\n---------------- -----------------\nODAWS12 12.2.0.1.0\n\nSQL> sho parameter spfile\n\nNAME TYPE VALUE\n------------------ ---------- ---------------------------------------------\nspfile string +DATA\/ODAWS12\/PARAMETERFILE\/spfileodaws12.ora<\/pre>\nIt also worked fine with an 12.1 database: and it also took about 20 minutes for an empty database.<\/p>\n
You may have noticed that it’s possible to upgrade several databases in the same time by providing multiple database id. Not sure if you would do that in real life \ud83d\ude42<\/p>\n
upgrade-database is also available on ODA that are still using oakcli (nowadays only virtualized ODA I think), but as oakcli has no repository, database id has to be replaced by database name,\u00a0 and db home id by the name registered in classic oraInventory, for example:<\/p>\n
oakcli upgrade database -db ODAWS11 -to OraDb12201_home1<\/pre>\n<\/p>\n
This great feature will not revolutionize your DBA life, but it should help to upgrade your database with minimum effort.<\/p>\n","protected":false},"excerpt":{"rendered":"
The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some old databases to the latest engine, at least those still running on 11.2. As you […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[656,1046,15,79,96,209,219],"type_dbi":[],"class_list":["post-10902","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-12-2","tag-engineered-system","tag-migration","tag-oda","tag-oracle","tag-oracle-12c","tag-upgrade"],"acf":[],"yoast_head":"\n
One command database upgrade on ODA - dbi Blog<\/title>\n<meta name=\"description\" content=\"ODA upgrade-database feature odacli\" \/>\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\/one-command-database-upgrade-on-oda\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"One command database upgrade on ODA\" \/>\n<meta property=\"og:description\" content=\"ODA upgrade-database feature odacli\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-20T12:00:12+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 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\/one-command-database-upgrade-on-oda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"One command database upgrade on ODA\",\"datePublished\":\"2018-02-20T12:00:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\"},\"wordCount\":636,\"commentCount\":0,\"keywords\":[\"12.2\",\"Engineered system\",\"Migration\",\"ODA\",\"Oracle\",\"Oracle 12c\",\"Upgrade\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\",\"name\":\"One command database upgrade on ODA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-02-20T12:00:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"description\":\"ODA upgrade-database feature odacli\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"One command database upgrade on ODA\"}]},{\"@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\/0fb4bbf128b4cda2f96d662dec2baedd\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"One command database upgrade on ODA - dbi Blog","description":"ODA upgrade-database feature odacli","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\/one-command-database-upgrade-on-oda\/","og_locale":"en_US","og_type":"article","og_title":"One command database upgrade on ODA","og_description":"ODA upgrade-database feature odacli","og_url":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/","og_site_name":"dbi Blog","article_published_time":"2018-02-20T12:00:12+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"One command database upgrade on ODA","datePublished":"2018-02-20T12:00:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/"},"wordCount":636,"commentCount":0,"keywords":["12.2","Engineered system","Migration","ODA","Oracle","Oracle 12c","Upgrade"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/","url":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/","name":"One command database upgrade on ODA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-02-20T12:00:12+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"description":"ODA upgrade-database feature odacli","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/one-command-database-upgrade-on-oda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"One command database upgrade on ODA"}]},{"@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\/0fb4bbf128b4cda2f96d662dec2baedd","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/efaa5a7def0aa4cdaf49a470fb4a7641a3ea6e378ae1455096a0933f99f46d6b?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 15 years of experience in the field of Information Technology. Ten years ago, he specialized in the Oracle Database technology. His expertise is focused on database architectures, high availability (RAC), disaster recovery (DataGuard), backups (RMAN), performance analysis and tuning (AWR\/statspack), migration, consolidation and appliances, especially ODA (his main projects during the last years). Prior to joining dbi services, J\u00e9r\u00f4me Dubar worked in a Franco-Belgian IT service company as Database team manager and main consultant for 7 years. He also worked for 5 years in a software editor company as technical consultant across France. He was also teaching Oracle Database lessons for 9 years. J\u00e9r\u00f4me Dubar holds a Computer Engineering degree from the Lille Sciences and Technologies university in northern France. His branch-related experience covers the public sector, retail, industry, banking, health, e-commerce and IT sectors.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10902","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\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10902"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10902\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10902"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}