Skip to Main Content

APEX

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!

Store results of the Advisor in a table

FabieneFeb 11 2019

Hey mates,

Is there a way to run the "Advisor tool" outside of the APEX environment? We have 25 applications developed with APEX, more than 500 pages and it's a pain in the neck to run the advisor manually prior each release. It's so boring that my team tend to forget about it... (it's not an excuse, they should do it but we all know that good developers are lazy people :))

In an ideal world, I'd like to run the "Advisor tool" in a PL/SQL procedure, store all the errors in a table and give the possibility to my development team to flag the entries as "False positive" so that they won't appear next time. But I am struggling with the first point (I should be able to handle the next steps 8D).

Did someone already investigate such possibility?

I checked the plugins, only found the "Quality Assurance" one, is it the best option so far?

I also tried to use the wwv_flow_advisor_dev.check_application procedure but it needs to be ran in an APEX environment.

We are using APEX 5.2.

Cheers.

Comments

I would definitely go with option #3. It is the easiest and the one with the least down time. I would suggest that you use AutoUpgrade to do the upgrade instead of the manual upgrade. It is easier and it does support having source Oracle Home and target Oracle Home on two different servers. Take a look at the Database Upgrade Quick Start Guide which shows how to get started with the tool. In your case you would execute "analyze" and "fixups" mode on the source system and wait for the changes to be applied on the standby. Then you break the connection and you can eventually do the upgrade using the "upgrade" mode. In your configuration file instead of specifying a "target_home" you should specify "target_version" instead.

Regards,

Daniel 

1 - 1

Post Details

Added on Feb 11 2019
0 comments
39 views