Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change password for ORDS_PUBLIC_USER - how to reflect within apex_pu.xml?

User302917Aug 15 2016 — edited Aug 17 2016

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!

This post has been answered by User302917 on Aug 17 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2016
Added on Aug 15 2016
1 comment
3,961 views