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.
a At the command line, execute the following commands:
su - aptare
sqplplus / 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;