Init parameterNetwork & services
GLOBAL_NAMES
What it controls
Requires a database link's name to match the remote database's global name.
Know this before you change it
Turning it on can break existing links whose names don't match.
Default: FALSE
Check and change it
1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'global_names';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'global_names' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET global_names = FALSE SCOPE = BOTH SID = '*';11 12-- Or for your own session only13ALTER SESSION SET global_names = FALSE;14 15-- Remove it from the spfile to go back to the default at the next restart16ALTER SYSTEM RESET global_names SCOPE = SPFILE SID = '*';Open in the parameter referenceOracle's reference
More in Network & services
- LOCAL_LISTENERThe listener the instance registers its services with.
- REMOTE_LISTENERRemote listeners the instance also registers with, such as the RAC SCAN listeners.
- SERVICE_NAMESService names the instance registers.