Error Message :
ErrorMsg: AwE-9999 Internal error
Details: 537080 TESTQUEUE queue doesn't exist
java.lang.RuntimeException
Databases configured to use an Oracle RAC or a scan address can utilize load balancing between the different nodes. While this many normally increase performance this is not the case if this is done on the Applications Manager Database.
As per documentation it is recommended that this be turned off. The reason why the application need load balancing to be off is that there are known issues with DBMS pipes. Application Manager processes 'sleep' and 'wake up' on DMBS Pipes. Pipes are instance-specific, so if Applications Manager processes are balanced across multiple instances, then wake-ups issued by one process might not activate the target process. For example, the Automation Engine (Master) might sleep on one of the RAC nodes, but the wake-up happens on another node and so the Master continues to sleep. Processes will wake up eventually, but this is not ideal because of performance.
The type of performance issues we have noted include (but are not limited to):
Beyond performance issues we have also noted other behaviors within the application when load balancing is enabled. These may include:
SQL> show user
USER is "SYS"
SQL> alter system set remote_listener ='';
System altered.
After you do this, you will need to restart the Applications Manager processes with stopso and startso commands so that connections will go to only one RAC node.