APPSDBA Data Lake

  Error :  Host SMBus controller not enabled!  In order to fix it, I modified and add one line to dccp-blacklist.conf file . Redhat   depricated   the module: for security reasons, automatic loading of the Datagram Congestion Control Protocol (DCCP) kernel modules through socket layer is now disabled by default. blacklist i2c-piix4 ls -ltr /etc/modprobe.d/blacklist.conf cd /etc/modprobe.d/ ls -ltr cp dccp-blacklist.conf dccp-blacklist.conf.sid ls -ltr vi dccp-blacklist.conf Add blacklist i2c-piix4 then save it. Followed by reboot.

Log Location of WF mailer:  cd $APPLCSF/$APPLLOG ls -ltr  FNDCPGSC*.txt OR Below query shows active workflow log file. SELECT fcp.logfile_name FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup WHERE concurrent_queue_name in ('WFMLRSVC') AND fcq.concurrent_queue_id = fcp.concurrent_queue_id AND fcq.application_id = fcp.queue_application_id AND flkup.lookup_code=fcp.process_status_code AND lookup_type ='CP_PROCESS_STATUS_CODE' AND meaning='Active'; -------------------------------------------------------------------------------- /appsolworld/a1/inst/apps/TANSID_shsdb01/logs/appl/conc/log/FNDCP* .txt

  DBCA Log Location Two locations that can seen for the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name format of DBCA log would be: $ORACLE_BASE/cfgtoollogs/dbca/<DB_NAME>/trace.log-YYYY-MM-DD_HH-MI-SSAM Or simply a trace.log without timestamp. $ORACLE_BASE/cfgtoollogs/dbca/<DB_NAME>/trace.log Alert log location Alert log location It's the same as instance alert log file $ORACLE_BASE/diag/rdbms/<db_name>/$ORACLE_SID/trace/alert_$ORACLE_SID.log /appsolworld/oracle/product/19.3.0/trace/alert_ORCL1.log .