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>