Sunday, August 9, 2009

AIA 2.2.1 installation on Solaris

while installing AIA FP 2.2.1 on Solaris SPARC, we came across following error:
com.oracle.oems.weblogic.AQJMSException: Failed to get Oracle AQ destinations: JMS-232: An invalid user/password was specified for the JMS connection

javax.jms.JMSSecurityException: JMS-232: An invalid user/password was specified for the JMS connection
at oracle.jms.AQjmsDBConnMgr.checkForSecurityException(AQjmsDBConnMgr.java:868)

This is can be resolved with following steps:
1) open file AIA_HOME/Infrastructure/install/wlscripts/FPWLCommonConfig.xml
2) reach to target CreateStartupClasses
3) there are three java tasks for com.oracle.oems.weblogic.AQJMSPasswordUtility
4) in the task for oraesb, password is hardcoded as 'oraesb' in clear text.
5) this should be password of 'ORAESB' database user.
6) change this password value; and restart the installation.

but If you are re-starting installing after failed attempt, you may following steps:
1. login to weblogic console.
2. Delete all the startup classes created as part of previous installation
3. Delete all AIA datasources and connection pools
4. drop AIA schema

No comments: