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
Log in with the root access.
Stop the portal and data receiver (Tomcat) services.
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.propertiesanddatrarcvrproperties.xml.Restart the portal and data receiver (Tomcat) services.