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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORDS Client ID and Secret is not working POST ATP Clone

Shilpa SINGHSep 10 2024

Hi,

We got out ATP database cloned from Prod instance. After that existing client id and secret is not working. Getting below error.

Created new client id and secret, still same error. Please help.

{
"type": "abcs://proxy_problem/oauth/auth_error_general",
"title": "OAuth token resource returned an error",
"detail": "OAuth token resource responded with status code 503 and body:\n\n{\n \"code\": \"ServiceUnavailable\",\n \"title\": \"Service Unavailable\",\n \"message\": \"The database user for the connection pool is not able to proxy to the schema named schema name. This could be a configured restriction on the maximum number of database sessions or an authorization failure.\",\n \"type\": \"tag:oracle.com,2020:error/ServiceUnavailable\",\n \"instance\": \"tag:oracle.com,2020:ecid/564c8b3158aa3fb199bd9bc268043b69\"\n}",
"status": 400,
"o:vbcs-token-notes": {
"thirdParty": true,
"tokenUrl": "https://host/ords/schemaname/oauth/token",
"credentialIDs": null,
"clientId": "ZTgyC-KqVgzcpqdidsDzDQ..",
"noAuthHeader": false,
"clientCredentials": "firstParty",
"form": {
"grant_type": [
"client_credentials"
]
},
"responseStatus": 503
}
}

Comments
Post Details
Added on Sep 10 2024
6 comments
111 views