{"id":227,"date":"2015-07-16T10:05:00","date_gmt":"2015-07-16T08:05:00","guid":{"rendered":"https:\/\/www.carajandb.com\/2015\/07\/16\/caution-the-12c-oracle-home-user-cannot-be-changed\/"},"modified":"2024-08-31T21:13:07","modified_gmt":"2024-08-31T19:13:07","slug":"caution-the-12c-oracle-home-user-cannot-be-changed","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2015\/07\/16\/caution-the-12c-oracle-home-user-cannot-be-changed\/","title":{"rendered":"Caution, 12c Oracle Home User cannot be changed!"},"content":{"rendered":"\n

Be careful when installing Oracle 12c on Windows. The first stumbling block, the Oracle Home User could produce a lot of trouble for you later. If you are used to running your Instance and Listener with an extra Account for Exports to Windows Shares, NAS devices or RMAN Backups to external storages for example with Avamar, a toughtless click at software installation could destroy all your work and efforts. It only remains to set up everything from scratch because the once selected user is not changeable.<\/p>\n\n\n\n\n\n\n\n

Under 10g and 11g it was very easy to change Listener and Instance from \u201elocal system\u201c to an (Active Directory) Account with neccessary write permissions to corresponding external filesystems. This behaviour ends with Oracle 12c. Unfortunately the Oracle documentation is very clear about that: \u201eOracle Home User cannot be changed post installation.\u201c<\/p>\n\n\n\n

If you choose \u201eCreate new Windows User\u201c or \u201eUse Windows Built-in Account\u201c and want to convert it to an existing AD Account it is not possible to logon to the database, the listener didn’t start properly or you may get the following or similar error messages at the database startup:<\/p>\n\n\n\n

ORA-01078: failure in processing system parameters<\/p>\n\n\n\n

LRM-00109: could not open parameter file \u2018INITSID.ORA\u2019<\/p>\n\n\n\n

\"01<\/figure>\n\n\n\n

<\/p>\n\n\n\n

There is no chance to avoid this problem. Of course you can try to give the local Oracle User someway access to the storage but that\u2019s not common in a domain. The only real solution is a new installation and now choose \u201cUse existing Windows User\u201d specifying your domain:<\/p>\n\n\n\n

Domain\\Username<\/p>\n\n\n\n

\"01<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Just another hint at the end treats the variety of the account. Oracle\u2019s idea is to implement the user only as a service account, so don\u2019t mix it up with an administrative account for your software installation. It is also not possible to choose an administrator account or a member of the admin group as Oracle Home User during installation: [INS-32095] Specified User has administrative privileges.<\/p>\n\n\n\n

\"03<\/figure>\n\n\n\n

<\/p>\n\n\n\n

But there seems to be still some issues with persmissions. The Oracle VSS Writer Service permanently produces an error in the Sever Event Log. The documentation of Oracle VSS Writer Service tells us why: “Thus, the Windows user must be able to log in as SYSDBA to the Oracle database instances managed by the writer service.” But the Oracle Home User didn\u2019t have these permission and taking the Oracle Home User into the ora_dba group didn\u2019t help because it\u2019s still not an administrative account: Volume Shadow Copy Service error: Unexpected error calling routine RegOpenKeyExW(-2147483646,SYSTEM\\CurrentControlSet\\Services\\VSS\\Diag,…).  hr = 0x80070005, Access is denied.<\/p>\n\n\n\n

\"04<\/figure>\n\n\n\n

<\/p>\n\n\n\n

A solution by Oracle reads in the MOS Note 19313580 as follows: “Take the Oracle Home User into the local admin group.” This is exactly the opposite of the statements in the oracle documentation regarding the 12c Home User.<\/p>\n\n\n\n

My solution is another. Just change the Log On for the OracleVssWriter Service to Local System.<\/p>\n\n\n\n

\"05<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Alternatively you can choose an administrative Account who is a member of the ora_dba group.<\/p>\n\n\n\n

\"06<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"07<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Now you are clean.<\/p>\n\n\n\n

More information regarding the new Oracle Home User you will get here:<\/p>\n\n\n\n

12c, Windows and the new Oracle Home User<\/a><\/h2>\n","protected":false},"excerpt":{"rendered":"

Be careful when installing Oracle 12c on Windows. The first stumbling block, the Oracle Home User could produce a lot of trouble for you later. If you are used to running your Instance and Listener with an extra Account for Exports to Windows Shares, NAS devices or RMAN Backups to external storages for example with Avamar, a toughtless click at software installation could destroy all your work and efforts. It only remains to set up everything from scratch because the once selected user is not changeable.<\/p>\n","protected":false},"author":3,"featured_media":629,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[406],"tags":[402],"class_list":["post-227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-en","tag-oracle-home-user"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":"","person_ordering-number":50,"publication_speakers":"","publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_thumbnail_id":["629"],"_fgj2wp_old_id":["227"],"_yoast_wpseo_metadesc":["Oracle 12c Home User Account Windows"],"_yoast_wpseo_metakeywords":["Oracle 12c Home User Account Windows"],"_fgj2wp_translation_association_key":["e3147b40e3c073154f08a0db494a8346"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1725131589:8"],"_edit_last":["8"],"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_yoast_wpseo_focuskw_text_input":["Oracle Home User"],"_yoast_wpseo_focuskw":["Oracle Home User"],"_yoast_wpseo_linkdex":["77"],"_yoast_wpseo_content_score":["60"],"layout_header":["light"],"_layout_header":["field_5a48111185e5f"],"layout_background":[""],"_layout_background":["field_5a481193c0995"],"layout_hide_services":["0"],"_layout_hide_services":["field_5a4811c5c0996"],"layout_show-categories-tags":["1"],"_layout_show-categories-tags":["field_5a64eee4c6491"],"blogpost_related-publications":[""],"_blogpost_related-publications":["field_5a480debdac62"],"blogpost_related-files":[""],"_blogpost_related-files":["field_5a480f377db29"],"_yoast_wpseo_primary_category":[""],"_wpml_location_migration_done":["1"],"_wpml_media_duplicate":["1"],"rank_math_primary_category":[""],"rank_math_description":["Oracle 12c Home User Account Windows"],"rank_math_focus_keyword":["Oracle Home User"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"rank_math_seo_score":["72"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["0"],"wpil_links_inbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_internal_count":["1"],"wpil_links_outbound_internal_count_data":["eJx1kcFuwyAMhl8l4jyakLbb5L7ADtt6mnpEBKyGlUIERNlU9d1nkmrqDrsg+9dv\/5+MAgEXC81uD2IL7DBYJ9+CQSdfrT8xEGu4JHgC5qiV1rBdMSdYAxujY1SJZgOsz3mAuo7o1Oh13zbtZqVVVJ\/Km26lw7lGX3cuHNP88jTROoeRkyzaLRet5iSZMCVOIzz3yD1OPESlHfI+nJGPCWMJLHEh5VK2j8D+zyyOZ2DWZ4xeEWwHYpkf5vl3amiBouGwbBbAiOShOiwoFW2qCKUilGo\/o1QvhFJ93FDKyZQxaGT3LQc3Hq0vKc0S7IJW2QZfnHRBHQjEL9zN7aBTb9OAUeqIKuPvdQWB2CTVmEOx3cuZME7WH+\/+osjnYEaH8o+7vYXMwV950a\/XH8JBo3Q="],"wpil_links_outbound_external_count":["0"],"wpil_links_outbound_external_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_sync_report2_time":["2024-08-27T11:47:28+00:00"],"astra_style_timestamp_css":["1773689245"],"_wpml_word_count":["536"],"_encloseme":["1"],"occupation":["Write the Occupation of the Person"],"_occupation":["field_6659fb3267362"],"person_can-be-speaker":["1"],"_person_can-be-speaker":["field_5a4ad1b739e05"],"person_is-team":["1"],"_person_is-team":["field_5a512462957b2"],"person_related-user-account":[""],"_person_related-user-account":["field_5a4e332e9c214"],"person_ordering-number":["50"],"_person_ordering-number":["field_5a512536414ad"],"publication_speakers":[""],"_publication_speakers":["field_5a4802faa74f8"],"publication_content-language":["a:1:{i:0;s:2:\"de\";}"],"_publication_content-language":["field_5a480422f57cc"],"publication_files":[""],"_publication_files":["field_5a4804adf57cd"],"publication_event":[""],"_publication_event":["field_5a48050cf57ce"],"publication_date":[""],"_publication_date":["field_5a48066f0a174"],"_wpml_media_featured":["1"],"_uagb_previous_block_counts":["a:90:{s:21:\"uagb\/advanced-heading\";i:0;s:15:\"uagb\/blockquote\";i:0;s:12:\"uagb\/buttons\";i:0;s:18:\"uagb\/buttons-child\";i:0;s:19:\"uagb\/call-to-action\";i:0;s:15:\"uagb\/cf7-styler\";i:0;s:11:\"uagb\/column\";i:0;s:12:\"uagb\/columns\";i:0;s:14:\"uagb\/container\";i:0;s:21:\"uagb\/content-timeline\";i:0;s:27:\"uagb\/content-timeline-child\";i:0;s:14:\"uagb\/countdown\";i:0;s:12:\"uagb\/counter\";i:0;s:8:\"uagb\/faq\";i:0;s:14:\"uagb\/faq-child\";i:0;s:10:\"uagb\/forms\";i:0;s:17:\"uagb\/forms-accept\";i:0;s:19:\"uagb\/forms-checkbox\";i:0;s:15:\"uagb\/forms-date\";i:0;s:16:\"uagb\/forms-email\";i:0;s:17:\"uagb\/forms-hidden\";i:0;s:15:\"uagb\/forms-name\";i:0;s:16:\"uagb\/forms-phone\";i:0;s:16:\"uagb\/forms-radio\";i:0;s:17:\"uagb\/forms-select\";i:0;s:19:\"uagb\/forms-textarea\";i:0;s:17:\"uagb\/forms-toggle\";i:0;s:14:\"uagb\/forms-url\";i:0;s:14:\"uagb\/gf-styler\";i:0;s:15:\"uagb\/google-map\";i:0;s:11:\"uagb\/how-to\";i:0;s:16:\"uagb\/how-to-step\";i:0;s:9:\"uagb\/icon\";i:0;s:14:\"uagb\/icon-list\";i:0;s:20:\"uagb\/icon-list-child\";i:0;s:10:\"uagb\/image\";i:0;s:18:\"uagb\/image-gallery\";i:0;s:13:\"uagb\/info-box\";i:0;s:18:\"uagb\/inline-notice\";i:0;s:11:\"uagb\/lottie\";i:0;s:21:\"uagb\/marketing-button\";i:0;s:10:\"uagb\/modal\";i:0;s:18:\"uagb\/popup-builder\";i:0;s:16:\"uagb\/post-button\";i:0;s:18:\"uagb\/post-carousel\";i:0;s:17:\"uagb\/post-excerpt\";i:0;s:14:\"uagb\/post-grid\";i:0;s:15:\"uagb\/post-image\";i:0;s:17:\"uagb\/post-masonry\";i:0;s:14:\"uagb\/post-meta\";i:0;s:18:\"uagb\/post-taxonomy\";i:0;s:18:\"uagb\/post-timeline\";i:0;s:15:\"uagb\/post-title\";i:0;s:20:\"uagb\/restaurant-menu\";i:0;s:26:\"uagb\/restaurant-menu-child\";i:0;s:11:\"uagb\/review\";i:0;s:12:\"uagb\/section\";i:0;s:14:\"uagb\/separator\";i:0;s:11:\"uagb\/slider\";i:0;s:17:\"uagb\/slider-child\";i:0;s:17:\"uagb\/social-share\";i:0;s:23:\"uagb\/social-share-child\";i:0;s:16:\"uagb\/star-rating\";i:0;s:23:\"uagb\/sure-cart-checkout\";i:0;s:22:\"uagb\/sure-cart-product\";i:0;s:15:\"uagb\/sure-forms\";i:0;s:22:\"uagb\/table-of-contents\";i:0;s:9:\"uagb\/tabs\";i:0;s:15:\"uagb\/tabs-child\";i:0;s:18:\"uagb\/taxonomy-list\";i:0;s:9:\"uagb\/team\";i:0;s:16:\"uagb\/testimonial\";i:0;s:14:\"uagb\/wp-search\";i:0;s:19:\"uagb\/instagram-feed\";i:0;s:10:\"uagb\/login\";i:0;s:17:\"uagb\/loop-builder\";i:0;s:18:\"uagb\/loop-category\";i:0;s:20:\"uagb\/loop-pagination\";i:0;s:15:\"uagb\/loop-reset\";i:0;s:16:\"uagb\/loop-search\";i:0;s:14:\"uagb\/loop-sort\";i:0;s:17:\"uagb\/loop-wrapper\";i:0;s:13:\"uagb\/register\";i:0;s:19:\"uagb\/register-email\";i:0;s:24:\"uagb\/register-first-name\";i:0;s:23:\"uagb\/register-last-name\";i:0;s:22:\"uagb\/register-password\";i:0;s:30:\"uagb\/register-reenter-password\";i:0;s:19:\"uagb\/register-terms\";i:0;s:22:\"uagb\/register-username\";i:0;}"],"copied_media_ids":["a:7:{i:0;i:7336;i:1;i:7337;i:2;i:7338;i:3;i:7339;i:4;i:7340;i:5;i:7341;i:6;i:7342;}"],"referenced_media_ids":["a:1:{i:0;i:629;}"],"_uag_css_file_name":["uag-css-227.css"]},"uagb_featured_image_src":{"full":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109.jpg",668,211,false],"thumbnail":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109-200x200.jpg",200,200,true],"medium":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109-450x142.jpg",450,142,true],"medium_large":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109.jpg",668,211,false],"large":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109.jpg",668,211,false],"1536x1536":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109.jpg",668,211,false],"2048x2048":["https:\/\/carajandb.com\/wp-content\/uploads\/2015\/07\/01_Oracle_LRM-00109.jpg",668,211,false]},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":3,"uagb_excerpt":"Be careful when installing Oracle 12c on Windows. The first stumbling block, the Oracle Home User could produce a lot of trouble for you later. If you are used to running your Instance and Listener with an extra Account for Exports to Windows Shares, NAS devices or RMAN Backups to external storages for example with…","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":2,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":9531,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/227\/revisions\/9531"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media\/629"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}