Init parameterNetwork & services

REMOTE_LISTENER

What it controls

Remote listeners the instance also registers with, such as the RAC SCAN listeners.

Know this before you change it

On RAC this is normally the SCAN name and port.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'remote_listener';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'remote_listener' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET remote_listener = 'rac-scan.example.com:1521' SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET remote_listener SCOPE = SPFILE SID = '*';

Related scripts

• Sessions per instance and serviceHow connections are spread across RAC nodes and services. A lopsided spread usually means a service isn't running where you think it is.

Open in the parameter referenceOracle's reference

More in Network & services

• LOCAL_LISTENERThe listener the instance registers its services with.
• SERVICE_NAMESService names the instance registers.
• GLOBAL_NAMESRequires a database link's name to match the remote database's global name.