tag:blogger.com,1999:blog-21122514.post5752222624509415238..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Upgrading Oracle APEX has never been easierDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-21122514.post-48829946475843462182023-11-20T23:17:58.565+01:002023-11-20T23:17:58.565+01:00Flawless upgrade. This couldn't be easier, wel...Flawless upgrade. This couldn't be easier, well maybe if I just think about it and my computer does it! :-)<br /><br />In my case I have different tablespaces:<br /><br />@apexins.sql tbs_apex tbs_apex temp /i/Nelsonhttps://www.blogger.com/profile/14015797014309495357noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-30070634180903551582023-06-12T23:35:56.235+02:002023-06-12T23:35:56.235+02:00No you don't need to uninstall APEX first. You...No you don't need to uninstall APEX first. You can just install the new version and apply 1 patch (it contains all patches over time).Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-40377958235617566092023-06-12T20:11:32.901+02:002023-06-12T20:11:32.901+02:00Question: I have to update from APEX 18.2.0 to 22....Question: I have to update from APEX 18.2.0 to 22.2<br />Should / Must I deinstall APEX first before installing new APEX with all patches ?<br /><br />any hint would be fine<br /><br />regards<br />RainerRainer Hartwighttps://www.blogger.com/profile/06415766261417131357noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-81848128655265267832022-11-18T18:17:05.295+01:002022-11-18T18:17:05.295+01:00You should never use undocumented APIs...
There is...You should never use undocumented APIs...<br />There is no documentation on undocumented APIs.<br /><br />I guess you can always look what the previous function is doing and create your own function from it.<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-58247610695121343852022-11-18T17:03:07.134+01:002022-11-18T17:03:07.134+01:00Hello,
Question. We have upgraded the Apex versio...Hello, <br />Question. We have upgraded the Apex version from 5.1 to 21.1:<br />We have some problems with some functions that no longer exist in this version, for example this one: apex_050100.wwv_render_report3.is_valid_query.<br />In version 21.1 this function does not exist, do you know with which other function could replace it? or if you have any documentation that could help me with this kind of problems?<br /><br />Thanks!Miminoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-80615787676973588212022-05-10T20:29:36.067+02:002022-05-10T20:29:36.067+02:00Hola dimitri:
Tengo este problema con APEX:
There...Hola dimitri:<br /><br />Tengo este problema con APEX:<br />There is a problem with your environment because the Application Express files are not up-to-date! The files for version 19.2.0.00.18 have been loaded, but 21.2.0 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.<br /><br />Saludos<br /><br />viviana<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-90180335760755863552022-01-18T20:13:53.337+01:002022-01-18T20:13:53.337+01:00Hello Sir, Can you please share steps to upgrade a...Hello Sir, Can you please share steps to upgrade apex from 19.1 to 21.2. As starts from 20.1 ORDS is required and customer will install ORDS.So first we need to install Apex right and then ask our customer to install ords as while installing customer need ORDS user which we create using @apex_rest_config.sql script or with 21.2 version that will be created automatically. Please guide and provide the docs or any link.. Thanks in advance sir,<br /><br />Regards,<br />SaurabhAnonymoushttps://www.blogger.com/profile/14546514082296336237noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-13516409802382313082021-12-17T10:18:06.921+01:002021-12-17T10:18:06.921+01:00In most cases CDN makes a lot of sense yes.In most cases CDN makes a lot of sense yes.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-15024056223569499682021-12-16T23:17:04.667+01:002021-12-16T23:17:04.667+01:00I changed over to use the CDN and it all came back...I changed over to use the CDN and it all came back. When I flipped to local images it stops working, so something wrong with my images. Is it recommended to use the CDN anyways? Michaelhttps://www.blogger.com/profile/11206707906777002583noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-8652565573500130902021-12-16T19:33:21.564+01:002021-12-16T19:33:21.564+01:00it's still there in APEX 21.2... it's the ...it's still there in APEX 21.2... it's the icon with the person and wrangler, next to the help icon.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-72403692863934498422021-12-15T20:52:44.773+01:002021-12-15T20:52:44.773+01:00Hi Dimitri, do you happen to know in version 21.2 ...Hi Dimitri, do you happen to know in version 21.2 the account menu acts differently? In 21.1 I can click the top right to log out. In version 21.2 if I click it nothing happens?<br /><br />It also looks like Manage Requests / Manage Instance / Manage Workspaces / Monitor Activity is no longer across the top bar (you just use the icons?)<br /><br />Or I'm wondering if I messed something up Michaelhttps://www.blogger.com/profile/11206707906777002583noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-60536660783650094662021-11-02T08:32:27.287+01:002021-11-02T08:32:27.287+01:00Hi Udo,
It looks like the images folder is not up...Hi Udo,<br /><br />It looks like the images folder is not up-to-date.<br />Did you copy the images folder? or did you update the CDN?<br />If you did, try to refresh your page or empty the cache of the browser.<br /><br />Hope that helps,<br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-38320558999390277702021-11-02T08:23:40.621+01:002021-11-02T08:23:40.621+01:00Hi Dimitri,
thanks for this Blog. After Upgarding...Hi Dimitri,<br /><br />thanks for this Blog. After Upgarding my apex from Version 19.1 to Version 21.1 as described here in your Blog.<br />I reveived the following message after accessing ORDS via Chrome.<br /><br />"There is a problem with your environment because the Application Express files are not up-to-date! The files for version 19.1.0.00.15 have been loaded, but 21.1.0 is expected. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide."<br /><br />do you have any tipp what could be wrong? regards Udo<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-65994292550373099202021-07-26T08:41:06.876+02:002021-07-26T08:41:06.876+02:00You can directly install the new version, no need ...You can directly install the new version, no need to uninstall.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-85124597785601307242021-07-26T07:06:45.554+02:002021-07-26T07:06:45.554+02:00can i directly install latest release on existing ...can i directly install latest release on existing old instance or i need to uninstall old apex instance then install new instance.<br /><br />Regards,manihttps://www.blogger.com/profile/12624675784969206372noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-63774857075310045652021-06-14T04:11:51.635+02:002021-06-14T04:11:51.635+02:00Hi Dimitri,
I really enjoyed the new Apex 21.1 fe...Hi Dimitri,<br /><br />I really enjoyed the new Apex 21.1 features. Is the release date for the oracle cloud environment available anywhere?<br /><br />Thanks,<br />RobertAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-16901616104284209522021-06-06T07:52:23.691+02:002021-06-06T07:52:23.691+02:00Hi Leo,
It doesn't really matter which you do...Hi Leo,<br /><br />It doesn't really matter which you do first.<br />Typically I would install APEX first, then ORDS.<br /><br />DimitriDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-44662505373239057402021-06-06T03:26:34.391+02:002021-06-06T03:26:34.391+02:00Hi Dimitri,
We run Apex version 5.0.4.00.12 with ...Hi Dimitri,<br /><br />We run Apex version 5.0.4.00.12 with EPG. Should I install ORDS 21.1.1 first and then do the Apex 21.1 upgrade?<br /><br />Thanks,<br />LeoLeo Glaubernoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-61732393458455549622021-06-05T12:23:48.822+02:002021-06-05T12:23:48.822+02:00There are many discussions about the usage of SYSA...There are many discussions about the usage of SYSAUX or not.<br />e.g. https://community.oracle.com/tech/developers/discussion/4184427/usage-of-sysaux-tablespace-for-apex<br /><br />I believe you need to decide for yourself if in your case it makes sense to have a dedicated APEX tablespace or not.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-16334858669818732752021-06-05T12:06:24.038+02:002021-06-05T12:06:24.038+02:00using sysaux for apex is actually bad practice.using sysaux for apex is actually bad practice.Anonymousnoreply@blogger.com