Author Archives: syedraheeldba.com

TMUX background session usage and benefits in RedHat Linux 8

Executing screen command in Linux 8 gives error:bash: screen: command not foundThis is because: From Linux 8.x onwards screen has been deprecated and tmux has been introduced.Execute Un-Interrupted Red Hat Linux 8 Sessions (Remotely in the Background) using TMUX (Replacement … Continue reading

Posted in Uncategorised | Leave a comment

Oracle EBS 12.2.14: Upgrade JDK to the Latest Java on the Application Tier

JAVA UPGRADE STEPS : NOTE: JDK 7 has reached Sustaining Support at the end of July 2022. However with Oracle EBS only JDK 7 is certified and supported untill the time of posting this blog To Upgrade JDK : Via … Continue reading

Posted in Uncategorised | Leave a comment

Here’s how to solve: Error on perl txkCfgUtlfileDir.pl on getUtlFileDir afer restoraion of 19c Database

ERROR on perl txkCfgUtlfileDir.pl on getUtlFileDir when 19c EBS Database backup has been restored [orauat@ebsdbuat dbs]$ su – orauatPassword:[orauat@ebsdbuat ~]$ cat envPRECDB.env. /do2/8010_uat_db/db/19.0.0/PRECDB_ebsdbuat.env[orauat@ebsdbuat ~]$ . /do2/8010_uat_db/db/19.0.0/PREUPG_ebsdbuat.env[orauat@ebsdbuat ~]$ cd /do2/8010_uat_db/db/19.0.0/appsutil/bin[orauat@ebsdbuat bin]$ [orauat@ebsdbuat bin]$ perl txkCfgUtlfileDir.pl -contextfile=/do2/8010_uat_db/db/19.0.0/appsutil/PREUPG_ebsdbuat.xml -oraclehome=/do2/8010_uat_db/db/19.0.0 -outdir=/do2/8010_uat_db/db/19.0.0/appsutil/log -mode=getUtlFileDirEnter the APPS … Continue reading

Posted in Uncategorised | Leave a comment

ORA-28000 – the account is locked in the Active Standby Database

ORA-28000, the account was unlocked in the primary database, but still locked in the Active Standby Database. Situation: The primary database is configured with Dataguard is returning an error ORA-28000, “the account is locked,” when the user tries to log … Continue reading

Posted in Uncategorised | Leave a comment

EBS 12.2 adcfgclone appsTier gives error: libnsl.so.1: cannot open shared object file: No such file or directory

ISSUE: /u01/ebs/fs1/EBSapps/10.1.2/bin/sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory While running adcfgclone appsTier single fs on EBS 12.2.10 FATAL ERROR PROGRAM : (/u01/ebs/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkManageDBConnectionPool.pl) TIME : Sun Nov 10 15:26:51 2024 FUNCTION: … Continue reading

Posted in Uncategorised | Leave a comment

How to Verify Oracle Data Guard Sync Status

Verify whether your Primary Oracle Database is in sync with the Standby Database in a Data Guard configuration. Solution: To ensure synchronization, you need to check the Managed Recovery Process (MRP) and query relevant views that provide real-time status and … Continue reading

Posted in Uncategorised | Leave a comment

EBS 12.2: Application tier SSL wallet gives error while opening Apache folder via Oracle Wallet Manager

ISSUE: I had to renew my customer’s EBS SSL certificate as it was about to expire soonSince the EBS 12.2.7 wallet had the ability to open wallet in GUI mode , I tried to open wallet BUT was Not able … Continue reading

Posted in Uncategorised | Leave a comment

After login to EBS 12.2.5 the Home page gives error: You have encountered an unexpected error. Please contact the system administrator for assistance

ERROR: When we click on the home button on landing page after login on java applet we are facing this issue.” You have encountered an unexpected error. Please contact the system administrator for assistance. “ when we click on ” … Continue reading

Posted in Uncategorised | Leave a comment

On Google Cloud Platform, Redhat Enterprise Linux 8.10 Virtual Machine could not be able to connect via ssh with below error: Permission Denied (publickey.gssapi-keyex.gssapi-with-mic)

ISSUE: While migrating one of my client’s Core Oracle Database from an on-premises environment to Google Cloud VM Instance. I encountered an issue while transferring files via SCP from the source Linux server to the target and was unable to … Continue reading

Posted in Uncategorised | Leave a comment

How To Resolve EBS 19c DbTechStack Cloning Issues On Red Hat Enterprise Linux 8.10 (perl Adcfgclone.pl DbTechStack)

ISSUE: While running perl adcfgclone.pl dbTechStack, Cloning EBS integerated 19c Database TechStack Fails on supported OS Check with Red Hat Linux 8.10 CAUSE: 19c does not contain Pre-req checks specific to Oracle Linux 8 / Red Hat Linux 8.10Silent Installer … Continue reading

Posted in Uncategorised | Leave a comment