DG0192-ORACLE11 - Remote database or other external access should use fully-qualified names - 'global_names = true'

Information

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.

Solution

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.

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_Oracle_Database_11g_Y21M10_STIG.zip

Item Details

References: CAT|II, Rule-ID|SV-24838r2_rule, STIG-ID|DG0192-ORACLE11, Vuln-ID|V-15660

Plugin: OracleDB

Control ID: eb78e28e65650ea93f24861bcb45ed90d5ff887a08f119220f832b306d4d5c2c