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

  JSP Compilation steps Step 1: Shutdown the application services Step 2: Take backup for the _Page(class file) folders $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> a $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> $ mkdir _pages $ ls -lrt To Implement the solution ===================== 1)Compile the JSP's. In Unix server: # perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 10 -log /tmp/ojspc_error.log 2) Cabo Images and style sheets can be corrupted or out of sync in the cabo caches, you may need to clear the files under cache directories after backup: $OA_HTML/cabo/images/cache $OA_HTML/cabo/styles/cache 3) Web Browser for Internet Explorer: - go to menu Tools => Internet Options, - select 'General' tab, - click on button 'Delete Files' in 'Temporary Internet files' area or - click on button 'Delete...' then in 'Delete Browsing History' pop-up window click on 'D...

  Group Services Scripts Purposes Root Services Node Manager adnodemgrctl.sh WLS Node Manager controls server instances within a domain providing automatic restart functionality. Web Administration Services WebLogic Admin Server adadminsrvctl.sh WLS AdminServer controls access to pages within WLS for system wide configuration Web Entry Point Services Oracle HTTP Server, Oracle Process Manager adapcctl.sh adopmnctl.sh FMW OHS (Apache) Service FMW Oracle Process Manager Notification Server (Controls Apache processes) Web Application Services oacore oafm forms forms-c4ws admanagedsrvctl.sh WLS Oracle E-Business Suite 12.2 Application Server for Self Service web based products transactions, Secure Enterprise Search (SES) and Web Service WLS Oracle E-Business Suite 12.2 Application Forms Server WLS Oracle E-Business Suite 12.2 Application Server utilized by WebService products using java API for Forms Batch Processing Services Concurrent Services adcmctl.sh Concurrent Managers Other Ser...

Stop “oracleasm.service’, and re-enable it.   [root@shsdbdr01 by-path]# systemctl status oracleasm.service ● oracleasm.service - Load oracleasm Modules    Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)    Active: inactive (dead) [root@shsdbdr01 by-path]# systemctl stop oracleasm.service [root@shsdbdr01 by-path]# systemctl enable oracleasm.service [root@shsdbdr01 by-path]# systemctl start oracleasm.service [root@shsdbdr01 by-path]# systemctl status oracleasm.service ● oracleasm.service - Load oracleasm Modules    Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)    Active: active (exited) since Tue 2022-11-01 20:55:23 IST; 8s ago   Process: 28264 ExecStart=/usr/sbin/oracleasm.init start_sysctl (code=exited, status=0/SUCCESS)  Main PID: 28264 (code=exited, status=0/SUCCESS) Nov 01 20:55:21 shsdbdr01.appsol.com systemd[1]: Starting Load oracleasm M...

The Background Engine is a PLSQL Procedure that checks and executes any deferred or timed-out activities in the workflow system.  If new activities are deferred or timed out after the current Background Engine is started, the procedure will check one more time for any new activities to execute before terminating. When all matching activities have been completed, the procedure comes to end. It  can be run as a Concurrent program or as a package or SQLPLUS command. Run Workflow Background Process from Unix SQL script placed in $APPL_TOP which can be used to run How to run Workflow Background Process from Unix $FND_TOP/Admin/Sql/wfbkg.sql       cat workflow_background.sh       sqlplus apps/<apps pass> << EOF       @$FND_TOP/Adm...

Below command will fix the issue:   sudo xfs_repair -v -L /dev/dm-0 Node failed to boot after a power outage and got the error "Failed to mount /sysroot" and entered into emergency mode. Mount and unmount failed so in this condition just run with  -L  option and that will help node to boot up again.

 The following points need to answer before jumping into troubleshooting: Are there any recent code changes done in the concurrent program?           Check long_running_sid and verify the recent code change of last_ddl_timestamp after a             discussion with the developer. Was this running long in the last few run as well, or was this time only?            ==> Check the program history. How much time does it take to complete?           Once again program history can give us some idea. Are these jobs fetching higher data compared to the last run           ===> Confirm on data change . Query Plan change will indicate this issue. Does this job runs at any specific time or it can be run anytime           ===> The nature of the job can help to understand the job's nature. Does this job fetch data using DB Link...

Linux instance can be connected through Putty by using the below method. SSH private key files generated by  Oracle Cloud Infrastructure  are not compatible with PuTTY. If you are using a private key file generated during the instance creation process you need to convert the file to a  .ppk  file before you can use it with PuTTY to connect to the instance. Convert a generated .key private key file: Open PuTTYgen. Click  Load , and select the private key generated when you created the instance. The extension for the key file is  .key . Click  Save private key . Specify a name for the key. The extension for the new private key is  .ppk . Click  Save . Connect to the Linux instance using a .ppk private key file: If the instance uses a key pair that you created using PuTTY Key Generator, use the following procedure. Open PuTTY. In the  Category  pane, select  Session  and enter the following: Host Name (or IP address): <use...

 Step 1: Create Authentication SSH-Keygen Keys on – (Source) ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/sid/.ssh/id_rsa): [Press enter key] Created directory '/home/sid/.ssh'. Enter passphrase (empty for no passphrase): [Press enter key] Enter same passphrase again: [Press enter key] Your identification has been saved in /home/sid/.ssh/id_rsa. Your public key has been saved in /home/sid/.ssh/id_rsa.pub. The key fingerprint is: 5f:ad:40:00:8a:d1:9b:99:b3:b0:f8:08:99:c3:ed:d3 sid@appsolworld.com The key's randomart image is: +--[ RSA 2048]----+ | ..oooE.++| | o. o.o | | .. . | | o . . o| | S . . + | | . . . o| | . o o ..| | + + | key will be generated in /user/.ssh/rsa_id/ folder use without a passcode. Step 2: Upload SSH Key to – (Target) ssh-copy-id sid@192.168.1.121 ssh-copy-id user@i.p/hostname Step 3: Test SSH Passwordless Login from Sourc...