Author Archives: syedraheeldba.com

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

How to Resolve Non-SSL Login Failures After Successfully Cloning SSL-Enabled EBS 12.2.13

ISSUE: After Adcfgclone appsTier for a newly cloned ebs 12.2.13 environment from an SSL-enabled ebs precloned stage backup prevents me from logging in to non-SSL EBS login URL, despite it was completed 100% successfully without any error. CAUSE: EBS Context … Continue reading

Posted in Uncategorised | Leave a comment

How to fix http service after sudden Power Shutdown of EBS 12.2 Server/Machine

Issue faced: Sudden Power shutdown of EBS 12.2 Application Server / Machine cd $ADMIN_SCRIPTS_HOME./adapcctl.sh status Noticed that the http service shows STOP SOLUTION: cd /u01/ebiz_APRIL_2018/fs1/FMW_Home/webtier/instances/web_GEAPROD_OHS1/config/OPMN/opmn/states ls -lrta -rw-r—–. 1 applprod dba 14 Oct 26 10:58 .locale-rw-r—–. 1 applprod dba 579 … Continue reading

Posted in Uncategorised | Leave a comment

ORA-12514: TNS:listener does not currently know of service requested

Symptoms/Problem Details : Unable to connect apps user from a Recently cloned and EBS RUP 12.2.12 applied Application nodesqlplus apps/*****ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.[oracle@clone admin]$ sqlplus apps/****SQL*Plus: Release 10.1.0.5.0 – Production on Mon … Continue reading

Posted in Uncategorised | Leave a comment