Init parameterNetwork & services

SERVICE_NAMES

What it controls

Service names the instance registers.

Know this before you change it

Deprecated in newer releases. Create services with srvctl or DBMS_SERVICE, which also handle role-based and RAC placement.

Check and change it

1-- Current value on every instance2SELECT inst_id, name, value, isdefault, ismodified3FROM gv$parameter4WHERE name = 'service_names';5 6-- Value stored in the spfile7SELECT sid, value FROM v$spparameter WHERE name = 'service_names' AND isspecified = 'TRUE';8 9-- Dynamic: takes effect now and is kept after a restart10ALTER SYSTEM SET service_names = 'sales' SCOPE = BOTH SID = '*';11 12-- Remove it from the spfile to go back to the default at the next restart13ALTER SYSTEM RESET service_names 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.
• REMOTE_LISTENERRemote listeners the instance also registers with, such as the RAC SCAN listeners.
• GLOBAL_NAMESRequires a database link's name to match the remote database's global name.