Davis Apps DBA

After I recently cloned a TEST Instance, I faced the issue while the forms are opening.  So I decided to check forms log and out files and found the below issue. So from forms_server1.out file I found out the actual cause for the issue. Some mandatory RPM's are missing and hence the issue. So inorder to fix the issue, I googled and found some sites which provides solutions for the exact issue. At that point I learned this error is generic and this issue could be by multiple reasons. So I decided to install the missing RPM's(as per the blogs I referred) in order to solve the issue. Below are the steps I followed. Now I've installed all the required RPM and now I need to relink the forms before starting the APPS service to check whether the issue is fixed or not. Once the forms compilation is completed, I started the APPS services and opened a form and ended up with the same issue. Now on further drill-down, I found out some of the library files are missing which are mandate ...

After creating a clone instance in R12.2, faced the below error. There was no problem in starting or stopping the concurrent manager. So to fix this issue, I tried running CM Recovery wizard. Press on Next button to complete all the steps. But this CM recovery wizard ends in vain. So after these steps, decided to update the CM related tables manually from backend to resolve this stated error. In the place of NODENAME replace your nodename and omit the angular brackets. You can find the nodename from fnd_nodes table. select node_name,target_node,control_code from fnd_concurrent_queues; update apps.fnd_concurrent_queues set node_name = '<NODENAME>' where node_name is null; select NODE_NAME,NODE_MODE,STATUS from fnd_nodes; select control_code,target_node,node_name,CONCURRENT_QUEUE_NAME from fnd_concurrent_queues; UPDATE fnd_concurrent_queues set control_code = null; select TARGET_NODE,NODE_NAME from fnd_concurrent_queues where node_name = '<NODENAME>'; select T...