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.
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.
Once downloaded, you have to extract the package to a folder. Please note, the extracted folder or the folder from which you will execute “Setup.exe” is going to be 19c Oracle Home. So, name the folder wisely. For example, I have extracted the files to a folder D:\Oracle\19c
You can start the installation by right clicking the Setup.exe and running as “Administrator”.
This will kick start the installation.
We will not create a database along with the software installation. Hence select “Set Up Software Only”
I suggest you to create a normal user (no administrator privileges) “oracle”, that will be used for all your future Oracle software installations. If you don’t have an account explicitly created yet for Oracle, the installation gives you an interface to create one. It’s your choice.
Please remember, earlier I said, the folder where you have extracted the installation media is going to be Oracle 19c home, aka Oracle Home. Rename the folder with an appropriate name before going ahead with the installation.
You will be asked to provide a location for Oracle Base. To content within the Oracle Home, you can specify a path like “D:\Oracle\19c\database” or “D:\Oracle\19c\db” or a folder name of your choice.
After few basic checks, the installation will proceed now. I strongly suggest you to assign a STATIC IP for your computer, prior continuing.
That’s it. No hacks, no modifications to config files or anything such to get the software installed on Windows!.
You can use “Database Configuration Assistant” for creating new database. We will see how to create a new database now. This time we will be creating a CDB (Container Database) and one PDB (Pluggable Database). You may go ahead with creating a single instance database when asked to choose between.
Select “Advanced Configuration”
You can choose between a normal database or Container database with PDB at next step. If you don’t wish to create the database as a container, uncheck the option “Create as Container database”. If you chose to continue with creating your database as container, I suggest you to leave the defaults as it is, other than the PDB name. If you need more PDBs, may add later to the container.
Leave the defaults, unless you know what you are doing.
If you are setting up the database for the LAB/Learning purposes, you may ignore these. However, for production instances, you must configure the Recovery area & setup archiving.
You can create a LISTENER for your database now. If you other Oracle database LISTENERs already running, choose a port number that wouldn’t raise a conflict.
Optionally you can setup Database Vault & Label Security at this step ;)
Okay, we need your attention here. Oracle automatically allocates 40% of total available physical memory for the newly created database. As I mentioned in the previous step, if you have more than one database running from the same computer, you must adjust the available memory to avoid choking the resources.
You may leave the defaults untouched here & you can change this value as sys admin when needed.
WebLogic Repos insist upon “AL32UTF8” Character Set & unless you have specific reasons to change the Character set, leave the defaults. If you are planning to migrate a legacy application that uses a different character set like Arabic (AR8MSWIN1256), please read this post
As per the post, you can use a different character set for a PDB starting from Oracle database versions 12.2.
We do love Scott bit too much, if yes, go with sample schemas (Trust me, you need it)
Enterprise Manager configuration is totally optional. If you choose to, will install an Express edition of Oracle Enterprise Manager (means more resources)
As usual, for a LAB environment I will go with same password for all accounts.
I would suggest you to accept the defaults at next step & change the passwords and unlock accounts as and when needed.
That should complete the installation and creation of database for 19c. Have comments? Please post them to me.
Windows 10 comes with a number of apps, usually we call them as bloatware in the mobile phones segments. Today we will see how to get rid of most of those pre-installed or bundled apps and a method to re-install the Microsoft Store app. By uninstalling the bundled software, trust me, you are going to save hell loads of bandwidth and storage.
Prerequisites: I am expecting you to have moderate experiences with Windows OS, as the below instructions might require you to open PowerShell as an administrator. For a fail safe situation, I will ask you to have minimum one more user account created and signed on prior you try to remove the pre-installed apps from your user account.
Once PowerShell console opens, you should able to see something like this on top of the console window “Administrator: Windows PowerShell”.
Before uninstalling the pre-installed apps, that includes “Microsoft Store”, we have to make a note of the Store application package name. Please note, the package name changes between builds, hence you must run the below command from your own Windows 10 machine, ie, do not copy from this post.
Side note: Please give extra attention to “PackageUserInformation”. This element lists all the user accounts those already have the “Microsoft Store” app installed. My work laptop (this machine) has four User accounts (default Administrator account disabled) including the domain user account. For my local and domain accounts, the store app is already installed and for other two accounts the app has been staged. Ie, not yet installed.
Please copy the “PackageFullName” element value to a notepad and save the file on the desktop with a name that you could remember.
In the same PowerShell console issue the below command
Get-AppxPackage -AllUsers | Remove-AppxPackage
This is going to start uninstalling the pre-installed apps. There will be some funny Red color texts, highlighted bars over the PowerShell prompt. Don’t get panicked. Based on the resources available this might take a while to finish. Once the PowerShell prompt returned, you will see that all the pre-installed apps are gone… for good!
However we need the Microsoft Store app back for downloading the most essential apps like Calculator, Mail client & few other. In the same PowerShell console, construct a command like below. Please make sure you will replace the package name with the one you have copied to the text file earlier.
I’m a huge fan of Oracle VirtualBox. Actually I have almost 10 different VMs (many of them were never used over years) scattered everywhere within my home network. Then I had this Windows 10 VM, that always had troubles.
Environment: HOST (HP PROBOOK 440 G7
Windows 10 Pro 64Bit, i7-10th Generation Processor with 8 CPUs, 32GB RAM, NVMe disk for OS and Crucial MX500 series 1TB SSD for data/Virtual Machines & Windows 10 guest has the configurations as seen with the image.
In addition to, for the VDI with fixed size, I have exclusively set “Solid-state Drive” flag. If you have a keen observation, I have selected “Hyper-V Paravirtualization” for “Acceleration” and I don’t have Hyper-V enabled :). Well, I didn’t hear any complaints (yet)!
After reviewing many posts and answers over VirtualBox forum, I have made few changes those I felt could make some differences, and I feel my VM responds much better after those changes.
Disable Transparency. This makes your Windows 10 VM respond much faster (not just “seems faster®” ;) )
Setup your box for best performance.
Reboot the Virtual Machine. I have seen slight gains with the booting time, however once logged in the VM is snappier than ever. I cannot help you, if you are using VM for something fancy that depends upon the Graphic processing. For a server side software like Oracle database where the performance matters, I think this is the only one go with current VirtualBox/Windows 10 setup.
If you are interested to see how long it takes for my VM to finally let me log in, watch the below video.
Well, it looks like the bug that Microsoft is dealing with is not something simple. Yesterday I was forced to change the password for my account, which has Administrator privileges due to some “too much gaming” by my 6 years old ;)
Immediately after the password change and restart, I started getting the message “OneDrive isn’t signed in” & one more thing I noticed was Microsoft Edge’s Sync profile account signed off. I always had a feeling that Microsoft Edge has something to do with the entire mess & I am not sure whether observing the above has any relevance as I am using individual apps to sign in, than using the live account globally.
The one positive thing until is, the entered credentials are still holding up & I was not asked to enter them once again today morning after cold reboot. It looks like Microsoft has messed up the Windows Credential Manager thingy little too deep this time!
**23rd November Update end***
“OneDrive isn’t signed in Please enter your sign-in info to start syncing again.” One of the little annoyances I had to live with post Windows 10, 2004 update.
After long “Googling” I came across multiple suggestions, none of which truly resolved my issues with OneDrive “automatic” signing in. Following couple of leads, I landed on to “Windows Credentials” and found that the OneDrive credentials were missing after a long shutdown & reboot.
This helped me to start finding details about cached credentials being “Expired” after a long interval between shutdown and reboot. I couldn’t find anything very specific explaining about this behavior until this moment.
Then I decided to uninstall OneDrive for a fresh installation. I uninstalled OneDrive, rebooted the box, reinstalled the software and tried various combinations like rebooting, cold reboots for next couple of hours to insure that the cached credentials were holding up. Started this thread and went to sleep the same night & next morning found that the cached credentials were once again missing!
While we were migrating from Windows XP to Windows 7, initial days the OS was plagued with unexplained bugs, causing this blogosphere :). One of the major issues we dealt with was corrupt profile for domain users, those required us to drop and recreate them on client machines!
I applied the same with this case, and did the following:
Enabled the “Administrator” account (You need minimum one account with Administrator privileges to carryout below)
Made necessary backups for the user account from which I was having OneDrive sign on issues. Please note, by deleting the user folder, you might lose some valuable data. So make sure adequate backups are made prior you delete the user account and related folders
Deleted the user account
Restarted & deleted the user folder (mandatory)
Re-created the user profile with same username!
Now Windows Credential Manager is holding up OneDrive credentials after 72 hours & I think this could be one of the possible fixes among many others!
The last standalone package for Remote Server Administration Tools was released for Windows 10 Version 1803 & the same was integrated into Windows 10 as optional packages with later versions of Windows.
There are many detailed installation instructions floating over dozens of tech blogs and sites, explaining how to enable/install RSAT on Windows 10. Today we will go through a quick how to without breaking much sweat & details.
As a Windows Domain Administrator, I need the following features at times:
Active Directory Users and Computers
For the rest, usually I use the remote desktop connection to domain controllers.
Please note, with each version of Windows 10, there might be minor changes with the way software is installed. Hence, make sure that you double check your version of Windows 10 before attempting the below instructions. These instructions are valid for Windows 10, Version 2004 with September 2020 cumulative updates.
Open Add or remove programs (Modern App management console)
Click on “Optional Features”
Click on “Add Feature” that will open up a list of available optional features. Remote Server Administration Tools or RSAT could be filtered by entering RSAT in the search area.
As I needed only “Active Directory users and computers” and “DNS Server” components, I chose them. You might need more components to be available to carry out your server administration. Choose everything that applies to your requirements & Press the “Install” button.
That’s all. Now you can access the features those were installed based on your selection from the start menu or by searching for them in the taskbar search box.
After weeks long considerations, finally I decided to give my development machine a fresh Windows installation using the Windows 10 version 2004 media. First time in my life, I opted GPT for Windows and switched to UEFI with secure boot.
While restoring my .Net project files, I noticed that the entire copying process getting hanged up while trying to copy “aspnet_client” folder from the backup disk to new location.
aspnet_client is a symbolic link to system_drive:\inetpub\wwwroot\aspnet_client folder, that is created within a project when SAP Crystal Reports for Visual Studio is referenced in a VS solution. I’m not sure whether the same symbolic link is created while using other 3rd party tools.
As my Crystal Reports experiments were recent and had multiple difficulties to get it finally work through my projects, immediately I setup IIS, which in turn created the “inetpub\wwwroot\aspnet_client” path on my box.
Next attempt, I was able to successfully copy the solutions to my box without any issues. It looks like, while symbolic links are used, the copying process tries to verify the paths & if the path doesn’t exist, process gets locked up.
If you are ever getting locked up trying to copy “aspnet_client”, I hope you will come across this post and happily end up with your tasks.
I can’t confidently say whether it is the KB4557957 or something that deliberate by me, I had serious troubles connecting to IKEV2 VPN, ending with a message “Parameter is incorrect”.
Although I landed on the solution earlier, I disrespected the order & spent another day trying to figure out the “issues”. Finally I did as the post asks & “fixed” the problems. Enough talks, just follow the instructions as mentioned on this page
I hardly had any issues with Windows 10, to conclude my experience with this specific OS. I’ve started using the OS from the 1st preview builds, was an insider etc.
Yesterday I couldn’t start the OS. Windows logo loads, OS loading animation starts and that’s all. After breaking the load process thrice, Windows initiated the Automatic Repair process and loaded the OS after a considerable amount of time.
As a practice, from years, I always move the Documents and Download folders to a different partition for my user account. This saves me additional time to backup and restore the user files when I need to rebuild the box.
Once Windows finally started, from experiences, I started checking for the partitions and found that two of the partitions on which I had the Documents and Downloads folders “WERE” missing. Now the difficult task was to identify the physical disk. My machine has total 6 disks (2 SSD, 4 various capacity mechanical drivers & couple of them 6+ years old) & after a thorough examination, realized that the disk that was having the “Downloads” and “Documents” folders has a SATA cable that was not anymore holding up it’s physical connection on the port. Once changed, everything went back to normal. Actually the user profile was trying to access the missing disk, causing the lockup during boot.
So, if you have heavily customized desktop computers once in a while, make sure that your connections are in place. Every time you open the case, make sure you are having all the cables checked and insured that tightly secured!
Internet explorer? Java client? Yes! Oracle E-Business Suite (Oracle Apps) uses NPAPI client when accessed through a web browser for Oracle Forms/Reports based applications. Currently the only one browser that allows the NPAPI client to load is Internet Explorer.
Depending upon the complex JAVA dependencies your version of Oracle Applications must be supporting a particular version of java client. Although you can use switches to load latest versions of JRE for your legacy Oracle application, not always advisable as I’ve experienced non-responsiveness & freezing.
Windows 10 version 2004 (Released by late May 2020) & subsequent cumulative updates MUST be the reason, causes a major issue with Internet Explorer (as on 26th June 2020). Once you installed & removed a higher version of JRE, JRE 6.x will not load anymore on the browser. You can reset Internet Explorer, reset your JRE & what not? Trying to open the Oracle forms based application would show the plugin being loaded and that’s all!
Strangely, I can see this issue is with only JRE 6.x when JRE 7.x and later load as usual without any problems. So if you think you have tried “everything” already & landed on this page, let us give it another try.
You can divide the below tasks into two sections. If JRE 6.x is the only one java client remaining after removing all other versions & if the JAVA_HOME or other Java related keys are not set under environment variables, just delete the “Sun” & “Java” Folders from “AppData” “Roaming”, “LocalLow” & “Local” folders. You may delete the “Javasoft” entry from “Computer\HKEY_CURRENT_USER\SOFTWARE\JavaSoft” registry path also. Try to load Oracle forms based application and if the java client is NOT at all loading, follow the below instructions.
Uninstall Java Software
After uninstallation remove all remnants of Java software from the system.
This should open the appdata folder the current user.
Let us find and delete all “Java” and “Sun” folders and content within those folders. Please note, if you are using JAVA for other than accessing Oracle EBS, the following instructions may result disastrous situations. Hence I recommend you to continue with utter caution.
Delete “Sun” and “Java” folders as I have said before from “Roaming”, “LocalLow” & “Local”
and open the below path
Delete the “JavaSoft” folder completely.
Now switch to “Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\JavaSoft”
This is the registry path where 32 Bit version of Java software is installed. Delete this folder also (if exists after uninstallation).
Now you are ready to re-install the Java client once again. I would prefer a computer restart prior attempting re-installation, which is not mandatory.
After the re-installation of JRE, opening the internet explorer should ask you for permission to enable the client and Oracle EBS should able to load the NPAPI client properly. Do let me know whether it helped you.