APPSDBA Data Lake

  crsctl get css Use the  crsctl get css  command to obtain the value of a specific Cluster Synchronization Services parameter. crsctl get css parameter Cluster Synchronization Services parameters and their default values include: clusterguid diagwait disktimeout (200 (seconds)) misscount (30 (seconds)) reboottime (3 (seconds)) priority (4 (UNIX), 3 (Windows)) logfilesize (50 (MB)) $ crsctl get css disktimeout CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services. crsctl get css diagwait  The time limit is to update the respective output logfiles for every process. crsctl get css disktimeout  Disk Latencies in seconds from node-to-votedisk. Default Value is 200. (Disk IO) crsctl get css misscount Network Latencies in second from node-to-node (Interconnect) crsctl get css  reboottime   T he  maximum time limit reached over to the voting disk, the node eviction happens between the nodes. [root@node1-pub ~]# crsctl get cs...

  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 ———————————————————...