Davis Apps DBA

In my environment, Prepare phase of R12.2 patching cycle failed. On examining the log found a unique issue, tried a small workaround, it worked like a charm. Actually I was not sure that my workaround will help me, but I give it a try and it worked. Issue:  FMW JDK version in use: 1.7.0_85 /u01/PROD/apps/fs1/FMW_Home/Oracle_EBS-app1/jdk is not a symbolic link, creating it... Running ln -s /u01/PROD/apps/fs1/EBSapps/comn/util/jdk64 /u01/PROD/apps/fs1/FMW_Home/Oracle_EBS-app1/jdk  ERROR: Command failed, exit code 1 After seeing this issue I went to respective directory and I can see the directory named jdk. Actually that jdk should have been created as a sym link but here it is created as a normal directory. I couldn't find the reason for that, after all the permissions and ownership are right as it should be. So I decided to move that particular file and restart the prepare phase again. Now this time, jdk was created as a proper symlink and the prepare phas...

One fine morning after the backup has finished in Production environment, thought to have a health checkup. DB was fine. When tried to login to APPS the login page is throwing the below issue, Apps Login Issue with Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE Quick search on google yields some hits on my issue. Solution 1: The root cause of the issue is with GUEST User and Password not in sync. Running the below query, confirmed that GUEST user and password was not in sync select fnd_web_sec.validate_password('GUEST','ORACLE') from dual; FND_WEB_SEC.VALIDATE_PASSWORD('GUEST','ORACLE') -------------------------------------------------------------------------------- N Also, confirmed with the below error on the oacore log javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE Fix: 1. Shu...

The following are the list of tasks for DR configuration. Primary Server Enable Force Logging Enable Archive log  Set remote_login_passwordfile=EXCLUSIVE Adding parameters in pfile Adding parameters in tnsnames.ora file TNSPING check Create Password file RMAN backup for stand-by Instance Stand-by Server OH Creation Set remote_login_passwordfile=EXCLUSIVE Adding parameters in pfile Adding parameters in tnsnames.ora file TNSPING check Copy Password file Create NFS mount point Duplicate database for standby using RMAN Primary Server Below steps should be performed on Primary Instance. Enable Force Logging SQL> ALTER DATABASE FORCE LOGGING; Database altered. SQL> select force_logging from v$database; FOR --- YES Enable Archive Log You can follow the steps mentioned in this post to enable archive log in your database. Change the directories as per your environment.  Click Here Set remote_login_passwordfile=EXCLUS...

After I've Installed 12.2.7 in my Linux Server, all the reports are opening in oracle default viewer in application level. In one of my client location all their reports irrespective of the report type is opening in browser. So my search on this leads to a profile option and it worked for me. Below are the steps for how to do it. Step 1: Log in as SYSADMIN user and choose System Administrator Responsibility Step 2: Choose Profile  à  System Step 3: In profile search as below "Viewer%" Step 4: Choose the following values in LOV Viewer: Application for HTML Browser Viewer: Application for PCL Printer Control Language Viewer: Application for PDF Browser Viewer: Application for PostScript Browser Viewer: Application for Text Browser Viewer: Application for XML Browser Viewer: Default Font Size 10 ...

CONFIGURE RETENTION POLICY It used with the 2 different options. Recovery Window or Redundancy Redundancy: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; If you set Redundancy to 1, RMAN will keep one backup. If you take second backup , RMAN will sign previous backup as obsolete. You can delete obsolete backup with “delete obsolete” command. Recovery Windows: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS; If you set Recovey windows to 3 days, RMAN will sign backups as obsolete older than 3 days. For example, we have 4 backups. And our backup dates are 16 may, 18 may, 21 may and 23 may. If we set Recovery window to 3 days, RMAN must sign 16may and 18 may backups as obsolete (23may – 3 days=20may). But RMAN signs 18may backup as not obsolete. Because RMAN automatically detects backups. And 18may backup is needed for recovery of 20may. CONFIGURE DEFAULT DEVICE TYPE Backup can be taken two different locations. Tape and Disk For backing up to disk: CONFIGUR...

In this post you can find the complete detailed step by step process for EBS 12.2.7 Fresh Installation Here in this post I've did my Fresh Installation in Linux Environment. My environment details are below. Operating System  : RHEL 6 Update 2 Memory                  : 32 GB Storage                  : 4 TB Reference Documents Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1) Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1) R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1) Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1) High Leve...