websphere叢集環境配置oracle資料源Test Connection失敗問題解決

websphere 叢集環境下配置oracle資料源，點選test connection按鈕測試的時候報錯：

java.sql.SQLException: ORA-01017: invalid username/password; logon denied DSRA0010E: SQL State = 72000, Error Code = 1,017. View JVM logs for further details；

經檢查username/password是沒錯的，google後找到答案了：

The reason for it is that the "Test Connection" button you see on the admin console, invokes the JDBC connection test from within the address-space of the Node Agent. There is no way for the J2C Alias information to propagate to the Node Agent without restarting it; some configuration objects take effect in WebSphere as soon as you save the configuration to the master repository, and some only take effect on a restart. J2C aliases take effect on restarts.

In a Network Deployment topology, you may have 10 server instances all controlled by the same Node Agent. You may restart your server instances many times, but unless you restart the Node Agent itself, the "test connection" button will never work.

It's a known WebSphere limitation... Which also exists on version 7.0, so don't be surprised when you test it during your next migration. :-)