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 More

Mobile 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 More

How 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 More

Oracle 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 More

Root 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 More

Deploying 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 More

Jinitiator 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 More

How 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 More

How 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 More

Continuation 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
Not found