STIGQter: STIG Summary: Oracle Database 12c Security Technical Implementation Guide Version: 2 Release: 1 Benchmark Date: 23 Apr 2021: STIGQter: STIG Summary: Oracle Database 12c Security Technical Implementation Guide Version: 2 Release: 1 Benchmark Date: 23 Apr 2021:SV-219838r533055_rule
V-219838
SRG-APP-000516-DB-000363
O121-BP-022700
CAT I
10
By default, Oracle Net Listener permits only local administration for security reasons. As a policy, the listener can be administered only by the user who started it. This is enforced through local operating system authentication. For example, if user1 starts the listener, then only user1 can administer it. Any other user trying to administer the listener gets an error. The super user is the only exception.
Remote administration of the listener must not be permitted. If listener administration from a remote system is required, granting secure remote access to the Oracle DBMS server and performing local administration is preferred. Authorize and document this requirement in the System Security Plan.
Note: In Oracle Database 12c Release 1 (12.1), the listener password feature is no longer supported. This does not cause a loss of security because authentication is enforced through local operating system authentication. Refer to Oracle Database Net Services Reference for additional information.
If a listener is not running on the local database host server, this check is not a finding.
Note: This check needs to be done only once per host system and once per listener. Multiple listeners may be defined on a single host system. They must all be reviewed, but only once per database home review.
For subsequent database home reviews on the same host system, this check is not a finding.
Determine all Listeners running on the host.
For Windows hosts, view all Windows services with TNSListener embedded in the service name
- The service name format is:
Oracle[ORACLE_HOME_NAME]TNSListener
For UNIX hosts, the Oracle Listener process will indicate the TNSLSNR executable.
At a command prompt, issue the command:
ps -ef | grep tnslsnr | grep -v grep
The alias for the listener follows tnslsnr in the command output.
Must be logged on the host system using the account that owns the tnslsnr executable (UNIX). If the account is denied local logon, have the system SA assist in this task by adding 'su' to the listener account from the root account. On Windows platforms, log on using an account with administrator privileges to complete the check.
From a system command prompt, execute the listener control utility:
lsnrctl status [LISTENER NAME]
Review the results for the value of Security.
If "Security = OFF" is displayed, this is a finding.
If "Security = ON: Local OS Authentication" is displayed, this is not a finding.
If "Security = ON: Password or Local OS Authentication", this is a finding (do not set a password on Oracle versions 10.1 and higher. Instead, use Local OS Authentication).
Repeat the execution of the lsnrctl utility for all active listeners.
V-219838
False
O121-BP-022700
If a listener is not running on the local database host server, this check is not a finding.
Note: This check needs to be done only once per host system and once per listener. Multiple listeners may be defined on a single host system. They must all be reviewed, but only once per database home review.
For subsequent database home reviews on the same host system, this check is not a finding.
Determine all Listeners running on the host.
For Windows hosts, view all Windows services with TNSListener embedded in the service name
- The service name format is:
Oracle[ORACLE_HOME_NAME]TNSListener
For UNIX hosts, the Oracle Listener process will indicate the TNSLSNR executable.
At a command prompt, issue the command:
ps -ef | grep tnslsnr | grep -v grep
The alias for the listener follows tnslsnr in the command output.
Must be logged on the host system using the account that owns the tnslsnr executable (UNIX). If the account is denied local logon, have the system SA assist in this task by adding 'su' to the listener account from the root account. On Windows platforms, log on using an account with administrator privileges to complete the check.
From a system command prompt, execute the listener control utility:
lsnrctl status [LISTENER NAME]
Review the results for the value of Security.
If "Security = OFF" is displayed, this is a finding.
If "Security = ON: Local OS Authentication" is displayed, this is not a finding.
If "Security = ON: Password or Local OS Authentication", this is a finding (do not set a password on Oracle versions 10.1 and higher. Instead, use Local OS Authentication).
Repeat the execution of the lsnrctl utility for all active listeners.
M
4059