Posts

Showing posts from 2022

Host SMBus controller not enabled! on Redhat 7.6

  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.

Workflow mailer log file location for Oracle EBS R12.2

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

  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 .

What to do when SYSAUX Tablespace Grows Rapidly

 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)             10368 SM/ADVISOR ***                  6720 SM/OTHER                  3584 WM                  3264 SMON_SCN_TIME        1. Check how many partitions do exist for the offen

what is the difference truncate or delete - All Records

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 by one. i.e., we can us

How to increase TABLESPACE size in ASM

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

What is the /etc/resolv.conf file

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 in EBS R12.2

  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

Usage of R12.2 EBS Application Services

  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 Service

How to enable systemctl start oracleasm.service

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 Modules... Nov 01 20:55:22 shsdbdr01.appsol.com oraclea

Submit Workflow Background Engine from backend

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/Admin/Sql/wfbkg.sql      exit      EOF Run Workflow Background Process from SQL*Plus BEGIN wf_engine.background (itemtype=>NULL , process_deferred=>TRUE , minthreshold=>NULL , maxthreshold=>NULL , process_timeout=>FALSE , process_stuck=>FA

How to repair Failed to mount /sysroot

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.

How to troubleshoot Long Running Concurrent Request in EBS 12.2

 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          ====> Check whether the DB link is involved or not. The below-given approach would help to conclude the gray areas. Check the load of the server using t

Connecting to a Linux Instance using Putty

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): <username> @ <public-ip-address> Port:  22 Connection type:

how to create password less connections to the server.

 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

How to generate a specific form through command line and AD "adadmin" utility

  At times, it may be necessary to regenerate a specific form for any number of reasons. This note provides a detailed example of how to generate a specific form through the AD utility adadmin. The basic steps are as follows: 1. Select the "Generate Applications Files menu" option. 2. Then select the "Generate forms files" option. 3. Choose the number of workers, the default is recommended and is based off the number of CPUs in your server. 4. Enter "yes" at this prompt to regenerate PL/SQL library files (.pll extension) 5. Enter "yes" at this prompt to regenerate Forms Menu files (.mmb -> .mmx extension) 6. Enter "yes" at this prompt to regenerate Forms Executable files (.fmb -> .fmx extension) 7. Enter the list of products, by short name as they are listed in "$APPL_TOP/". Use commas to separate the product names. 8. If you would like to generate specific files for each product, you may answer "Yes" here and