Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
ISSUE: In this Blog we are going to learn about How To Find a Particular Database Session ID From the SQLID.One of my customer informed me I have query running …
Read More »Yearly Archives: 2024
Oracle ACE PRO Award To Syed Saad Ali
ORACLE ACE PRO AWARD On 5th June 2024, I finally received an e-mail from the Oracle Corporation with the approval of my application to become an Oracle ACE Pro I’m …
Read More »How to check status ( State and Health ) of Managed Servers under weblogic console from linux instead of browser URL
Issue:While accessing the EBS 12.2.13 Weblogic Console to check health status of EBS managed server the browser redirects to below error as a security restriction:The Server is not able to …
Read More »Updating OS in Oracle RAC
Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC …
Read More »April CPU JDK Upgrade on DB
April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version “1.8.0_311” …
Read More »Changing IP Address in an Oracle EBS R12 Environment
Changing IP Address in an Oracle EBS R12 Environment 1. First, Change the IP Address of the Server by editing the /etc/hosts file
Read More »AUTOCONFIG COULD NOT SUCCESSFULLY INSTANTIATE THE FOLLOWING FILES
ERROR Error: ****** DB autoconfig Error: ***************** [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory and phase. …
Read More »Manually remove ODA DB HOME
Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. Check if any running jobs currently: # odacli list-jobs. 2. If none, then stop the …
Read More »Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status
ERROR Adrelink Fails With Error tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status /u01/app/applmgr/TST123/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm -lpthread /usr/bin/ld: cannot find /u01/prod/apps/tech_st/10.1.2/lib/stubs/libc.so.6 collect2: ld returned 1 exit status make: *** [/u01/app/applmgr/TST123/apps/apps_st/appl/ad/12.0.0/bin/adpchnew] Error …
Read More »Removing Old Grid Home
Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-componentSystem Version—————19.20.0.0.0 System node Name—————testlinux …
Read More »