← Back to Oracle Database 12c Security Technical Implementation Guide

V-219872

CAT II (Medium)

Remote database or other external access must use fully-qualified names.

Rule ID

SV-219872r879887_rule

STIG

Oracle Database 12c Security Technical Implementation Guide

Version

V2R9

CCIs

CCI-000366

Discussion

The Oracle GLOBAL_NAMES parameter is used to set the requirement for database link names to be the same name as the remote database whose connection they define. By using the same name for both, ambiguity is avoided and unauthorized or unintended connections to remote databases are less likely.

Check Content

From SQL*Plus:

  select value from v$parameter where name = 'global_names';

If the value returned is FALSE, this is a finding.

Fix Text

From SQL*Plus:

  alter system set global_names = TRUE scope = spfile;

Note: This parameter, if changed, will affect all currently defined Oracle database links.

The above SQL*Plus command will set the parameter to take effect at next system startup.