Skip to Main Content
  • Questions

  • Update all listeners to new Oracle Home after upgrade

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Terri.

Asked: September 07, 2021 - 12:23 pm UTC

Last updated: September 09, 2021 - 6:17 am UTC

Version: Oracle 19c, OEM 13.4

Viewed 1000+ times

You Asked

Is there a way to update all listeners to a new OHome after upgrade? Going in manually to each listener (say 10) to update the new OHome seems like there should be an easier way but I'm unable to locate anything on it.

and Connor said...

Not to my knowledge.

If you're using Grid/Oracle Restart etc, then "srvctl" can be used to do this programmatically (srvctl modify listener) but if you have standard OS configuration files, then its a case of modifying them either manually or with Net Config Assistant.

Typically a listener config file does not need to include a reference to ORACLE_HOME unless you need explicit SID_LIST entries (eg for external procedures) so you could take this opportunity to clean these files a little as part of the upgrade.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database