After a brand new installation of CA-WAAE 11.3.6 on Linux, cannot connect to the Application Server.
It fails with the following error messages:
CAUAJM_E_10029 Communication attempt with the CA WAAE Application Server has failed! [server12:9000]
CAUAJM_E_10221 Exhausted list of available Application Server(s). Failing request.
CAUAJM_E_50033 Error initializing tx subsystem: CAUAJM_E_10062 Failed to get initial configuration from CA WAAE Application Server(s).
When we verified in the installation log we found the following Oracle error reported:
ORA-01031: insufficient privileges
This user who ran the installation did not have the required privileges and consequently database AEDB was not created properly.
The following privileges are required for the user who will create the AEDB database:
CREATE USER <user> IDENTIFIED BY <password>;
GRANT DBA TO <user>;
GRANT CREATE SESSION TO <user>;
GRANT SELECT ON "SYS"."DBA_TABLESPACES" TO <user> WITH GRANT OPTION;
You can consult the CA-WAAE Implementation Guide for a complete list of all the required privileges.
Once all the required privileges were granted, we recreated the AEDB database properly and this helped to fix the connection issues to the Application Server.