Interview Question

 Super

• oracle-apps-basics
• listener-interview-question
• interview-question-on-adutilities
• mobile-servermsca
• cloning-interview-questions
• Patching-Interview-Question
• file-system
• Concurrent Manager

Super

Interview Question

Archietechure

 1.) Explain in brief about EBS login flow.? Why APPLSYS and APPS should have the same password. ? and Why Guest User cant be end dated

2.) Usage of OAFM and OACORE run in OC4J in Release 12

3.) What happened behind the scene when a concurrent request is submitted?
4.)How To Recreate the /appsutil/scripts/ director
5.) In how many phases autoconfig will run?

DMZ

 1.) Steps to configure DMZ in oracle R12?

 2.) How to configure SSL in R12?

 3.) How do you configure R12 EBS DR?

Oracle Workflow

1.) High Level steps to configure R12 Workflow Notification Mailer Configuration .

Concurrent Manager.
 1.) CRM log file location 

Concurrent Manager

Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.

Where is Concurrent Manager log file location.

By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well

cd $APPLCSF/$APPLLOG

For ICM Log                                       –> ls -lrt *$TWO_TASK*

For Standard manager Log                  –> ls -lrt w*.mgr

For Conflict Resolution manager Log –> ls -lrt c*.mgr

Question 1: What are different types of concurrent manager?

Answer There are several types of concurrent manager. Important ones:

Internal Manager

Standard Manager.

Conflict Resolution Manager

Internal monitors

Service Manager

Transaction Manager

Custom Manager Defined

Read more on below link

Oracle Concurrent Manager

Question 2: What is Internal Concurrent Manager?

Answer : It is responsible for controlling all other concurrent managers. Its main task is to make sure that all other concurrent managers are up and running. It controls other manager through the requests made to the service manager. It also starts, stops and restarts the service manager for all nodes.

Question 3: What is Conflict Resolution Manager (CRM)?

Answer: It takes care of resolving the program incompatibilities and checks if a request in queue can be run in parallel with the running request. If a program is identified as run alone, then it prevents concurrent managers from starting other programs in the same conflict domain.

Question 4: What is Standard Manager?

Answer : Standard Manager is the master concurrent manager. It is always running and can take care of processing any concurrent request. If at all, no other manager is assigned to a program, that program will be picked by standard manager.

Question 5:

What happened behind the scene when a concurrent request is submitted?

Answer

1) Once a concurrent request is submitted by the user, the table FND_CONCURRENT_REQUESTS is automatically updated with the details of the request. The table is also updated with the information about the schedule of the concurrent request whether it’s immediately scheduled or scheduled at a fixed time.

2)a) If the request is incompatible/constraints defined ,Once the request time to run is arrived,it status is set to pending/Standby.Now the conflict resolution manager takes care of the request and finds out what are the incompatibilities and set the status pending normal when the incompatibilities are cleared.

b) If there are no incompatibilities then Once the request time to run is arrived,it status is set to pending/Normal

c) ALL the standard concurrent Manager and special manager continuously poll the FND_CONCURRENT_REQUESTS table .The job of a concurrent manager is to execute concurrent requests that are in Pending / Normal phase / status and that it is qualified to run according to its specialization rules.

Concurrent Manager Processes

– Act independently

– Select only requests that: (a) match the manager specialization rules, (b) are Pending/Normal, (c) have a requested start time <= sysdate

d) Once the request is processed, the FND_CONCURRENT_REQUESTS table is updated with the status.

Question 6: Business user create the task that Concurrent request is taking a lot of time to complete. What will be your approach for debugging it?

Answer

1) First find the status of the concurrent request. It may be scheduled later on or it could be pending/standby mode or all the concurrent manager are occupied running other request. If it is pending/standy, we need to find the incompatible program running and inform user.Many times the users schedule the request to run at a later time.

2) Find out the database sid of the concurrent request and check it is waiting on any locks. We will kill the blocking session to order to complete the job

3) We can run a trace on the request id to find the sql running and then generate the explain plan for it. You can see if the sid is stuck on particular sql . If it is particular sql, then it is good to check the statistics of the table involved . We can look for tuning option for that query

4) We can check the parameters with which the request is run. (For example, once a user came saying the request is not printing the output. On Checking the possible things, it was realized that he scheduled the request with print copies = 0.)

Question 7: What happens when the internal concurrent manager dies abruptly? Are all the managers also killed immediately after it?

Answer

No ALL the standard manager keep running and executing the request. if the internal manager dies, below queue control request are not performed

a) Starts all other processes.

b) Executes “control requests” submitted by the administrator.

c) Activate/Deactivate/Abort Concurrent Manager

d) Terminate Concurrent Request

e) Monitors processes, restarting any that failed.

f) Sets the target number of processes for each service based on the current work shift.

Question 8: Does the internal manager run or schedule any request for itself?

Answer

No, the internal manager does not run or schedule any requests. It has nothing to do with scheduling requests, or deciding which manager will run a particular request. Its function is only to run ‘queue control’ requests

a) Starts all other processes.

b) Executes “control requests” submitted by the administrator.

c) Activate/Deactivate/Abort Concurrent Manager

d) Terminate Concurrent Request

e) Monitors processes, restarting any that failed.

f) Sets the target number of processes for each service based on the current work shift.

Question 9: How do I process more concurrent requests in parallel?

Answer

We can increase the target processes of the concurrent manager in order to increase the parallelism. This can be done using define concurrent manager form or through direct update from sqlplus

Question 10 : If the internal manager goes down, do I need to kill all the managers before restarting the internal manager?

Answer

No, if the internal manager goes down you need not kill all the managers. You can simply start the internal manager using startmgr.

Concurrent Manager troubleshooting

Question 11 : What are the problems u have faced while shutting down applications?

Answer

While shutting down application generally concurrent manager won’t go down because some or the other request may be running. We will see what are the concurrent requests running by querying fnd_concurrent_requests, fnd_concurrent_program_vl, v$session, v$process and v$sqltext.

If that request is only doing some select statement then we will kill those requests, otherwise we will check what time it will take to complete by querying the previous runs of that request and then we will decide what to do.

Oracle Concurrent Manager Secrets

Question 12: What are Internal Monitors ?

Answer: Internal Monitors are used specifically in PCP to allow for ICM failover to other available middle tier nodes.

a) Place an Internal Monitor on any node where the ICM can start in case of a failure.

b) Internal Monitors are seeded on every registered node by default.

c) If the ICM goes down, the Internal Monitor will attempt to start a new ICM on the local node.

d) If multiple ICMs are started, only the first will stay active. The others will gracefully exit.

Question 13: Can I delete concurrent manager?

Answer:

Yes, you can delete any concurrent manager. For deleting, query for the manager in the defined concurrent manager form and then delete the row.

Deleting the predefined concurrent managers is not recommended and it should never be done. Deletion may cause instability in the system.

Question 14: How can you know which trace file is created for the particular request?

Answer

You can find out the same using the script given below. The trace will be located in the udump location of the database server.

prompt

accept request prompt ‘Please enter the concurrent request id for the appropriate concurrent program:’

prompt

column traceid format a8

column tracename format a80

column user_concurrent_program_name format a40

column execname format a15

column enable_trace format a12

set lines 80

set pages 22

set head off

SELECT ‘Request id: ‘||request_id, ‘Trace id: ‘||oracle_Process_id, ‘Trace flag: ‘||req.enable_trace, ‘Trace Name: ‘||dest.value||’ ‘||lower(dbnm.value)||’ora’||oracle_process_id||’.trc’, ‘Prog. Name: ‘||prog.user_concurrent_program_name, ‘File name: ‘||execname.execution_file_name||execname.subroutine_name , ‘Status :’||decode(phase_code, ‘R’, ‘Running’)||’ ‘||’-‘||decode(status_code, ‘R’, ‘Normal’), “SID Serial: “||ses.sid||” , “||ses.serial#, “Module : “||ses.module

from fnd_concurrent_requests req,

v$session ses, v$process proc,

v$parameter dest, v$parameter dbnm,

fnd_concurrent_programs_v1 prog,

fnd_executables execname

where req.request_id = &request

and req.oracle_process_id=proc.spid(+)

and proc.addr = ses.paddr(+)

and dest.name=’user_dump_dest’

and dbnm.name=’db_name’

and req.concurrent_program_id =

prog.concurrent_program_id

and req.program_application_id =

prog.application_id

and prog.application_id =

execname.application_id

and

prog.executable_id=execname.executable_id;

Top 30 Most Useful Concurrent Manager Queries

Question 15: Explain how parallel concurrent processing(PCP) works?

Answer

In case of parallel concurrent processing, all the managers are assigned a primary and a secondary node. The managers are started in their primary node by default. In case of node failure or Oracle instance failure, all the concurrent managers on that node are switched to their secondary nodes. Once the primary node is available again the concurrent managers on the secondary nodes are migrated back to the primary node. During the migration process, a manager may be spread across both primary and secondary nodes.

In case of parallel concurrent processing, it may happen that in a node where parallel concurrent processing is configured, the Oracle instance may or may not be running. The node which is not running Oracle, the concurrent managers connects via Net8 to a node which is running Oracle.

The internal concurrent manager can run on any node, and can activate and deactivate concurrent managers on all nodes. Since the internal concurrent manager must be active at all times, it needs high fault tolerance. To provide this fault tolerance, parallel concurrent processing uses internal monitor processes. The job of the internal monitor process is to constantly monitor the internal manager and start it when it fails. Only one internal monitor process can be active on a single node. You decide which nodes have an internal monitor process when you configure your system. You can also assign each internal monitor process a primary and a secondary node to ensure fail over protection. Internal monitor processes, like concurrent managers, can be assigned work shifts, and are activated and deactivated by the internal concurrent manager.

Parallel Concurrent Processing

Question 16: What are the circumstances in which you need to bounce the concurrent manager?

Answer: There can be many situation where you need to bounce the concurrent manager

a) When you modify the definition of the printers

b) When you modify the environment variables. Suppose you have changed the APPLTMP and APPLPTMP variable.

c) When all the requests are pending and hanging and no processing happening

d) patch application requires the bounce of the CM

e) We have many global hangs in the system due to locks by several concurrent manager and other processes

Question 17: What are the reasons a concurrent manager hangs?

Answer:

The concurrent manager hangs due to many reasons. A few of them are:

– Long running jobs

– The internal manager was activated by someone other then owner of the application system

– The operating system files system is full

– It’s not able to create the log file

– You’ve shut down the internal manager, but actual has a number in it

– The database is hanging may be because the archive log files have filled

– Pending/standby requests are too many

Question 18: How can we enable/disable Conflict Resolution Manager?

Answer: It can be done using profile options “Concurrent: Use ICM”. Set it to “Y” to enable Conflict Resolution manager. To disable it, set the profile option to “N”.

Question 19: What are Transaction Managers?

Answer : Transaction managers provide synchronous job processing by continually monitoring a DBMS pipe for requests to come through from a client-side application. The job of a transaction manager is to process this job immediately and send information back to the client using the pipe.

a) Transaction Managers Provide Synchronous Job Processing

b) A client makes a request for a specific transaction manager to run a program, and waits for the results of that program

c) Product teams’ programs are linked directly into the transaction manager executables

d) PO, CRP, INV, AR, and OE all ship transaction managers

Question 20: How the mechanism of viewing log and output files works from browser?

Answer

The sequence of events is as follows:

1. A user within an Applications session requests to view a log or out file.

2. The browser receives the request and spawns the cgi program FNDWRR.exe

3. FNDWRR.exe logs into the database and queries FND_CONCURRENT_REQUESTS to discover on which node the files for this request are stored.

4. FNDWRR.exe constructs the service name for the file server on that node. And makes the tns call to contact the listener for this service name.

5. The listener responds by spawning the local FNDFS executable, as defined in it’s listener.ora file. Now, FNDFS and FNDWRR.exe are able to communicate directly now, using RPC calls.

6. FNDWRR.exe requests FNDFS to transfer the file that was selected by the user.

7. FNDFS transfers the file contents to a temporary file directory on the web server’s node.

8. The web server displays the file contents to the user.

Question 21: Why does the Concurrent manager put a concurrent program into a queue? Why doesn’t the manager simply let the program run?

Answer: Because at any given point in time a concurrent manager can run no more than say 10 programs concurrently. This figure of 10 is configurable of course. First the manager puts a submitted program into a queue, next the manager checks if there is a slot available (i.e. Less than 10 programs are currently running). If a slot is found available, the concurrent manager then runs the program, or else it keeps the concurrent program in a queue with status Pending.

Question 22: What to do if a request is Inactive/No Manager

Answer: This is quite tricky questions

a) Make certain that there is at least one active manager with specialization rules that allow the program.

b) If you have confirmed the previous point, then the problem may be a stale Worker Request View

– The view is used internally to map requests to managers

– The view is regenerated when managers are created, or specialization rules are altered

c) You can manually regenerate the view

FNDLIBR FND FNDCPBWV apps/apps SYSADMIN ‘System Administrator’ SYSADMIN

Question 23: What are Service Managers

Answer: Service Managers are spawned on the middle-tier nodes of a GSM enabled system in order to act as an agent of the ICM. When the ICM sees that it needs An Service Manager to perform some function, such as start a concurrent manager process, on a middle-tier node, it will make remote procedure control (RPC) calls to the Apps listener on that node to start the Service manager. Once the Service manager has been started and initialized, the ICM communicates directly to the SM through RPC, giving it information to manage the services on that node. The SM is spawned from the APPS TNS Listener.The APPS TNS Listener must be started on every middle-tier node in the system, and started by the user that starts ICM (e.g. applmgr) .TNS Listener spawns Service Manager to run as agent of ICM for the local node

The Service Manager is started by ICM on demand when needed. If no management actions are needed on a node a Service Manager will not be started by ICM until necessary. When ICM exits its Service Managers exit as well.

Question 24: What all is performed by ICM Process Monitor?

Answer: The ICM itself and each process spawned by the ICM has an entry in FND_CONCURRENT_PROCESSES and holds a uniquely named DBMS lock.

The unique lock of the ICM has a format of FNDCPLK_ICM. This database session lock is the method that the ICM ensures each PMON cycle that manager and service processes are still alive. If the ICM can get the DBMS session lock of a process, the ICM will start a new process for that manager or service.

Very inportatnt

Oracel R12 Installatiion

http://appsdbaworkshop.blogspot.in/2012/02/

Oracle R12 cloning 

http://appsdbaworkshop.blogspot.in/2013/02/

install oracle 11g 

http://appsdbaworkshop.blogspot.in/2008/10/installing-oracle-database-11g-on-red.html

Important

Copied file /OPRDQC/shared/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.pll from resource/CUSTOM.pll /OPRDQC/shared/apps/tech_st/10.1.2/bin/frmcmp_batch module=/OPRDQC/shared/apps/apps_st/appl/au/12.0.0/resource/CUSTOM.pll userid=apps/*********** Module_Type=library compile_all=y Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)



Mike/Murali -  Patch 14279929 is not obsolete for 12.1 EBS its obsolete only for 12.0, I applied below to F12DEV3 and updated CR with instructions.





Acknowledging your last update on the Service Request.

Perform the following step and let me know what error you are getting.

Upload the screenshot of the error, if any.

Go to $AU_TOP/forms/US.
Execute the following command:
frmcmp_batch.sh userid=apps/apps module= $AU_TOP/forms/US/APXPAWKB.fmb output_file=$AP_TOP/forms/US/APXPAWKB.fmx
module_type=form batch=no compile_all=special



1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.




Now form compilation throwing below error while generating the form .

[OSPT1]-->frmcmp_batch.sh module=CSFFEDBF.fmb userid=apps/***** output_file=CSFFEDBF.fmx module_type=form compile_all=special
Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production)



Hi David/Simon,

Instead of applying patch, we changed the TNS_ADMIN and ORACLE_HOME entries in frmcmp_batch.sh as below:

ORACLE_HOME=${ORACLE_HOME:-/OSPT1/shared/apps/tech_st/10.1.2}
TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}

Tried re-compiling CSFFEDBF.fmb on OSPT1 and it completed with errors. Attached is the log file.

So as per Oracle SR update, performed below steps and CSFFEDBF.fmb was compiled successfully on OSPT1. Log file is attached.

Normally, the non-customized CUSTOM.pll/plx will be the one with a file size of 20480. In your case, that will be:
CUSTOM.pll.DBA
CUSTOM.plx.DBA

So, what you can do is:

1. Take a backup of your current CUSTOM.pll/plx
2. Copy the CUSTOM.pll.DBA to CUSTOM.pll and CUSTOM.plx.DBA to CUSTOM.plx
3. After that, try to compile the CSFFEDBF.fmb again and let me know if you still get the exact same errors or not.




I placed a new CUSTOM.pll.DMV and placed it into $AU_TOP/resource on OSPT1.  Would you please retest using this PLL?

David Vogelsang | Acelity
Manager Application Development

a:  5751 Northwest Parkway, San Antonio  TX 78249
o:  210-255-6461
e:  david.vogelsang@acelity.com
w: acelity.com


We have to use frmcmp (Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But for 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.
===================================


 java -Xmx2048m -jar panaya-ptl-extractor.jar w1ndm1ll /stage/patches/panaya/OPRD/25949781


7933    adpatch driver=u22297430.drv logfile=u22297430.log options=hotpatch workers=12
7934    cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i error
7935    cat /OSPT1/shared/apps/apps_st/appl/admin/OSPT1_BALANCE/log/u22297430.log | grep -i fail
7936    ospt1

Post-patch:
cd $FND_TOP/patch/115/bin/
perl ojspCompile.pl --compile --flush -p 6

flush forces recompilation of all parent JSPs
p paralell


8517    WFLOAD apps/w1ndm1ll@OSPT1 0 Y DOWNLOAD ARCMREQ.wft ARCMREQ



2090    cd cd $FND_TOP/resource
2091    cd $FND_TOP/resource
2092    ls -lrt ixlib.cfg
2093    cp -p ixlib.cfg ixlib.cfg_123_bkp
2094    vi ixlib.cfg
2095    ls -lrt pasta.cfg
2096    view pasta.cfg
2097    view ixlib.cfg
2098    cp -p ixlib.cfg ixlib.cfg_1221r
2099    cp -p pasta.cfg pasta.cfg_1221r
2100    vi ixlib.cfg
2101    ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ALBANWTJ.ttf
2102    vi pasta.cfg
2103    ls -lrt /OPRDQC/shared/apps/apps_st/appl/fnd/12.0.0/resource/ADUOK.ttf
2104    sqlplus


1855    adpatch driver=u23338547.drv logfile=u23338547.log options=hotpatch workers=12
1856    cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i error
1857    cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i fail
1858    cat /OPRDQC/shared/apps/apps_st/appl/admin/OPRDQC_BALANCE/log/u23338547.log | grep -i warning

================================


perl ojspCompile.pl --compile --flush -p 6


8316    clear
8317    cd $INST_TOP/admin/scripts
8318    ls -ltr
8319    ./adapcctl.sh status


java -jar panaya-extractor.jar w1ndm1ll F -customJavaTop=$JAVA_TOP


=======================

ADRELINK

ü  To relink executables only in $AD_TOP/bin we should use adrelink.sh script

ü  To relink executables in product tops(PROD_TOP/bin) use relink application program of  adadmin

ü  To relink executables in 10.1.2 oracle home use $ORACLE_HOME/appsutil/clone/adlnktools.sh

ü  To relink executables in 10.1.3 oracle home use $IAS_ORACLE_HOME/appsutil/clone/adlnkweboh.sh

Implementation Instructions: $ cd <12.1_INSTALL_DIR>/apps/tech_s
t/10.1.2/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches/12415211/files/
lib/stubs/libgcc_s-2.3.2-stub.
so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so

$ORACLE_HOME/appsutil/clone/ad
lnktools.sh

The instructions for the 10.1.3 Oracle Home are:

$ cd <12.1_INSTALL_DIR>/apps/tech_s
t/10.1.3/lib
$ cp -p -R stubs stubsORIG
$ cd stubs
$ cp /stage/patches /12415211/files/lib/stubs/libg
cc_s-2.3.2-stub.so .
$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
$ ln -s libgcc_s.so.1 libgcc_s.so

$IAS_ORACLE_HOME/appsutil/clon
e/adlnkweboh.sh




Hi

FNDSM can be sensitive when it comes to listener disconnects or time outs.
FNDSM_AMXQ05EXT01A_OPRDQC died and has no listener connection for the service.

Simplest troubleshooting to insure it is reset:
Insure the Service Manager is setup for nodeA
Bring the managers down.
Kill the FNDLIBR processes at the OS level (do a kill -9 to insure the database connection is also reset at startup)
Run the Recovery Wizard from Document 134007.1
Bring the managers up again.


If there is still an issue, then \relink the FND executables.
cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y "fnd FNDLIBR"
$ adrelink.sh force=y link_debug=y "fnd FNDCRM"
$ adrelink.sh force=y link_debug=y "fnd FNDSM"

If there is still an issue then,
 Check for core.* files under $APPLCSF/$APPLLOG.
Can set ulimit -c unlimited to get core dump when the issue happens again.
Upload the core file for review.

Also upload screenshots of the Concurrent% profile setting or the instance and the listener.ora file for review to insure the entries for nodeA are valid:
Check the $ORACLE_HOME/network/admin/listener.ora
 For example:
1. Make sure that both the FNDFS SID_DESC and FNDSM SID_DESC entry are present in the Listener.ora

( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII,LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib:/usr/ucblib,LIBPATH=/usr/dt/lib:/usr/openwin/lib:/apps/oracle/prodora/8.0.6/lib' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh'))

2. If the FNDFS SID_DESC entry "envs" setting includes LD_LIBRARY_PATH, LIBPATH and/or SHLIB_PATH, shorten the envs setting to include only 1 LIBRARY reference,
or exclude all the LIB settings.

SID_LIST_APPS_PROD =
(SID_LIST =
( SID_DESC = ( SID_NAME = FNDFS )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDFS )
( envs='EPC_DISABLED=TRUE,NLS_LANG=AMERICAN_AMERICA.US7ASCII' )
)
( SID_DESC = ( SID_NAME = FNDSM_<dbname> )
( ORACLE_HOME = /apps/oracle/prodora/8.0.6 )
( PROGRAM = /apps/oracle/prodappl/fnd/11.5.0/bin/FNDSM )
( envs='MYAPPSORA=/apps/oracle/prodappl/APPSORA.env,PATH=/usr/bin,FNDSM_SCRIPT=/apps/oracle/prodappl/fnd/11.5.0/bin/gsmstart.sh')
)
)


If there is still an issue then patch should be applied,
Patch 17814970: INCORRECT ERROR HANDLING FOR TERMINATED REQUESTS incorrect error handling during the ICM functions of terminating requests, cleaning up dead managers, and shutting down because the requests are dying when the connection is not made.
1) Please download and review the readme for Patch 17814970: Incorrect Error Handling for Terminated Requests.
2) Please apply Patch 17814970 in a Test environment initially before application to any Production instance.
3) Please retest the issue.
4) If the issue is resolved, please migrate the solution as appropriate to other environments.
Note: I understand that you are going live and now is not an advantageous time for patching; however, the requests are dying.
Thank You
Denise

File System

File System

 1. What all directories will be there under any “product” top

Ans à

cd $AP_TOP (Example of product top AP) (Below are various directory under each product top – ad, ap, gl..)
admin  bin  forms  help  html  lib  log  mds  media  mesg  out  patch  reports  sql  xml

--- “forms” contains all .fmx (compiled version of forms)

---“mesg” contains language specific message files and error message for the product.

--- "bin” directory contains executable files like in $AP_TOP/bin you will see APPBCF  APTZGF  apxamex.ctl                apxboav.ctl  apxdiner.ctl  apxgecmc.ctl  apxusbv.ctl  APXXTR

patch direcotry contians pathc deliverables. 

--- "reports"- will have rdf ( datamodel) file. Its used with rtf file to generate outfile xml file.

5) Location of the .odf file

odf stands for Object Description Files used to create tables & other database objects.

$PO_TOP/patch/115/odf

This file also exists in $AP_TOP/admin

8) Location of .pls files

$AP_TOP/patch/115/sql

9) To find .lct file

$AP_TOP/patch/115/import

To find .rtf 

$AP_TOP/patch/115/publisher/templates/US

10) To find .lpc file

.lpc are generally part of .exe files eg. rvtbm.lpc. The relevant command is as follows:

[OSPT1]-->echo $AU_TOP
/OSPT1/shared/apps/apps_st/appl/au/12.0.0

cd $AU_TOP/resource

 -- custom.pll / .pll and plx files pls filse

cd $AU_TOP/forms/US

 -- .fmb files

[OTST1_BALANCE]-->echo $JTF_TOP

/OTST1/shared/apps/apps_st/appl/jtf/12.0.0

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

65: How to compile JSP in Oracle Apps ?

You can use ojspCompile.pl perl script shipped with Oracle apps to compile JSP files. This script is under $JTF_TOP/admin/scripts. Sample compilation method is

perl ojspCompile.pl --compile --quiet

[F12SPT]-->echo $XDO_TOP
/F12SPT/shared/apps/apps_st/appl/xdo/12.0.0

cd $AP_TOP/patch/115/publisher


Hi Where can we find the .rtf files in server loaded through XML Publisher Administrator-->Template?
You can go to the $XDO_TOP/patch/115/publisher/templates/US.

XDO- A type of XML file used to keep track of various resources.

Also what is temporary directory set for XML Publisher Administrator? 

SQL> select value from apps.XDO_CONFIG_VALUES WHERE property_code = 'SYSTEM_TEMP_DIR'; 

VALUE 
-------------------------------------------------------------------------------- 

/u01/app/tmp/OPRD 

*** If the file system grows****

Check to see if debug is turned on for XDO
cd $XDO_TOP
find . -name xdodebug.cfg
cd $AF_JRE_TOP
find . -name xdodebug.cfg
cd $OA_JRE_TOP
find -name xdodebug.cfg
in all three locations search for xdodebug.cfg if it exists stop cm, remove the file and restart cm and see if xdo_top/temp is growing
Also
And any file under $XDO_TOP/temp

2. Where are .fmb (Forms) stored

Ans àThey will be under $AU_TOP/forms/US

NOTE* .fmb and .fmx are different

6. How to compile apps schema and when to compile??
Ans àYou can use “adadmin” utility to compile apps schema (other methods like utlrp.sql exists). Usually you compile apps  after application of the patches, maintanance patch, upgrade, runtime error due to AD_DDL packages or scenarios where there are invalid objects in apps schema.

7. How many database connections are allowed during fresh installation of oracle application.
Ans à100. (Number has increased to 250 for Pluggable Databases in 12c)

"hi, we have a requirement that, we need to make a xml based report without rdf and output should be in Excel, actual we have four sql queries so the output should come in one excel sheet with four tab for four queries."


Hi,

Without .rdf, it is not possible to create a xml publisher report, you have to
have .rdf file, you can create report via discoverer but that is one of the tool
available outside the ERP.

As you require four tab for your four queries, I have no clue about it, but you
can include all the four queries in different data model in rdf and based on the
condition you can show them in rtf file, which gives you output in Excel.

[OTST1_BALANCE]-->echo $APPL_TOP                        -- top level application directory ( take snapshot of it)

/OTST1/shared/apps/apps_st/appl

[OTST1_BALANCE]-->echo $AD_TOP                                   - Admin utility binaries

/OTST1/shared/apps/apps_st/appl/ad/12.0.0

echo $AD_Top/bin

   Adworker,adpatch,admrgpch,adident,adrelink,adadmin,adctrl,adsplice,

 What is adsplice utility ?

   adsplice in oracle apps is utility to add a new product.

 How can you licence a product after installation ?

    You can use ad utility adlicmgr to licence product in Oracle Apps.

  Licence manager(adlicmgr) utility is used to licence/unlicence , enable new       languages,enbale country specific functionality.

 adident utility is used for what ?

 adident utility in oracle apps is used to find version of any file . AD Identification.

 or ex. "adident Header <filename>

 $ cd $ADMIN_SCRIPTS_HOME

 $ strings -a adstrtal.sh|grep '$Header'

How to compile Invalid Objects in database ?

 You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects.

 What are various options available with adpatch ?

 Various options available with adpatch depending on your AD version are

  autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate

 How to compile an Oracle Reports file ?

  Utility adrepgen is used to compile Reports. Synatx is given below

adrepgen userid=apps\<psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename.rdf stype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character

 What are the post installation task?

  Running adjkey –initialize and then runnning adadmin to regerate jar files.

 How you will start Discoverer in Oracle Apps 11i ?

 In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME or startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier)

 if we run autoconfig which files will get effected?

 cd $AD_TOP/bin

 ls -tlrh adchkcfg.sh ===>run this file it will ask for apps password ,you can use it in 11i/r12

 adchkcfg.sh ===> It will generate HTML report.

 This report will list all files and profile options going to change when you run autoconfig.

What is difference between adpatch & opatch ?

 adpatch is utility to apply oracle apps Patches whereas

 opatch is utility to apply database patches

Can you use both adpatch & opatch in Apps ?

 Yes you have to use both in apps , for apps patches you will use adpatch utility and for applying database patch in apps you will opatch utility.

 AD Utility Name: AD Controller

 Executable: adctrl

 Purpose: To know the status of Auto Upgrade, AD Administration, Auto Patch workers and control their actions.

  What is adrelink?

 adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted.

  What is adodfcmp utility?

  This utility is used to recreate/repair corrupted database objects from odf(object defination files) files.

How To Recreate the /appsutil/scripts/ directory

 a. On the Application Tier (as the APPLMGR user)

   Log in to the APPL_TOP environment (source the environment file) cd $AD_TOP/bin

   perl /bin/admkappsutil.pl

   This will create appsutil.zip in $APPL_TOP/admin/out .

 b. On the Database Tier (as the ORACLE user):

   Copy or FTP the appsutil.zip file to the RDBMS ORACLE_HOME

      cd RDBMS_ORACLE_HOME

      unzip -o appsutil.zip

  Generate your Database Context File follow the steps below:

       On UNIX cd . .env

       cd /appsutil/bin perl adbldxml.pl tier=db appsuser= appspasswd=

 c.  Run autoconfig

      On UNIX cd /appsutil/bin, run adconfig.sh contextfile= appspass=After running adconfig.sh contextfile= appspass= ,the scripts directory "/appsutil/scripts//" is created in appsutil directory.

 After running adconfig.sh contextfile= appspass= ,the scripts directory "/appsutil/scripts//" is created in appsutil directory

In how many phases autoconfig will run?

 Autoconfig will run in 3 phases.

1.INIT – Instantiate the drivers and templates

2.SETUP – Fill the templated with values from xml and create files

3.PROFILE – Update the profile values in database.

Is it possiable to restore a autoconfig run?

Partially. Adconfig will create a restore.sh script at $APPL_TOP/admin//out/. This restore.sh will copy the backed up files before autoconfig run to its original

locations. But the profile values updated in the database can’t be restored back.

How to run autoconfig in test mode?

 adchkcfg.sh script at AD_TOP/bin. This script will run autoconfig in test mode and create the difference file which tells us what is going to change , when u actually

run autoconfig.

Where all ADUTILITIES EXE'S LOCATED?

$AD_TOP/bin

For each utility three files are presented.

[applvision@apps bin]$ ls -ltrh adadmin adadminnew adadmin_wrapper

-rwxr-xr-x 1 applvision applmgr 9.2K Dec 31  2006 adadmin_wrapper

-rwxr-xr-x 1 applvision applmgr 9.2K Mar 27  2009 adadmin

-rwxr-xr-x 1 applvision applmgr 3.5M Mar 30  2009 adadminnew

[applvision@apps bin]$

First two files are wrapper files and both are same in size.

 ==>adadmin will internall call adadminnew

 ==>adadminnew is key executable which calls adadmin.

What happen if we lost adadminnew?

adadmin will not work.

Scenario:

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013

[applvision@apps bin]$ adadmin

sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory

[applvision@apps bin]$

What we had to do if we lost adadminnew?

If we lost adadminnew we can recreate it by using adrelink.sh.

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013

[applvision@apps bin]$ adadmin

sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory

[applvision@apps bin]$

Now fire the below command to recreate it.

 $AD_TOP/bin/adrelink.sh force=y "ad admin adadmin"

 NOTE: force=y indicates to check for all libraries.

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

Both are the shell scripts.Its not possible to regenerate it.

we need to copy it from other server.

 How can we generate env file?

 BY using adadmin

Choose Maintain Applications file menu.

Create application environment file

Above is applicable in 11i and in R12 i don't see this option.

(or)

Run autoconfig.

if we lost dbc,can we recreate it?

 Yes ,we can re create dbc file.

 To generate dbc file run autoconfig(OR) Execute adgendbc.sh script.

 Using adadmin is it possible to relink ad product?

 No,we cannot do it using adrelink.sh

 what is the configuration file of adutilities?

 adconfig.txt which is located at $APPL_TOP/admin.

 How oracle will know some adadmin session is running or not?

 It will know from restart file.

 cd $APPL_TOP/admin/$SID/restart

<name>.rf9

 Which adutlilty will not create table in the database?

 adident utility will not create table in the dataabase.

Echo $FND_TOP

/OTST1/shared/apps/apps_st/appl/fnd/12.0.0

15: What is .dbc file , where its stored , whats use of .dbc file ?

dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE

49: What is *.dbc file & whats is location of dbc file ?

dbc as name stands for is database connect descriptor file used to connect to database. This file by default located in $FND_TOP/secure directory also called as $FND_SECURE directory.

50: What is content of dbc file & why its important ?

DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses dbc file. Typical entry in dbc file is

GUEST_USER_PWD

APPS_JDBC_URL

DB_HOST

51: There are lot of dbc file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?

This value is determined from profile option "Applications Database ID"

111: What is FNDSM ?

FNDSM is executable & core component in GSM ( Generic Service Management Framework discussed above). You start FNDSM services via APPS listener on all Nodes in Application Tier in E-Business Suite.

97: What are .ldt & .lct files which you see in apps patch or with FNDLOAD ?

.ldt & .lct stands for Loader datafile & Loader configuration files, used frequently in migrating customization, profile options, configuration data, etc.. across Instances.

95: If by mistake you/someone deleted FNDLIBR can this executable be restored if Yes, How& if no, what will you do ?

Yes, you can restore FNDLIBR executables

run adadmin on concurrent manager node

select option 2. Maintain Applications Files menu

then select 1. Relink Applications programs

when prompts for

Enter list of products to link ('all' for all products) [all]

select FND

when prompt for

Generate specific executables for each selected product [No] ? YES

select YES

& from list of executables select FNDLIBR

This will create new FNDLIBR executables.

87: What is 0 & Y in FNDCPASS, FNDLOAD or WFLOAD ?

0 & Y are flags for FND Executable like FNDCPASS & FNDLOAD where

0 is request id (request ID 0 is assigned to request ID's which are not submitted via Submit Concurrent Request Form.

'Y' indicates the method of invocation. i.e. it is directly invoked from the command-line not from the Submit Request Form.

80: How to retrieve SYSADMIN password ?

If forgot password link is enabled and sysadmin account is configured with mail id user forget password link else you can reset sysadmin password via FNDCPASS.

52: What is RRA/FNDFS ?

Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files & log files. As most of apps dba's are not clear about Report Server & RRA, I'll discuss one on my blog and update link here .

[OTST1_BALANCE]-->echo $ORACLE_HOME

/OTST1/shared/apps/tech_st/10.1.2

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->echo $ORACLE_IAS_HOME

How to compile forms in oracle.
frmcmp_batch location -> $ORACLE_HOME/bin

Go to $AU_TOP/forms/US.
Execute the following command:
frmcmp_batch.sh userid=apps/apps module= $AU_TOP/forms/US/APXPAWKB.fmb output_file=$AP_TOP/forms/US/APXPAWKB.fmx
module_type=form batch=no compile_all=special

compile_all=special  in case we use costom pll/plx i.e customized ffiles.
*** Why would we get a TNS error when recompiling a form?

, we changed the TNS_ADMIN and ORACLE_HOME entries in frmcmp_batch.sh as below:

ORACLE_HOME=${ORACLE_HOME:-/OSPT1/shared/apps/tech_st/10.1.2}

TNS_ADMIN=${TNS_ADMIN:-$ORACLE_HOME/network/admin}

[OTST1_BALANCE]-->echo $IAS_ORACLE_HOME

/OTST1/shared/apps/tech_st/10.1.3

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->

78: Where is plssql cache stored in Oracle Apps ?

Usually two type of cache session & plssql stored under $IAS_ORACLE_HOME/Apache/modplsql/cache

[OTST1_BALANCE]-->echo $COMMON_TOP

/OTST1/shared/apps/apps_st/comn

[applmgr@amxt05ap01a:/OTST1/shared/apps/apps_st/appl/ad/12.0.0/bin]

[OTST1_BALANCE]-->

77: Where is HTML Cache stored in Oracle Apps Server ?

Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages

[OTST1_BALANCE]-->echo $OA_HTML

/OTST1/shared/apps/apps_st/comn/webapps/oacore/html

[OSPT1]-->echo $INST_TOP
/OSPT1/local/inst/apps/OSPT1_amxt05ap03
[applmgr@amxt05ap03:/OSPT1/local/inst/apps/OSPT1_amxt05ap03/appl/admin]

[OSPT1]-->ls

admin  logs     out   portal  soa   appl   certs   ora                      

[applmgr@amxt05ap03:/OSPT1/local/inst/apps/OSPT1_amxt05ap03]

6)what is the location of context file in 11i/r12?

Database side: $ORACLE_HOME/appsutit/<sid>.<hostname>.xml

11i *:  $APPL_TOP/admin/<sid>_<hostname>.xml
R12*: $INST_TOP/appl/admin



114)How can we generate dbc file?.
By running autoconfig.
cd $INST_TOP/admin/install
By executing a file adgendbc.sh file.
Its better to run adgendbc.sh file as it will take less than a minute to create dbc file where as autoconfig will take more than 5mins.
.


7)How to run autoconfig in 11i/R12?

The procdure is same in 11i and R12 but the location is different.
cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.

R12
===
cd $ADMIN_SCRIPTS_HOME (OR) cd $INST_TOP/admin/scripts
in the above location you will find adautocfg.sh file.just give filename and hit enter it will ask for apps password.
if you run adautocfg.sh file which in turn call adconfig.sh file which further call adconfig.pl.you should not worry about the later two script its only for information.