Tuesday, April 14, 2015

Oracle SOA MDS Account Locked



Today, when tried to deploy a composite to standalone SOA Server from JDeveloper, I ran into the below issue.

JDeveloper stopped listing my SOA Server in the deploy wizard. Reason is SOA_MDS Schema password is expired. To find this out, I validated the data source connection in Weblogic Console.

I followed below steps to bring up the SOA Server and deploy my composite successfully.

The DBMS driver exception was: ORA-28000: the account is locked 

Change Password and Unlock the MDS account
ALTER USER username IDENTIFIED BY new-password;
ALTER USER username ACCOUNT UNLOCK;

Validate if data source connection works fine in Weblogic Console and then restart SOA Server.

No comments:

Post a Comment