select distincts.inst_id,s.status,s.username,s.sid,s.serial#,s.schemaname,s.osuser,f.user_name,p.spid,f.request_id,s.process,s.module,s.action,s.machine,s.program,u.value || ‘/’ || lower(n.value) || ‘ora’ || p.spid || ‘.trc’ Trace_File,t.sql_textfrom gv$session s,gv$process…
/d01/oracle/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/diagnostics/logs/OHS/EBS_webtail -f EBS_web.logaccess_logvi /d01/oracle/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/config/OHS/EBS_web/mod_wl_ohs.conf /d01/oracle/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/oaea_server1/logs cd $EBS_DOMAIN_HOME/servers/oaea_server1/logsoaea_server1.outoaea_server1.log R12 E-Business Suite AccessGate User Login Fails After…
set lines 1000 pages 140col OutBytesPerSec for a10col OUTPUT_BYTES_DISPLAY for a20col INPUT_BYTES_DISPLAY for a20col TIME_TAKEN_DISPLAY…
http://mkkoracleapps.blogspot.com/2013/10/you-have-encountered-unexpected-plsql.html You have encountered an unexpected PLSQL Error, Please contact System Administrator You have encountered…
You have encountered an unexpected PLSQL error. Please contact System Administrator for assistance. log file…
Some of the most important Linux system logs include: /var/log/syslog and /var/log/messages store all global…
grep SwapTotal /proc/meminfodd if=/dev/zero of=/swapfile bs=2048 count=17408000dd if=/dev/zero of=/swapfile bs=2048 count=8704000df -hchmod 600 /swapfilesudo mkswap…
sudo firewall-cmd –zone=public –add-port=1521/tcp –permanent sudo firewall-cmd –reload sudo firewall-cmd –list-all
19c Database with Oracle E-Business Suite R12 Known Issues & Solutions (Doc ID 2662860.1)