Guest Author: Sreelatha Doma

The database listener name can now be configured using AutoConfig with newly introduced context variable s_db_listener. Prior to this certification it was not possible to use AutoConfig generated listener.ora files for managing listeners from SRVCTL when there were multiple RAC instances on the same server. To use this feature E-Business Suite customers need to apply the following patch:

  • 11.5.10CU2 – Roll Up Patch 9535311 (RUP-U) or higher
  • 12.0.x – R12.TXK.A.delta.7 or higher
  • 12.1.x – R12.TXK.B.delta 3 or higher
There is a small difference between Oracle Database 10gR2/11gR1 and 11gR2 Listener names. In Oracle Database 10g Release 2 and 11g Release 1 NETCA creates the listener with the given name suffix nodename. For example : If the given listener name is ebs then NETCA creates listener with ebs_<nodename>. But in Oracle Database 11g Release 2 NETCA creates the listener with the given name. To configure the listener with a customized name:
  • Create listener using NETCA
  • Update s_db_listener context variable with listener name.
  • Run Autoconfig.
References
E-Business Suite 11i E-Business Suite 12
Related Articles