How to identify OPP process
ps -ef |grep GSM or ps -ef |grep FNDOPP
ORA 16038 log 1 sequence# 158249 cannot be archived
https://community.oracle.com/thread/1081454?start=15&tstart=0 https://lokeshaggarwal.wordpress.com/2010/06/07/ora-16038-log-3-sequence-13-cannot-be-archived-ora-19504-failed-to-create-file/ ORA-16038: log 3 sequence# 13 cannot be archived ORA-19504: failed to create file “”…
weblogic error
http://oraclesoaweblogics.blogspot.com/2015_04_15_archive.html Wednesday, April 15, 2015 Weblogic domain creation error “Unable to invoke parse in InvokeStaticMethodTask”…
Concurrent requests queries
http://www.erpschools.com/scripts/sysadmin-aol/concurrent-requests-programs-executed-specific-user http://dilipappsdba.blogspot.com/2015/07/long-running-concurrent-requests.html https://techgoeasy.com/concurrent-manager-queries/
RAC issues
Listener issue TNSLSNR for Linux: Version 12.1.0.2.0 – Production System parameter file is /d01/oracle/product/12.1.0/dbhome_1/network/admin/ebsdb1_linux1/listener.ora Log…
ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete
https://jameshuangsj.wordpress.com/2017/09/05/ora-15001-diskgroup-data-does-not-exist-or-is-not-mounted-ora-15040-diskgroup-is-incomplete/ ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete restore…
Clone issues
Issues 1>Concurrent manager was not starting https://moreappsdba.blogspot.com/2017/05/cm-was-not-coming-up-even-while-taking.html Concurrent Managers Fail to Start: “insert_fcp failed due…
ORA-28040: No matching authentication protocol
$FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes -appspass=apps ORA-28040: No matching authentication protocol Solution: Bug 14575666 In 12.1, the…
Clone failed
Fix: 12.2 EBS adop phase=fs_clone fails during wlsT2PApply on unpack.sh with error “Java Heap Space”/”java.lang.OutOfMemoryError:…
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…