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.