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