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 .

 There is no single source for higher than expected growth in the SYSAUX tablespace:  There are however a few common sources that can be investigated and confirmed quickly using a few views and scripts One important view is V$SYSAUX_OCCUPANTS Another very useful and provided script is the AWRINFO.SQL script found in the Oracle_home/rdbms/admin directory Let's start by taking a closer look at V$SYSAUX_OCCUPANTS*    select OCCUPANT_NAME,OCCUPANT_DESC       from V$SYSAUX_OCCUPANTS       order by SPACE_USAGE_KBYTES desc    select SPACE_USAGE_KBYTES, OCCUPANT_NAME       from V$SYSAUX_OCCUPANTS       order by  1 desc SPACE_USAGE_KBYTES OCCUPANT_NAME ------------------ -------------------------------- (1)            118144 SM/AWR (2)             23360 SM/OPTSTAT                 13696 LOGMNR (3)...

very basic question:  to delete data for more than 100 tables and wanted to retain the table structure and index. Which one is the best option to remove all data from table TRUNCATE or DELETE? truncate is DDL. which means - implicit commit before the statement - implicit commit after the statement - the high water mark of the table will be reset It will use no redo and can not be rolled back. delete is dml it means if no commit after the statement The HWM will not be reset. commit/rolled back is possible DROP :   It is a DDL. It is used to drop the whole table. With the help of the “DROP” command we can drop the whole structure in one go it removes the object from the schema.  DROP table table-name purge; c an’t restore the table by using the “ROLLBACK” command because it auto commits. DELETE :   it is dml  It is used to delete one or more tuples of a table. With the help of the “DELETE” command, we can either delete all the rows in one go or can delete rows one...

 Re-sizing data files in ASM is very straightforward. +ASM oraprod@appsolworld:/home/oracle>sqlplus / as sysdba SSQL*Plus: Release 19.0.0.0.0 - Production on Sun Nov 27 19:53:53 2022 Version 19.14.0.0.0 Copyright (c) 1982, 2021, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.0.0.0 SQL> select name from v$datafile; NAME ——————————————————————————– +DBA/appsolworld/datafile/system.260.932399649 +DBA/appsolworld/datafile/sysaux.261.932399653 +DBA/appsolworld/datafile/undotbs1.262.932399655 +DBA/appsolworld/datafile/users.264.932399665 +DBA/appsolworld/datafile/cw_data.266.933506593 +DBA/appsolworld/datafile/cw_index.267.933506607 +DBA/appsolworld/datafile/tools.268.933506617 +DBA/appsolworld/datafile/xcom_data.269.933506639 +DBA/appsolworld/datafile/xcom_indx.270.933506647 +DBA/appsolworld/datafile/xcom_lobs.271.933506659 +DBA/appsolworld/datafile/cw_data.272.933506675 NAME ———————————————————...

cluvfy fails with PRVG-13602 : NTP daemon is not synchronized with any external time source on node "node1" Following is an example,where the ntp.conf is configured with Time Source Servers - $ cat /etc/ntp.conf driftfile /var/lib/ntp/drift restrict default kod nomodify notrap nopeer noquery restrict -6 default kod nomodify notrap nopeer noquery restrict 127.0.0.1 restrict -6 ::1 restrict 10.206.2.0 mask 255.255.255.0 nomodify notrap server ntp-server1 iburst dynamic server ntp-server2 iburst dynamic tos maxdist 30 includefile /etc/ntp/crypto/pw keys /etc/ntp/keys However,when the Time Source is checked using the below command - $ /usr/sbin/ntpq -p remote refid st t when poll reach delay offset jitter ============================================================================== +10.206.2.102 10.206.2.101 2 u 586 1024 377 1.898 -6.212 52.072 *10.206.2.101 .LOCL. 1 u 1044 1024 377 0.985 -2.890 63.651  Here,* denotes the current External Time Source.In this case,the Synchroniza...