weblogic.jdbc.extensions.ConnectionDeadSQLException

http://kr.forums.oracle.com/forums/thread.jspa?threadID=1038232

problem whle starting the SOA server. 게시일: 2010. 3. 3 오후 10:49
Hi, I have Installed Oracle SOA suite in a server. I have created a domain and with in that domain, there is Admin server, Soa server and BAM server. They were working fine. But when I tried to re-start them recently , the Admin server was showing the warning <Mar 3, 2010 10:42:58 PM PST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-SpacesDS": ORA-28001: the password has expired> but still I am able to access teh web logic console of the admin server. When I try to start the SOA server it gives the message Internal Exception: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired The same is the case with the BAM server also . The console of BAM server is showing the message Internal Exception: weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired. I have used SYSTEM user credentials while installaing the SOA-SUITE. I have changed and re-set the password for that user. But That did not help. can any one please let me know how this issue can be resolved. Please contact me if any more info is needed. Thanks in advance for your time, Raj Kumar

Anuj Dwivedi, TCS 글: 2,440 등록일: 08-10-29

Re: problem whle starting the SOA server. 게시일: 2010. 3. 3 오후 11:44   Raja Kumar님의 질문에 답변 유용함       댓글 Hi Raj, Have you created any connection pool with name "mds-SpacesDS"? ORA-28001: the password has expired Above error shows that account of username, used in the DataSource of connection pool "mds-SpacesDS", has expired and password should be changed. After changing the pasword of DB user, mention the same in your Data-Source as well. Update the DBAdapter to refresh the connection pool. Regards, Anuj

Raja Kumar 글: 36 등록일: 08-12-04

Re: problem whle starting the SOA server. 게시일: 2010. 3. 4 오전 5:15   Anuj Dwivedi, TCS님의 질문에 답변         댓글 Anuj, Thanks for the reply. This connection pool seems to have got created during the installation of SOA-suite. Can you please tell me how can I findout the username of the Databse for which the password needs to be changed, sothat I can update the pwd and reflect that change in the DB Adpater configuration and the Datasource. Thanks, Raj Kumar

Raja Kumar 글: 36 등록일: 08-12-04

Re: problem whle starting the SOA server. 게시일: 2010. 3. 4 오전 6:00   Raja Kumar님의 질문에 답변         댓글 Hi,