Modify the Oracle database user passwords for split architecture

The following are the steps to modify the Oracle password in a split architecture for Linux.

Steps to be performed on portal server

Steps to perform on the Oracle server at the command prompt

su - aptare
source <INSTALL_PATH>/aptare/bin/aptare_env.sh
sqlplus / as sysdba
alter session set container=scdb;
Note:
scdb is the oracle service name.
alter user aptare_ro identified by aptare123456789;
Note:
aptare123456789 is the new password.
alter user portal identified by portal123456789;
Note:
portal123456789 is the new password.
commit
exit

Steps to perform on the portal server

Change the user password:
/<install path>/aptare/utils/changeDBPassword.sh -user <user_name> <password>
The utility will ask if the passwords are updated on the oracle server.
```
Is the password updated on Oracle Server (y/n)?
```
Enter 'y' if the password is updated on the oracle server, as mentioned in step 1, else enter 'n' to exit.
Note:
This updates the specified user's password in the properties files like portal.properties and datrarcvrproperties.xml.
Restart the portal and data receiver (Tomcat) services.