foalabs

How to check what SSL/TLS versions are available for a site in Linux I wanted to check the TLS protocols version available for a website in Linux. So I used the nmap command to do the same. Steps: 1) Log into the server via SSH. 2) Execute the command: # nmap --script ssl-enum-ciphers -p 443 funoracleapps.com | grep -E "TLSv|SSLv" Note: replace the example.com with the name of the required domain. The output will be as shown below: # | SSLv3: No supported ciphers found   | TLSv1.0:   | TLSv1.1:   | TLSv1.2: Output Example: nmap --script ssl-enum-ciphers -p 443  google.com | grep -E "TLSv|SSLv" |   TLSv1.0: |   TLSv1.1: |   TLSv1.2: If you like please follow and comment

While applying adop patch "Importing Function Definition for `BASH_FUNC_module" Error: When attempting to apply a patch using adop or while starting services using adadminscrvctl.sh script, the following may occur on Oracle Linux 6 64-bit server or Red Hat Enterprise 6. sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for 'BASH_FUNC_module' or sh: module: line 1: syntax error: unexpected end of file sh: error importing function definition for `module' Solution: 1) Connect as root:  Please rename the /etc/profile.d/modules.sh to /etc/profile.d/modules.sh.bkup  # mv /etc/profile.d/modules.sh /etc/profile.d/modules.sh.bkup 2) Retry the patch again If you like please follow and comment

Concurrent Manager Target Node/queue Unavailable After changing complete permission at (Root) / Filesystem Error: Concurrent Manager not coming up. You have checked your concurrent managers, all of your managers have the error Target node/queue unavailable.   Reason: The last activity performed was the complete file permission change at / filesystem. ping doesn't work for applmgr user . ping is used by the Internal Concurrent Manager to check that the nodes are available. Solution: Change the permission of /bin/ping to chmod u+s to solve the issue . If you like please follow and comment

Postfix email delivery fails with `error: postdrop: warning: mail_queue_enter: create file maildrop/xxxxxx.xxxxx: Permission denied` Error: When starting the Concurrent Manager getting below error in the log file Postfix email delivery fails with `error: postdrop: warning: mail_queue_enter: create file maildrop/xxxxxx.xxxxx: Permission denied` Reason /usr/sbin/postdrop had incorrect permissions. It had following permissions: # ll /usr/sbin/postdrop  -rwxr-xr-x. 1 root postdrop 180808 Feb 13  2023 /usr/sbin/postdrop While correct permissions are: # ll /usr/sbin/postdrop  -rwxr-sr-x. 1 root postdrop 180808 Feb 13  2023 /usr/sbin/postdrop Resolution Fix the permissions and user/group ownership on postfix files using following commands # rpm --setugids postfix # rpm --setperms postfix Restart postfix afterwards # service postfix restart If you like please follow and comment

When viewing the cron entries-  (user) are not allowed to use this program (crontab) Error: "crontab -l" for non root or oracle user fails with following error: $ crontab -l You (user) are not allowed to use this program (crontab) Reason: Incorrect permissions for /usr/bin/crontab Below shows the correct permissions.  Setuid permission is needed for /usr/bin/crontab as shown below: # ls -l /usr/bin/crontab -rwsr-xr-x. 1 root root 57664 Apr 19 16:16 /usr/bin/crontab Solution: Add setuid permission  # chmod u+s /usr/bin/crontab If you like please follow and comment

How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent Verify the current status of each notifications found in the WF_NOTIFICATIONS table that has potential for being sent when the Java Mailer gets started. SQL> select notification_id, recipient_role, message_type, message_name, status, mail_status from wf_notifications where status in (‘OPEN’, ‘CANCELED’) And Mail_Status In (‘MAIL’, ‘INVALID’) order by notification_id; Normally, only records where status = ‘OPEN’ and mail_status = ‘MAIL’ are notifications that would be sent, but there are programs that also can retry Canceled or Invalid notifications, so we included these as well. This query should show which notifications are waiting to be e-mailed. 2) Use BEGIN_DATE in the where clause to help narrow down the emails not to get sent by the Mailer from a specific date range. SQL> select notification_id, begin_date, recipient_role, message_type, message_name, status, mail_status ...

How to Change Hostname in Oracle Cloud Infrastructure (OCI) Compute Environment on Oracle Linux Permanently I wanted to change the host name for OCI Compute VM. I have below method to change the same For Oracle Linux previous to version 7 Steps: 1: Edit /etc/sysconfig/network change the parameter value for "hostname" # cat /etc/sysconfig/network NETWORKING=yes HOSTNAME=funebs-ol6 <--------- change here 2: In the file /etc/oci-hostname.conf change the value of PRESERVE_HOSTINFO to 2. /etc/oci-hostname.conf PRESERVE_HOSTINFO=2 This change will be persistent across reboots. For Oracle Linux 7 and later versions Steps: 1: Update the /etc/hostname file with below command.     hostnamectl set-hostname <new name> 2: Edit the oci configuration file for hostnames as given below to update the needed value to 2.     vi /etc/oci-hostname.conf     PRESERVE_HOSTINFO=2     save the changes. 3: Edit the FQDN from OCI console GUI a) Go to compute instance...

ORA-12578: TNS:wallet open failed Error: ORA-12578: TNS:wallet open failed. No Problem you are at right place then. $ sqlplus / as sysdba ORA-12578: TNS:wallet open failed Solution: Edit your sqlnet.ora file and modify SQLNET.WALLET_OVERRIDE parameter value from TRUE to FALSE. Change this: SQLNET.WALLET_OVERRIDE = TRUE to this: SQLNET.WALLET_OVERRIDE = FALSE If you like please follow and comment

How To Restore Default Permissions Of All Files Under / (ROOT) on Linux Someone accidentally changed / (ROOT) permission to 777 with following command. I wanted to reset it back to original permissions. This is an OCI system. # chmod 777 -R / After that, All files and folders on my server changed to 777 permissions. And I try to reboot my server, I can’t login into my server. It’s shown error: Failed to start SSH server : Starting sshd:WARNING: UNPROTECTED PRIVATE KEY FILE! Permissions 0775 for '/etc/ssh/ssh_host_key' are too open. Or if try to switch to login from opc to root user will get below error [opc@funoracleapps ~]$ sudo su -   sudo: /etc/sudo.conf is world writable sudo: /usr/bin/sudo must be owned by uid 0 and have the setuid bit set Solution Boot OCI system into Single User Mode , then type 2 commands I was having an OCI system so I created and Serial Connection to connect. # /bin/mount -o remount,rw / Now if we validate all files/folder permission would be shown a...

Create a Console Connection to DBCS system in OCI I was working for an OCI customer and they came to me for an issue for PROD DBCS system. I check and found someone tempered the file permission and no command was working after logging to DB node. As DBCS is a PAAS service so we cannot go to the OS boot directly. To fix there problem I created a Console Connection to login on DBCS underlying OS and correct the permissions. A serial console connection to bare metal or virtual machine DB system allows you to manage and troubleshoot your system in single-user mode using an SSH connection Steps: 1) Go to DB System on OCI an Click the respective DB System name 2) On the Left Bottom go to Resources and select Console Conection. 3) Click on Create Console Connection 4) Paste the SSH key of the server from where I would be connecting. I am using another server to connect to it. 5) Now once the Console Connection is Ready. Copy the ssh string and connect from Server. You should see a login promp...

Deploy a Solaris VM on OCI Cloud Solaris is an operating system developed by Oracle Corporation, and it can be run on Oracle Cloud Infrastructure (OCI). In this post, I am sharing how to deploy a Solaris VM on Oracle Cloud OCI. Pre-requisites: You should be having oracle Cloud Account. 1) Go to Market Place and search for Solaris 2) Click and select the compartment where it needs to be deployed. 3) Click on Launch Instance. 4) We will be directed to page for providing details for the machine shape, storage,OS etc. Please choose the values as required. Below screenshots refer to values provided by me in Demo. Provide required SSH keys Once all values are entered, then Click on Create. 5) Once an instance has reached the running state, ssh to the opc user on the instance using the ssh key you provided or generated when launching the instance. 6)  Connect to Server using SSH tools and validate. root@solarisvm:~# cat /etc/os-release  NAME="Oracle Solaris" PRETTY_NAME="Oracle...

Script to Update the Employee(per_all_people_f) and User(fnd_user) Email address through API from Backend in EBS If you know username find the user employee id From below   select * from fnd_user where 1=1 and username='HSINGH' Find the value from per_all_people_f select * from per_all_people_f where 1=1 and person_id = 8426; SELECT * FROM APPLSYS.WF_LOCAL_ROLES WHERE 1=1 AND ORIG_SYSTEM_ID = 8426; select * from fnd_user where 1=1 and employee_id = 8426; Details: select ppf.person_id, ppf.last_name, ppf.full_name, ppf.email_address emp_email, rol.name, rol.email_address rol_email, usr.user_id, usr.email_address usr_email from per_all_people_f ppf, applsys.wf_local_roles rol, fnd_user usr where 1=1 and ppf.person_id = rol.orig_system_id and rol.name = usr.user_name and ppf.person_id = usr.employee_id and sysdate between effective_start_date and effective_end_date and person_id = 8426 order by full_name; API to update declare l_employee_number per_people_f.employee_number%TYPE; l...

Cancel and Launch Cost Manager in EBS R12 Cancel Cost Manager 1) To cancel the Cost Manager : use one of the following method: a) use 'System Administrator' responsibility        Navigate to Concurrent/Request/view        Set : specific Request=on        Name=Cost Manager. In the lower part of the Find requests window there is a field "Select the Number of Days to view" set by default to 7 days. -> Set "Select the Number of Days to view"=999 In fact this field is a filter which limits how far back it will query requests. From here Cancel the Cost Manager which is Pending Scheduled. or b) Use the following SQL script: SELECT request_id Request_ID, request_date RequestDt, concurrent_program_name, phase_code Phase, status_code Status FROM fnd_concurrent_requests fcr, fnd_concurrent_programs fcp WHERE fcp.application_id = 702 AND fcp.concurrent_program_name in ('CMCTCM', 'CMCMCW', 'CMCACW', 'CMCLCW', 'CMCCTW') AND fcr.c...