'weblogic.jdbc.extensions.ConnectionDeadSQLException'에 해당되는 글 1건

  1. 2010.08.16 weblogic.jdbc.extensions.ConnectionDeadSQLException
02.Oracle/DataBase2010. 8. 16. 08:41

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님의 질문에 답변 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 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님의 질문에 답변 Raja Kumar님의 질문에 답변 		 
      댓글
Hi,

Posted by 1010

티스토리툴바