foalabs

How to use OEM 12c graphs and activities after Adobe flash is unsupported Adobe flash was unsupported starting 1 Jan 2021. So now using OEM12c graphs and activity bars would be a problem. We will need to upgrade to OEM13c or 19c. But if you still want to continue using OEM12c then follow the below youtube link. It has all the required information. I use the same for my OEMS12c and works fine in firefox. Please download the flash old version from the link below and follow the video. https://www.youtube.com/watch?v=gu7E9t9vfOI If you like please follow and comment

Oracle  EBS ADOP R12.2 Multi-Node Manual Patching  In a multi-node setup on EBS 12.2, we can apply patches individually on each node as well. If ssh is enabled from primary to secondary node then it is not necessary. But I will show in this post how we can do it manually. This is an interview question and may be required sometimes. Scenario 1: Shared Application Tier File System with SSH enabled primary node run below adop phase=<phase_name> Scenario 2: Shared Application Tier File System without SSH enabled primary node:  adop phase=<phase_name> allnodes=no action=db secondary node: adop phase=<phase_name> allnodes=no action=nodb Note: In a multi-node environment, the cleanup phase is to be executed on the primary node only as it is the DB phase. All other phases have to be executed on primary and all secondary nodes. Scenario 3: Non-Shared Application Tier File System with SSH enabled primary node run below adop phase=<phase_name> Scenario 4: Non...

How to Implement HAPROXY in Oracle Apps R12.1 Please read article on more website security checks  How to Conduct a Website Security Check In an earlier post, I shared how HAPROXY is used as a reverse proxy for Oracle Apps. Now I am going to share how to implement the same. I am using a separate server to install HAproxy and one EBS server. The HAProxy server(OEL 7) I am using in my environment is known as oel7.lab (DNS name I have mapped as funerptest.lab) [root@oel7 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.110 oel7.lab oel7 192.168.56.110 funerptest.lab funerptest Steps: 1) Install haproxy [root@oel7 ~]# yum install haproxy 2)  Validate haproxy installation [root@oel7 ~]# which haproxy /usr/sbin/haproxy [root@oel7 ~]# ls -l /etc/haproxy total 4 -rw-r--r-- 1 root root 3142 Jun 28 2019 haproxy.cfg 3) Check the status of haproxy [r...

Self-Signed Certificate and How to Create a Using OpenSSL SSL is for Secure Socket Layer is   To secure connection an SSL Certificate is used which is commonly used on web servers. SSL Certificates mainly serve two functions: Authenticates the identity of the servers (so that users know that they are not sending their information to the wrong server). Encrypts the data that is being transmitted. Mostly we use CA Certification Authority(Go-Daddy, Verisign, etc..) as a trusted certificate.  But we can also use a self-signed certificate.  Self Signed Certificate A self-signed certificate is a certificate that is signed by its own creator rather than a trusted authority.  These are less trustworthy as an attacker can create a self-signed certificate and launch a middle attack. Self-signed certificates in scenarios like: 1) Intranet. 2) Personal sites with few visitors. 3) Development or Testing phase of the application. Don't use a self-signed certificate for the applica...

How to install GUI on Oracle Linux 7 As a root user run the below commands 1)yum update   2)yum groupinstall "Server with GUI" 3)Enable GUI on system startup ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target or  systemctl set-default graphical.target 4) Reboot the Server and it will start in GUI  If you like please follow and comment

How to disable HTTP port in Oracle Apps R12.1 when SSL is enabled If we have SSL enabled in our Oracle Apps/EBS then the web service/HTTP server would be listening on the HTTPS port. In this scenario, we can disable the HTTP services for security reasons. It is not mandatory but a good practice. Steps: 1) Make a custom folder in FND top, if not already present.  mkdir -p $FND_TOP/admin/template/custom 2) Navigate to custom folder. cd $FND_TOP/admin/template/custom 3) Copy the http configuration template cp ../httpd_conf_1013.tmp . 4) Update the custom file by commenting out the following line: Listen %s_http_listen_parameter% 5) Run autoconfig and restart services to verify. Now the connection to HTTP port will not work. If you like please follow and comment

Query to find full Access Details for Users in EBS/Oracle Apps This query can be helpful during audits and other user details-related requirements. Query: SELECT     distinct fu.user_name "User_Name",     fu.end_date "User_End_Date",     frt.responsibility_name "Responsibility_Name",     fat.application_name "Application_Name",     furg.start_date "Responsibility_Start_Date",     furg.end_date "Responsibility_End_Date",     fu.last_update_date "Last Updated Date",     (SELECT user_name FROM fnd_user WHERE user_id = fu.last_updated_by) "Last Update By" FROM     fnd_user_resp_groups_direct furg,     applsys.fnd_user fu,     applsys.fnd_responsibility_tl frt,     applsys.fnd_responsibility fr,     applsys.fnd_application_tl fat,     applsys.fnd_application fa WHERE         furg.user_id = fu.user_id     AND     ...

Create Logical Volume with 100 percent volume group space Command: lvcreate -n <lv_name> -l 100%FREE <vg_name> If you like please follow and comment

Orapki Quick Reference and Usage with wallets In this post, I am going to share about orapki which is a command-line tool. You can also use Oracle Wallet Manager(owm) as well, but that is not the scope of this post. Oracle Wallets: Wallet is a password-protected container used to store authentication and signing credentials, including private keys, certificates, and trusted certificates needed by SSL. The wallets it creates can be read by Oracle Database, Oracle Application Servers (OHS) used commonly in EBS when enabling SSL , and the Oracle Identity Management infrastructure. In Oracle mostly there will be 3 types of wallets 1.Password protected - ewallet.p12 Required password for all operations like display, add,delete 2.Password protected with autologin- ewallet.p12 and  cwallet.sso Required password for the only add, delete not for display. It can be read by oracle products without a password. 3.Auto_login_only - cwallet.sso Doesn’t require a password for any operations. Usefu...

How to Enable Password Authentication in AWS EC2 Instances By default, the authentication is done using ssh keys. Enabling password authentication is a security loophole. Step 1: Login to AWS instances using ssh key ssh -i your-key.pem username@ip_address Step 2: Setup a password for the user using passwd command along with the username. My username that I want to enable is "himanshu" sudo passwd himanshu Step 3: Edit sshd_config file. sudo vi /etc/ssh/sshd_config Find the Line containing 'PasswordAuthentication' parameter and change its value from 'no' to 'yes' PasswordAuthentication yes If you want to set up 'root' login, find  'PermitRootLogin' parameter and change its value from 'prohibit-password' to 'yes' PermitRootLogin yes After these changes save the file and exit. Step 4: Restart the SSH service. service sshd restart            or systemctl  sshd  restart Step 5: Now log in using the password you set for the us...

Query to find if we are connected to Run or Patch Database Edition on EBS12.2 In Oracle Apps R12.2 if we want to determine that database connection is to run or patch edition. The below query can help you to get the answer Query: SQL> select ad_zd.get_edition_type from dual; GET_EDITION_TYPE -------------------------------------------------------------------------------- RUN If you like please follow and comment

Upgrade the IAS oracle home to 10.1.3.5 in EBS R12.1 I was doing an IAS oracle home upgrade in EBS 12.1, so didn't find any easy document to refer to. I am sharing the steps that I created to make it easy for readers. Checking Current Version: IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server Server built:   Jul  7 2008 14:58:00 Steps: Download OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) delivered via Patch 8626084 Download Environment Preparation Patch 8920270 for OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5.0) Apply the Oracle E-Business Suite Release 12 Template patch to support OracleAS 10g Release 3 (10.1.3) Patch Set 5 (10.1.3.5) Apply 7359933 . Follow the patch readme for any pre-requisite or post-requisite steps.-- Already present in my environment Open VNC  and set the 10.1.3 home environment. cd $ORA_CONFIG_HOME/10.1.3 . fuat_funebs122.env Backup 10.1.3 home ...

Error while generating jar in Oracle Apps the adogjf() Unable to copy Registry.Dat While generating jar using adadmin getting below error. Error: Error copying the Forms Registry file to /u01/oracle/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat ISSUE:   Copying Registry.dat from the Forms Java directory to /u01/oracle/apps/apps_st/comn/java/classes ... AutoPatch error: Error copying the Forms Registry file to /u01/oracle/apps/apps_st/comn/java/classes/oracle/forms/registry/Registry.dat. adogjf() Unable to copy Registry.Dat. AutoPatch error: Failed to generate the product JAR files Cause: Incorrect ORACLE_HOME sourced Solution: -bash-3.2$ echo $ORACLE_HOME /u01/oracle/apps/tech_st/10.1.3 -bash-3.2$ cd $APPL_TOP -bash-3.2$ . APPSEBS_funapps.env -bash-3.2$ echo $ORACLE_HOME /u01/oracle/apps/tech_st/10.1.2 If you like please follow and comment

OPatch detects your platform as 226 while this patch supports other platforms. While applying security patches under 'Oracle Fusion Middleware 10.1.3.5 getting the below error. This arises when applying a 32-bit version patch on 64 bits environment. Error: OPatch detects your platform as 226 while this patch 21815758 supports platforms:    46 (Linux Intel) Cause OPatch detects your platform as 46 while this patch 21815758 supports platforms: 226 (Linux x86-64) 46 (Linux Intel) 226 (Linux x86-64) Solution export OPATCH_PLATFORM_ID=46 then opatch apply Patch will complete successfully.   If you like please follow and comment

Cloning an EBS instance R12.2.10 from OEL 6.10 to OEL 7.9 using adcfgclone and RMAN In this post, I am going to share how to clone the EBS R12.2.10 instance from OEL 6 to OEL 7. This can be used for the normal cloning process as well. Source Machine: OEL 6.10 DB : 12.1.0.2 APPS: 12.2.10 Target Machine: OEL 7.9 DB : 12.1.0.2 APPS: 12.2.10 Shared Mount between both machines:  /media/sf_Downloads Pre-requisites: Please install a target machine with Oracle Linux 7.9 and install all related RPMs from the below post. https://www.funoracleapps.com/2021/03/how-to-install-pre-requisites-rpm-for.html Target Machine Preparation 1) Edit Security Limits.conf and enter below values /etc/security/limits.conf: ---------------  * hard nofile 65536  * soft nofile 4096  * hard nproc 16384  * soft nproc 2047  * hard stack 16384  * soft stack 10240 2) Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows. S...