foalabs

How to find cookie details in Chrome Browser A cookie is a small piece of data stored on the user's computer by the web browser while browsing a website. Cookies were designed to be a reliable mechanism for websites to remember stateful information or to record the user's browsing activity. How to check cookie in Google Chrome Start browsing using a new tab window and navigate to the URL of your website. Open the Developer Tools. Depending on your browser this can be done in different ways. For Google Chrome go to View > Developer > Developer Tools or CMD + ALT + I on Mac or F12 on Windows or Ctrl + Shift + J on windows. ‍Now open the Application tab and check the cookies for each domain. Usually, the cookies have names that resemble the name of the service they are being used by. You can also Google search the cookie names to find specific information about them. If you like please follow and comment

How to find if the Linux OS needs Reboot after Patching/Updates In this post, I am going to share how to identify if servers/services need a reboot after OS patching. RHEL/OEL/Centos We might need to reboot because of core library updates, at least if it is glibc. (And also, services may need to be restarted after updates). With the yum-utils package, you can use a command called needs-restarting . You can use it both for checking if a full reboot is required because of kernel or core libraries updates (using the -r option), or what services need to be restarted (using the -s option). needs-restarting -r returns 0 if a reboot is not needed, and 1 if it is, so it is perfect to use in a script. Example [himanshu@fundb ~]$ needs-restarting -r No core libraries or services have been updated. Reboot is probably not necessary. Now let's do an OS update yum update -y Once completed, please check the restart required or not. [root@fundb ~]# needs-restarting -r Core libraries or services h...

Understanding Patching on Linux WHAT IS A PATCH? A patch is a piece of software code that will be inserted into the existing program in the system. This is an imidate fix to existing software before a minor release is planned. A patch is a kind of temporary and quick fix to existing software. WHAT IS A PATCH LOOKS LIKE? Suppose you have some xyz.c file within your Linux kernel which requires a patch, the patch is just the difference between the existing line of code in that file and extra lines which we will add to this file. It is just a diff of lines of code which is added to an existing file. Enterprise-level Approach On Red-Hat based systems we use the yum package manager as the preferred method to install and update packages. Understaimg yum in Linux -->   https://www.funoracleapps.com/2020/05/understanding-yum-in-linux.html Patching is generally motivated by system security. Remember that IT security, in general, has three aspects: Confidentiality - wrong people must not g...

Workflow Deferred Agent Listener not starting Understanding Workflow Deferred Agent WF_DEFERRED is the main queue for the deferred events that need to be processed offline. "Workflow Deferred Agent Listener" must be running to clear the events from this queue. Several EBS modules have subscribers to various Workflow BES events with a phase >100 which means that the subscribers will be deferred for the agent listeners to process later.  Unless these deferred events are processed by agent listeners, QMON or any other module-specific cleanup event will not remove any events from the WF_DEFERRED queue and hence the backlog.  You should configure agent listeners to run by default in Oracle Applications even if you do not use Oracle Workflow. Trouble shooting 1) Take a snapshot of events in WF_DEFERRED at the beginning of troubleshooting This is important so as to compare with the results of the same select during the course of troubleshooting.       select wfd.us...

There are no Active Responsibilities available for this User in Oracle EBS R12 When the user logs in, not able to see any responsibilities on the home page. Already performed the action as per " https://www.funoracleapps.com/2013/10/now-able-to-view-responsibilities.html " Error: On the Home Page, Responsibility Navigator (Left Side), shown "There are no Active Responsibilities available for this User". Solution: 1. On the Home Page, Navigator (Left Side), click on the "Personalize" button. It will open another page called "Personalize Navigator". 2. In Personalize "Search", by default 'Display' will be with "All Responsibilities". Click on the "Go" button. 3. After click on "Go", all responsibilities will be listed that assigned to the user, and the "Status" column will be in 'Hidden'. 4. Now, click on the "Show All" button, and "Status" will become 'Shown...

How To Enable Macro, Active X, and Protection Settings in Microsoft Excel (2010 and 2016) for Oracle Apps Webadi In this post, I am sharing how to enable Macros related to Oracle Apps Webadi For MS Excel 2010 Version  1. In Excel 2010, click FILE, Trust Center and Trust Center Settings 2. Under Active X Settings, Click to enable "Enable all controls..." and uncheck "safe mode" 3. Under Macro Settings, Click to enable "Enable all macros...." and check to enable "Trust access to the VBA..." 4. Under Protected View, uncheck everything 5. Under External Contents, click to enable. 6.  Under File Block Settings, follow the below format and make sure to click to enable "open selected file types in protected view and allow editing" 7. Click OK and restart excel 2010. FOR MS Excel 2016 Version 1. In Excel 2016 (365), click File and choose Options  2. Under Trust Center, click Trust Center Settings 3. Under ActiveX Settings, click to enable ...

Resend Failed/Sent Notifications Again in Oracle Apps R12 In this post, I am sharing how to resend the notification mail to users if it fails or user have not received. 1) Check if the Notification mailer/Agent listener is running       select (case when (select count(1)                          from apps.fnd_concurrent_queues                         where concurrent_queue_name = 'WFMLRSVC') > 0                  then 'Notification Mailer Running'                   else 'Notification Mailer Not Running'                 end) "Status"        from dual 2) Run the below query to get the exact number based on dates        select *         from wf_notifications ...

Purge AWR snapshots in Oracle Database Display retention period: select dbms_stats.get_stats_history_retention from dual; SELECT SNAP_INTERVAL, RETENTION FROM DBA_HIST_WR_CONTROL; More Details via below query: select extract( day from snap_interval) *24*60+ extract( hour from snap_interval) *60+ extract( minute from snap_interval ) “Snapshot Interval”, extract( day from retention) *24*60+ extract( hour from retention) *60+ extract( minute from retention ) “Retention Interval” from dba_hist_wr_control; AWR Snapshot Purging Policy DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (retention IN NUMBER DEFAULT NULL, interval IN NUMBER DEFAULT NULL, topnsql IN NUMBER DEFAULT NULL); retention = snapshot interval (1 hr ) X 24 X X 7 days To retain 1 weeks data set retention to 10080 - Retain data for 21 days ( 3 weeks ) exec dbms_workload_repository.modify_snapshot_settings(retention => 30240, interval => 60, topnsql => ‘DEFAULT’); - Retain data for 28 days (4 weeks) exec dbms_workloa...

Shell Script to find the Expiry Date of a Certificate using orapki I am sharing the script to find the expiry date of the certificate and send mail 30 days before expiration. My Certificate:  Server_certificate.cer Script: . ~/.bash_profile cd $INST_TOP/certs/Apache $ORACLE_HOME/bin/orapki  cert display -cert Server_certificate.cer >/tmp/certificate_info $ORACLE_HOME/bin/orapki  cert display -cert Server_certificate.cer |grep -i Valid > /tmp/cert_valid_txt EXP_DATE=`cat /tmp/cert_valid_txt|cut -f2- -d':' |awk '$1=$1'` TODAY_DATE=`date` no_of_days_left=$(( ($(date -d "$EXP_DATE" +%s) - $(date -d "$TODAY_DATE" +%s) )/(60*60*24) )) if [ $no_of_days_left -lt 30 ] then echo "-----------------------------------------------------------------------" >> /tmp/certificate_info echo "Certificate is Going to Expire, Please get a new certificate and deploy" >> /tmp/certificate_info mailx -s "Critical: `hostname -a` EBS Ce...

Configure Datasource and JNDI for DB adapter In the post, I am sharing the steps on how to create data source in WebLogic and configure the JNDI for the DB adapter. To Complete this blog, you must have WebLogic and oracle database up and running. Below simple steps that show how to create Datasource. 1) Login into the WebLogic console http://funebs122:7001/console 2) Click on lock and edit. 3) Expand Services and click on Data sources 4) Click  New -> Generic Data Source 5) Enter below information and click Next  Name : UAT JNDI Name : jdbc/uat Database Type : Oracle 6) Select Database drive as per your need, let it be default as of now and click Next 7) Click Next 8) Enter the database details and click Next 9) Click on Test Configuration button and click Next 10) Select the  DefaultServer  as target and click Finish 11) Click on Activate Changes button You are done with data source creation.  JNDI in DBAdapter 12) Click on th...

How to check SSL certificate expiration date for the certificate in wallet using orapki In this post I am going to share how to find the certificate expiry information from an oracle wallet. Locate the location where the wallet files are present cd $INST_TOP/certs/Apache ls cwallet.sso  ewallet.p12   Find DN applmgr@funebs122:/u01/oracle/apps/inst/certs/Apache> orapki wallet display -wallet ewallet.p12 Oracle PKI Tool : Version 12.1.0.2 Copyright (c) 2004, 2014, Oracle and/or its affiliates. All rights reserved. Enter wallet password: Requested Certificates: User Certificates: Trusted Certificates: Subject: CN=xyz EV RSA CA 2018,OU=www.funebs122.lab,O=xxx Inc,C=US <====dn Export ewallet.p12 to the certificate applmgr@funebs122:/u01/oracle/apps/inst/certs/Apache> orapki wallet export -wallet ewallet.p12 -dn "CN=xyz EV RSA CA 2018,OU=www.funebs122.lab,O=xxx Inc,C=US" -cert certificate_expiry Oracle PKI Tool : Version 12.1.0.2 Copyright (c) 2004, 2014, Oracle and/or its...

Error while launching forms on an SSL/HTTPS Enabled Oracle Apps 'The connection to this website is untrusted' URL = https://company.com:443 The certificate is not valid Solution: 1. From the client, access: Control Panel->Java->Security->Certificates 2. User tab->Change drop down to 'Secure Site' 3. Import the server SSL certificate.  Not the code signing certificate, but the server user ssl certificate. If you like please follow and comment