On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed to do the next step: feed up the database with a manual restore or an RMAN duplicate.<\/p>\n
Unfortunately, creating an instance-only doesn’t work for me with 19.9. I tried to create a 12.2 instance and it failed immediatly:<\/p>\n
odacli list-dbhomes\n\nID Name DB Version Home Location Status\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\n1de83958-c38e-4b9b-9bd3-6c510ce2d3c3 OraDB19000_home1 19.9.0.0.201020 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1 Configured\nc191668f-10de-4184-b22e-b953648bf4a7 OraDB12201_home1 12.2.0.1.201020 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1 Configured\n\n\nodacli create-database -dh 'c191668f-10de-4184-b22e-b953648bf4a7' -u ADM001BD_765D -n ADM001BD -r asm -io\n\nodacli describe-job -i b86b28be-0d71-49db-a926-59b98d0c0d6c\n\nJob details\n----------------------------------------------------------------\n ID: b86b28be-0d71-49db-a926-59b98d0c0d6c\n Description: Database service creation with db name: ADM001BD\n Status: Failure\n Created: November 19, 2020 9:06:16 AM CET\n Message: DCS-10001:Internal error encountered: Failed to run sql in method : createTemporaryInstance.Unable to startup standby instance in nomount mode as output conatins ora- :\n\nTask Name Start Time End Time Status\n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nDatabase Service creation November 19, 2020 9:06:19 AM CET November 19, 2020 9:07:06 AM CET Failure\nDatabase Service creation November 19, 2020 9:06:19 AM CET November 19, 2020 9:07:06 AM CET Failure\nSetting up ssh equivalance November 19, 2020 9:06:19 AM CET November 19, 2020 9:06:19 AM CET Success\nCreating volume datADM001BD November 19, 2020 9:06:19 AM CET November 19, 2020 9:06:31 AM CET Success\nCreating volume rdoADM001BD November 19, 2020 9:06:31 AM CET November 19, 2020 9:06:43 AM CET Success\nCreating ACFS filesystem for DATA November 19, 2020 9:06:43 AM CET November 19, 2020 9:06:54 AM CET Success\nCreating ACFS filesystem for RECO November 19, 2020 9:06:54 AM CET November 19, 2020 9:07:05 AM CET Success\nDatabase Service creation November 19, 2020 9:07:05 AM CET November 19, 2020 9:07:06 AM CET Failure\nAuxiliary Instance Creation November 19, 2020 9:07:05 AM CET November 19, 2020 9:07:06 AM CET Failure\n<\/pre>\nLooking in the dcscli.log and dcs-agent.log (under \/opt\/oracle\/dcs\/log\/) didn’t help. But I found a new init file in the database home:<\/p>\n
cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/dbs\/initADM001BD.ora\ndb_name=ADM001BD\ndb_unique_name=ADM001BD_765D\nwallet_root=+DATA\/ADM001BD_765D,tde_configuration='KEYSTORE_CONFIGURATION=FILE'db_domain=intranet.ch\n<\/pre>\nIs an instance really able to start on this kind of pfile? Let’s try.<\/p>\n
cp \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/dbs\/initADM001BD.ora \/tmp\/\n\nsu - oracle\n\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\nexport ORACLE_SID=ADM001BD\n$ORACLE_HOME\/bin\/sqlplus \/ as sysdba\n\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 19 10:01:20 2020\n\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup nomount pfile='\/tmp\/initADM001BD.ora';\nLRM-00101: unknown parameter name 'wallet_root'\nLRM-00101: unknown parameter name 'tde_configuration'\nORA-01078: failure in processing system parameters\nexit\n<\/pre>\nNo for sure it can’t work. These wallet_root and tde_configuration parameters are for 18c and later databases. Don’t expect it will work on 11.2, 12.1 or 12.2.<\/p>\n
Let’s also try to start a 19c instance with this pfile:<\/p>\n
export ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\n$ORACLE_HOME\/bin\/sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 19 09:58:59 2020\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup nomount pfile='\/tmp\/initADM001BD.ora';\nORACLE instance started.\n\nTotal System Global Area 436204272 bytes\nFixed Size 8897264 bytes\nVariable Size 285212672 bytes\nDatabase Buffers 134217728 bytes\nRedo Buffers 7876608 bytes\n<\/pre>\nYes a 19c instance can start on it.<\/p>\n
I also tested an instance-only creation with odacli for a 19c and it worked fine, the init file being the same.<\/p>\n
Workaround<\/h2>\n
As my database is in Failed status, my registry is not very clean:<\/p>\n
odacli list-databases\n\nID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID \n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\n8ad09a72-fbcf-410f-854b-cd8c945fb3de DBTEST Si 19.9.0.0.201020 false Oltp Odb1s Asm Configured 1de83958-c38e-4b9b-9bd3-6c510ce2d3c3\n1d0de144-c93c-4f26-b00a-6cbbfafda6dd ADM001BD Si 12.2.0.1.201020 false Oltp Odb1 Asm Failed c191668f-10de-4184-b22e-b953648bf4a7\n<\/pre>\nWhat you could do is to delete this database (it will be correctly deleted) and create a complete database: it takes longer but it will succeed for whatever version you use:<\/p>\n
odacli create-database -cs WE8ISO8859P15 -no-c -dh 'c191668f-10de-4184-b22e-b953648bf4a7' -u ADM001BD_765D -n ADM001BD -r asm -s odb1s -no-co\n<\/pre>\nWhen database creation is complete, you need to remove all the files belonging to it, let’s generate a script for that purpose:<\/p>\n
su - oracle\n. oraenv <<< ADM001BD\nsqlplus -s \/ as sysdba\n\nset pages 0\nset lines 200\nset serveroutput off\nset feedback off\nspool \/tmp\/delete_files.txt\nselect 'asmcmd rm -rf '||file_name from dba_data_files;\nselect 'asmcmd rm -rf '||file_name from dba_temp_files;\nselect 'asmcmd rm -rf '||member from v$logfile;\nselect 'asmcmd rm -rf '||value from v$spparameter where name='control_files';\nselect 'asmcmd rm -rf '||value from v$parameter where name='spfile';\nspool off\nexit\n\nsu - grid\ncat \/tmp\/delete_files.txt\nasmcmd rm -rf +DATA\/ADM001BD_765D\/DATAFILE\/undotbs1.298.1056884325 \nasmcmd rm -rf +DATA\/ADM001BD_765D\/DATAFILE\/system.306.1056884289 \nasmcmd rm -rf +DATA\/ADM001BD_765D\/DATAFILE\/sysaux.304.1056884317 \nasmcmd rm -rf +DATA\/ADM001BD_765D\/DATAFILE\/users.309.1056884715 \nasmcmd rm -rf +DATA\/ADM001BD_765D\/TEMPFILE\/temp.310.1056884383 \nasmcmd rm -rf +RECO\/ADM001BD_765D\/ONLINELOG\/group_3.2390.1056884377 \nasmcmd rm -rf +RECO\/ADM001BD_765D\/ONLINELOG\/group_2.2389.1056884377 \nasmcmd rm -rf +RECO\/ADM001BD_765D\/ONLINELOG\/group_1.2386.1056884377 \nasmcmd rm -rf +RECO\/ADM001BD_765D\/CONTROLFILE\/current.2385.1056884373 \nasmcmd rm -rf +DATA\/ADM001BD_765D\/PARAMETERFILE\/spfile.308.1056884469 \nsh \/tmp\/delete_files.txt\nexit\n\nsu - oracle\n. oraenv <<< ADM001BD\nstartup force nomount;\n\nstartup failed: ORA-01078: failure in processing system parameters\nLRM-00109: could not open parameter file '\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/dbs\/initADM001BD.ora'\n\nstarting Oracle instance without parameter file for retrieval of spfile\nOracle instance started\n\nTotal System Global Area 1073741824 bytes\n\nFixed Size 8628936 bytes\nVariable Size 293602616 bytes\nDatabase Buffers 763363328 bytes\nRedo Buffers 8146944 bytes\n<\/pre>\nConclusion<\/h2>\n
This little bug is a bit disappointing, but there is a workaround. I opened a SR in MOS and will keep you informed if a better workaround is proposed by Oracle.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed […]<\/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":[604,224,1007,2145,2182,2183,2184,2185,14,2186,79,1831,365,2144,1532,1533,1534,1535,1330,1331,1332,1697,1698,1699],"type_dbi":[],"class_list":["post-15234","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-11-2-0-4","tag-12-1-0-2","tag-12-2-0-1","tag-19-9","tag-conatins-ora","tag-createtemporaryinstance","tag-dcs-10001","tag-failed-to-run-sql-in-method-createtemporaryinstance-unable-to-startup-standby-instance-in-nomount-mode","tag-i-o","tag-instance-only","tag-oda","tag-odacli-create-database","tag-oracle-database-appliance","tag-x5-2ha","tag-x6-2ha","tag-x6-2l","tag-x6-2m","tag-x6-2s","tag-x7-2ha","tag-x7-2m","tag-x7-2s","tag-x8-2ha","tag-x8-2m","tag-x8-2s"],"acf":[],"yoast_head":"\n
odacli create-database -io doesn't work for older databases in 19.9 - 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\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"odacli create-database -io doesn't work for older databases in 19.9\" \/>\n<meta property=\"og:description\" content=\"Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-20T18:10:08+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=\"5 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\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"odacli create-database -io doesn’t work for older databases in 19.9\",\"datePublished\":\"2020-11-20T18:10:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\"},\"wordCount\":322,\"commentCount\":0,\"keywords\":[\"11.2.0.4\",\"12.1.0.2\",\"12.2.0.1\",\"19.9\",\"conatins ora-\",\"createTemporaryInstance\",\"DCS-10001\",\"Failed to run sql in method : createTemporaryInstance.Unable to startup standby instance in nomount mode\",\"I\/O\",\"instance only\",\"ODA\",\"odacli create-database\",\"Oracle database appliance\",\"X5-2HA\",\"x6-2ha\",\"x6-2l\",\"x6-2m\",\"x6-2s\",\"X7-2HA\",\"X7-2M\",\"X7-2S\",\"x8-2ha\",\"x8-2m\",\"x8-2s\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\",\"name\":\"odacli create-database -io doesn't work for older databases in 19.9 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-11-20T18:10:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"odacli create-database -io doesn’t work for older databases in 19.9\"}]},{\"@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":"odacli create-database -io doesn't work for older databases in 19.9 - 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\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/","og_locale":"en_US","og_type":"article","og_title":"odacli create-database -io doesn't work for older databases in 19.9","og_description":"Introduction On ODA, you create your databases with odacli create-database. You can create a complete database, and it takes about 10 minutes, and you can also create an instance-only database. It will simply and quickly create a record in the ODA registry, start the instance with a basic pfile, and that’s it. Then you’re supposed […]","og_url":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/","og_site_name":"dbi Blog","article_published_time":"2020-11-20T18:10:08+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"odacli create-database -io doesn’t work for older databases in 19.9","datePublished":"2020-11-20T18:10:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/"},"wordCount":322,"commentCount":0,"keywords":["11.2.0.4","12.1.0.2","12.2.0.1","19.9","conatins ora-","createTemporaryInstance","DCS-10001","Failed to run sql in method : createTemporaryInstance.Unable to startup standby instance in nomount mode","I\/O","instance only","ODA","odacli create-database","Oracle database appliance","X5-2HA","x6-2ha","x6-2l","x6-2m","x6-2s","X7-2HA","X7-2M","X7-2S","x8-2ha","x8-2m","x8-2s"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/","url":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/","name":"odacli create-database -io doesn't work for older databases in 19.9 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-11-20T18:10:08+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-io-doesnt-work-for-older-databases-in-19-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"odacli create-database -io doesn’t work for older databases in 19.9"}]},{"@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\/15234","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=15234"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15234\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15234"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}