eBusiness NLS Patch u6678700.drv (12.1.1) Takes Too Much Time as compare to u6078836.drv (12.0.4) – Oracle Bug
Bug 8520057 – 12.1.1 NLS PATCHING HAS INCREASED IN TIME OVER 12.0.4 Follow the Note : 839978.1 (12.1.1 NLS Upgrade Patch 6678700 : Performance Installation Issues With XLIFFImporter Java Jobs) The issue is caused by the time delay spent in connection time within each Java job. Abort the session and apply the patch : 8576725 […]
Read MoreReaders Question – Which Driver (c, d, g, u) to apply on which Node ?
Let suppose below is the read me file of one patch says: This patch contains one or more driver files to be applied with AutoPatch. Please apply the driver files in the following order (if they exist) : c3196140.drv (This is the copy driver) d3196140.drv (This is the database driver) g3196140.drv (This is the generate […]
Read MoreOracle Apps 11i / R12 Interview Question (Installation)
On popular request from newbie I am posting few more Apps DBA Interview Questions (around Installation). If you are new to Oracle Apps and prefer book then you can order one from Amazon written by Joyjeet Banerjee – Cracking the Oracle Apps DBA Interview: 325 Frequently Asked Questions Q1. Which user you use to install Oracle Apps 11i/R12 on […]
Read MoreOracle Database – 11g R2 (11.2.0.1.0) is available to download
. Oracle Database 11g R2 is now available to download from here. You can access 11gR2 Database documentation from here For overview of Oracle Database 11g R2 click here Difference between Oracle Database 11g R1 and 11g R2 coming soon !!
Read MoreInstalling Oracle Fusion Middleware (FMW) 11g – Identity Management Components (OID, DIP, OVD, OIF)
This post covers overview & installation of Oracle Identity Management 11g, for 11g SOA Suite installation on Linux/Unix click here Before I jump to isntallation of Oracle FMW 11g Identity Management, I am going to cover some basics . Oracle Identity Management overview in Fusion Middleware 11g R1 1. Oracle Identity Management consist of various products, here […]
Read MoreStandby Redo Logs (SRL) in Standby Database
. Standby Redo Logs (SRL) : is similar to Online Redo Log (ORL) and only difference between two is that Standby Redo Log is used to store redo data received from another database (primary database). Standby Redo Logs are only used if you have the LGWR as transport mode to Remote Standby Database. (step to check transport mode below) […]
Read MoreFile Attachment in Linux using MAIL/SENDMAIL – How to Send eBusiness 11i/r12 DB Status on Daily Basis
Assumption The rpm sharutils-4.2.1-17.i386.rpm is already there. Verify the same, as followed: rpm –qa sharutil* If not, download and install sharutils-4.2.1-17.i386.rpm by the following, as it is mandatory: rpm -ivh sharutils-4.2.1-17.i386.rpm. DB Check Script is already implemented and scheduled. As root user, schedule the following script: #!/bin/bash FILE=dbchk.doc FILE2=output.html RECIPIENT=rawishsiddiqui@yahoo.ca RECIPIENTCC=oracle@******.com RECIPIENTBCC=rsiddiqui@*****.com ( echo “Dear […]
Read MoreDiagnosing RAC Issues and RAC Best Practices
I just wanted to share few metalink notes on Diagnosing RAC Issues across various platforms. Oracle Support has recently few interesting metalink notes on how to troubleshoot the various layers in a RAC Install i.e Storage, Network, OS, Database, Listener, CRS and ASM Components. The document also lists various whitepapers/metalink articles on troubleshooting IPMP, RAC […]
Read MoreXML Reports going in Warning after taking a long time.
[Preliminary Note: Please do not try it on PRODUCTION Instance until you have applied it on TEST] During working on 12.0.6 running on Linux environment I received a complain from the user that: “Their XML reports (.rtf) are taking too much time in running and ending in Warning status”. Following is the message I saw […]
Read MoreFile in patch is not a known Oracle Applications file: NLS Patching Issue
Follow the Subsequent in order to avoid the aforementioned Error: 1. License Language from OAM – Login with User, having SYSADMIN Responsibility – Oracle Application Manager (Under System Administration) – License Manager- Under Application Dashboard/Site Map (License Manager) -> . . . Languages -> Edit- Choose Required Language -> Next -> Next . . When you get the message […]
Read More