Oracle APPS DBA Interview 2

How do I check from the server if the forms server is running or not?

It can be checked by querying process f60ctl. If this is running, that means forms server is running.

How do you relink f60webmx?

It can be done by using the below command:

adrelink.sh force=y "fnd f60webmx"

What is FORM60_TIMEOUT?

It is the environment setting, which refresh to the maximum idle time before f60webmx shuts down.

I am able to launch direct forms, but its hanging when launching it through php. How can I fix it?

Check the profile option "ICX: Forms Launcher". Set forms URL properly here.

What is ICX: Forms Launcher system profile used for?

It is used by the self service WEB applications personal home page (also known as ICX) to determine the base URL needed to launch an application.

What should be the value of ICX: Forms Launcher?

It should be set to http://hostname:port/dev60cgi/f60cgi?

How do we check form version?

Open the form whose version has to be checked. Go to menu bar, select Help -> About Oracle Applications. You will find the form version near the bottom under the heading FORMS.

What is the difference between forms running in socket mode and servlet mode?

When the forms are run on socket mode, there will be a dedicated connection between the client desktop and the forms server. Whereas, when the forms are started in servlet mode, the forms request are processed by Jserv.

How can we find if forms are running in socket or servlet mode?

It can be checked by querying f60 process. It will show the mode in which form is running.

What are different types of concurrent manager?

There are several types of concurrent manager. Important ones:

• Internal Manager
• Standard Manager.
• Conflict Resolution Manager
• Custom Manager

What is Internal Concurrent Manager?

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.

What is Conflict Resolution Manager (CRM)?

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.

What is Standard Manager?

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.

How can we enable/disable Conflict Resolution Manager?

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".

How do I process more concurrent requests in parallel?

It can be done by either increasing the number of target process for the manager, or by changing the cache size of the manager.

What happens if the Internal Concurrent Manager dies? Are all the managers also killed immediately?

No. If the Internal manager dies, the requests continue to run normally except for queue control requests.

Does the ICM run or schedule any request by itself?

No. It does not run or schedule any request. Its function is only to run 'queue control' requests, which are requests to start or stop other manager.

If the ICM goes down, do I need to kill all the managers before restarting the ICM?

No. If the ICM goes down you need not kill all the managers. You can simply restart it using startmgr.

Can a concurrent manager be deleted?

Yes. It can deleted. Query the concurrent manager in defined concurrent manager form and then delete the row.

What is Internal Manager?

It is used for Parallel Concurrent Processing (PCP). It monitors whether ICM is running or not, and if not it will start it on other node.





Click below links for more Oracle APPS DBA Interview Questions and Answers 
Oracle APPS DBA Interview 1