My Oracle Support Banner

ASM LOCAL_LISTENER using incorrect port after GIPSU was installed (Doc ID 2201573.1)

Last updated on AUGUST 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

o The issue has been seen after installing 12.1.0.2.160119 GIPSU (Jan-2016) or 12.1.0.2.160719 GIPSU (Jul-2016). But the issue even can happen on 12.1.0.2.161018 GIPSU (Oct-2016).

o The agent is changing the value for LOCAL_LISTENER from port 1521, where the node listener is running (ora.LISTENER.lsnr), to port 1522, where the ASM listener is running (ora.ASMNET1LSNR_ASM.lsnr)

o The alert for ASM showes around the same time:

ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=<node IP>)(PORT=1521))' SCOPE=MEMORY SID='+ASM1';
 
ALTER SYSTEM SET local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=<node IP>)(PORT=1522))' SCOPE=MEMORY SID='+ASM1';

o This is a Flex ASM configuration, where we have ASM listeners running (e.g. ora.ASMNET1LSNR_ASM.lsnr)

o On this issue, the cluster have two networks used for interconnect and ASM, like:

$ oifcfg getif
eth0  <public subnet>  global  public
eth1  <interconnect subnet 1>  global  cluster_interconnect,asm
eth2  <interconnect subnet 2>  global  cluster_interconnect,asm

 

Changes

Applied the GIPSU.

Cause

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
Symptoms
Changes
Cause
Solution
References


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