Ameer Khan

Step 1. Update the /etc/hostname file following command. [root@uat-database-dr rman_bkp]# hostnamectl set-hostname ccuine1126.xxx.co.in  Step 2.  Edit the oci configuration file for hostnames and set the value to 2.    vi /etc/oci-hostname.conf    PRESERVE_HOSTINFO=2    save the changes. Note:- By setting Value 2, it preserve user configured hostname across instance reboots; no custom changes to /etc/hosts and /etc/resolv.conf from the… Continue Reading

Login to apps user sqlplus apps/<apps_passwd> SELECT sess.sid,    sess.serial#,    oracle_process_id OS_PROCESS_ID,    fusr.description user_name,    fcp.user_concurrent_program_name progName,    TO_CHAR (actual_Start_date, ‘DD-MON-YYYY HH24:MI:SS’)    StartDate,    request_id RequestId,    (SYSDATE – actual_start_date) * 24 * 60 * 60 ETime    FROM fnd_concurrent_requests fcr,    fnd_concurrent_programs_tl fcp,    fnd_user fusr,    v$session sess    WHERE fcp.concurrent_program_id = fcr.concurrent_program_id    AND fcr.program_application_id = fcp.application_id    AND fcp.language = ‘US’    AND fcr.phase_code… Continue Reading

How  to backup EBS R12.2 application using shell script Create a shell script with any name for example /home/applmgr/apps_backup.sh #!/bin/bash date=`date +%d%m%Y` . /app/prod/apps/fs2/EBSapps/appl/APPSPROD_prodappdb.env echo “” /app/prod/apps/fs2/inst/apps/PROD_prodappdb/admin/scripts/adpreclone.pl appsTier pwd=<apps_passwd> <<EOF weblogic123 EOF echo “———Application Preclone end `date` ————–“ echo “” >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log echo “————–Tar backup end `date`—————” >> /home/applmgr/BACKUP_PROD_APPS/log/backup_$date.log cp /backup/PROD_APPS_Backup/apps_prod_$(date +%d-%m-%Y).tar.gz /remote_HDD/PROD_Backup_DND/Apps_backup/ echo “————–backup copied… Continue Reading

libdb.so.2: cannot open shared object file: No such file or directory  Applicable to :- Oracle E-Business Suite Technology Stack – Version 12.0 to 12.1.3 [Release 12.0 to 12.1]Linux x86Linux x86-64 So , while doing a fresh clone in a new hardware, we faced the error message “libdb.so.2: cannot open shared object file: No such file… Continue Reading

Recently for one of my customer, I was doing a new R12.1.3 clone into a new server which was outside of their production domain. So after the cloning when tried to open the EBS url from browser it showed error saying  “You are trying to access a page that is no longer active.– The referring page… Continue Reading

Many people find it problematic to download EBS software, So I will show here how to download it easily. Login to http://edelivery.oracle.com/ using your credentials. To download oracle ebs , write down with “Oracle Advanced Supply Chain Planning” . Don’t write Oracle E business suite as this will only download the EBS software not all the components… Continue Reading

How To Apply weblogic PSU Patch Env Details: OS= Windows Server 2012 R12 64bit #Middleware Home MW_HOME= D:\Oracle\Middleware Step 1.   In this example we will be installing WLS PSU 10.3.6.0.211019(p33172858_1036_Generic.zip) So download the patch from support.oracle.com P.S. Following are the generic steps for installing a WLS Psu patch. But its always recommended to go through… Continue Reading

While installing agent in target host for oracle enterprise manager 13c, following error is observed  “The user  does not have the privileges to run commands as user “root” using the Privilege Delegation tool “/usr/bin/sudo”  Solution:- 1. Ignore this warning and proceed with installation. Execute <agent Oracle Home>/root.sh manually after logging in as root. OR Ensure… Continue Reading

In this blog post we will see how to get notifications for OCI Data Integration task executions. Each time a job is started or completed we can post use the OCI Events service to post a notification, let’s see the completion notify then we will see how to get notify in error cases. Firstly I… Continue Reading

How to start/stop/ check status of OMS and Agent in OEM 13c To start  Oracle Management Server(OMS), login to oem server. Navigate to oracle middleware home export MW_HOME= /data2/app/oracle/middleware cd $MW_HOME/bin [oem@ccuine25 bin]$ ./emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 5 Copyright (c) 1996, 2021 Oracle Corporation.  All rights reserved. Starting Oracle Management Server… WebTier… Continue Reading