I know this is a very genric error and why it is caused but the problem we are facing is we cannot trace it and its not permanent, it comes and goes. When we start MWS sometimes MWS does not start and gives this error :
2008-06-03 14:00:28 EST (Framework : FATAL) - Error creating database connection to: jdbc:wm:oracle://xxxx:1528;serviceName=xxxx
java.sql.SQLException: [wm-cjdbc36-0039][Oracle JDBC Driver]Error establishing socket to host and port: xxxx:1528. Reason: Address already in use
From IS JDBC pool, the test connection somes gives this error and sometimes is successful.
I thought it might be a problem with DATA DIRECT Drivers and hence changed it in IS to create new driver alias using ORACLE THIN driver and it works fine.
We cannot configure ORACLE THIN driver from MWS DataSource page as it gives error while testing connection :
“java.sql.SQLException: Io exception: The Network Adapter could not be found.”
OS : RED HAT Linux 4.0
DB : ORACLE 10g
MWS : 7.1.1
IS : 7.1.1