Open GasparYYC opened 5 years ago
Update 2020-07-03:
I just want to share with everyone I just used the same steps for upgrading ORDS 18.3 to 19.4
All views were valid and life was perfect.
Update 2020-08-02:
Upgrade of ORDS with servers with just 1 GB of RAM fails with this error " java.lang.OutOfMemoryError: Java heap space". The solution with Digital Ocean (the cloud provider I use) I resized the server to a 2GB of RAM, upgraded then reduced back to 1 GB of RAM to prevent unecessary charges. As a workaround (untested) would be to reduce the memory used by XE to the lowest possible value.
Note: I had to validate ORDS views after I installed APEX 20.1, for some reason the installation of APEX 20.1 invalidated the views. The validation worked flawless.
I propose a new document/section on the github page of OXAR that has specific information about upgrading to Oracle ORDS (release 18.3 in this example) This is not using patches that requires any kind of support, this is by downloading the current version available for download.
These are the steps I followed and have upgraded my ORDS installation from version v3.0.9 to v18.3 No issues whatsover.
Note: All commands must be run as root
Run the install of ORDS and answer the prompts, with a vanilla OXAR you should only be prompted for the config directory and SYS password:
Now start tomcat and while its running configure the configdir. (for some weird reason it only worked while running, maybe a bug?). Then start node4ords and you're done!
Last step is to cleanup:
Note: Seems ORDS leaves some views with errors or at least on a weird state, the log shows errors like this:
Check the views owned by ORDS_METADATA schema and if there are some views with errors, validate to have them fixed. For me I just run the following and works/fix the issue always: