Hi!
I have to change the password for the ORDS_PUBLIC_USER for security reasons.
As it is a productive system, there is no option to re-run configuration of the .war file again, as the resulting (total) configuration might result in different behavior.
From Oracle ORDS 3.0 documentation, i have learned that you have to remove the db.password within apex_pu.xml in such a case. But still the question remains: how to insert the new password in there?
When you install Oracle REST Data Services for the first time, you are prompted for passwords for these users: the PL/SQL gateway database user and ORDS_PUBLIC_USER. The encrypted passwords are stored in the parameter file (for example, user.public.password=@0585904F6C9B442532D5212962835D00C8
).
If you later want to change the passwords, you must remove the encrypted passwords from the parameter file. For security reasons, readable (non-encrypted) passwords are not allowed in the parameter file.
There is another option which can be found on the net:
by placing an exclamation mark before the password, for example "!your_password" (without the quotes). When you restart Tomcat, ORDS will update the config file with an encrypted version of the password.
Both approaches are not working for me. Is there someone out there who has additional experience/ideas to this topic?
Btw: its a linux system with tomcat6.0.24,apex 5.0.1.00.06 and ords 3.xx
Thanks for reading&sharing!