Month: December 2022

Linux 8 | Enable desktop icons

On By windows7bugsIn LinuxLeave a comment

I had a colleague, he challenged me 20 years back that “One day Linux will take over”. I don’t see anyone I know using Linux until date. That’s the end of the story.

So, let us see how a default installation of Linux 8 (Oracle Linux 8) looks immediately after installation

That’s it. User must click on the lone “Activities” menu & choose one of the listed. We’ve had a joke doing rounds about driver’s license application from a particular Indian state. That form had 5 names listed and the applicant was asked to select HIS name from the given.

I don’t have to look for another reason to understand why my ex-colleague was wrong whole the way. Instead of adapting to the users experience base that is mostly around Microsoft Windows, Linux is getting further away from normal desktop users. Minimum the Enterprise editions are. I know Ubuntu is far different from the Enterprise distros & this article is not meant for Ubuntu users.

So, let us see how to get few of the desktop icons (Classic as it is called now)

Click on “Activities” that will provide you a search box. Type in “Gnome” and you will see a number of suggested software listing. Select “GNOME Tweaks” & Install it.

Click on Extensions & switch Desktop icons “ON”. The moment you do that, Desktop icons will be visible.

Shame on you for using the old “Classic mode” geeks. Shame on you!

ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration]

On By windows7bugsIn NOT a DBA, Oracle Database 19cLeave a comment

I do loads of labs & after upgrading a cloned instance of EBS R12 (12.2) database 19c (19.14) to 19.16 & started noticing the error “ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration]” being logged. I tried to figure out what went wrong after the upgrade & after referring dozens of blog posts and Oracle documents, couldn’t fix this error.

Then, I configured this VM for Oracle ORDS & broke the system by applying few updates that overwritten few mandatory packages for Oracle EBS, forcing me to wipe the system and fresh installation of Oracle Linux 7.9

After applying the prerequisites, I brought up the cloned instance once again & decided to go by the book. After the database clone, I didn’t forget to apply “root.sh” from $ORACLE_HOME/bin folder as “root” this time.

If you are ever coming across this error, please ensure the folder/file accesses ($ORACLE_HOME/bin) are like the images below. Running “root.sh” fixes much of these access rights.

“oradism“

“extjob” & “jssu“

This should mostly address the VKTM related issues. If not, please proceed with further measures. If interested refer these documents/posts.

https://asanga-pradeep.blogspot.com/2021/07/ora-00800-soft-external-error-arguments.html

ORA-00800: Soft External Error, Arguments: [Set Priority Failed], [VKTM] [Check traces and OS configuration] (Doc ID 2551359.1)

Hope this helps few out there! Merry Christmas and a Happy New Year in advance!

Oracle VirtualBox 7 | Windows guests auto-resize guest display

On By windows7bugsIn Oracle VirtualBox, Windows 10, Windows 11Leave a comment

Host: Windows 11, 22H2, VirtualBox 7.0.4

I have one Windows 10 guest from last many years, upgraded through VirtualBox versions 5, 6. Recently I upgraded VirtualBox to 7. While Windows XP & Oracle Linux guests automatically resized the display on host, Windows 10 guest was adamant. Uninstalling and installing the guest addons didn’t help.

After scavenging through few posts over VirtualBox forums, came across one of them discussing about fixing the resizing issue by choosing “VBoxVGA”, though it was not supported. I decided to give it a try and Windows 10 guest resized the display when I toggled the “Auto-Resize Guest Display” from the view menu.

Then I shutdown the guest, changed the Display back to “VBoxSVGA” & the guest allowed me to resize the display using View menu & subsequent restarts were resizing the guest display as expected. However, there were times when I had to manually adjust the display size. Hope Oracle fixes this issue in coming releases.

Microsoft SQL Server | CREATE FILE encountered operating system error 5(Access is denied.)

On By windows7bugsIn .net programming, NOT a DBA, T-SQLLeave a comment

You might come across this error when trying to attach an existing MDF file. 

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:\Microsoft SQL Server\MSSQL\Data\AM8K.mdf'. (Microsoft SQL Server, Error: 5123)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-5123-database-engine-error

------------------------------
BUTTONS:

OK
------------------------------

Please do the following:

Make sure currently logged in Windows/Domain user has access to the physical folder where the MDF file resides.

Start “Microsoft SQL Server Management Studio” as administrator.

Now, try to attach the MDF file, this should resolve the Access Denied error.