Skip to Main Content

ORDS, SODA & JSON in the Database

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!

OAuth token - 401 Unauthorized

partlycloudyFeb 12 2021 — edited Feb 14 2021

I followed the instructions here and here to secure the service here and used this Firefox add-on to send a request to the /oauth/token endpoint with Basic authentication provided the client_id and client_secret from the user_ords_clients view and POST body grant_type=client_credentials but I get a 401/Unauthorized
This support note talks about a WebLogic setting enforce-valid-basic-auth-credentials=false to disable Basic authentication but I am not sure whether apex.oracle.com uses WLS or Tomcat. Besides, on our own environment, we use Tomcat and we see the same error. Is there a equivalent setting for Tomcat? Or is there something else going on here?
Any ideas?
Thanks

Comments

103122
Have you tried setting LD_LIBRARY_PATH=%ORACLE_HOME%/Lib ? I don't know if it will work, but it's a good first thing to try.
On Windows the variable would be PATH
789319
thanks for the reply i tried but it didn't work




pavanbabu g.s
Fahd.Mirza
Hi,
Please make sure that you have full rights and logged in as administrator user. Also check that in the PATH environment variable in Windows, the above mentioned path is included at the front.

regards
862974
I met this issue too and I fixed it.
The issue is that there were several copy of "OCI.dll" exist in different plance and they belong to different Oracle version. I remove the other version's OCI and the app works fine.
Also I use the following setup.py

from distutils.core import setup
import py2exe, sys

sys.argv.append('py2exe')

setup(
options = {'py2exe': {
'bundle_files': 2,
'compressed': True,
'dll_excludes': ["oci.dll"]
}},
console = [{'script': "test.py"}],
zipfile = None
)
1 - 5

Post Details

Added on Feb 12 2021
36 comments
6,280 views