C Troubleshooting Oracle REST Data Services
This appendix contains information on troubleshooting Oracle REST Data Services.
Topics:
Enabling Detailed Request Error Messages
To enable detailed request error messages, add the following setting to the Oracle REST Data Services configuration file named: defaults.xml
:
<entry key="debug.printDebugToScreen">true</entry>
When this setting is present in defaults.xml
, any request that produces an error response includes a detailed message, including a stack trace. This setting must not be enabled on productions systems due to the risk of sensitive information being revealed to an attacker.
ORDS User Defined Service
The following table lists the ORDS user defined services:
Table C-1 List of ORDS user defined service
Service | Response |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
Configuring Application Express Static Resources with Oracle REST Data Services
When using Oracle REST Data Services, a blank page might be displayed when attempting to access an Oracle Application Express page, for example, when attempting to display https://example
/ords/
. This problem is caused by an improper configuration of Application Express static resources, which causes the JavaScript and CSS resources required by Application Express not to be found and the Application Express page not to render correctly.
The specific cause can be any of the following:
-
Forgetting to ensure that the Application Express static images are located on the same server as the Oracle REST Data Services instance
-
Forgetting to deploy
i.war
on WebLogic Server -
Specifying an incorrect path when using the
java -jar ords.war static
command to generatei.war
-
Configuring Application Express to use a nondefault context path for static resources (
/i
) and not specifying the same context path (using the--context-path
option) when usingjava -jar ords.war static
-
Moving, renaming, or deleting the folder pointed to by
i.war
after deployingi.war
-
When running in Standalone mode, entering an incorrect path (or not specifying a path) when prompted on the first run of Standalone mode
-
When running in Standalone mode, entering an incorrect path with the
--static-images
option -
Upgrading to a new version of Application Express and forgetting to reconfigure and redeploy
i.wa
r to point to the static resources for the new Application Express version, or in Standalone mode forgetting to update the location by using the--apex-images
option
To help in diagnosing the problem, you can try to access the apex_version.txt
file. For example, if your Application Express deployment is located at https://example.com/ords/
and your static resources have been deployed at https://example.com/i/
, use a browser to access the following URL:
https://example.com/i/apex_version.txt
If you get a 404 Not Found
error, then check the preceding list of possible specific causes, including i.war
not being deployed or not pointing to a folder containing Application Express static resources.
If a plain text file is displayed, it should contain text like the following:
Application Express Version: 4.2.1
Check that the version number matches the version of Application Express that is deployed on the database. If the numbers do not match, check if you have made an error mentioned in the last item in the preceding list of possible specific causes, because Oracle REST Data Services is not configured to use the correct version of the Application Express static resources to match the Application Express version in the database.
If you need help in solving the problem, check the information in this book about
creating and deploying i.war
for your environment, such as WebLogic
Server.
You can also get detailed help on the static listener command by entering the following at a command prompt:
java -jar ords.war help static