1. How to start and stop application services?
cd $APPLCSF/scripts/$CONTEXT_NAME
./adstrtal.sh apps/apps
./adstpall.sh apps/apps
2. How do you reset apps password?
Stop All Services
FNDCPASS apps/{Old APPS Password} 0 Y system/manager SYSTEM {New APPS PASSWORD}
Ex. FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
Run adconfig.sh on all nodes, enter the new apps password you set in above command.
Re-start all Services.
3. Which tool can be used to apply application patches?
adpatch
4. Describe application patch process.
Stop All services
Put in Maintenance Mode
Adpatch
Take out of Maintenance mode
Start all services
OR
You can go for hotpatch
5. Describe steps to clone production database and application to another server.
It’s a 3 step process. 1. Prepare 2. Copy 3. Configure
1. Prepare the source system
perl adpreclone.pl dbTier ## On DB Tier
perl adpreclone.pl appsTier ## On APPS Tier
2.1 Copy the Application
[APPL_TOP]
[OA_HTML]
[OA_JAVA]
[OA_JRE_TOP]
[COMMON_TOP]/util
[COMMON_TOP]/clone
[COMMON_TOP]/_pages (when this directory exists)
[806 ORACLE_HOME]
[iAS ORACLE_HOME]
2.2 Copy the Database
3.1 Configure the Target System Database Server
cd [RDBMS ORACLE_HOME]/appsutil/clone/bin
perl adcfgclone.pl dbTier
3.2 Configure the Target System Application Tier Server Nodes
cd [COMMON_TOP]/clone/bin
perl adcfgclone.pl appsTier
Ref Metalink Note 230672.1
6. Which tool can be used to reconfigure application parameters?
Oracle recommends using OAM.
However if the OAM is not accessible the Context Editor must be used.
Application tier:
Database tier:
7. Where can you check concurrent manager log files?
cd $APPLCSF/$APPLLOG
8. Where can you check apache log files?
cd $IAS_ORACLE_HOME/Apache/Apache/logs
9. How do you trace user forms session?
FRD Forms Runtime Diagnostic
Edit ICX: Forms Launcher with the Forms parameters for FRD
http://ServerName.DomainName.com:8005/dev60cgi/f60cgi?record=all&log=/tmp/username_frd.log
Default directory for forms Tracing is FORMS60_TRACE_PATH is $ORACLE_HOME/forms60/log
10. How do you get oracle session id for forms process running more than 20 mins?
Check v$session v$session_longops and check for action and time_remaining columns.
11. What is the environment file to source application environment?
cd $APPL_TOP
APPS{ENV_NAME}_{server_name}.env
12. How do you monitor concurrent manager’s status?
1. Log file for Concurrent Manager is at cd $APPLCSF/$APPLOG and check for ls -l *{ENV_NAME}*mgr
2. Login to application Concurrent Request : Manager : Administer
Check the value of Actual and Target.
3. You can check the values from backend in APPS.FND_CONCURRENT_QUEUES.
13. How do you submit concurrent jobs out side of application?
Example
$FND_TOP/bin/CONCSUB apps/$PW SYSADMIN "$RESPONSIBILITY" 'SYSADMIN' CONCURRENT FND FNDSCURS START=$DATETIME 1>$LOG_FILE 2>&1
