The second problem is one that plenty of people have hit, Oracle and Windows password complexity mismatch. This is a bug that I really cannot understand why Oracle haven\u2019t fixed yet, but perhaps it\u2019s more complex than I am giving them credit for. If whilst doing a software install you get an error during the installation window about \u2018Couldn\u2019t create Oracle home user\u2019 and you DEFINITELY ran the installer as Admin, then chances are you\u2019ve fallen foul of this. The issue is fully repeatable. All you need to do is:<\/p>\n
- \n
- Check your Windows password complexity rules in local security policy -> account policies\u00a0-> password policy is set to enabled<\/li>\n
- Run the Oracle installer for the database<\/li>\n
- Select Software only (or create DB if you want)<\/li>\n
- When prompted for user details, make sure you select \u2018New user\u2019<\/li>\n
- Enter a basic password like Oracle12<\/li>\n<\/ul>\n
Oracle will accept the password without complaint and will continue with the install seemingly fine. However, when it gets to 86% it fails with the below error:<\/p>\n
![\"\"](\"http:\/\/www.onomi.co.uk\/wp-content\/uploads\/2018\/02\/error2.jpg\")
<\/p>\n2 solutions, one not recommended, but both require backing out the install:<\/p>\n
- \n
- Switch off the password complexity rules \u2013 not recommended for obvious security reasons but you may need to do this if you need a certain password<\/li>\n
- Redo the install but make sure it matches your complexity rules<\/li>\n<\/ul>\n
Simple fixes but very unnecessary.<\/p>\n
The third headache was a bit more complex. After uninstalling Grid and reinstalling it successfully, time came to install the DB software and create our new DB. The software installer threw an error I had not seen before:<\/p>\n
![\"\"](\"http:\/\/www.onomi.co.uk\/wp-content\/uploads\/2018\/02\/error.jpg\")
<\/p>\nThis points to a privileges or permissions issue, but I\u2019m running the install as Administrator, so I should have all the access needed. Checking the log file shows that the installer is trying to write Oracle registry keys but checking them against a working install shows they all appear correct. I can click \u2018Ignore\u2019 on the error and the installer completes but it then will not allow me to create a DB using that software installation, giving a further error complaining of being unable to write to the controlfiles. I can write to that location, and when I check the controlfile it refers to is there and can be opened by my user. Strange.<\/p>\n
I did what every modern DBA does and turned to Google which has saved all of us on many occasions. Nothing. Only 1 hit for \u2018Failed to create user ACLs\u2019 which mentions Oracle and I have a different error message. Nothing on Oracle Support either. Looks like I\u2019m on my own with this one. Time to think it through logically.<\/p>\n
- \n
- ACLs \u2013 Access control lists, so for some reason Oracle doesn\u2019t think I have permissions when Windows thinks I do?<\/li>\n
- What user does Oracle try to use when I use the \u2018Run as Admin\u2019 option? Is it really using \u2018Administrator\u2019? How can I find out? If you are lucky enough to have auditing turned on (it\u2019s off by default but I really do recommend turning it on!) then you can check commands run with elevated privileges in the Security Event viewer. Fortunately, this was enabled for me and suddenly the issue became clear\u2026<\/li>\n<\/ul>\n
This server was setup to use Danish language as it\u2019s default. Oracle however loaded most of the text in English, so I didn\u2019t need to change it for the install. In a Danish server the admin account is called \u2018Administrat\u00f6r\u2019 and Oracle cannot handle the special characters. The solution to this one is to create a new user with Admin privs and run the installer using that account instead. Another non-perfect solution.<\/p>\n
Even more unhelpfully, if you click ignore enough times for all these issues the installer completes and reports success even though the registry keys aren\u2019t set, some files aren\u2019t installed and any attempt to create a DB will fail. I have raised a bug report with Oracle which has been acknowledged but not yet actioned.<\/p>\n
<\/p>\n
\n[\/et_pb_text][et_pb_divider color=”#e05206″ _builder_version=”3.9″ background_color=”#e05206″ height=”2px”][\/et_pb_divider][et_pb_team_member name=”Kate Gawron” position=”Database Consultant” image_url=”http:\/\/content.n4stack.io\/wp-content\/uploads\/2018\/07\/Kate-Gawron-2.png” _builder_version=”3.11″ global_module=”53225″ saved_tabs=”all”]<\/p>\nKate spends most of her time working with Oracle databases and products, but dabbles in MySQL and SQL Server when the need arises.<\/p>\n
She enjoys researching and testing new solutions to see how they could benefit our projects, often testing to destruction!<\/p>\n