Skip to content

Duh! Microsoft did it again

(They always discourage & We always do)

  • About
  • Contact me
  • Donate, Please

Day: March 26, 2021

ORA-28000: the account is locked | Database Creation

On March 26, 2021March 26, 2021 By windows7bugsIn NOT a DBA, Oracle database 11g, Windows 10Leave a comment

Recently I had to install Oracle 11G R2 on a computer running Windows 10 20H2. Though the software installation completed successfully, I came across a ORA-28000 while creating a new database using DBCA. I was logged in as Domain\Administrator account while creating the database. Immediately remembered our troubles with Windows 2019 server recently, that wouldn’t allow the domain administrator account “Administrator” to change any vitals while logged in! (You may note run in to this situation if you are logged in as another domain administrator, eg: your own user account that is a domain account with admin privileges)

As both Windows 10 & Windows Server OS (2016+) share much of the same code, most of these behaviors are visible on both OS and the thankfully the solutions are the same. If you were having the Oracle installation error ORA-28000 and the situations are matching the above described, please head towards making the following changes. Please note, you must take maximum precautions while changing registry, local security policies etcetera. You must remember, ORA-28000 could arise when Oracle accounts are locked up due different reasons, those you need to take care differently. This post is strictly dealing with the ORA-28000 that arises during the database creation using DBCA.

Run/Execute gpedit.msc

You have to open the node Computer Configuration->Windows Settings->Security Settings->Local Policies->Security Options and configure “User Account Control: Admin Approval Mode for the Built-in Administrator account”. Follow the below image for more details.

Once enabled, you must sign off and log in to bring this mode change in effect. Although this enablement is for the built-in local “Administrator” account, somehow due to the similarities in the account names, Domain administrator account “Administrator” also gets restricted. This could be planned or a bug from Microsoft.

You can use DBCA to delete the database that you were forced to abort during creation & continue creating a database with same name or another now.

Hope this helps few out there!

We are on twitter

  • We had a salesman who always managed to crash carefully crafted, tested in-house developed applications. So we came… twitter.com/i/web/status/1… 3 days ago
  • I see many #dotnet developers not interested to develop with @Oracle database. It looks like much of them "think"… twitter.com/i/web/status/1… 4 days ago
  • Using #EntityFramework with @Oracle #EBS database should be the challenge of a life time as much of the tables do n… twitter.com/i/web/status/1… 6 days ago
  • .@connor_mc_d recently I have changed from a PLSQL block (4 lines of logic) to over() windowing using analytic and… twitter.com/i/web/status/1… 1 month ago
  • After developing business applications for more than 2 decades, I realized that I should start learning #SQL #Oracle 1 month ago
Follow @w7bugs
March 2021
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031  
« Jan    

Top Posts

  • Install Oracle forms & reports 12.2.1.4 with Weblogic 12c 12.2.1.4
  • Oracle services disappear from Windows Services panel after upgraded to Windows 8.1
  • Windows | Upgrade Oracle Database 12c to 19c
  • Windows 10 | MAP SMS/MMS Other devices
  • Install Oracle 12c forms & reports, database, weblogic server
  • OneDrive isn't signed in
  • ASP.Net | Freeze GridView header row using java script & CSS
  • Windows 10 | parameter is incorrect
  • Windows | ORA-12560: TNS:protocol adapter error
  • RMAN | Restore Linux Backup to Windows

Recent Posts

  • ORA-28000: the account is locked | Database Creation
  • Microsoft SQL Server | Reduce disk usage
  • Oracle Inventory | Aging Analysis
  • Windows | Upgrade Oracle Database 12c to 19c
  • Install Oracle Database 19c on Windows 10

Word Press

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Blog Stats

  • 1,072,085 hits

Recent Comments

windows7bugs on Install Oracle forms & rep…
Deddy Sinaga on Install Oracle forms & rep…
windows7bugs on Install Oracle forms & rep…
Rizwan on Install Oracle forms & rep…
windows7bugs on Install Oracle forms & rep…

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 101 other subscribers

Categories

  • .net programming
  • Active Directory
  • Android
  • Educational
  • Gadgets
  • Hardware
  • Linux
  • Linux
  • Networking
  • NOT a DBA
  • Notes for personal references
  • Offtopic
  • Oracle Applications (R12.0.4)
  • Oracle Applications(R12)
  • Oracle database 11g
  • Oracle database 12c
  • Oracle Database 19c
  • Oracle Enterprise Linux
  • Oracle Forms
  • Oracle Inventory (R12)
  • Oracle related
  • Oracle SQL Developer
  • Oracle VirtualBox
  • Samsung
  • Security
  • T-SQL
  • Uncategorized
  • Visual Studio(VB.Net)
  • Weblogic
  • Windows
  • Windows 10
  • Windows 2016
  • Windows 7
  • Windows 8
  • Windows 8.1
  • Windows Phone
  • Windows Server 2016
  • wordpress
Powered by WordPress.com.