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 20, 2023

Applies to:

Symptoms

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

• oraagent log

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

• sqlplus output

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

• output of "srvctl config listener"

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

Changes

Cause

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