Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle unauthenticated remote system compromise (#NISR16022003a)
>From Bugtraq:
"NGSSoftware Insight Security Research" <nisr_at_nextgenss.com>
02/17/2003 02:09 PM
To: <bugtraq_at_securityfocus.com> cc: Subject: Oracle unauthenticated remote system compromise (#NISR16022003a)
NGSSoftware Insight Security Research Advisory
Name: Oracle unauthenticated remote system compromise
Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release
1,
8i, 8.1.7, 8.0.6
Severity: Critical Risk
Category: Remote System Buffer Overrun
Vendor URL: http://www.oracle.com
Author: Mark Litchfield (mark_at_ngssoftware.com)
Date: 16th February 2003
Advisory number: #NISR16022003a
Description
Details
C:\ora9ias\BIN>loadpsp -name -user LONGUSERNAME/tiger_at_iasdb myfile
Fix Information
http://otn.oracle.com/deploy/security/pdf/2003alert51.pdf
NGSSoftware advise Oracle database customers to review and install the
patch
as a matter of urgency.
A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite
http://www.ngssoftware.com/software/squirrelfororacle.html
It is further recommend that Oracle DBAs have their network/firewall administrators ensure that the database server is protected from Internet sourced traffic.
Further Information
http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf
About NGSSoftware
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
enquiries_at_ngssoftware.com
"NGSSoftware Insight Security Research" <nisr_at_nextgenss.com>
02/17/2003 02:12 PM
To: <bugtraq_at_securityfocus.com> cc: Subject: Oracle TO_TIMESTAMP_TZ Remote System Buffer Overrun (#NISR16022003b)
NGSSoftware Insight Security Research Advisory
Name: Oracle TO_TIMESTAMP_TZ Remote System Buffer Overrun
Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release
1,
8i, 8.1.7, 8.0.6
Severity: High Risk
Category: Remote System Buffer Overrun
Vendor URL: http://www.oracle.com
Author: Mark Litchfield (mark_at_ngssoftware.com)
Date: 16th February 2003
Advisory number: #NISR16022003b
Description
Details
SELECT TO_TIMESTAMP_TZ('2003-02-016 12:00:00 -8:00','YYYY-MM-DD HH:MI:SS
TZH:TZM') FROM DUAL;
By supplying a long character string for the second parameter an attacker
can overwirte a saved return address on the stack of Oracle process.
Before
this issue can be exploited an attacker must be able to log on to the
database server with a valid user ID and password, but as the
TO_TIMESTAMP_TZ() function can be executed by PUBLIC by default any user
of
the system can gain control. Any arbitrary code supplied by an attacker
would execute with the same privileges as the user running the service;
this
account is typically "Oracle" on linux/unix based platforms and Local
System
on Windows based operating systems such as NT/2000/XP. As such this allows
for a complete compromise of the data stored in the database and possibly
a
complete compromise of the operating system.
Fix Information
http://otn.oracle.com/deploy/security/pdf/2003alert50.pdf
A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite
http://www.ngssoftware.com/software/squirrelfororacle.html
Further Information
http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf
About NGSSoftware
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
enquiries_at_ngssoftware.com
"NGSSoftware Insight Security Research" <nisr_at_nextgenss.com>
02/17/2003 02:17 PM
To: <bugtraq_at_securityfocus.com> cc: Subject: Oracle9i Application Server Format String Vulnerability (#NISR16022003d)
NGSSoftware Insight Security Research Advisory
Name: Oracle9i Application Server Format String Vulnerability
Systems Affected: All platforms; Oracle9i Application Server Release
9.0.2
Severity: Critical Risk
Category: Format String Vulnerability
Vendor URL: http://www.oracle.com
Author: David Litchfield (david_at_ngssoftware) and Mark Litchfield
(mark_at_ngssoftware.com)
Date: 16th February 2003
Advisory number: #NISR16022003d
Description
Details
>From mod_dav.c revision 1.157
..
..
lookup = dav_lookup_uri(dest, r);
if (lookup.rnew == NULL)
{
if (lookup.err.status == HTTP_BAD_REQUEST) { ap_log_rerror(APLOG_MARK, APLOG_ERR | APLOG_NOERRNO, r,lookup.err.desc); return HTTP_BAD_REQUEST; } return dav_error_response(r, lookup.err.status, lookup.err.desc);}
This code calls the dav_lookup_uri() function in dav_util.c. From
dav_util.c
revision 1.84
..
dav_lookup_result dav_lookup_uri(const char *uri, request_rec * r)
{
..
..
if (strcasecmp(comp.scheme, scheme) != 0 || comp.port != port)
{
result.err.status = HTTP_BAD_GATEWAY; result.err.desc = ap_psprintf(r->pool, "Destination URI refers to different " "scheme or port (%s://hostname:%d)\n" "(want: %s://hostname:%d)", comp.scheme ? comp.scheme : scheme, comp.port ? comp.port : port, scheme, port); return result;
..
..
}
When dav_lookup_uri() returns to mod_dav.c the format strings occurs
..
lookup = dav_lookup_uri(dest, r);
if (lookup.rnew == NULL)
{
if (lookup.err.status == HTTP_BAD_REQUEST) { // THIS IS THE FIRST FORMAT STRING VULNERABILITY ap_log_rerror(APLOG_MARK, APLOG_ERR | APLOG_NOERRNO,r,lookup.err.desc);
Of course the code should have read
ap_log_rerror(APLOG_MARK, APLOG_ERR | APLOG_NOERRNO, r,"%s",lookup.err.desc);
to not be vulnerable.
By crafting a specially formed format string and sending to the server an
attacker can overwrite arbitrary address with arbitrary values which can
allow an attacker to gain control of the web server. To do this they could
overwrite a saved return address on the stack, an exception handler or
pointer to a function with an address that points to a buffer that
contains
the arbitrary code to execute.
Fix Information
http://otn.oracle.com/deploy/security/pdf/2003alert52.pdf
A check for these issues has been added to OraScan, a comprehensive automated vulnerability assessment tool for Oracle Application Servers of which more information is available from the NGSSite
http://www.nextgenss.com/software/orascan.html
About NGSSoftware
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
enquiries_at_ngssoftware.com
"NGSSoftware Insight Security Research" <nisr_at_nextgenss.com>
02/17/2003 02:15 PM
To: <bugtraq_at_securityfocus.com> cc: Subject: Oracle TZ_OFFSET Remote System Buffer Overrun (#NISR16022003c)
NGSSoftware Insight Security Research Advisory
Name: Oracle TZ_OFFSET Remote System Buffer Overrun
Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release
1,
8i, 8.1.7, 8.0.6
Severity: High Risk
Category: Remote System Buffer Overrun
Vendor URL: http://www.oracle.com
Author: Mark Litchfield (mark_at_ngssoftware.com)
Date: 16th February 2003
Advisory number: #NISR16022003c
Description
SELECT TZ_OFFSET('US/Eastern') FROM DUAL;
would return the time zone offset value of -04:00. The TZ_OFFSET()
function
contains a remotely exploitable buffer overflow vulnerability.
Details
Fix Information
http://otn.oracle.com/deploy/security/pdf/2003alert50.pdf
A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite
http://www.ngssoftware.com/software/squirrelfororacle.html
Further Information
http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf
About NGSSoftware
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
enquiries_at_ngssoftware.com
"NGSSoftware Insight Security Research" <nisr_at_nextgenss.com>
02/17/2003 05:09 PM
To: <bugtraq_at_securityfocus.com>, <vulnwatch_at_vulnwatch.org>, <ntbugtraq_at_listserv.ntbugtraq.com>
cc: Subject: Oracle bfilename function buffer overflow vulnerability (#NISR16022003e)
NGSSoftware Insight Security Research Advisory
Name: ORACLE bfilename function buffer overflow vulnerability
Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release
1,
8i, 8.1.7, 8.0.6
Severity: High Risk
Category: Remote System Buffer Overrun
Vendor URL: http://www.oracle.com
Author: David Litchfield (david_at_ngssoftware.com)
Date: 16th February 2003
Advisory number: #NISR16022003e
Description
Details
Fix Information
http://otn.oracle.com/deploy/security/pdf/2003alert50.pdf
A check for these issues has been added to NGSSQuirreL for Oracle, a comprehensive automated vulnerability assessment tool for Oracle Database Servers of which more information is available from the NGSSite
http://www.ngssoftware.com/software/squirrelfororacle.html
Further Information
http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf http://www.ngssoftware.com/papers/ntbufferoverflow.html http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf http://www.ngssoftware.com/papers/unicodebo.pdf
About NGSSoftware
http://www.ngssoftware.com/
http://www.ngsconsulting.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
enquiries_at_ngssoftware.com
Muhammad Faisal Rauf Danka <mfrd_at_priorityzero.com>
02/20/2003 12:59 AM
Please respond to mfrd
To: bugtraq_at_securityfocus.com cc: Subject: Fwd: CERT Advisory CA-2003-05 Multiple Vulnerabilities in Oracle Servers
Subscribe for your Free URGENT @priorityzero.com E-mail
click the link below
http://priorityzero.mail.everyone.net
-----BEGIN PGP SIGNED MESSAGE----- CERT Advisory CA-2003-05 Multiple Vulnerabilities in Oracle Servers
Original release date: February 19, 2003
Last revised: --
Source: CERT/CC
A complete revision history can be found at the end of this file.
Systems Affected
Overview
Multiple vulnerabilities exist in Oracle software that may lead to execution of arbitrary code; the ability to read, modify, or delete information stored in underlying Oracle databases; or denial of service. All of these vulnerabilites were discovered by Next Generation Security Software Ltd.
I. Description
Multiple vulnerabilities exist in Oracle9i Application Server, Oracle9i Database, and Oracle8i Database. The majority of these vulnerabilities are buffer overflows.
Oracle has published Security Alerts describing these vulnerabilities. If you use Oracle products listed in the "Systems Affected" section of this document, we strongly encourage you to review the following Oracle Security Alerts and apply patches as appropriate:
NGSSoftware Insight Security Research Advisories describing these issues are listed below:
The CERT/CC has published vulnerability notes for each of these issues as well. The vulnerability in Oracle's mod_dav module (VU#849993) has been as assigned CVE ID CAN-2002-0842.
II. Impact
Depending on the vulnerability being exploited, an attacker may be able to execute arbitrary code; read, modify, or delete information stored in underlying Oracle databases; or cause a denial of service. The vulnerabilities in "ORACLE.EXE" (VU#953746) and the WebDAV modules (VU#849993, VU#511194) may be exploited prior to authentication.
III. Solution
Apply a patch
Solutions for specific vulnerabilities can be found in the above referenced Oracle Security Alerts, NGSSoftware Insight Security Research Advisories, and individual CERT/CC Vulnerability Notes.
Mitigation Strategies
Until a patch can be applied, the CERT/CC recommends that vulnerable sites
Appendix A. Vendor Information
This appendix contains information provided by vendors. When vendors report new information, this section is updated and the changes are noted in the revision history. If a vendor is not listed below, we have not received their comments.
Oracle Corporation
Please see the following Oracle Security Alerts:
Appendix B. References
The CERT/CC acknowledges both Next Generation Security Software Ltd. and Oracle for providing information upon which this document is based.
Feedback can be directed to the author: Ian A. Finlay.
This document is available from:
http://www.cert.org/advisories/CA-2003-04.html
CERT/CC Contact Information
Email: cert_at_cert.org
Phone: +1 412-268-7090 (24-hour hotline) Fax: +1 412-268-6989 Postal address: CERT Coordination Center Software Engineering Institute Carnegie Mellon University Pittsburgh PA 15213-3890 U.S.A.
CERT/CC personnel answer the hotline 08:00-17:00 EST(GMT-5) / EDT(GMT-4) Monday through Friday; they are on call for emergencies during other hours, on U.S. holidays, and on weekends.
Using encryption
We strongly urge you to encrypt sensitive information sent by email.
Our public PGP key is available from
http://www.cert.org/CERT_PGP.key
If you prefer to use DES, please call the CERT hotline for more information.
Getting security information
CERT publications and other security information are available from
our web site
http://www.cert.org/
To subscribe to the CERT mailing list for advisories and bulletins, send email to majordomo_at_cert.org. Please include in the body of your message
subscribe cert-advisory
NO WARRANTY
Any material furnished by Carnegie Mellon University and the Software
Engineering Institute is furnished on an "as is" basis. Carnegie
Mellon University makes no warranties of any kind, either expressed or
implied as to any matter including, but not limited to, warranty of
fitness for a particular purpose or merchantability, exclusivity or
results obtained from use of the material. Carnegie Mellon University
does not make any warranty of any kind with respect to freedom from
patent, trademark, or copyright infringement.
Conditions for use, disclaimers, and sponsorship information
Copyright 2003 Carnegie Mellon University.
Revision History
February 19, 2003: Initial release
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQCVAwUBPlPkcmjtSoHZUTs5AQGFkAQAmTTDL3Tyn818VW59c0Ec5Tt+N78TKs8y
h6Mnp4gkZuFLaPXju8zw1oNat4HoR7JWefBo7Lj6QFMf9HANlg7NexYmmQZSupL/
TZrFF6Nisfg/jQ7H6hPH/kajm/siJO6BuPgQIyEWtHkrJ6ce4jgcPGmuJsLzuUW3
N4QKY3gFD2A=
=nkbt
-----END PGP SIGNATURE-----
Peter Conrad <conrad_at_tivano.de>
03/31/2003 12:48 AM
To: bugtraq_at_securityfocus.com cc: Subject: Oracle JDBC: Inconsistent handling of timestamps
Product: Oracle database 8.1.7 & JDBC "thin" driver 8.1.7.1 Issue: Inconsistent handling of timestamps Impact: Minor (as a security issue, what comes to mind is bad timestamps
when logging to an Oracle DB) Could be a major problem for any application relying on certain timestamp properties, though.
(see http://www.oracle.com/forums/message.jsp?id=1422122&gid=390686 ) Sent email to secalert_us_at_oracle.com on December 3rd - vendor acknowledged receipt on Dec 4 Requested status from secalert_us_at_oracle.com on Feb 18 and Mar 17 - no response so far
Description:
Certain java.sql.Timestamp values aren't written to (or retrieved from)
the database correctly. Timestamps affected are in the time interval just
before switchover from DST to non-DST (the bug was noticed on
October 27th 2002 for the first time, when the switchover from MET/DST to
MET
took place). Various timestamp values in the range
2:00 AM - 2:59:59 AM (MET/DST) on October 27th 2002 as well as on October
26th 2003 have been verified to reproduce the bug, with the database as
well as the JDBC client running in MET.
What happens is this:
Example code:
The following code snippet can be used to reproduce the bug in the MET timezone. The "problem" timestamp probably has to be adjusted for other timezones.
Connection c = DriverManager.getConnection(DB_URL, DB_USER, DB_PWD);
PreparedStatement p = c.prepareStatement("CREATE TABLE BugTest (ts
DATE NOT NULL)");
p.execute();
p.close();
Timestamp problem = new Timestamp(1067130000000L); // 26.10.03 02:00 MET/DST p = c.prepareStatement("INSERT INTO BugTest (ts) VALUES (?)");
p.setTimestamp(1, problem); p.execute(); p.close();
p = c.prepareStatement("SELECT * FROM BugTest WHERE ts = ?");
p.setTimestamp(1, problem);
ResultSet rs = p.executeQuery();
if (rs.next()) {
Timestamp ts = rs.getTimestamp(1); if (ts.equals(problem)) { System.out.println("Everything's OK"); } else { System.out.println("Gotcha! DB returns " + ts.getTime() + " but we gave it " + problem.getTime() + "!"); }
p.execute(); p.close(); c.close(); -- Peter Conrad Tel: +49 6102 / 80 99 072 [ t]ivano Software GmbH Fax: +49 6102 / 80 99 071Bahnhofstr. 18
Germany
"Peter J. Holzer" <hjp_at_wsr.ac.at>
04/02/2003 01:17 AM
To: bugtraq_at_securityfocus.com cc: Subject: Re: Oracle JDBC: Inconsistent handling of timestamps
On 2003-03-31 10:48:05 +0200, Peter Conrad wrote:
> Certain java.sql.Timestamp values aren't written to (or retrieved from)
> the database correctly. Timestamps affected are in the time interval
just
> before switchover from DST to non-DST (the bug was noticed on
> October 27th 2002 for the first time, when the switchover from MET/DST
to MET
> took place). Various timestamp values in the range
> 2:00 AM - 2:59:59 AM (MET/DST) on October 27th 2002 as well as on
October
> 26th 2003 have been verified to reproduce the bug, with the database as
> well as the JDBC client running in MET.
[...]
> Timestamp problem = new Timestamp(1067130000000L); // 26.10.03 02:00
MET/DST
That's a general problem with daylight savings time. On the switch from
DST to standard time, one hour (02:00:00 .. 03:00:00 in the case of MET)
occurs twice. If a timestamp is stored in the local timezone but without
timezone information, this information is ambiguous.
This is not Oracle-specific but would happen with any database which stores timestamps in "human readable" form without timezone information.
If you need to store unambiguous timestamps, use UTC or a numeric
"units since the epoch" format (like POSIX time_t or Java millis).
What's nasty about your sample code is that you specify the timestamp in Java millis, but it isn't stored that way. It is easy for a programmer to forget about the type conversion and possible loss of information.
hp -- _ | Peter J. Holzer | Unser Universum wäre betrüblich |_|_) | Sysadmin WSR / LUGA | unbedeutend, hätte es nicht jeder | | | hjp_at_wsr.ac.at | Generation neue Probleme bereit. __/ | http://www.hjp.at/ | -- Seneca, naturales quaestiones
"Integrigy Security Alerts" <alerts_at_integrigy.com>
04/10/2003 08:33 PM
To: <bugtraq_at_securityfocus.com> cc: Subject: Integrigy Security Advisory - Oracle Applications FNDFS Vulnerability
Integrigy Security Advisory
Oracle E-Business Suite FNDFS Vulnerability April 10, 2003
Summary:
The Oracle Applications FNDFS program, used to retrieve report output from the Concurrent Manager server, can be used to remotely retrieve any file from the server without operating system or application authentication. A mandatory patch from Oracle is required to solve this security issue.
Product: Oracle E-Business Suite
Versions: 10.7, 11.0 and 11.5.1 - 11.5.8
Platforms: All platforms
Risk Level: High
Description:
There exists a weakness in the communications protocol used by the Oracle
Applications FND File Server (FNDFS) program, also referred to as the
Report
Review Agent (RRA), that may allow an attacker to retrieve any file from
Oracle Applications Concurrent Manager servers bypassing operating system,
database, and application authentication. The Concurrent Manager server
is
usually also the database server in most implementations. The FNDFS
program
is used by the Report Viewer (FNDWRR.exe) and ADI Request Center to
retrieve
reports and logs from the Concurrent Manager server.
An attacker can exploit this vulnerability to retrieve sensitive data or
files containing critical passwords from the server. Any file accessible
by
the oracle or applmgr accounts can be retrieved. Direct access to the
Concurrent Manager server via SQL*Net is required.
Solution:
Oracle has released patches for Oracle Applications 11.0 and 11i to
correct
this vulnerability. Oracle has implemented a new security layer in the
communications protocol used by the FNDFS program.
The following Oracle patches must be applied to all servers --
Version Patch ------- ----- 11.0 2782950 (All Releases) 11i 2782945 (11.5.1 - 11.5.8)
Application Desktop Integrator (ADI) users must also apply patch 2778660
to
allow ADI clients to connect to the new FNDFS program.
Appropriate testing and backups should be performed before applying any patches.
All firewalls should block or filter the SQL*Net protocol, not permitting
any SQL*Net access to the Concurrent Manager or database servers from the
Internet or unsecured networks. Please note that the FNDFS program does
not
run on the standard Oracle SQL*Net port 1521, thus multiple SQL*Net ports
must be blocked or filtered.
Security for the FNDFS TNS Listener should be evaluated and include a
password on the listener and connection limitations to only allow the
application servers access to the listener. Customers running ADI may not
be able to limit access to the listener, since ADI's Request Center
requires
direct access to the listener from the client. Additional information on
security for Oracle TNS listeners can be found at:
http://www.integrigy.com/info/Integrigy_OracleDB_Listener_Security.pdf
Additional Information:
http://www.integrigy.com/resources.htm http://otn.oracle.com/deploy/security/pdf/2003alert53.pdf
For more information or questions regarding this security alert, please contact us at alerts_at_integrigy.com.
Credit:
This vulnerability was discovered by Stephen Kost of Integrigy
Corporation.
Integrigy is a member of the Oracle PartnerNetwork.
About Integrigy Corporation (www.integrigy.com)
Integrigy Corporation is a leader in application security for large
enterprise, mission critical applications. Our application vulnerability
assessment tool, AppSentry, assists companies in securing their largest
and
most important applications. Integrigy Consulting offers security
assessment
services for leading ERP and CRM applications.
For more information, visit www.integrigy.com.
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.
This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.
--=_mixed 000A892D88256D0D_=--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Apr 18 2003 - 21:56:40 CDT
- application/octet-stream attachment: attl9dg4.dat
![]() |
![]() |