Changing the Database User Password > Overview
  
Version 9.2.00
Overview
To access the StorageConsole database, a database user account is set to the following defaults:
Database User ID: portal
Database User Password: portal
Use the steps to change the password for this User ID. As expected, the steps impact access to the StorageConsole database, so be sure to:
Execute these steps with caution.
Execute all relevant steps in this process.
Steps to Modify the Database User Password
Stop the Tomcat Services
1. Log in with root access.
2. Linux: Execute the following scripts.
/opt/aptare/bin/tomcat-portal stop
/opt/aptare/bin/tomcat-agent stop
3. Windows: Stop the following services via the Windows Services Control Panel.
APTARE Portal Tomcat
APTARE Agent Tomcat
Alter the Portal User
1. 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
new_password = new password
EXAMPLE:
SQL> alter user portal identified by portal;
 
Update Configuration Files
1. Log in with root access.
2. Edit the portal.properties file.
Linux: /opt/aptare/portalconf/portal.properties
Windows: C:\opt\aptare\portalconf\portal.properties
3. Update db.password.
db.password=<new_password>
4. Remove the encrypted password value, leaving a null value after the equals sign.
db.password.encrypted=
5. Edit the datarcvrproperties.xml file.
Linux: /opt/aptare/datarcvrconf/datrarcvrproperties.xml
Windows: C:\opt\aptare\datarcvrconf\datrarcvrproperties.xml
6. Remove the value between the password tags and enter the new password.
<Password>new_password</Password>
7. Restart the services.
Note: The password will be encrypted when the services are started.
Start the Tomcat Services
1. Log in with root access.
2. Linux: Execute the following scripts.
/opt/aptare/bin/tomcat-portal start
/opt/aptare/bin/tomcat-agent start
3. Windows: Start the following services via the Windows Services Control Panel.
APTARE Portal Tomcat
APTARE Agent Tomcat