foalabs

Shell Script to Validate and alert if EBS Oracle Apps URL is working or not We can use the below script to validate the URL for EBS is working or not and send a mail. Please check URL and  recipient mail id as required. Script: #!/bin/bash # URL to check URL="https://funebstraining.com/OA_HTML/AppsLocalLogin.jsp" # Email details TO="recipient@example.com" SUBJECT="URL Check Alert" MESSAGE="The URL $URL is not responding." # Function to check URL status check_url() {     STATUS=$(curl -s -o /dev/null -w "%{http_code}" "$URL")     if [ "$STATUS" -ne 200 ]; then         send_email     fi } # Function to send email send_email() {     echo "$MESSAGE" | mail -s "$SUBJECT" "$TO" } # Run the check check_url Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment

Function-Based Index in Oracle Database A function-based index is an index created on the result of a function or expression applied to one or more columns of a table. This allows the Oracle optimizer to use the index for queries that involve expressions or functions, improving query performance when such expressions are frequently used. Why Use Function-Based Indexes? Optimize Complex Queries : When queries frequently use functions or expressions on columns, a function-based index can speed up these queries. Support Case-Insensitive Searches : You can create an index to support case-insensitive searches. Efficient Use of Virtual Columns : You can index virtual columns that are derived from other columns. Creating Function-Based Indexes Syntax CREATE INDEX index_name ON table_name (function_or_expression); Example Scenarios Scenario 1: Case-Insensitive Search Assume you have a table EMPLOYEES with a column LAST_NAME . You frequently perform case-insensitive searches on LAST_NAME . S...

How to Submit a Concurrent Program from Backend Standard API to Submit concurrent program from backend in Oracle Apps 1. fnd_request.submit_request 3 major required things to Submit concurrent program from backend in Oracle Apps 1. Short Application Name under which the Concurrent Program registered . 2.Concurrent Program short code name which we want to call from pl/sql. 3.Needs to know the Concurrent Program Parameters , which we also needs to pass while calling the concurrent program from pl/sql package. Sample Script SET SERVEROUTPUT ON; DECLARE ln_responsibility_id NUMBER; ln_application_id    NUMBER; ln_user_id            NUMBER; ln_request_id           NUMBER; BEGIN     SELECT DISTINCT fr.responsibility_id,                   frx.application_id              INTO ln_responsibility_id,          ...

How to get the Execution Plan for a SQL ID In Oracle Database 1.To Display the execution plan of the last SQL statement executed by the current session  SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR);  2.To display the execution plan for a specific SQL ID SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR('8cjf2rudn9una'));  3.To display the execution plan for a specific SQL Handle from the SQL Plan Baseline. SET LINESIZE 150  SET PAGESIZE 2000  SELECT t.* FROM TABLE(DBMS_XPLAN.DISPLAY_SQL_PLAN_BASELINE('SYS_SQL_b1d424fg78r295af')) t;  4.To display the execution plan for a specific SQL ID from the SQL Tuning Set. SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_SQLSET('fsy3ubymdz500_STS','8cjf2rudn9una',367245326));  OR  SELECT * FROM table (DBMS_XPLAN.DISPLAY_SQLSET('fsy3ubymdz500_STS','8cjf2rudn9una')); 5. To Display t...

Useful Commands Related to Keytool These commands can be used while we create, import, export, delete, and/or change certificate in a keystore. Generate a Java keystore and key pair: keytool -genkey -alias aliasname -keyalg RSA -keystore keystore.jks -keysize 2048 Generate a certificate signing request (CSR) for an existing Java keystore: keytool -certreq -alias aliasname -keystore keystore.jks -file domainname.csr Generate a keystore and self-signed certificate: keytool -genkey -keyalg RSA -alias selfsigned -keystore keystore.jks -storepass password -validity 360 -keysize 2048 View or list the certificate; the command below can be used:  keytool -list -v -keystore keystore.jks  Import a root or intermediate CA certificate to an existing Java keystore: keytool -import -trustcacerts -alias root -file domainname.crt -keystore keystore.jks Delete a certificate from a Java keytool keystore: keytool -delete -alias aliasname -keystore keystore.jks Change a Java keystore password: ke...

How to Generate a Keystore and CSR Using the Keytool Command Understanding of the Flow Generate a keystore and key pair  using  keytool -genkeypair . Generate a CSR  from the keystore using  keytool -certreq . Submit the CSR  to a Certificate Authority (CA) to get a signed certificate. Import the CA's root certificate  into the keystore using  keytool -import . Import the signed certificate  into the keystore using  keytool -import . Steps: Step 1: Generate a Keystore Open a Terminal or Command Prompt: Ensure you have Java installed, as the keytool command is part of the Java Development Kit (JDK). Generate the Keystore: Run the following command to create a new keystore and generate a key pair (public/private key) within it. keytool -genkeypair - alias mykey -keyalg RSA -keysize 2048 -keystore mykeystore.jks -validity 365 Explanation: -genkeypair : Generates a key pair (public and private key). -alias mykey : An alias for the key pair...

How to Renew Demo Identity Certificate thats Expired for DemoIdentity in Weblogic Error DemoIdentity identity certificate expired and getting the following error in the logs:    <Notice> <Security> <BEA-090171> <Loading the identity certificate and private key stored under the alias DemoIdentity from the kss keystore file kss://system/demoidentity.> <Alert> <Security> <BEA-090154> <Identity certificate has expired: Solution: 1. Login to EM console. 2. Navigate to <domain name> [ eg :- base_domain ] 3. Click on the drop down Weblogic Domain -> Security -> Keystore 4. Expand the system folder. 5. Select the demoidentity -> click Manage 6. It will prompt for password , enter the password DemoIdentityKeyStorePassPhrase 7. It will open the Manage Certificates option. 8. Select the existing 'DemoIdentity' certificate which is expired -> Select Delete. (NOTE: You need to click the refresh button on the top right to see th...