My Oracle Support Banner

RDBPROD: LISTENER.ORA and SQLSRV_CONFIG File to Be Used Clusterwide (Doc ID 739502.1)

Last updated on NOVEMBER 06, 2023

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Goal

When using OCI Services within SQL/Services, the configuration file named LISTENER.ORA contains the TCPIP related data.

The OCI dispatcher definition in SQLSRV_CONFIG file has a pointer to the entry in LISTENER.ORA:

Each node (in a cluster) requires a different entry for OCI_LISTENER, as the host entry would be different for each node.

Adding more address lines for each node in a cluster does not work. When the dispatcher encounters an invalid address line within a listener specification, startup of the dispatcher will fail  - the dispatcher logfile logs an error  TNS 12545.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.