Owner: Oracle Apps Blog URL:http://onlineappsdba.blogspot.com Join Date: Tue, 17 Jun 2008 04:59:02 -0500 Rating:0 Site Description: Oracle Apps DBA Blog Site statistics:Click here
Versions of APPS Technology Stack Components 2008-06-11 04:13:40 How to find the versions of technology stack components (Forms, iAS, Framework, JDK, OJSP, etc.)? Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system. Ensure "APPLRGF" variable is set in environment. If not, set it to the same value as "APPLTMP". Navigate to <FND_TOP>/patch/115/bin. Run the Read more:Technology
, Stack
, Components
Oracle Apps Interview Questions - Part I 2008-06-05 23:42:40 Here are some of the Oracle
Apps Interview Questions. These Questions cover from Operating System Installation, Pre-requisites for Apps, Apps Installation, Architecture, File System. In the next part of Questions , I will cover more into advanced apps topics. For any doubts you may post comment so that i could help you. 1) How to Check the memory of the system while the time of Linux Install
RMAN - Duplicate Database on the same host 2008-06-05 23:25:33 Primary DB : ORCL Clone DB : AUX Production Database
should be archive enabled. Startup mount; alter database archivelog; alter database open; archive log list; Recovery catalog for RMAN Creating the Recovery Catalog Owner Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner Read more:Duplicate
RMAN - Duplicate Database on a New host 2008-06-05 07:57:50 How To Create A Production Duplicate
On a New Host using RMAN Primary Database
SID: ORCLDuplicate Database SID: AUXRMAN Catalog SID: RMANBackup of the primary database.Host A (Target) # export ORACLE_SID=ORCL# rman target=/ catalog=rman/rman@ORCLRMAN> run {allocate channel d Read more:New host
Personalizing The Login Page 2008-06-05 04:34:44 1. Attributes of the login page It is possible to control the display of some attributes of the login page, for instance user name or password hints, language switchers, forgot password link, corporate policy message, etc. For this, you need to set the profile option 'Local Login
Mask' (FND_SSO_LOCAL_LOGIN_MASK) with a number being the sum of the mask values described in the table bel
How to find out if a product is installed in e-Business Suite? 2008-06-05 03:39:03 You can find out what products are installed in e-BusinessSuite
, and their patch levels, via Oracle Applications Manager. You will also find a list of the installed by running the script <adutconf.sql> ($AD_TOP/sql/adutconf.sql), or in the file <applprod.txt>. You can find out the patch level of any product you have installed in e-Business Suite
by running the following query vi
How to Change IP Address in an Oracle Applications Environment 2008-06-05 03:38:53 1. Change
the IP Address
in the Server; 2. Verify the current ip address setup in the OracleApplications
environment. Connect as apps user into SQL*Plus and run:select NODE_NAME, STATUS, NODE_MODE, NODE_ID,SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP from fnd_nodes where node_name = upper('hostname');3. Run the following command to remove the old ip address from the Oracle Applications t Read more:Environment
Pinning Oracle Applications Objects into the shared pool 2008-06-05 03:38:40 OracleApplications
DBAs who want to improve database performance by pinning packages into shared pool. Why pinning objects into the shared pool? Oracle Applications requires space in the ORACLE System Global Area (SGA) for stored packages and functions. If SGA space is fragmented, there may not be enough space to load a package or function. You should pre-allocate space in the SGA shared po
How to Reload APPS Java Class Objects 2008-06-05 03:38:28 How to reload the APPS Java Classes This should only be necessary if the JVM was rebuilt for some reason. The solution can also be helpful for customers that have some invalid APPS Java Classes. Using the utility adadmin it is possible to rebuild the JAR/ZIP files and have these loaded into the database. Before providing steps to do the rebuild and load it is necessary to be awar
Replacing Jinitiator with Sun Java JRE for APPS 2008-06-05 03:38:19 Why wait until 2009 July when Oracle desupports Jinitiator for Oracle Applications. Replace your jinitiator now with Sun Java JRE and see the difference PLATFORM : Red Hat Linux AS4DB : 9.2.0.8APPS : 11.5.10.2JINITIATOR : 1.3.1.21
How to compile invalid objects in an APPS Environment 2008-06-05 03:38:10 Applying Patches can create invalid objects
. To get a quick count of the number of existing invalids (if any), use the following select statement : SELECT COUNT(*)FROM DBA_OBJECTSWHERE STATUS = 'INVALID';For a more detailed query, use the following script : SELECT OWNER, OBJECT_TYPE, COUNT(*)FROM DBA_OBJECTSWHERE STATUS = 'INVALID'GROUP BY OWNER, OBJECT_TYPE;To recompile an indiv Read more:Environment
How to setup Password Security? 2008-06-05 03:38:03 Signon Password
Failure LimitThe Signon Password Failure Limit profile option determines the maximum number of login attempts before the user's account is disabled.Users cannot see or update this profile option.The internal name for this profile option is SIGNON_PASSWORD_FAILURE_LIMIT.Signon Password Hard to GuessThe Signon Password Hard to Guess profile option sets rules for choosing Read more:setup
Count Total Number of Users Connected to ORACLE Applications 2008-06-05 03:37:50 Want to determine how many users are connected to Oracle apps 11i,V$session does not give the true picture as mostly there are more than 1 oracle session for the same forms connection depending on how many forms the user has opened up. Solution 1:- Can use this SQL statement to count concurrent_users in Oracle apps: select count(distinct d.user_name) from apps.fnd_logins a, v$session b Read more:Applications
, Total
, Number
, Connected
How AutoConfig sets ICX: Session Timeout 2008-06-05 03:37:36 AutoConfig (adconfig) uses the variable s_sesstimeout from the $APPL_TOP/admin/<context>.xml to determine the ICX:Session Timeout Profile Option. adconfig runs the script afwebprf.sql which does the following : Setting ICX_SESSION_TIMEOUT to correspond to Jserv Session Timeout set_profile(178, 'ICX_SESSION_TIMEOUT',10001, 0,
Using Virtual Hostname When Installing an Oracle AS Instance 2008-06-05 03:35:33 How to force the Oracle
Installer to use a virtual hostname rather than the 'real' hostname when installing an OracleAS instance? solution To ensure that the Oracle Installer picks up the desired hostname follow the steps below:In this example the virtual hostname is virtualhost.oracle.com, and the real hostname is realhost.oracle.com1. Set the ORACLE_HOSTNAME environment variable ORAC
How to Recreate the OraInventory 2008-06-05 03:35:13 How can I recreate the OraInventory if it gets corrupted or removed? Solution In cases where the OraInventory is missing or otherwise corrupt, recreate the oraInventory directory on UNIX systems, using the following steps. In a normal installation, there is a Global Inventory (OraInventory) and a Local Inventory ($ORACLE_HOME/inventory). Locate the oraInst.loc file, which may be in d
How To Configure Apache In R12 (10.1.3) To Listen On A Restricted Port (< 1024) 2008-06-05 03:34:21 To configure Apache
(10.1.3) in Release 12 of EBS to run on a restricted port. A port below 1024. Solution By default, Oracle HTTP Server runs as a non-root user (the user that installed Oracle Application Server). On UNIX systems, if you change the Oracle HTTP Server Listen
port number to a value less than 1024, you must enable Oracle HTTP Server to run as root. For more i
How To Generate A Stack Trace For Forms With Applications 11i 2008-06-05 03:32:44 When troubleshooting forms issues such as FRM-92100, it is often useful to generate a stack trace. Below are the steps for Applications
DBAs to follow to produce a stack trace for forms in an Oracle EBusiness Suite 11i environment. Solution 1. Set the following environment variables: a) check the value of $FORMS60_TRACE_PATH and make sure this directory has write pe Read more:Stack
, Trace
, Forms
Obtaining Forms Runtime Diagnostics (FRD) In Oracle Applications 2008-06-05 03:31:43 A. Introduction When starting a Forms
-based session in Applications
it is possible to pass various useful parameters like formname=xyz, or lang=US, or NLS=xyz etc. This is really helpful when debugging Forms. In addition, there are two other parameters config=debug and record=all which make it possible to perform Forms RuntimeDiagnostics
(FRD.) FRD is a runtime event-based lo Read more:Oracle
How to Add a Web Link to the APPS Forms Menu 2008-06-05 03:31:18 Forms
personalization feature may be used to add a new field in the menus of the forms in the e-business suite 11 i .Below is the Forms Personalization code which will add a Web Link in the Tools menu : 1) Login to your responsibility2) Go to the Forms you need to personalize3) Open personalizations forms : Help/Diagnostics/Custom Code/personalize4) Enter sequence as
Access Oracle Apps R12 / 11i from Linux Client 2008-04-12 00:23:42 In Oracle
Applications professional Users can access professional forms via Applet in web browser. This Form Applet must run with in Java Virtual Machine (JVM) and Oracle bundles its own JVM as Oracle Jinitiator. This Jinitiator is available only for Windows Client
and for Unix/Linux
you have to use Java Plug-In. Till Oracle Apps 11i default JVM was Jinitiator b Read more:Access
How to start Apps R12 in forms socket mode for testing 2008-04-05 22:21:16 Here are two methods (A and B) of starting the forms server for testing in R12. A. Modify the existing adformsrvctl.sh script, that starts the forms servlet process, to start the forms server. 1. Create a new copy of the $ADMIN_SCRIPTS_HOME/adformsrvctl.sh, name it something like testformsocket.sh 2. chmod 755 testformsocket.sh 3. In the new file/testformsocket.sh, Change this line: if [ "se
Oracle Applications 11i Hot Backup Cloning 2008-04-05 08:42:38 You can make use of rapid clone for hot backup cloning of oracle applications 11i. These are very useful while OracleApplications
Production server where downtime is very much limited and is required to 24/7. For 9i database, you can generate script to put tablespaces in offline mode. For 10g datbase, you can put database itself in offline mode. Here are the steps explained from Atul Kuma Read more:Cloning
Changing Application Tier Platforms for Applications Release 12 2008-04-05 08:36:38 It's now possible to migrate your E-Business Suite Release
12 application tier servers from one operating system platform to another. Oracle announced the availability of new Oracle Application
s.htm">Applications
Platform Migration Methodology for E-Business Suite Release 12.This process provides a way to quickly and easily move an existing Oracle E-Business Suite middle tier (applications tier) syste Read more:Changing
, Platforms
Downtime and Apache Restricted Mode in Release 12 2008-04-05 08:36:38 E-Business Suite Release
12 provides a useful mechanism for the Applications administrators to start the Apache
on the applications tier during down time. Applications administrator can start the apache in a mode called restricted mode. Down time tasks like patching can continue to be performed while the Apache is in restricted mode. Restricted access to Oracle Applications Manager (OAM Read more:Downtime
Create a User Event Trace in 11i / R12 2008-06-18 06:28:35 A user event trace is very handy for tracing sql operations to debug various issues. The benefit of a user event trace is that it is linked to a specific user so that only code run by this user is traced. This makes diagnosis easier when compared to similar tracing methods at the database level where all user calls are traced. Step 1 Login to Oracle Applications and select the System Adminis Read more:Trace
Script to Monitor Concurrent Jobs and Hanging Sessions 2008-06-19 10:53:03 Here is a monitoring system to monitor all concurrent jobs, concurrent managers and hung sessions every hour proactively and take appropriate action immediately. It gives the following reports 1. List of Concurrent Jobs that completed with error in last one hour.2. List of Concurrent Jobs running for more then 1 hour.3. List of concurrent Jobs completed with Warning in last one hour4. List Read more:Monitor
, Hanging
, Sessions
Prevent Concurrent Requests Executing on New Cloned Environment 2008-06-19 10:52:51 To prevent concurrent requests executing on a newly cloned environment 2 steps will be required.1) Prevent Concurrent Managers from starting as part of the Clone2) Change data concerning concurrent requests so they do not execute when the concurrent managers start.To prevent Applications Services (including Concurrent Managers) from starting automatically during Rapid Clone an enhancem Read more:Requests
, Cloned
, Environment
Queries Related to Concurrent Requests in 11i Applications 2008-06-19 10:52:42 As part of day to day work, we need to use lot of queries to check the information about concurrent requests. Here are few queries which can be frequently used for day to day works and troubleshooting concurrent request / manager issues. Note: These queries needs to be run from APPS schema. Scheduled concurrent requests Lot of times we need to find out the concurrent programs schedule Read more:Requests
, Queries
, Applications
Reference : Unix, Solaris, Linux, AIX, HP-UX Commands 2008-06-19 10:52:24 As you know, there exists vast array of commands that enable you to do a multitude of tasks. Depending on what you need to accomplish, you use only a certain subset of these commands. These subsets differ from user to user and from need to need. However, there are a commands that you commonly use. You need these commands either to answer your own questions or to provide answers to the q Read more:Solaris
, Linux
, Commands
Recommend Site To A Friend
