Changing Oracle Database User Passwords > Configuring Oracle Passwords in APTARE IT Analytics Configuration Files
  
Version 10.2.01P10
Configuring Oracle Passwords in APTARE IT Analytics Configuration Files
Once you’ve made the change in Oracle, Modifying the Oracle Database User Passwords, changes must be made in two files: datrarcvrproperties.xml and portal.properties.
In the portal.properties file
1. Revise the credentials using the portal.properties file:
Linux:
/opt/aptare/portalconf/portal.properties
Windows:
C:\opt\aptare\portalconf\portal.properties
2. Modify the following lines (for the Database User ID):
db.user=portal(preset value)
db.password=portal
db.password.encrypted=
Modify the following lines (for the System DBA):
db.sysdba_user=system (preset value)
db.sysdba_password=
db.sysdba_password.encrypted=
Note: For encryption, the system completes the part after the “=” sign and removes the clear text password entry once Tomcat portal services are restarted.
In the datarcvrproperties.xml
3. Revise the credentials using the datrarcvrproperties.xml file:
Linux:
/opt/aptare/datarcvrconf/datrarcvrproperties.xml
Windows:
C:\opt\aptare\datarcvrconf\datrarcvrproperties.xml
4. Add the following lines (for the Database User ID):
db.user=portal(preset value)
db.password=portal
db.password.encrypted=
Add the following lines (for the System DBA):
<sysdba_user>system</sysdba_user>
<sysdba_password>new_password</sysdba_password>
<oracle_service_name>SCDB</oracle_service_name>
5. Restart the portal and data receiver Tomcat services.
Note: When the Tomcat service is restarted, credentials will be replaced with the encrypted string, so it's important to make note of the original values.
For example:
<db.user>Tij0nQG/IWdtAjwPmFX8xw==</db.user>
<db.password>hs47wbzenhnzTgI0JP62kw==</db.password>
and
For example:
<sysdba_user>Tij0nQG/IWdtAjwPmFX8xw==</sysdba_user>
<sysdba_password>hs47wbzenhnzTgI0JP62kw==</sysdba_password>
<oracle_service_name>SCDB</oracle_service_name>