This concerns 12.2.1.4.0 on Oracle Linux Server 6.9.
We have an instance which is dedicated to running agents. There are nearly one thousand running agents on this instance, with non-trivial integration into other parts of our infrastructure.
Our problem is that we do not seem to have a painless way to migrate this instance using an out-of-place upgrade process. When importing the BAR file from the old instance to the new, OOP instance, we get RPD, webcat, and security just fine, however *_BIPLATFORM.S_NQ_JOB is empty and none of the Agents are scheduled. The brute-force solution, which we have done once and have no desire to ever do again, is to go re-save every single Agent so it gets re-registered in the jobs table. Unfortunately, due to our integration points we use command-line job execution for certain business needs and these rely on Job ID, which of course changes if we manually re-register all jobs in the job table. So after spending dozens of person-hours touching all Agents in the webcat, we then get to spend another few person-hours collecting new Job IDs and updating scripts.
I have searched this forum and the wider Googleverse and I have not found anybody specifically discussing how to bring up Agents after a BAR-file migration. I am a bit surprised that the BAR file import does not at least automatically re-register all active Agents in the webcat into S_NQ_JOB. This at least would keep them all running, though we would still have to collect the new Job IDs. It would save us about 75% of the work we have to do otherwise.
Our next attempt is going to be to try to lift S_NQ_JOB and S_NQ_JOB_PARAM out of the old instance's schema and drop it into the new schema. Webcat paths are obviously going to be the same so we're hopeful that obisch will be happy and keep on humming along.
And but so, my question for the forum is if someone has found a good process to do an OOP migration/upgrade while preserving Agents - where they run as scheduled without additional work, and preferably with the same Job IDs.
Thanks in advance.