ORDS: Unable To Encrypt Password In Xml Files Using ORDS 18.1 Using Exclamation Point (!)
Last updated on MAY 11, 2018
Applies to:Oracle REST Data Services - Version 18.1.1 and later
Information in this document applies to any platform.
A configuration has been successfully created using ORDS 18.1.1. In order to create a new set of database configuration files, the original files for the configuration have been copied and renamed: test.xml, test_al.xml, test_rt.xml, test_pu.xml.
The passwords in these files has been modified to use the TEST passwords using the !<PASSWORD> syntax. For example:
When ORDS is restarted, new requests fail with an HTTP 404 "Page not found" error:
- In the log file, an ORA-1017 error can be seen indicating that the username or password value is incorrect
- In the .xml files, the password has not been encrypted and is still in clear text format:
- If the exclamation point (!) is removed, and ORDS is restarted the login is successful and ORDS requests to the new configuration are successful.
This same method works with ORDS 3.0.x - the <entry key="db.password">!NewPassword</entry> entry in the .xml file is encrypted after restarting ORDS when using !<PASSWORD>.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms