Modifying the Oracle Database User Passwords
Complete these steps to modify passwords for the Oracle database user. These instructions apply to users portal, aptare_ro and sysdba. Replace user_name with the relevant user.
1. Log in with root access.
2. Stop the portal and data receiver Tomcat services.
3. Change the user password.
At the command line, execute the following commands:
su - aptare
sqlplus / as sysdba
SQL> alter user <user_name> identified by <new_password>;
SQL> commit;
WHERE:
user_name = portal, aptare_ro or system
new_password = new password
For example:
SQL> alter user portal identified by newportalpass;