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 100+ 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 we 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.

More to Explore

Administration

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