Oracle iSQLPlus SID Check - Metasploit
This page contains detailed information about how to use the auxiliary/scanner/oracle/isqlplus_sidbrute metasploit module. For list of all metasploit modules, visit the Metasploit Module Library.
Module Overview
Name: Oracle iSQLPlus SID Check
Module: auxiliary/scanner/oracle/isqlplus_sidbrute
Source code: modules/auxiliary/scanner/oracle/isqlplus_sidbrute.rb
Disclosure date: -
Last modification time: 2017-07-24 06:26:21 +0000
Supported architecture(s): -
Supported platform(s): -
Target service / protocol: http, https
Target network port(s): 80, 443, 3000, 5560, 8000, 8008, 8080, 8443, 8880, 8888
List of CVEs: -
This module attempts to bruteforce the SID on the Oracle application server iSQL*Plus login pages. It does this by testing Oracle error responses returned in the HTTP response. Incorrect username/pass with a correct SID will produce an Oracle ORA-01017 error. Works against Oracle 9.2, 10.1 & 10.2 iSQL*Plus. This module will attempt to fingerprint the version and automatically select the correct POST request.
Module Ranking and Traits
Module Ranking:
- normal: The exploit is otherwise reliable, but depends on a specific version and can't (or doesn't) reliably autodetect. More information about ranking can be found here.
Basic Usage
This module is a scanner module, and is capable of testing against multiple hosts.
msf > use auxiliary/scanner/oracle/isqlplus_sidbrute
msf auxiliary(isqlplus_sidbrute) > show options
... show and set options ...
msf auxiliary(isqlplus_sidbrute) > set RHOSTS ip-range
msf auxiliary(isqlplus_sidbrute) > exploit
Other examples of setting the RHOSTS option:
Example 1:
msf auxiliary(isqlplus_sidbrute) > set RHOSTS 192.168.1.3-192.168.1.200
Example 2:
msf auxiliary(isqlplus_sidbrute) > set RHOSTS 192.168.1.1/24
Example 3:
msf auxiliary(isqlplus_sidbrute) > set RHOSTS file:/tmp/ip_list.txt
Go back to menu.
Msfconsole Usage
Here is how the scanner/oracle/isqlplus_sidbrute auxiliary module looks in the msfconsole:
msf6 > use auxiliary/scanner/oracle/isqlplus_sidbrute
msf6 auxiliary(scanner/oracle/isqlplus_sidbrute) > show info
Name: Oracle iSQLPlus SID Check
Module: auxiliary/scanner/oracle/isqlplus_sidbrute
License: Metasploit Framework License (BSD)
Rank: Normal
Provided by:
CG <[email protected]>
todb <[email protected]>
Check supported:
No
Basic options:
Name Current Setting Required Description
---- --------------- -------- -----------
DB_ALL_CREDS false no Try each user/password couple stored in the current database
DB_ALL_PASS false no Add all passwords in the current database to the list
DB_ALL_USERS false no Add all users in the current database to the list
Proxies no A proxy chain of format type:host:port[,type:host:port][...]
RPORT 5560 yes The target port (TCP)
SID no A single SID to test
SIDFILE /opt/metasploit-framework/embedded/framework/data/wordlists/sid.txt no A file containing a list of SIDs
SSL false no Negotiate SSL/TLS for outgoing connections
STOP_ON_SUCCESS false yes Stop guessing when a credential works for a host
THREADS 1 yes The number of concurrent threads (max one per host)
TIMEOUT 30 no Time to wait for HTTP responses
URI /isqlplus/ yes Oracle iSQLPlus path
VERBOSE true yes Whether to print output for all attempts
VHOST no HTTP server virtual host
Description:
This module attempts to bruteforce the SID on the Oracle application
server iSQL*Plus login pages. It does this by testing Oracle error
responses returned in the HTTP response. Incorrect username/pass
with a correct SID will produce an Oracle ORA-01017 error. Works
against Oracle 9.2, 10.1 & 10.2 iSQL*Plus. This module will attempt
to fingerprint the version and automatically select the correct POST
request.
References:
http://carnal0wnage.attackresearch.com
Module Options
This is a complete list of options available in the scanner/oracle/isqlplus_sidbrute auxiliary module:
msf6 auxiliary(scanner/oracle/isqlplus_sidbrute) > show options
Module options (auxiliary/scanner/oracle/isqlplus_sidbrute):
Name Current Setting Required Description
---- --------------- -------- -----------
DB_ALL_CREDS false no Try each user/password couple stored in the current database
DB_ALL_PASS false no Add all passwords in the current database to the list
DB_ALL_USERS false no Add all users in the current database to the list
Proxies no A proxy chain of format type:host:port[,type:host:port][...]
RPORT 5560 yes The target port (TCP)
SID no A single SID to test
SIDFILE /opt/metasploit-framework/embedded/framework/data/wordlists/sid.txt no A file containing a list of SIDs
SSL false no Negotiate SSL/TLS for outgoing connections
STOP_ON_SUCCESS false yes Stop guessing when a credential works for a host
THREADS 1 yes The number of concurrent threads (max one per host)
TIMEOUT 30 no Time to wait for HTTP responses
URI /isqlplus/ yes Oracle iSQLPlus path
VERBOSE true yes Whether to print output for all attempts
VHOST no HTTP server virtual host
Advanced Options
Here is a complete list of advanced options supported by the scanner/oracle/isqlplus_sidbrute auxiliary module:
msf6 auxiliary(scanner/oracle/isqlplus_sidbrute) > show advanced
Module advanced options (auxiliary/scanner/oracle/isqlplus_sidbrute):
Name Current Setting Required Description
---- --------------- -------- -----------
DOMAIN WORKSTATION yes The domain to use for Windows authentication
DigestAuthIIS true no Conform to IIS, should work for most servers. Only set to false for non-IIS servers
FingerprintCheck true no Conduct a pre-exploit fingerprint verification
HttpClientTimeout no HTTP connection and receive timeout
HttpPassword no The HTTP password to specify for authentication
HttpRawHeaders no Path to ERB-templatized raw headers to append to existing headers
HttpTrace false no Show the raw HTTP requests and responses
HttpTraceColors red/blu no HTTP request and response colors for HttpTrace (unset to disable)
HttpTraceHeadersOnly false no Show HTTP headers only in HttpTrace
HttpUsername no The HTTP username to specify for authentication
MaxGuessesPerService 0 no Maximum number of credentials to try per service instance. If set to zero or a non-number, this option will not be used.
MaxGuessesPerUser 0 no Maximum guesses for a particular username for the service instance. Note that users are considered unique among different services, so a user at 10.1.1.1:22
is different from one at 10.2.2.2:22, and both will be tried up to the MaxGuessesPerUser limit. If set to zero or a non-number, this option will not be use
d.
MaxMinutesPerService 0 no Maximum time in minutes to bruteforce the service instance. If set to zero or a non-number, this option will not be used.
PASSWORD_SPRAY false yes Reverse the credential pairing order. For each password, attempt every possible user.
REMOVE_USERPASS_FILE false yes Automatically delete the USERPASS_FILE on module completion
SSLVersion Auto yes Specify the version of SSL/TLS to be used (Auto, TLS and SSL23 are auto-negotiate) (Accepted: Auto, TLS, SSL23, SSL3, TLS1, TLS1.1, TLS1.2)
ShowProgress true yes Display progress messages during a scan
ShowProgressPercent 10 yes The interval in percent that progress should be shown
TRANSITION_DELAY 0 no Amount of time (in minutes) to delay before transitioning to the next user in the array (or password when PASSWORD_SPRAY=true)
UserAgent Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) no The User-Agent header to use for all requests
WORKSPACE no Specify the workspace for this module
Auxiliary Actions
This is a list of all auxiliary actions that the scanner/oracle/isqlplus_sidbrute module can do:
msf6 auxiliary(scanner/oracle/isqlplus_sidbrute) > show actions
Auxiliary actions:
Name Description
---- -----------
Evasion Options
Here is the full list of possible evasion options supported by the scanner/oracle/isqlplus_sidbrute auxiliary module in order to evade defenses (e.g. Antivirus, EDR, Firewall, NIDS etc.):
msf6 auxiliary(scanner/oracle/isqlplus_sidbrute) > show evasion
Module evasion options:
Name Current Setting Required Description
---- --------------- -------- -----------
HTTP::header_folding false no Enable folding of HTTP headers
HTTP::method_random_case false no Use random casing for the HTTP method
HTTP::method_random_invalid false no Use a random invalid, HTTP method for request
HTTP::method_random_valid false no Use a random, but valid, HTTP method for request
HTTP::pad_fake_headers false no Insert random, fake headers into the HTTP request
HTTP::pad_fake_headers_count 0 no How many fake headers to insert into the HTTP request
HTTP::pad_get_params false no Insert random, fake query string variables into the request
HTTP::pad_get_params_count 16 no How many fake query string variables to insert into the request
HTTP::pad_method_uri_count 1 no How many whitespace characters to use between the method and uri
HTTP::pad_method_uri_type space no What type of whitespace to use between the method and uri (Accepted: space, tab, apache)
HTTP::pad_post_params false no Insert random, fake post variables into the request
HTTP::pad_post_params_count 16 no How many fake post variables to insert into the request
HTTP::pad_uri_version_count 1 no How many whitespace characters to use between the uri and version
HTTP::pad_uri_version_type space no What type of whitespace to use between the uri and version (Accepted: space, tab, apache)
HTTP::uri_dir_fake_relative false no Insert fake relative directories into the uri
HTTP::uri_dir_self_reference false no Insert self-referential directories into the uri
HTTP::uri_encode_mode hex-normal no Enable URI encoding (Accepted: none, hex-normal, hex-noslashes, hex-random, hex-all, u-normal, u-all, u-random)
HTTP::uri_fake_end false no Add a fake end of URI (eg: /%20HTTP/1.0/../../)
HTTP::uri_fake_params_start false no Add a fake start of params to the URI (eg: /%3fa=b/../)
HTTP::uri_full_url false no Use the full URL for all HTTP requests
HTTP::uri_use_backslashes false no Use back slashes instead of forward slashes in the uri
HTTP::version_random_invalid false no Use a random invalid, HTTP version for request
HTTP::version_random_valid false no Use a random, but valid, HTTP version for request
Go back to menu.
Error Messages
This module may fail with the following error messages:
- <MSG> Unknown Oracle version, skipping.
- <MSG> Cannot connect
- <MSG> no response
- <MSG> Received an HTTP 404, check URIPATH
- <MSG> Received an HTTP 302 to <LOCATION>
- <MSG> Received an HTTP <RES.CODE>
- <MSG> Cannot connect
- <MSG> Unknown Oracle version detected.
- <MSG> No response
- <MSG> Incorrect SID: '<SID.STRIP>' (got error code )
- <MSG> Possible correct SID, but got ORA-12541: No Listener error.
- <MSG> Received an unknown error
- Cannot read file '<SID_FILE>'
Check for the possible causes from the code snippets below found in the module source code. This can often times help in identifying the root cause of the problem.
<MSG> Unknown Oracle version, skipping.
Here is a relevant code snippet related to the "<MSG> Unknown Oracle version, skipping." error message:
64: end
65:
66: def run_host(ip)
67: oracle_ver = get_oracle_version(ip)
68: if not check_oracle_version(oracle_ver)
69: print_error "#{msg} Unknown Oracle version, skipping."
70: return
71: end
72: begin
73: print_status("#{msg} Starting SID check")
74: sid_data.each do |sid|
<MSG> Cannot connect
Here is a relevant code snippet related to the "<MSG> Cannot connect" error message:
74: sid_data.each do |sid|
75: guess = check_oracle_sid(ip,oracle_ver,sid)
76: return if guess and datastore['STOP_ON_SUCCESS']
77: end
78: rescue ::Rex::ConnectionRefused, ::Rex::HostUnreachable, ::Rex::ConnectionTimeout => e
79: print_error "#{msg} Cannot connect"
80: rescue ::Timeout::Error, ::Errno::EPIPE,Errno::ECONNRESET => e
81: print_error e.message
82: end
83: end
84:
<MSG> no response
Here is a relevant code snippet related to the "<MSG> no response" error message:
89: 'uri' => uri,
90: 'method' => 'GET',
91: }, timeout)
92: oracle_ver = nil
93: if (res.nil?)
94: print_error("#{msg} no response")
95: elsif (res.code == 200)
96: print_status("#{msg} Received an HTTP #{res.code}")
97: oracle_ver = detect_oracle_version(res)
98: elsif (res.code == 404)
99: print_error("#{msg} Received an HTTP 404, check URIPATH")
<MSG> Received an HTTP 404, check URIPATH
Here is a relevant code snippet related to the "<MSG> Received an HTTP 404, check URIPATH" error message:
94: print_error("#{msg} no response")
95: elsif (res.code == 200)
96: print_status("#{msg} Received an HTTP #{res.code}")
97: oracle_ver = detect_oracle_version(res)
98: elsif (res.code == 404)
99: print_error("#{msg} Received an HTTP 404, check URIPATH")
100: elsif (res.code == 302)
101: print_error("#{msg} Received an HTTP 302 to #{res.headers['Location']}")
102: else
103: print_error("#{msg} Received an HTTP #{res.code}")
104: end
<MSG> Received an HTTP 302 to <LOCATION>
Here is a relevant code snippet related to the "<MSG> Received an HTTP 302 to <LOCATION>" error message:
96: print_status("#{msg} Received an HTTP #{res.code}")
97: oracle_ver = detect_oracle_version(res)
98: elsif (res.code == 404)
99: print_error("#{msg} Received an HTTP 404, check URIPATH")
100: elsif (res.code == 302)
101: print_error("#{msg} Received an HTTP 302 to #{res.headers['Location']}")
102: else
103: print_error("#{msg} Received an HTTP #{res.code}")
104: end
105: return oracle_ver
106: rescue ::Rex::ConnectionRefused, ::Rex::HostUnreachable, ::Rex::ConnectionTimeout => e
<MSG> Received an HTTP <RES.CODE>
Here is a relevant code snippet related to the "<MSG> Received an HTTP <RES.CODE>" error message:
98: elsif (res.code == 404)
99: print_error("#{msg} Received an HTTP 404, check URIPATH")
100: elsif (res.code == 302)
101: print_error("#{msg} Received an HTTP 302 to #{res.headers['Location']}")
102: else
103: print_error("#{msg} Received an HTTP #{res.code}")
104: end
105: return oracle_ver
106: rescue ::Rex::ConnectionRefused, ::Rex::HostUnreachable, ::Rex::ConnectionTimeout => e
107: print_error "#{msg} Cannot connect"
108: end
<MSG> Cannot connect
Here is a relevant code snippet related to the "<MSG> Cannot connect" error message:
102: else
103: print_error("#{msg} Received an HTTP #{res.code}")
104: end
105: return oracle_ver
106: rescue ::Rex::ConnectionRefused, ::Rex::HostUnreachable, ::Rex::ConnectionTimeout => e
107: print_error "#{msg} Cannot connect"
108: end
109: end
110:
111: def detect_oracle_version(res)
112: m = res.body.match(/iSQL\*Plus Release (9\.0|9\.1|9\.2|10\.1|10\.2)/)
<MSG> Unknown Oracle version detected.
Here is a relevant code snippet related to the "<MSG> Unknown Oracle version detected." error message:
115: oracle_ver = m[1].to_f if m[1] && m[1] =~ /9\.[012]/
116: if oracle_ver
117: print_status("#{msg} Detected Oracle version #{oracle_ver}")
118: print_status("#{msg} SID detection for iSQL*Plus 10.1 may be unreliable") if oracle_ver == 10.1
119: else
120: print_error("#{msg} Unknown Oracle version detected.")
121: end
122: return oracle_ver
123: end
124:
125: def check_oracle_version(ver)
<MSG> No response
Here is a relevant code snippet related to the "<MSG> No response" error message:
142: end
143:
144: def parse_isqlplus_response(res,sid)
145: guess = false
146: if (res.nil?)
147: print_error("#{msg} No response")
148: elsif (res.code == 200)
149: if (res.body =~ /ORA-01017:/ or res.body =~ /ORA-28273:/)
150: if sid.nil? || sid.empty?
151: print_good("#{msg} Received ORA-01017 on a blank SID -- SIDs are not enforced upon login.")
152: else
<MSG> Incorrect SID: '<SID.STRIP>' (got error code )
Here is a relevant code snippet related to the "<MSG> Incorrect SID: '<SID.STRIP>' (got error code )" error message:
152: else
153: print_good("#{msg} Received ORA-01017, probable correct SID '#{sid.strip}'")
154: end
155: guess = true
156: elsif (res.body =~ /(ORA-12170):/ or res.body =~ /(ORA-12154):/ or res.body =~ /(ORA-12162):/)
157: vprint_status("#{msg} Incorrect SID: '#{sid.strip}' (got error code #{$1})")
158: elsif res.body =~ /(ORA-12541):/
159: print_status("#{msg} Possible correct SID, but got ORA-12541: No Listener error.")
160: guess = true
161: else
162: print_status("#{msg} Received an unknown error") # Should say what the error was
<MSG> Possible correct SID, but got ORA-12541: No Listener error.
Here is a relevant code snippet related to the "<MSG> Possible correct SID, but got ORA-12541: No Listener error." error message:
154: end
155: guess = true
156: elsif (res.body =~ /(ORA-12170):/ or res.body =~ /(ORA-12154):/ or res.body =~ /(ORA-12162):/)
157: vprint_status("#{msg} Incorrect SID: '#{sid.strip}' (got error code #{$1})")
158: elsif res.body =~ /(ORA-12541):/
159: print_status("#{msg} Possible correct SID, but got ORA-12541: No Listener error.")
160: guess = true
161: else
162: print_status("#{msg} Received an unknown error") # Should say what the error was
163: end
164: elsif (res.code == 404)
<MSG> Received an unknown error
Here is a relevant code snippet related to the "<MSG> Received an unknown error" error message:
157: vprint_status("#{msg} Incorrect SID: '#{sid.strip}' (got error code #{$1})")
158: elsif res.body =~ /(ORA-12541):/
159: print_status("#{msg} Possible correct SID, but got ORA-12541: No Listener error.")
160: guess = true
161: else
162: print_status("#{msg} Received an unknown error") # Should say what the error was
163: end
164: elsif (res.code == 404)
165: print_status("#{msg} Received an HTTP 404, check URIPATH")
166: elsif (res.code == 302)
167: print_status("#{msg} Received an HTTP 302 redirect to #{res.headers['Location']}")
Cannot read file '<SID_FILE>'
Here is a relevant code snippet related to the "Cannot read file '<SID_FILE>'" error message:
199: if datastore['SID'] and not datastore['SID'].empty?
200: [datastore['SID']]
201: elsif sid_file and ::File.readable? sid_file
202: ::File.open(sid_file,"rb") {|f| f.read f.stat.size}.each_line.map {|x| x.strip.upcase}.uniq
203: else
204: raise ArugmentError, "Cannot read file '#{sid_file}'"
205: end
206: end
207:
208: def check_oracle_sid(ip,oracle_ver,sid)
209: post_request = build_post_request(oracle_ver,sid)
Go back to menu.
Related Pull Requests
- #8716 Merged Pull Request: Print_Status -> Print_Good (And OCD bits 'n bobs)
- #8338 Merged Pull Request: Fix msf/core and self.class msftidy warnings
- #6655 Merged Pull Request: use MetasploitModule as a class name
- #6648 Merged Pull Request: Change metasploit class names
- #2525 Merged Pull Request: Change module boilerplate
- #1228 Merged Pull Request: MSFTIDY cleanup #1 - auxiliary
References
See Also
Check also the following modules related to this module:
- auxiliary/scanner/oracle/isqlplus_login
- auxiliary/scanner/oracle/emc_sid
- auxiliary/scanner/oracle/oracle_hashdump
- auxiliary/scanner/oracle/oracle_login
- auxiliary/scanner/oracle/sid_brute
- auxiliary/scanner/oracle/sid_enum
- auxiliary/scanner/oracle/spy_sid
- auxiliary/scanner/oracle/tnslsnr_version
- auxiliary/scanner/oracle/tnspoison_checker
- auxiliary/scanner/oracle/xdb_sid
- auxiliary/scanner/oracle/xdb_sid_brute
- auxiliary/admin/oracle/oracle_index_privesc
- auxiliary/admin/oracle/oracle_login
- auxiliary/admin/oracle/oracle_sql
- auxiliary/admin/oracle/oraenum
- auxiliary/admin/oracle/ora_ntlm_stealer
- auxiliary/admin/oracle/osb_execqr
- auxiliary/admin/oracle/osb_execqr2
- auxiliary/admin/oracle/osb_execqr3
- auxiliary/admin/oracle/post_exploitation/win32exec
- auxiliary/admin/oracle/post_exploitation/win32upload
- auxiliary/admin/oracle/sid_brute
- auxiliary/admin/oracle/tnscmd
- auxiliary/sqli/oracle/dbms_cdc_ipublish
- auxiliary/sqli/oracle/dbms_cdc_publish
- auxiliary/sqli/oracle/dbms_cdc_publish2
- auxiliary/sqli/oracle/dbms_cdc_publish3
- auxiliary/sqli/oracle/dbms_cdc_subscribe_activate_subscription
- auxiliary/sqli/oracle/dbms_export_extension
- auxiliary/sqli/oracle/dbms_metadata_get_granted_xml
- auxiliary/sqli/oracle/dbms_metadata_get_xml
- auxiliary/sqli/oracle/dbms_metadata_open
- auxiliary/sqli/oracle/droptable_trigger
- auxiliary/sqli/oracle/jvm_os_code_10g
- auxiliary/sqli/oracle/jvm_os_code_11g
- auxiliary/sqli/oracle/lt_compressworkspace
- auxiliary/sqli/oracle/lt_findricset_cursor
- auxiliary/sqli/oracle/lt_mergeworkspace
- auxiliary/sqli/oracle/lt_removeworkspace
- auxiliary/sqli/oracle/lt_rollbackworkspace
- exploit/windows/oracle/client_system_analyzer_upload
- exploit/windows/oracle/extjob
- exploit/windows/oracle/osb_ndmp_auth
- exploit/windows/oracle/tns_arguments
- exploit/windows/oracle/tns_auth_sesskey
- exploit/windows/oracle/tns_service_name
Authors
- CG
- todb
Version
This page has been produced using Metasploit Framework version 6.1.24-dev. For more modules, visit the Metasploit Module Library.
Go back to menu.