Changing Oracle Database User Passwords > Modifying the Oracle Database User Passwords
  
Version 10.3.00P13
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;
4. Follow the instructions in Configuring Oracle Passwords in APTARE Configuration Files to update the portal configuration files with the new passwords.