{"id":15608,"date":"2021-02-08T11:49:27","date_gmt":"2021-02-08T10:49:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/"},"modified":"2021-02-08T11:49:27","modified_gmt":"2021-02-08T10:49:27","slug":"oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/","title":{"rendered":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts"},"content":{"rendered":"

In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool<\/a> , which is the preferred tool to do Oracle upgrades today. <\/p>\n

Before doing the upgrade at the customer, I performed 2 tests in my personal environment:<\/p>\n

– Upgrade 12.2. to 19.9. and the plugin to a container-DB in 2 separate steps
\n– Upgrade 12.2. to 19.9. and the plugin to a container-DB in 1 step (i.e. calling “autoupgrade -mode deploy” only once)<\/p>\n

Doing the upgrade and the plugin in 2 steps requires to manually create the Windows services again after the upgrade finished using the oradim-utility. I.e. first step is the upgrade, which automatically uses a temporary Windows service. At the end of the upgrade new services have to be created manually, because autoupgrade has no clue about the password of the user running the Oracle services. I.e. I used the following config file upgrade_config_122_199_SIMC.cfg.txt:<\/p>\n

\n# Global parameter\n# ================\n\nglobal.autoupg_log_dir=D:Downloadsoracle19cautoupgradelogs\nglobal.target_home=D:appcblvirtualproduct19.9.0dbhome_1\nglobal.target_version=19\n\n\n# Database parameter SIMC\n# =======================\n\nupg1.dbname=simc\nupg1.start_time=NOW\nupg1.source_home=D:appcblvirtualproduct12.2.0dbhome_1\nupg1.sid=simc\nupg1.upgrade_node=dbi-pc-cbl\n# upg1.add_after_upgrade_pfile=D:Downloadsoracle19cautoupgradepfileadd_after_init.ora\n<\/code><\/pre>\n
The commands for the upgrade were<\/p>\n
\n%ORACLE_HOME%jdkbinjava -jar autoupgrade.jar -config configupgrade_config_122_199_SIMC.cfg.txt -mode analyze\n%ORACLE_HOME%jdkbinjava -jar autoupgrade.jar -config configupgrade_config_122_199_SIMC.cfg.txt -mode fixups\n%ORACLE_HOME%jdkbinjava -jar autoupgrade.jar -config configupgrade_config_122_199_SIMC.cfg.txt -mode deploy\n<\/code><\/pre>\n
And finally executed the oradim-commands on the cmd-prompt:<\/p>\n
\noradim -delete -sid SIMC\noradim -new -sid SIMC -startmode auto -spfile -shutmode immediate\n<\/code><\/pre>\n
The second step then was to plugin the non-container-DB with the following config file:<\/p>\n
\n# Global parameter\n# ================\n\nglobal.autoupg_log_dir=D:Downloadsoracle19cautoupgradelogs3\nglobal.target_home=D:appcblvirtualproduct19.9.0dbhome_1\nglobal.target_version=19\n\n\n# Database parameter SIMC\n# =======================\n\nupg1.dbname=simc\nupg1.start_time=NOW\nupg1.source_home=D:appcblvirtualproduct19.9.0dbhome_1\nupg1.sid=simc\nupg1.upgrade_node=dbi-pc-cbl\n# upg1.add_after_upgrade_pfile=D:Downloadsoracle19cautoupgradepfileadd_after_init.ora\nupg1.target_cdb=cdbsimc\nupg1.target_pdb_name=PDBSIMC\nupg1.target_pdb_copy_option=file_name_convert=('D:APPCBLVIRTUALORADATASIMC','D:APPCBLVIRTUALORADATACDBSIMCSIMC')\n<\/code><\/pre>\n
As the source and target ORACLE_HOME are the same, no upgrade actually happens, but just the plugin.<\/p>\n
During installation of Oracle I did choose to use the virtual account. This worked fine for the migration in 2 steps. Later on we’ll see that the virtual account causes issues during plugin when doing the upgrade and plugin in 1 step.<\/p>\n
See this blog<\/a> with more information about the virtual account on Windows.<\/p>\n
Doing the upgrade and plugin in one step has the following advantage:<\/p>\n
There’s no need to manually create the Windows service, because the services of the pre-created container-DB are already there.<\/p>\n
To do the upgrade and plugin in one step I used the following autoupgrade-config-file after creating an empty container db CDBSIMC:<\/p>\n
\n# Global parameter\n# ================\n\nglobal.autoupg_log_dir=D:Downloadsoracle19cautoupgradelogs2\nglobal.target_home=D:appcblvirtualproduct19.9.0dbhome_1\nglobal.target_version=19\n\n\n# Database parameter SIMC\n# =======================\n\nupg1.dbname=simc\nupg1.start_time=NOW\nupg1.source_home=D:appcblvirtualproduct12.2.0dbhome_1\nupg1.sid=simc\nupg1.upgrade_node=dbi-pc-cbl\n# upg1.add_after_upgrade_pfile=D:Downloadsoracle19cautoupgradepfileadd_after_init.ora\nupg1.target_cdb=cdbsimc\nupg1.target_pdb_name=PDBSIMC\nupg1.target_pdb_copy_option=file_name_convert=('D:APPCBLVIRTUALORADATASIMC','D:APPCBLVIRTUALORADATACDBSIMCSIMC')\n<\/code><\/pre>\n
The upgrade went through, but the plugin failed with the following error:<\/p>\n
createpdb_simc_PDBSIMC.log: <\/p>\n
\nStart of SQL*Plus output\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 29 22:54:33 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\n\nSQL> SQL> Connected.\nSQL> SQL> old   1: create pluggable database \"&pdbName\" &asClone using '&xmlFilePath' &fileNameConvertOption tempfile reuse\nnew   1: create pluggable database \"PDBSIMC\" as clone using 'D:Downloadsoracle19cautoupgradelogs2simcsimc105noncdbtopdbPDBSIMC.xml' COPY file_name_convert=('D:APPCBLVIRTUALORADATASIMC','D:APPCBLVIRTUALORADATACDBSIMCSIMC') tempfile reuse\ncreate pluggable database \"PDBSIMC\" as clone using 'D:Downloadsoracle19cautoupgradelogs2simcsimc105noncdbtopdbPDBSIMC.xml' COPY file_name_convert=('D:APPCBLVIRTUALORADATASIMC','D:APPCBLVIRTUALORADATACDBSIMCSIMC') tempfile reuse\n*\nERROR at line 1:\nORA-19505: failed to identify file\n\"D:APPCBLVIRTUALORADATASIMCSYSTEM01.DBF\"\nORA-27041: unable to open file\nOSD-04002: unable to open file\nO\/S-Error: (OS 5) Access is denied.\n<\/code><\/pre>\n
REMARK: As you can see the plugin is actually a “Clone”. I.e. the original datafiles are kept to be able to go back. <\/p>\n
The reason for the issue was that the 12.2.-Window-service runs under permission of the group ORA_OraDB12Home1_SVCACCTS and hence permission to access the associated DB-files are also granted to that group. This does not change during the upgrade to 19c, but of course can be adjusted with oradim. As we skipped the manual step with oradim, the 19c-services for the container DB CDBSIMC (which runs in group ORA_OraDB19Home1_SVCACCTS) do not have access to the DB-files to clone them.<\/p>\n
The workaround in my environment was to grant full rights on the db-files to group ORA_OraDB19Home1_SVCACCTS prior to the upgrade\/plugin. <\/p>\n
Afterwards my upgrade and plugin went through with the following content in the createpdb_simc_PDBSIMC.log:<\/p>\n
\nStart of SQL*Plus output\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 30 01:15:55 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\n\nSQL> SQL> Connected.\nSQL> SQL> old   1: create pluggable database \"&pdbName\" &asClone using '&xmlFilePath' &fileNameConvertOption tempfile reuse\nnew   1: create pluggable database \"PDBSIMC\" as clone using 'D:Downloadsoracle19cautoupgradelogs5simcsimc100noncdbtopdbPDBSIMC.xml' COPY file_name_convert=('D:APPCBLVIRTUALORADATASIMC','D:APPCBLVIRTUALORADATACDBSIMCSIMC') tempfile reuse\n\nPluggable database created.\n<\/code><\/pre>\n
The best solution here is of course to use the same local account for all Oracle DB-services and not the virtual account. If you plan to use the virtual account then it is a good idea from the beginning to use the same value for the registry entry ORACLE_SVCUSER for all installed versions. E.g. I used ORA_DBSVCACCTS instead of the defaults ORA_OraDB12Home1_SVCACCTS (for 12.2.) and ORA_OraDB19Home1_SVCACCTS (for 19c) during my tests successfully.<\/p>\n","protected":false},"excerpt":{"rendered":"
In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool , which is the preferred tool […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[1570,15,1094,549],"type_dbi":[],"class_list":["post-15608","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-autoupgrade","tag-migration","tag-plugin","tag-windows"],"acf":[],"yoast_head":"\nOracle autoupgrade on Windows and plugin to a Container DB with virtual accounts - 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-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts\" \/>\n<meta property=\"og:description\" content=\"In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool , which is the preferred tool […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-08T10:49:27+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\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\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts\",\"datePublished\":\"2021-02-08T10:49:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\"},\"wordCount\":590,\"commentCount\":0,\"keywords\":[\"autoupgrade\",\"Migration\",\"Plugin\",\"Windows\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\",\"name\":\"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-02-08T10:49:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts\"}]},{\"@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\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts - 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-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/","og_locale":"en_US","og_type":"article","og_title":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts","og_description":"In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool , which is the preferred tool […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/","og_site_name":"dbi Blog","article_published_time":"2021-02-08T10:49:27+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts","datePublished":"2021-02-08T10:49:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/"},"wordCount":590,"commentCount":0,"keywords":["autoupgrade","Migration","Plugin","Windows"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/","name":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-02-08T10:49:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-autoupgrade-on-windows-and-plugin-to-a-container-db-with-virtual-accounts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15608","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=15608"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/15608\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=15608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=15608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=15608"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=15608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}