who is connected – username
select distinct d.user_name, b.SID,b.SERIAL# from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d where b.paddr…
Yearly Archives: 2018
_pages directory in 12.2
Location of _pages directory in 12.2 is $EBS_APPS_DEPLOYMENT_DIR/oacore/html/WEB-INF/classes/_pages If any page needs to be compiled navigate…
find command in linux
find . -name “*.*” -size +500000k -exec ls -ltr {} \;
weblogic admin password
If we don’t remember weblogic admin password, we can get it as below. [applmgr@ebs1213 ~]$…
Top 30 Most Useful Concurrent Manager Queries
https://techgoeasy.com/concurrent-manager-queries/
error while loading shared libraries: libclntsh.so.12.1
lsnrctl start TEST lsnrctl: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file:…
txkGenADOPWrapper.pl APPS.AD_ZD_ADOP package error
Running AutoConfig generates ORA-04063: Package Body “APPS.AD_ZD_ADOP” Has Errors (Doc ID 2175698.1) SQL> alter package…
AWR report analysis in depth-part 1
https://clouddba.co/awr-report-analysis-depth-part-1/
error -29548: ORA-29548: Java system class reported
While changing the apps password Working… Oracle error -29548: ORA-29548: Java system class reported:…
Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28
Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 (Doc ID…