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!

RESTful service cannot be used after migration

蒋 京辰Apr 18 2025

Environment
Server A: oracel 19c, apex 23.2, ords 20.3
Server B: oracel 19c, apex 23.2, ords 23.2

After cloning the pdb of server A to server B, reinstall ords using ./ords install. The apex application after migration can be used normally, but the restful service in ords cannot be accessed. At this time, the ords version is already 23.2. I tried to uninstall ords and reinstall it. At this time, the data under ORDS_METADATA has been cleared, but the problem still occurs, prompting that some functions are unavailable and the ords version is too low.

Then I created a new oracel user in the migrated pdb, and then created a new workspace in apex to associate the schema of the new user. Strangely, the restful service in the new workspace can be used normally. After testing, it was found that as long as the workspace is associated with the oracle schema before migration, an error will be prompted.How should I deal with this problem?

This post has been answered by 蒋 京辰 on Apr 22 2025
Jump to Answer
Comments
Post Details
Added on Apr 18 2025
4 comments
321 views