ORAAGENT DOES NOT REGISTER INSTANCE/SERVICE TO LOCAL_LISTENER IN MULTIPLE LISTENER ENV: ORA-32021: parameter value longer than 255 characters (Doc ID 1381539.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

11gR2 GI oraagent does not register instance/service to local listener in multiple-listener environment:

2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} Value of
LOCAL_LISTENER is
2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} sqlStmt =
ALTER SYSTEM SET
LOCAL_LISTENER
='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.
XX.XX)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1531))(ADDRES
S=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1535))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.X
XX.XX.XX)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1532))(ADD
RESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1542))(ADDRESS=(PROTOCOL=TCP)(HOST=
XX.XXX.XX.XX)(PORT=1530))))' SCOPE=MEMORY SID='racdb1' /* db agent *//*
{1:47226:28141} */
2011-10-24 09:18:32.725: [ USRTHRD][3389032768] {1:47226:28141} ORA-32021:
parameter value longer than 255 characters
SQL> ALTER SYSTEM SET LOCAL_LISTENER='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1531))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1535))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1532))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1542))(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XXX.XX.XX)(PORT=1530))))' SCOPE=MEMORY SID='racdb1';

*
 ERROR at line 1:
 ORA-32021: parameter value longer than 255 characters
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521
Name: LISTENER2
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1531
Name: LISTENER3
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1535
Name: LISTENER4
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1529
Name: LISTENER5
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1532
Name: LISTENER6
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1542
Name: LISTENER7
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1530



Other symptoms that can occur: high CPU usage of oraagent crsd

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms