Oracle Application R12 12.2 one user cannot logon

We are using Oracle EBS R12 for last 12 years and recently upgraded to 12.2.10. We hardly had much technical issues with the instance until recent days, then came a real annoyance.

One particular user was unable to logon. Instead of OA_HTML page, he was either getting redirected to logout page or the OA_HTML page keeps on trying to load. One of the workarounds we came across was, resetting his password. Once the password changed, he was taken to setup password page and to regular landing page. Well, this also turned into troublesome as each time his session expired, we were forced to reset his password.

So what went wrong? We had an issue with concurrent manager outputs and logs opening into a blank page recently. This happened after RMAN backup up, that is scheduled and we had to run autoconfig to fix this issue. Although autoconfig fixed that issue, opened issues with user logon, as explained above. We kept on watching the alerts for possible errors and there were none. Anyhow, we decided to do the following as the ONLY one relevant document we were able to find on Oracle support was “Unable To Login With One User On Oracle EBS Application (Doc ID 2480008.1)” and the case described was not our case.

This is what finally worked:

  • Cleared global cache (didn’t fix issues)
  • Shutdown Apps tier
  • Ran autoconfig on database Tier
  • Ran autoconfig on both Run and Patch file systems
  • Restarted Apps tier and the issues were resolved

We really don’t know what happened after the RMAN & we didn’t update/altered the OS (Oracle Linux 7). Well, things could go south once in a while, after all Oracle EBS is such a huge and complex repository!

Oracle | Single listener for multiple versions of database

Environment: Windows OS (Windows 11)

Currently I’ve 2 different versions of Oracle database installed & instances running from my development machine. Oracle 11G R2 (11.20.4) and Oracle 19c (19.14) & yes, we are supported by Oracle. I had 11G installed first & later installed 19c for checking out APEX and ORDS.

As 11G listener was running, I didn’t notice anything problematic until, tried to connect as a specific user. I started getting the error that the listener doesn’t know of the service name.

PS D:\Oracle19c> sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 12 12:45:30 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> quit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
PS D:\Oracle19c> sqlplus system@SCTCDB

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 12 12:45:34 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:

I went ahead and using netca registered the 19c service with 11g listener, restarted the listener services and this time instead of complaining about the missing service, connection attempt froze.

After some confusion, I decided to drop the 11g listener services and created a new listener from 19c environment.

Registered both 19c & 11g services using 19c NETCA this time & restarted the listener. I was able to connect to both databases using username/password@servicename syntax this time.

So let us see what went wrong. 11g database was configured for connections from Oracle Developer 6i legacy applications.

This cannot be modified without failing the legacy application. Please refer the below to understand how the authentication works with different versions of databases and what has changed.

Check for the SQLNET.ALLOWED_LOGON_VERSION Parameter Behavior (oracle.com)

As I am not allowed to change 11g environment, the ONLY one way I can use the same listener was to register 11g service with 19c listener. Simple, clean and effective. Hope this helps few out there who is not a certified DBA like me ;)

Linux 8 | Enable desktop icons

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]

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

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.)

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.

Windows Mobile hotspot | Connected without internet

Update: 7th December 2022

Today I managed to narrow down the issues to Intel driver specific. AX201 Wi-Fi module driver 22.160 and above breaks the mobile hotspot on both Windows 10 & Windows 11. The only possible solution is to rollback to driver version 22.150.x.x & stay there until Intel identifies and fixes this issue. I have opened a thread with Intel and the representative is investigating this issue. If you are interested, follow the thread here

We’ve poor cellular coverage by the datacenter area from the service provider & most of the times I use my work laptop as Mobile hotspot & it did work. Well, minimum until recent days.

I started seeing my mobile phone showing “Connected without internet” once in few minutes times & I had to reconnect which was a recent development. Unfortunately, I couldn’t land upon any relevant solutions after spending almost two working days searching for solutions & executing my own logic with resetting network/Winsock etcetera.

As I use Samsung Galaxy A71 5G Android phone, I thought of giving another attempt by searching for “Galaxy a71 5g connected without internet” & one of the first search results was:

Samsung Galaxy Phones “Connected without Internet”

Here, the vlogger talks about “Randomized MAC” Galaxy phones use when connecting to Wi-Fi networks. Although the vlogger suggests Static IP address & other changes to resolve this issue, I only changed the connection property from “Random MAC” to “Phone MAC” & days long frustrations were over.

I wanted to figure out why all of a sudden this issue started. I remember using the Mobile Hotspot without any issues, had a PowerShell script to start the mobile hotspot startup automatically whenever I am connected to work network for months & couldn’t just give up because I found a solution. Hence, I continued to find more answers.

There were more videos discussing the same issue about Samsung Galaxy phones & subsequently I landed on a Samsung community discussion here

My mobile is paired over Bluetooth to my laptop & it connects every time laptop restarts. One of the initial settings I checked was to ensure Mobile Hotspot was not setup for 2.4GHz, that causes issues for Bluetooth which uses 2.4GHz by default.

In my case, at work I am not connected to Wi-Fi networks & mobile hotspot is configured to share internet from my domain network connection. By default, as the 5GHz is not consumed by Wi-Fi connections, mobile hotspot utilizes that frequency and leaves a notification, asking to switch the frequency if devices fail to connect.

Hence, it could be one of the many elements as discussed in the Samsung community thread. All you need is to try and find out one that suits your situation. Regardless, if it is a Samsung Galaxy phone, the first solution you could try is to setup Phone MAC instead of Randomized MAC for the specific Wi-Fi connection that you have issues with. If that didn’t resolve, try others.

Oracle Linux | “Peer’s certificate issuer has been marked as not trusted by the user.”

Recently I was trying to update one of the Oracle Linux 7 boxes that is used for lab & came across multiple errors.

OCI : Yum Fails with [Errno 14] curl#6 - "Could not resolve host: yum-iad.$ocidomain; Unknown error"
[Errno 14] curl#60 - "Peer's certificate issuer has been marked as not trusted by the user."

I kept on doing almost everything yum was suggesting, disable the repos, cleaning etc. Yes, I did ping both google.com & yahoo.com to “insure” that I was connected to “internet” (I’m still struggling to figure out how the heck I managed to ping these hosts when I was actually unable to connect to Oracle mirrors)

However, after exhausting more than couple of hours, I decided to access the server through VNC & see whether I am missing something, that cannot be done from the command line.

Fired up Firefox & realized, I am not connected to “Internet” in real terms. I couldn’t open any pages and I proceeded with adding the static IP address to exclusion list and that was it.

So, if you ever come across the above mentioned errors, make sure you ARE connected!

Windows | “ORA-12640-Authentication adapter initialization failed.”

Recently at a gathering I was asked about my job. I told a group of young chaps that I work with Oracle EBS and my primary role is developing extensions using Oracle Forms & Reports. Interestingly, none of them knew anything about Oracle Forms & Reports.

Couple of days back I installed Oracle 11G R2 database once “again” as I had to open our legacy software for some historical data access. Then I had to develop a report and to my utter surprise, found Oracle 10g report developer will not connect to 11G database, generating the following errors:

REP-0501: Unable to connect to the specified database.
ORA-12640: Authentication adapter initialization failed

I hurried to check the database sqlnet.ora file and found the authentication set as NTS (Windows default for Oracle products) & interestingly Developer 6i products were connecting to the database without any issues. This helped me to confirm that issues were from Developer 10g side & I changed the sqlnet.ora settings for the Developer 10g Suite.

from NTS to NONE did the trick.

I don’t know how my people are ever going to land on this page! Trust me, I haven’t seen an interesting question about Oracle Forms/Reports in any of the Oracle support forums from last many years. I will be pretty sad to see such a wonderful product that was built for developing Business applications on the go being ignored for some crappy browser based gimmicks.

Happy Diwali guys 🙏

Windows 11 | File Explorer not responding

Last couple of years, I stopped evaluating new Windows OS, as they were shipped with so many bugs and updates breaking them further. I felt reporting the bugs didn’t make anything better & few of the folks from Microsoft on Twitter are just lame like their OS. Always finding excuses for a broken OS.

Well, regardless, I always applied the updates, always fixed the issues and continued working on my projects, which are Oracle development (mostly). Like usual, I’ve downloaded the Windows11 22H2 the very first day it was released and upgraded my work laptop. Basically the OS is once again filled with many bugs, one of the notorious being the large file copying lag issues, that is openly acknowledged by Microsoft.

Well I was stuck by an undocumented issue ;) Whenever I tried to open File Explorer, it took many minutes before it was ready to interact with. None of the searches landed me on a proper solution & I just wasted hours tweaking the OS following tips to parameterize the OS for better performance. Then I was expected to copy a large SQL output for our sales manager and I had a shortcut for a folder in his computer on my desktop. I couldn’t open this folder this time & I couldn’t find his laptop’s hostname in the DNS. As the folder was mapped using the hostname, every time I tried to access the folder, gave me the same network path not found error. It took the same amount of time file explorer tried to open & I could make a guess towards what was going wrong with the file explorer.

I remembered this particular folder always listed under the quick access area of the File explorer & I removed it from the quick access area once after the File Explorer was ready next time. File Explorer started opening as snappier as possible then onwards.

Now, this looks like another problem from Microsoft’s latest release that attempts to connect to all the items listed under quick access, ie, like connecting the network folders & failing to establish a connection, throws the exception “File explorer not responding” and taking minutes until the attempts are aborted.

I’ve many folders pinned to quick access area, as a developer I work with multiple projects and this saves loads of time for me. Windows 10, 11 keep tabs on regularly accessed items and pin them to quick access area, a default behavior of the OS. This might create certain unexpected situations like the one I described above. I will not say this feature is useless, but sometimes a user who is not that tech savvy may never realize what is going on here. If I were the File explorer designer/developer I will definitely make sure to code the piece in a way that Explorer would try to connect to network folders only when the user tries to open the folder.

Said, if you are having the same issues with File Explorer taking too much time to open, please check whether any network folders are listed under Quick Access area. If yes, remove them. Unless you are a die hard of fan of automatically pinning items in the Quick Access area, disable the automatic pinning.

This could OS automatically pinning items to your Quick access area & avoid the issue I were discussing.