{"id":16538,"date":"2021-07-21T15:03:59","date_gmt":"2021-07-21T13:03:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/"},"modified":"2021-07-21T15:03:59","modified_gmt":"2021-07-21T13:03:59","slug":"oracle-update-dcscomponents-failure-during-oda-patching-to-19-11","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/","title":{"rendered":"oracle update-dcscomponents failure during ODA patching to 19.11"},"content":{"rendered":"

You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during the odacli update-dcscomponent<\/em> command. Starting 19.10, DCS Agent will then use MySQL server to display any metadata information, as for example when running odacli list-databases<\/em> command. MySQL server is automatically installed and configured during the dcscomponent update. MySQL server does not run with root user. A new operating system user, called odamysql, will be created. This user is not allowed to run any shell and thus can not be used for logging. systemctl oda-mysql service can be used to stop and start MySQL server. Stopping MySQL server will stop the DCS Agent as well.
\n<\/br>
\nI recently patched an ODA from version 19.9 to 19.11. During the patching, update-dcscomponent failed on the metadata migration which blocked the entire patching project. Troubleshooting together with customer we could find a workaround that I wanted to share with you.
\n<\/p>\n

Failure during odacli update-dcscomponents<\/h3>\n

Running the update of all components failed into following error:<\/p>\n

\n[root@ODA01 patch]# \/opt\/oracle\/dcs\/bin\/odacli update-dcscomponents -v 19.11.0.0.0\nDCS-10008:Failed to update DCScomponents: 19.11.0.0.0\n \nInternal error while patching the DCS components :\nDCS-10001:Internal error encountered: DCS-10001:Internal error encountered: Failed to configure MySQL for ODA...DCS-Agent shutdown is successful.\n[root@ODA01 patch]# \n<\/pre>\n
Failure in DCS Admin log file<\/h3>\n
During the troubleshooting, we could see that the MySQL server package has been installed successfully but found, in the dcs-admin.log stored in \/opt\/oracle\/dcs\/log directory, the following errors related to the MySQL configuration:<\/p>\n
\n2021-07-20 09:18:45,177 DEBUG [dw-24 - PUT \/dcscomponents] [] c.o.d.a.u.MySQLTask: Configure MySQL for ODA\n2021-07-20 09:18:45,177 DEBUG [dw-24 - PUT \/dcscomponents] [] c.o.d.c.u.CommonsUtils: \nrun: cmd= '[\/opt\/oracle\/dcs\/mysql\/etc\/configodamysql.sh]'\n2021-07-20 09:18:50,993 DEBUG [Thread-30] [] c.o.d.c.u.CommonsUtils: Output :\nInitialize MySQL - Failed\n2021-07-20 09:18:50,993 DEBUG [dw-24 - PUT \/dcscomponents] [] c.o.d.c.u.c.DCSProcessBuilder: Return code: 1\n2021-07-20 09:18:50,993 DEBUG [dw-24 - PUT \/dcscomponents] [] c.o.d.c.u.c.CommandExecutor: Return code: 1\n2021-07-20 09:18:50,993 ERROR [dw-24 - PUT \/dcscomponents] [] c.o.d.a.u.MySQLTask: Exception : DCS-10001:Internal error encountered: Failed to configure MySQL for ODA..\nncountered: Failed to configure MySQL for ODA..\n2021-07-20 09:18:50,994 ERROR [dw-24 - PUT \/dcscomponents] [] c.o.d.a.r.DcsComponentServiceTaskFactory: Current status - DCS-Agent shutdown is successful. \n2021-07-20 09:18:50,997 INFO [dw-24 - PUT \/dcscomponents] [] c.o.d.a.r.DcsComponentServiceTaskFactory: Components {zookeeper ,MySQL, Agent, Dcs-Cli, Dcs-Controller} upgrade operation completed.\n2021-07-20 09:18:50,997 ERROR [dw-24 - PUT \/dcscomponents] [] c.o.d.a.r.DcsComponentLifecycleApi: Internal error while patching the DCS components  \n<\/pre>\n
<\/br><\/p>\n
Failure in MySQL log files<\/h3>\n
Going further with the troubleshooting, we could find the following in the MySQL log file:<\/p>\n
\n[root@ODA01 patch]# cd \/opt\/oracle\/dcs\/mysql\/log\/\n  \n[root@ODA01 log]# ls -ltrh\ntotal 4.0K\n-rw-r----- 1 odamysql odamysql 2.3K Jul 20 09:18 mysqldb.log\n  \n[root@ODA01 log]# more mysqldb.log\n2021-07-20T07:18:45.946735Z 0 [System] [MY-013169] [Server] \/opt\/oracle\/dcs\/mysql\/bin\/mysqld (mysqld 8.0.23-commercial) initializing of server in progress as process 66381\n2021-07-20T07:18:45.952983Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.\n2021-07-20T07:18:45.959155Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before giving up.\n2021-07-20T07:18:45.959220Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.\n2021-07-20T07:18:46.459426Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.\n2021-07-20T07:18:46.959669Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.\n2021-07-20T07:18:47.459946Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.\n2021-07-20T07:18:47.960193Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.\n2021-07-20T07:18:48.460487Z 1 [Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before giving up.\n2021-07-20T07:18:48.460594Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 1.\n2021-07-20T07:18:48.960802Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 2.\n2021-07-20T07:18:49.461068Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 3.\n2021-07-20T07:18:49.961352Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 4.\n2021-07-20T07:18:50.461608Z 1 [Warning] [MY-012583] [InnoDB] io_setup() attempt 5.\n2021-07-20T07:18:50.961904Z 1 [ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.\n2021-07-20T07:18:50.962203Z 1 [ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system\n2021-07-20T07:18:50.962314Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.\n2021-07-20T07:18:50.962557Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.\n2021-07-20T07:18:50.962716Z 0 [ERROR] [MY-013236] [Server] The designated data directory \/opt\/oracle\/dcs\/mysql\/data\/ is unusable. You can remove all files that the server added to it.\n2021-07-20T07:18:50.962890Z 0 [ERROR] [MY-010119] [Server] Aborting\n2021-07-20T07:18:50.963406Z 0 [System] [MY-010910] [Server] \/opt\/oracle\/dcs\/mysql\/bin\/mysqld: Shutdown complete (mysqld 8.0.23-commercial)  MySQL Enterprise Server - Commercial.\n<\/pre>\n
<\/br><\/p>\n
It seems there were troubles with InnoDB function because the ODA has no Asynchronous IO available. This is another question why and we opened a SR on the Oracle support portal to have an explanation and ensure our next workaround is adequate.<\/p>\n
Workaround<\/h3>\n
The workaround is to add innodb_use_native_aio = 0 parameter to both mysql cnf files : mysqldb_ssl.cnf and mysqldb.cnf and manually run configodamysql.sh before executing again odacli update-dcscomponents command. <\/p>\n
Adding innodb_use_native_aio = 0 parameter to both mysql cnf files<\/h4>\n
\n[root@ODA01 \/u01]# cd \/opt\/oracle\/dcs\/mysql\/etc\n  \n[root@ODA01 etc]# ls -ltrh\ntotal 40K\n-rwxr-x--- 1 odamysql odamysql  892 May 31 04:05 oda-mysql.service\n-rwxr-x--- 1 odamysql odamysql  596 May 31 04:05 mysqldb_ssl.cnf.bak\n-rwxr-x--- 1 odamysql odamysql  399 May 31 04:05 mysqldb.cnf.bak\n-rwxr-x--- 1 odamysql odamysql 1.9K May 31 04:05 getodamysqlport.sh\n-rwxr-x--- 1 odamysql odamysql   55 May 31 04:05 enable_auth_socket.sql\n-rwxr-x--- 1 odamysql odamysql 6.6K May 31 04:05 configodamysql.sh\n-rwxr-x--- 1 odamysql odamysql 2.4K May 31 04:05 cleanodamysql.sh\n-rwxr-x--- 1 odamysql odamysql  399 Jul 20 11:57 mysqldb.cnf\n-rwxr-x--- 1 odamysql odamysql  596 Jul 20 11:57 mysqldb_ssl.cnf\n  \n[root@ODA01 etc]# cp -p mysqldb_ssl.cnf mysqldb_ssl.cnf.bak.20210720\n  \n[root@ODA01 etc]# vi mysqldb_ssl.cnf\n  \n[root@ODA01 etc]# diff mysqldb_ssl.cnf mysqldb_ssl.cnf.bak.20210720\n16d15\n< innodb_use_native_aio = 0\n  \n[root@ODA01 etc]# cp -p mysqldb.cnf mysqldb.cnf.bak.20210720\n  \n[root@ODA01 etc]# vi mysqldb.cnf\n  \n[root@ODA01 etc]# diff mysqldb.cnf mysqldb.cnf.bak.20210720\n12d11\n< innodb_use_native_aio = 0\n  \n[root@ODA01 etc]# grep innodb_use_native_aio *\nmysqldb.cnf:innodb_use_native_aio = 0\nmysqldb_ssl.cnf:innodb_use_native_aio = 0\n<\/pre>\n
<\/br><\/p>\n
Start DCS Agent again<\/h4>\n
DCS Agent has been stopped during dcs-components update and needs to be restarted.<\/p>\n
\n[root@ODA01 etc]# ps -ef | grep dcs-agent\nroot     90513 25271  0 11:58 pts\/3    00:00:00 grep --color=auto dcs-agent\n  \n[root@ODA01 etc]# systemctl start initdcsagent\n  \n[root@ODA01 etc]# ps -ef | grep dcs-agent\nroot     90893     1  0 11:58 ?        00:00:00 \/bin\/sh -c . \/opt\/oracle\/dcs\/bin\/setupJreAgent.sh;$JAVA -Xms128m -Xmx256m -XX:MetaspaceSize=128m -XX:MaxMetaspaceSize=256m -XX:+DisableExplicitGC -XX:ParallelGCThreads=4 -XX:+PrintGCDetails -XX:+PrintHeapAtGC -XX:+PrintTenuringDistribution -XX:+PrintGCTimeStamps -XX:+PrintGCDateStamps -Xloggc:\/opt\/oracle\/dcs\/log\/gc-dcs-agent-%t-%p.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=10M -Doracle.security.jps.config=\/opt\/oracle\/dcs\/agent\/jps-config.xml -jar  \/opt\/oracle\/dcs\/bin\/dcs-agent*.jar server \/opt\/oracle\/dcs\/conf\/dcs-agent.json >\/opt\/oracle\/dcs\/log\/dcsagent-stdout_$(date +%Y%m%d-%H%M).log 2>\/opt\/oracle\/dcs\/log\/dcsagent-stderr_$(date +%Y%m%d-%H%M).log\nroot     90894 90893 99 11:58 ?        00:00:04 \/opt\/oracle\/dcs\/java\/1.8.0_281\/bin\/java -Xms128m -Xmx256m -XX:MetaspaceSize=128m -XX:MaxMetaspaceSize=256m -XX:+DisableExplicitGC -XX:ParallelGCThreads=4 -XX:+PrintGCDetails -XX:+PrintHeapAtGC -XX:+PrintTenuringDistribution -XX:+PrintGCTimeStamps -XX:+PrintGCDateStamps -Xloggc:\/opt\/oracle\/dcs\/log\/gc-dcs-agent-%t-%p.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=10 -XX:GCLogFileSize=10M -Doracle.security.jps.config=\/opt\/oracle\/dcs\/agent\/jps-config.xml -jar \/opt\/oracle\/dcs\/bin\/dcs-agent-19.9.0.0.0.jar server \/opt\/oracle\/dcs\/conf\/dcs-agent.json\nroot     91038 25271  0 11:59 pts\/3    00:00:00 grep --color=auto dcs-agent\n[root@ODA01 etc]# \n<\/pre>\n
<\/br><\/p>\n
Manually execute the configodamysql.sh script<\/h4>\n
\n[root@ODA01 \/]# cd \/opt\/oracle\/dcs\/mysql\/etc\/\n  \n[root@ODA01 etc]# ls -l\ntotal 48\n-rwxr-x--- 1 odamysql odamysql 2393 May 31 04:05 cleanodamysql.sh\n-rwxr-x--- 1 odamysql odamysql 6731 May 31 04:05 configodamysql.sh\n-rwxr-x--- 1 odamysql odamysql   55 May 31 04:05 enable_auth_socket.sql\n-rwxr-x--- 1 odamysql odamysql 1923 May 31 04:05 getodamysqlport.sh\n-rwxr-x--- 1 odamysql odamysql  425 Jul 20 12:00 mysqldb.cnf\n-rwxr-x--- 1 odamysql odamysql  399 May 31 04:05 mysqldb.cnf.bak\n-rwxr-x--- 1 odamysql odamysql  399 Jul 20 11:57 mysqldb.cnf.bak.20210720\n-rwxr-x--- 1 odamysql odamysql  622 Jul 20 11:58 mysqldb_ssl.cnf\n-rwxr-x--- 1 odamysql odamysql  596 May 31 04:05 mysqldb_ssl.cnf.bak\n-rwxr-x--- 1 odamysql odamysql  596 Jul 20 11:57 mysqldb_ssl.cnf.bak.20210720\n-rwxr-x--- 1 odamysql odamysql  892 May 31 04:05 oda-mysql.service\n  \n[root@ODA01 etc]# .\/configodamysql.sh\n\/opt\/oracle\/dcs\/mysql\/data directory should be empty to proceed further with ODA MySQL post install configuration\n  \n[root@ODA01 etc]# cd ..\/data\n  \n[root@ODA01 data]# ls\nbinlog.index\n  \n[root@ODA01 data]# rm binlog.index -f\n  \n[root@ODA01 data]# cd ..\/etc\n  \n[root@ODA01 etc]# .\/configodamysql.sh\nInitialize MySQL - Done\nStarting MySQL for ODA - Done\nmysql: [Warning] Using a password on the command line interface can be insecure.\nEnable server-side auth_socket authentication plugin for MySQL root user - Done\nGenerating RSA private key, 2048 bit long modulus\n................+++\n.................................................................................................................................................................................................+++\ne is 65537 (0x10001)\nGenerating a 2048 bit RSA private key\n...................................................................................+++\n.........................................+++\nwriting new private key to 'server-key.pem'\n-----\nwriting RSA key\nSignature ok\nsubject=\/CN=ODA01\nGetting CA Private Key\nGenerating a 2048 bit RSA private key\n....................................................+++\n...+++\nwriting new private key to 'dcsagent-client-key.pem'\n-----\nwriting RSA key\nSignature ok\nsubject=\/CN=dcsagent\nGetting CA Private Key\nGenerating a 2048 bit RSA private key\n.................................+++\n.+++\nwriting new private key to 'rhp-client-key.pem'\n-----\nwriting RSA key\nSignature ok\nsubject=\/CN=rhp user\nGetting CA Private Key\nAll certificates : OK\nmkdir: cannot create directory \u2018\/opt\/oracle\/dcs\/odamysqlcert\/\u2019: File exists\nGenerate certificates for CA, MySQL Server and Clients (DCS Agent & RHP) - Done\nEnable SSL and Restart MySQL - Done\nCreate database dcsagentdb - Done\nCreate user dcsagent - Done\nGrant privileges to user dcsagent - Done\nCreate database GHSUSER21 - Done\nCreate user GHSUSER21 - Done\nGrant privileges to user GHSUSER21 - Done\nCreate schemas, users for CS Agent & RHP - Done\nWarning: Unable to load '\/usr\/share\/zoneinfo\/iso3166.tab' as time zone. Skipping it.\nWarning: Unable to load '\/usr\/share\/zoneinfo\/leapseconds' as time zone. Skipping it.\nWarning: Unable to load '\/usr\/share\/zoneinfo\/tzdata.zi' as time zone. Skipping it.\nWarning: Unable to load '\/usr\/share\/zoneinfo\/zone.tab' as time zone. Skipping it.\nWarning: Unable to load '\/usr\/share\/zoneinfo\/zone1970.tab' as time zone. Skipping it.\nLoad the timezone tables in mysql database - Done\nMySQL installed version details :\n\/opt\/oracle\/dcs\/mysql\/bin\/mysql  Ver 8.0.23-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial)\nMySQL installation and configuration.....Completed\n<\/pre>\n
<\/br><\/p>\n
We can check that mySQL server daemon is now running :<\/p>\n
\n[root@ODA01 etc]# ps -ef | grep mysql\nodamysql 26130     1 11 12:07 ?        00:00:01 \/opt\/oracle\/dcs\/mysql\/bin\/mysqld --defaults-file=\/opt\/oracle\/dcs\/mysql\/etc\/mysqldb.cnf\nroot     27198 35360  0 12:08 pts\/4    00:00:00 grep --color=auto mysql\n<\/pre>\n
<\/br><\/p>\n
Execute again odacli update-dcscomponents<\/h4>\n
\n[root@ODA01 etc]# \/opt\/oracle\/dcs\/bin\/odacli update-dcscomponents -v 19.11.0.0.0\n{\n  \"jobId\" : \"ff4d652d-b394-4c43-9195-a0740d1a08e6\",\n  \"status\" : \"Success\",\n  \"message\" : \"Update-dcscomponents is successful on all the node(s):DCS-Agent shutdown is successful. MySQL already on required version. Metadata migration is successful. Metadata schema update is done. dcsagent RPM upgrade is successful.  dcscli RPM upgrade is successful.  dcscontroller RPM upgrade is successful.  Successfully ran setupAgentAuth.sh zookeeper RPM upgrade is successful.  DCS-Agent restart is successful. \",\n  \"reports\" : null,\n  \"createTimestamp\" : \"July 20, 2021 12:09:47 PM CEST\",\n  \"description\" : \"Update-dcscomponents job completed and is not part of Agent job list\",\n  \"updatedTime\" : \"July 20, 2021 12:11:48 PM CEST\"\n}\n<\/pre>\n
<\/br><\/p>\n
And we can see that the dcscomponents update is now successfull. We could also test that the Apache derby database repository is no more existing :<\/p>\n
\n[root@ODA01 etc]# cd \/opt\/oracle\/dcs\/\n[root@ODA01 dcs]# ls\nagent  bin  clients  commonstore  conf  configuredcs.pl  dcsagent_wallet  dcscli  dcs-ui  docs  ft  Inventory  java  log  mesg  mysql  odajavasdk  odamysqlcert  oracle.ahf  rdbaas  sample\n[root@ODA01 dcs]# \n<\/pre>\n
<\/br><\/p>\n
And that new MySQL metadata database is running fine executing any commands like odacli list-databases<\/em>.<\/p>\n
As explained previously, we opened a SR on oracle support to know the root cause, to have feedback on this workaround and in case of any other resolution. I will update this post accordingly as soon as we have got a feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"
You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during […]<\/p>\n","protected":false},"author":48,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2362,144,79,155],"type_dbi":[],"class_list":["post-16538","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dcscomponents","tag-mysql","tag-oda","tag-patching"],"acf":[],"yoast_head":"\noracle update-dcscomponents failure during ODA patching to 19.11 - 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\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"oracle update-dcscomponents failure during ODA patching to 19.11\" \/>\n<meta property=\"og:description\" content=\"You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-21T13:03:59+00:00\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 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\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"oracle update-dcscomponents failure during ODA patching to 19.11\",\"datePublished\":\"2021-07-21T13:03:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\"},\"wordCount\":471,\"commentCount\":0,\"keywords\":[\"dcscomponents\",\"MySQL\",\"ODA\",\"Patching\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\",\"name\":\"oracle update-dcscomponents failure during ODA patching to 19.11 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-07-21T13:03:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"oracle update-dcscomponents failure during ODA patching to 19.11\"}]},{\"@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\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"oracle update-dcscomponents failure during ODA patching to 19.11 - 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\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/","og_locale":"en_US","og_type":"article","og_title":"oracle update-dcscomponents failure during ODA patching to 19.11","og_description":"You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/","og_site_name":"dbi Blog","article_published_time":"2021-07-21T13:03:59+00:00","author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"oracle update-dcscomponents failure during ODA patching to 19.11","datePublished":"2021-07-21T13:03:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/"},"wordCount":471,"commentCount":0,"keywords":["dcscomponents","MySQL","ODA","Patching"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/","name":"oracle update-dcscomponents failure during ODA patching to 19.11 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-07-21T13:03:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-update-dcscomponents-failure-during-oda-patching-to-19-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"oracle update-dcscomponents failure during ODA patching to 19.11"}]},{"@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\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16538","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\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16538"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16538\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16538"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}