{"id":13459,"date":"2020-02-14T15:21:23","date_gmt":"2020-02-14T14:21:23","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/"},"modified":"2020-02-14T15:21:23","modified_gmt":"2020-02-14T14:21:23","slug":"odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/","title":{"rendered":"odacli create-database extremely slow on ODA X8-2 with 19.5"},"content":{"rendered":"

Introduction<\/h2>\n

ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that can be extremely slow on these servers if you are using ODA 19.5.<\/p>\n

Edit (April 2020): actually this bug is related to the Linux kernel. There will not be a patch to solve the problem. 19.6 should have a new kernel without this bug.<\/p>\n

Deployment, appliance creation and core configuration<\/h2>\n

X8-2 reimaging is fine, and appliance creation is done without any problem on X8-2. Don’t hesitate to create a DBTEST database during appliance creation, it’s a good practise to check if everything is OK after deployment. Once appliance creation is done you should find these pmon processes running on the system:<\/p>\n

[root@oda-cr-test ~]# ps -ef | grep pmon<\/strong>
\noracle 17600 1 0 11:49 ? 00:00:00 asm_pmon_+ASM1
\noracle 20604 1 0 11:50 ? 00:00:00 apx_pmon_+APX1
\noracle 21651 1 0 11:50 ? 00:00:00 ora_pmon_DBTEST
\nroot 81984 37658 0 13:44 pts\/0 00:00:00 grep --color=auto pmon
\n<\/code><\/p>\n

If you deployed your ODA for Enterprise Edition, you should now apply the core configuration, understand disabling the unlicensed cores. It’s better to do that immediatly after deployment to avoid using cores you didn’t pay for. One EE license is 2 cores, 2 licenses is 4 cores, etc:<\/p>\n

odacli update-cpucore -c 2<\/strong><\/code><\/p>\n

Core configuration is done within a few seconds, you could check with this command:<\/p>\n

odacli describe-cpucore<\/strong>
\nNode Cores Modified Job Status
\n----- ------ ------------------------------ ---------------
\n0 2 January 27, 2020 9:56:37 AM CET Configured
\n<\/code><\/p>\n

Starting from now, you can create your own databases.<\/p>\n

Database creation: extremely slow and eventually failing<\/h2>\n

Without additional steps you can create your very first DB. I’m using basic shape for all my databases, as I fine tune everything later using a SQL script (SGA and PGA targets, undo_retention, archive_lag_target, redolog configuration, options, etc):<\/p>\n

[root@oda-cr-test ~]# odacli list-dbhomes<\/strong>
\nID Name DB Version Home Location Status
\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
\nae442886-6bcc-497c-8e16-2e8b4e55157e OraDB19000_home1 19.5.0.0.191015 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1 Configured
\nodacli create-database -m MAnager_2020_dbi -cs AL32UTF8 -no-c -u DBSUS -dh 'ae442886-6bcc-497c-8e16-2e8b4e55157e' -n DBSUS -s odb1s -l AMERICAN -dt AMERICA -no-co -r asm<\/strong>
\n<\/code><\/p>\n

ASM is a better solution than acfs for me: no need to have “real” filesystems and optimal storage usage.<\/p>\n

Creating the database lasts normally less than 10 minutes, but not this time:<\/p>\n


\nodacli describe-job -i 94726b11-ea0c-46b0-ab55-6d709ef747d3<\/strong>
\nJob details
\n----------------------------------------------------------------
\n ID: 94726b11-ea0c-46b0-ab55-6d709ef747d3
\n Description: Database service creation with db name: DBSUS
\n Status: Failure
\n Created: February 13, 2020 11:24:53 AM CET
\n Message: DCS-10001:Internal error encountered: Fail to create User tablespace .
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\nDatabase Service creation February 13, 2020 11:24:53 AM CET February 13, 2020 6:23:16 PM CET Failure
\nDatabase Service creation February 13, 2020 11:24:53 AM CET February 13, 2020 6:23:16 PM CET Failure
\nSetting up ssh equivalance February 13, 2020 11:26:26 AM CET February 13, 2020 11:26:36 AM CET Success
\nDatabase Service creation February 13, 2020 11:26:36 AM CET February 13, 2020 6:23:11 PM CET Success
\nDatabase Creation February 13, 2020 11:26:36 AM CET February 13, 2020 6:21:37 PM CET Success
\nChange permission for xdb wallet files February 13, 2020 6:21:37 PM CET February 13, 2020 6:21:38 PM CET Success
\nPlace SnapshotCtrlFile in sharedLoc February 13, 2020 6:21:38 PM CET February 13, 2020 6:22:06 PM CET Success
\nSqlPatch upgrade February 13, 2020 6:23:02 PM CET February 13, 2020 6:23:05 PM CET Success
\nRunning dbms_stats init_package February 13, 2020 6:23:05 PM CET February 13, 2020 6:23:07 PM CET Success
\nupdating the Database version February 13, 2020 6:23:07 PM CET February 13, 2020 6:23:11 PM CET Success
\ncreate Users tablespace February 13, 2020 6:23:11 PM CET February 13, 2020 6:23:16 PM CET Failure
\nCreating Users tablespace February 13, 2020 6:23:11 PM CET February 13, 2020 6:23:16 PM CET Failure
\n<\/code><\/p>\n

I took 7 hours and it finished with a failure!<\/p>\n

Failure can be slightly different, for example :
\nDCS-10001:Internal error encountered: configure snapshot control file for databaseDBSUS.<\/code><\/p>\n

Troubleshooting<\/h2>\n

Creation of the DBTEST database was fine at appliance creation. So what changed between deployment and database creation? The cpu-core configuration. Something is probably wrong with this core configuration.<\/p>\n

dbca log is not very interesting regarding our problem:<\/p>\n

cat \/u01\/app\/oracle\/cfgtoollogs\/dbca\/DBSUS\/DBSUS.log<\/strong>
\n[ 2020-02-13 11:37:46.492 CET ] Prepare for db operation
\nDBCA_PROGRESS : 10%
\n[ 2020-02-13 11:38:22.441 CET ] Registering database with Oracle Restart
\nDBCA_PROGRESS : 14%
\n[ 2020-02-13 11:38:51.365 CET ] Copying database files
\nDBCA_PROGRESS : 43%
\n[ 2020-02-13 12:09:44.044 CET ] Creating and starting Oracle instance
\nDBCA_PROGRESS : 45%
\nDBCA_PROGRESS : 49%
\nDBCA_PROGRESS : 53%
\nDBCA_PROGRESS : 56%
\nDBCA_PROGRESS : 62%
\n[ 2020-02-13 15:44:47.163 CET ] Completing Database Creation
\nDBCA_PROGRESS : 68%
\n[ 2020-02-13 17:48:28.024 CET ] [WARNING] ORA-13516: AWR Operation failed: AWR Schema not initialized
\nORA-06512: at \"SYS.DBMS_SWRF_INTERNAL\", line 356
\nORA-06512: at \"SYS.DBMS_SWRF_INTERNAL\", line 389
\nORA-06512: at line 1
\nDBCA_PROGRESS : 71%
\n[ 2020-02-13 18:20:49.119 CET ] Executing Post Configuration Actions
\nDBCA_PROGRESS : 100%
\n[ 2020-02-13 18:20:49.123 CET ] Database creation complete. For details check the logfiles at:
\n \/u01\/app\/oracle\/cfgtoollogs\/dbca\/DBSUS.
\nDatabase Information:
\nGlobal Database Name:DBSUS.salt.ch
\nSystem Identifier(SID):DBSUS
\n<\/code><\/p>\n

Let’s check the ASM alert.log:<\/p>\n

tail \/u01\/app\/oracle\/diag\/asm\/+asm\/+ASM1\/trace\/alert_+ASM1.log<\/strong>
\n2020-02-13T14:35:24.880987+01:00
\nLGWR (ospid: 17755) waits for event 'kfk: async disk IO' for 44 secs.
\n2020-02-13T14:35:24.881028+01:00
\nLGWR (ospid: 17755) is hung in an acceptable location (inwait 0x1.ffff).
\n2020-02-13T14:35:30.039917+01:00
\nLGWR (ospid: 17755) waits for event 'kfk: async disk IO' for 59 secs.
\n2020-02-13T14:35:40.280979+01:00
\nLGWR (ospid: 17755) waits for event 'kfk: async disk IO' for 75 secs.
\n2020-02-13T14:37:13.180477+01:00
\nLGWR (ospid: 17755) waits for event 'kfk: async disk IO' for 39 secs.
\n2020-02-13T14:37:13.180536+01:00
\nLGWR (ospid: 17755) is hung in an acceptable location (inwait 0x1.ffff).
\n<\/code><\/p>\n

There is a problem with the disks.<\/p>\n

What the system tells us?<\/p>\n

tail \/var\/log\/messages<\/strong>
\n...
\nFeb 13 14:34:49 oda-cr-test kernel: nvme nvme1: I\/O 615 QID 1 timeout, completion polled
\nFeb 13 14:35:09 oda-cr-test kernel: nvme nvme0: I\/O 348 QID 1 timeout, completion polled
\nFeb 13 14:35:12 oda-cr-test kernel: nvme nvme1: I\/O 623 QID 1 timeout, completion polled
\nFeb 13 14:35:12 oda-cr-test kernel: nvme nvme1: I\/O 624 QID 1 timeout, completion polled
\nFeb 13 14:35:16 oda-cr-test kernel: nvme nvme0: I\/O 349 QID 1 timeout, completion polled
\nFeb 13 14:35:40 oda-cr-test kernel: nvme nvme0: I\/O 348 QID 1 timeout, completion polled
\nFeb 13 14:35:46 oda-cr-test kernel: nvme nvme0: I\/O 349 QID 1 timeout, completion polled
\nFeb 13 14:35:46 oda-cr-test kernel: nvme nvme0: I\/O 351 QID 1 timeout, completion polled
\nFeb 13 14:35:46 oda-cr-test kernel: nvme nvme0: I\/O 352 QID 1 timeout, completion polled
\nFeb 13 14:35:46 oda-cr-test kernel: nvme nvme0: I\/O 353 QID 1 timeout, completion polled
\nFeb 13 14:35:46 oda-cr-test kernel: nvme nvme0: I\/O 354 QID 1 timeout, completion polled
\n...
\n<\/code><\/p>\n

Let’s try to create a database with more cores:<\/p>\n

odacli update-cpucore -c 16
\nreboot
\nodacli create-database -m MAnager_2020_dbi -cs AL32UTF8 -no-c -u DBSUP -dh '2d147842-4f42-468a-93c9-112ce9c23ee7' -n DBSUP -s odb1s -l AMERICAN -dt AMERICA -no-co -r asm
\nodacli describe-job -i 204fcd53-a9f1-416e-953b-c50448207fc1<\/strong>
\nJob details
\n----------------------------------------------------------------
\n ID: 204fcd53-a9f1-416e-953b-c50448207fc1
\n Description: Database service creation with db name: DBSUP
\n Status: Success
\n Created: February 7, 2020 3:41:54 PM CET
\n Message:
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\nSetting up ssh equivalance February 7, 2020 3:41:55 PM CET February 7, 2020 3:41:55 PM CET Success
\nDatabase Service creation February 7, 2020 3:41:56 PM CET February 7, 2020 3:50:07 PM CET Success
\nDatabase Creation February 7, 2020 3:41:56 PM CET February 7, 2020 3:48:16 PM CET Success
\nChange permission for xdb wallet files February 7, 2020 3:48:16 PM CET February 7, 2020 3:48:16 PM CET Success
\nPlace SnapshotCtrlFile in sharedLoc February 7, 2020 3:48:16 PM CET February 7, 2020 3:48:19 PM CET Success
\nSqlPatch upgrade February 7, 2020 3:49:52 PM CET February 7, 2020 3:50:01 PM CET Success
\nRunning dbms_stats init_package February 7, 2020 3:50:01 PM CET February 7, 2020 3:50:05 PM CET Success
\nupdating the Database version February 7, 2020 3:50:05 PM CET February 7, 2020 3:50:07 PM CET Success
\ncreate Users tablespace February 7, 2020 3:50:07 PM CET February 7, 2020 3:50:12 PM CET Success
\nClear all listeners from Databse {8a6b0534-26be-4a9a-90fd-f2167f57fded} February 7, 2020 3:50:12 PM CET February 7, 2020 3:50:14 PM CET Success
\n<\/code><\/p>\n

Success in 9 minutes.<\/p>\n

odacli update-cpucore -c 8 --force
\nreboot
\nodacli create-database -m MAnager_2020_dbi -cs AL32UTF8 -no-c -u DBSUQ -dh '2d147842-4f42-468a-93c9-112ce9c23ee7' -n DBSUQ -s odb1s -l AMERICAN -dt AMERICA -no-co -r asm
\nodacli describe-job -i 210e1bd7-fe87-4d60-adce-84b121448c2b<\/strong>
\nJob details
\n----------------------------------------------------------------
\n ID: 210e1bd7-fe87-4d60-adce-84b121448c2b
\n Description: Database service creation with db name: DBSUQ
\n Status: Success
\n Created: February 7, 2020 4:05:48 PM CET
\n Message:
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\nSetting up ssh equivalance February 7, 2020 4:05:49 PM CET February 7, 2020 4:05:49 PM CET Success
\nDatabase Service creation February 7, 2020 4:05:49 PM CET February 7, 2020 5:53:09 PM CET Success
\nDatabase Creation February 7, 2020 4:05:49 PM CET February 7, 2020 5:46:50 PM CET Success
\nChange permission for xdb wallet files February 7, 2020 5:46:50 PM CET February 7, 2020 5:46:50 PM CET Success
\nPlace SnapshotCtrlFile in sharedLoc February 7, 2020 5:46:50 PM CET February 7, 2020 5:48:55 PM CET Success
\nSqlPatch upgrade February 7, 2020 5:50:28 PM CET February 7, 2020 5:53:02 PM CET Success
\nRunning dbms_stats init_package February 7, 2020 5:53:02 PM CET February 7, 2020 5:53:06 PM CET Success
\nupdating the Database version February 7, 2020 5:53:06 PM CET February 7, 2020 5:53:09 PM CET Success
\ncreate Users tablespace February 7, 2020 5:53:09 PM CET February 7, 2020 5:53:45 PM CET Success
\nClear all listeners from Databse {f0900b63-baf8-4896-8572-a4120770a362} February 7, 2020 5:53:45 PM CET February 7, 2020 5:53:47 PM CET Success
\n<\/code><\/p>\n

Success in 1h50.<\/p>\n


\nodacli update-cpucore -c 4 --force
\nreboot
\nodacli create-database -m MAnager_2020_dbi -cs AL32UTF8 -no-c -u DBSUR -dh '2d147842-4f42-468a-93c9-112ce9c23ee7' -n DBSUR -s odb1s -l AMERICAN -dt AMERICA -no-co -r asm
\nodacli describe-job -i 1931b118-3407-413b-babc-ff9a832fab59<\/strong>
\nJob details
\n----------------------------------------------------------------
\n ID: 1931b118-3407-413b-babc-ff9a832fab59
\n Description: Database service creation with db name: DBSUR
\n Status: Success
\n Created: February 7, 2020 6:25:37 PM CET
\n Message:
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\nSetting up ssh equivalance February 7, 2020 6:25:38 PM CET February 7, 2020 6:25:38 PM CET Success
\nDatabase Service creation February 7, 2020 6:25:38 PM CET February 7, 2020 10:09:17 PM CET Success
\nDatabase Creation February 7, 2020 6:25:38 PM CET February 7, 2020 9:30:40 PM CET Success
\nChange permission for xdb wallet files February 7, 2020 9:30:40 PM CET February 7, 2020 9:30:40 PM CET Success
\nPlace SnapshotCtrlFile in sharedLoc February 7, 2020 9:30:40 PM CET February 7, 2020 9:35:21 PM CET Success
\nSqlPatch upgrade February 7, 2020 9:51:49 PM CET February 7, 2020 10:08:17 PM CET Success
\nRunning dbms_stats init_package February 7, 2020 10:08:17 PM CET February 7, 2020 10:09:14 PM CET Success
\nupdating the Database version February 7, 2020 10:09:14 PM CET February 7, 2020 10:09:17 PM CET Success
\ncreate Users tablespace February 7, 2020 10:09:17 PM CET February 7, 2020 10:39:01 PM CET Success
\nClear all listeners from Databse {8cb507cf-3c84-4ad9-8302-844005965f6b} February 7, 2020 10:39:01 PM CET February 7, 2020 10:41:49 PM CET Success
\n<\/code><\/p>\n

Success in 4h15.<\/p>\n

That’s it. Decreasing the cores dramatically decreases the I\/O performance and makes our ODA unusable. <\/p>\n

And this problem doesn’t limit to database creation: don’t expect to run correctly a database with this bug. A small datafile creation will take long minutes.<\/p>\n

Are you concerned?<\/h2>\n

This problem does not concern everybody. If you use Standard Edition 2 databases, you don’t need to decrease the cores on your ODA. So you won’t experience this problem. If you have enough Enterprise Edition licenses (at least to enable half of the total cores), you also won’t have this problem. This problem only impacts those who have limited number of licenses.<\/p>\n

All my tests were done with ODA 19.5, so it’s probably limited to this specific version. ODA X8.2 with 18.7 shouldn’t have this bug.<\/p>\n

Is there a workaround?<\/h2>\n

For now, there is no workaround. But it seems that an updated Linux kernel could solve the problem. Current kernel provided with 19.5 is 4.14.35-1902.5.2.el7uek.x86_64. Oracle will probably provide something soon. <\/p>\n

Edit (April 2020): No new kernel or fix will be provided by Oracle for this 19.5 version. The only way to solve the problem is going for 19.6 (most likely to be released in May).<\/p>\n

Conclusion<\/h2>\n

One of the main advantages of ODA is the core configuration to fit the license. But for now it doesn’t work out of the box with ODA X8-2 and 19.5. If you can keep 11g\/12c\/18c, waiting for release 19.6 is probably better.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that can be extremely slow on these servers if you are using ODA 19.5. Edit (April […]<\/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,198,199,42,59],"tags":[1813,1826,1827,1828,1829,79,1830,1831,365,1832,1697,1833,1698,1699],"type_dbi":[],"class_list":["post-13459","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-hardware-storage","category-operating-systems","category-oracle","tag-19-5","tag-dcs-10001internal-error-encountered","tag-extremely-slow","tag-limited-cores","tag-nvme","tag-oda","tag-oda-x8-2-19-5","tag-odacli-create-database","tag-oracle-database-appliance","tag-update-cpucore","tag-x8-2ha","tag-x8-2l","tag-x8-2m","tag-x8-2s"],"acf":[],"yoast_head":"\nodacli create-database extremely slow on ODA X8-2 with 19.5 - 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-extremely-slow-on-oda-x8-2-with-19-5\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"odacli create-database extremely slow on ODA X8-2 with 19.5\" \/>\n<meta property=\"og:description\" content=\"Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that can be extremely slow on these servers if you are using ODA 19.5. Edit (April […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-14T14:21:23+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\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"headline\":\"odacli create-database extremely slow on ODA X8-2 with 19.5\",\"datePublished\":\"2020-02-14T14:21:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\"},\"wordCount\":645,\"commentCount\":0,\"keywords\":[\"19.5\",\"DCS-10001:Internal error encountered\",\"extremely slow\",\"limited cores\",\"NVMe\",\"ODA\",\"ODA X8-2 19.5\",\"odacli create-database\",\"Oracle database appliance\",\"update-cpucore\",\"x8-2ha\",\"X8-2L\",\"x8-2m\",\"x8-2s\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Hardware & Storage\",\"Operating systems\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\",\"name\":\"odacli create-database extremely slow on ODA X8-2 with 19.5 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-02-14T14:21:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"odacli create-database extremely slow on ODA X8-2 with 19.5\"}]},{\"@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 extremely slow on ODA X8-2 with 19.5 - 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-extremely-slow-on-oda-x8-2-with-19-5\/","og_locale":"en_US","og_type":"article","og_title":"odacli create-database extremely slow on ODA X8-2 with 19.5","og_description":"Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that can be extremely slow on these servers if you are using ODA 19.5. Edit (April […]","og_url":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/","og_site_name":"dbi Blog","article_published_time":"2020-02-14T14:21:23+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\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"headline":"odacli create-database extremely slow on ODA X8-2 with 19.5","datePublished":"2020-02-14T14:21:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/"},"wordCount":645,"commentCount":0,"keywords":["19.5","DCS-10001:Internal error encountered","extremely slow","limited cores","NVMe","ODA","ODA X8-2 19.5","odacli create-database","Oracle database appliance","update-cpucore","x8-2ha","X8-2L","x8-2m","x8-2s"],"articleSection":["Database Administration & Monitoring","Database management","Hardware & Storage","Operating systems","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/","url":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/","name":"odacli create-database extremely slow on ODA X8-2 with 19.5 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-02-14T14:21:23+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0fb4bbf128b4cda2f96d662dec2baedd"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/odacli-create-database-extremely-slow-on-oda-x8-2-with-19-5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"odacli create-database extremely slow on ODA X8-2 with 19.5"}]},{"@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\/13459","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=13459"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13459\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13459"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}