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.