Rotate your device back to portrait to use STIG Vault.

Home
Dashboard
Search
STIG Repository
STIG Compare
SCAP Repository
SCAP Compare
CCIs
Guides
Contact

Appearance

Palette

Oracle Database 11g Instance STIG

The Oracle Database 11g Instance STIG (V9 R1) has 94 STIG checks. New to STIG checklists? Read What is a STIG checklist?, CKL vs CKLB, and STIG vs SCAP benchmark.

Find STIG checks

94STIG checks

Search filters this STIG's checks locally. Separate terms must all match (use quotes for an exact phrase). A search you ran on the Search page carries over here.

Severity

Version

V9 · R1

CurrentPublished Wed Oct 27 2021

The Oracle RESOURCE_LIMIT parameter should be set to TRUE.

Oracle Database 11g Instance STIG

Assessment Title

Rule Text

Description

Discussion Text

The Oracle RESOURCE_LIMIT parameter determines whether resource limits are enforced in database profiles. If Oracle resource limits are disabled, any defined profile limits will be ignored.

NOTE: This does not apply to password resources.

New to STIG checklists? Read What is a STIG checklist? and CKL vs CKLB.

Objective

V-2593

Rule

SV-24942r2_rule

Severity

medium

Rule Version

DO3696-ORACLE11

Documentable

false

IA Controls

NIST SP 800-53

Rev 5

Assessment Procedure

Check Text

From SQL*Plus:

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

If the value returned is not set to TRUE, this is a Finding.

Implementation Procedure

Fix Text

Enable resource limit checking on the database.

From SQL*Plus:

  alter system set resource_limit = TRUE scope = both;

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

STIG check 70 of 94 in the Oracle Database 11g Instance STIG checklist

← Previous · V-2589Object permissions granted to PUBLIC should be restricted.Next · V-3437 →Application role permissions should not be assigned to the Oracle PUBLIC role.