All posts by Rajat
Oracle Database Recovery Scenario and Solution
The purpose of this article is to get acquianted with some of the recovery scenarios , this topic is useful for the folks who is having less experience and looking for good DBA exposure and preparing for interview . I am trying to jotting down both RMAN and normal database technique :- 1.Complete Closed […]
Read MoreMobile Web Application Tips
With reference to the article in our web site about Mobile Supply chain , I am trying to nail down some of the problem and configuration about MWA , which take care by DBA . This tips can be followed Mobile apllication Server version 11.5.5 to 11.5.10.X One of the important configuration file for the […]
Read MoreHow can i see, Critical Patch Update is installed on the database,
Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended for a DBA to properly document all applied patches to the software installation. The output of ‘opatch lsinventory’ will give you a list of bug numbers, but it can be awkward to cross reference them […]
Read MoreOracle Application Management Pack for Oracle E-Business Suite, Release 2.0
Oracle E-Business Suite Application Technology Group (ATG) is pleased to announce the availability of the Application Management Pack for Oracle E-Business Suite (EBS) version 2.0.2 Rollup update. Oracle strongly recommends that you apply the latest release, 2.0.2. Oracle application Management Pack 2.0.2 Application Management Pack 2.0.2 (Patch 6809246 ) is an OPatch rollup update […]
Read MoreRoot password Recovery SUN,AIX, LINUX(Redhat) and HP-UX
I am trying to cover the password file information and root password recovery . It is not the task of DBA but sometimes the knowledge of Unix administration task help us to do the activities in effective manner . Password file information of root :- Operating system Sun Solaris :- /etc/passwd and /etc/shadow Operating system […]
Read MoreDeploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Introduction This document describes the steps needed to replace the use of Oracle JInitiator with the Sun JRE Native Client in Oracle E-Business Suite 11i. This document also covers the procedure to upgrade the version of the Sun JRE Native Client being used in Oracle E-Business Suite 11i. Prerequisites JRE native plug-in is […]
Read MoreJinitiator 1.3 to be desupported for 11i on July 2009
As of July 31, 2009 Error Correction Support for JInitiator 1.3 will end. In other words, the Oracle Forms group will no longer issue bug fixes via new versions of JInitiator 1.3.x as of July 31, 2009. Metalink notes to upgrade You need to start the upgrade process for your end-users’ desktops to the native […]
Read MoreHow to set up SSH for No Password on SunOS
This setup will allow you to log in to another account without having to provide the password. Identify the Sun Server’s and its user id’s among which you wish to enable secure session without passwords. The below steps concentrates on SSH2, the second version of SSH. Don’t use the first version any longer; it […]
Read MoreHow to generate FRD trace
The steps I have followed :- 1. Login as oracle application user 2. Go to $FND_TOP/secure 3. java oracle.apps.fnd.security.AdminAppServer apps/ \AUTHENTICATION ON DBC= Please check the below example :- 4. java oracle.apps.fnd.security.AdminAppServer apps/ffdev21 \AUTHENTICATION ON DBC=ffus.com_ffus.dbc Output will be :- AUTHENTICATION ON executed successfully – ffus.com_ffus.dbc 5. In the command prompt echo $FORMS60_TRACE_PATH It will […]
Read MoreContinuation of my last post Migrating to AutoConfig on the Database Tier
After upgradation of database , DB Tier would not have the auto config features , we need to make sure that we enable the auto config. The below steps helps us to do so 1. Copy AutoConfig to the RDBMS ORACLE_HOME Update the RDBMS ORACLE_HOME file system with the AutoConfig files by performing the following […]
Read More