Thought it will be helpful to share this here:
after further troubleshooting, I've identified that one of the SQL statements in step 2 is the breaking change -
update ARCMNCONFIG set paramvalue='http://maa-vm.ca.com:8080/mdo/collector/v2' where paramname like '%MDO.CollectorURL%';
instead of changing the param value to the value provided, I just changed the <host> portion to FQDN of that host, leaving the port and the path unchanged. In addition, there are two different parameters - MDO.CollectorURL and MDO.CollectorURL.Internal, I only changed MDO.CollectorURL, leaving MDO.CollectorURL.Internal pointing to localhost.
It's working now, although not all the metrics are being collected - but it's another issue - I'll start another thread.
Thanks,
Maxim.