Init parameterNetwork & services
LOCAL_LISTENER
What it controls
The listener the instance registers its services with.
Know this before you change it
Needed when the listener isn't on port 1521 on the local host. Run ALTER SYSTEM REGISTER after changing it.
Check and change it
1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'local_listener';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'local_listener' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.example.com)(PORT=1522))' SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET local_listener SCOPE = SPFILE SID = '*';Open in the parameter referenceOracle's reference
More in Network & services
- REMOTE_LISTENERRemote listeners the instance also registers with, such as the RAC SCAN listeners.
- SERVICE_NAMESService names the instance registers.
- GLOBAL_NAMESRequires a database link's name to match the remote database's global name.