Problems with a Database Deployment
Problems related to the database deployment used by Oracle SOA Suite on Marketplace can occur.
Creating an opss datasource fails
An attempt to create an opss datasource can fail because the database deployment’s opss user account is locked.
To unlock the opss user account:
-
Log in to the database deployment’s VM by using the private key.
ssh -i private-key opc@ip-address-of-db-vm
-
Change to user
oracle
.sudo su - oracle
-
Start sqlplus.
cd $ORACLE_HOME/bin ./sqlplus
-
Log in using the
system
user, and enter the password.Enter user-name: system Enter password: system_user_password
-
Unlock the account.
ALTER USER schema_prefix_opss ACCOUNT UNLOCK;
-
Change the password.
ALTER USER schema_prefix_opss INDENTIFIED BY new_password;
-
Exit sqlplus.
exit