Microsoft ODBC Driver 17: A previous installation required a reboot of the machine for changes to take effect.

Today I was trying to install SSMS SQL Server Management Studio 18.9.1 & the installation was stopped with a message “Microsoft ODBC Driver 17: A previous installation required a reboot of the machine for changes to take effect”

Abiding, I went ahead to reboot & instead pressed the shutdown button. After restarting the PC, tried to install SSMS once again and the installer gave up mentioning the same message.

All I needed was “reboot” the machine. Microsoft is sometimes, grr.

Install Oracle Database 19c on Windows 10

This time let us see how to install Oracle database 19c on Windows 10. This installation is not much different from Oracle 18c installation.

You can download the 19c Installation media for Windows from the below link.

Database Software Downloads | Oracle

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 | Uninstall pre-installed/bundled software & apps

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.

Get-AppxPackage -AllUsers -Name "Microsoft.WindowsStore"

So for my Windows 10 box, I need to copy the value for “PackageFullName”, that is

Microsoft.WindowsStore_12011.1001.1.0_x64__8wekyb3d8bbwe

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.

Add-AppxPackage -register "C:\Program Files\WindowsApps\Microsoft.WindowsStore_12011.1001.1.0_x64__8wekyb3d8bbwe\appxmanifest.xml" –DisableDevelopmentMode

Microsoft Store app should be installed instantly and you can proceed with installing your essential apps from the store now.

Like all other times, I ask you not to proceed, if you don’t know what you are going to end up with!

One much detailed information you can find here [Guide] How to Uninstall and Remove All Built-in Apps in Windows 10 – AskVG

VirtualBox | Windows 10 Guests too slow

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.

Leave me your comments!

OneDrive isn’t signed in

Updated on: 23rd November 2020

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!

regards,

rajesh

RSAT: Remote Server Administration Tools for Windows 10

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:

  1. Active Directory Users and Computers
  2. DNS Manager

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.

regards,

rajesh

aspnet_client | Windows copying hangs

Hello guys

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.

rajesh

Windows 10 | parameter is incorrect

Hi guys

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

https://github.com/trailofbits/algo/issues/1051

regards,

rajesh

Windows 10 | Stuck in the boot

Hi guys

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!

regards,