search menu icon-carat-right cmu-wordmark

CERT Coordination Center

Oracle9i Application Server Apache PL/SQL module does not properly decode URL

Vulnerability Note VU#758483

Original Release Date: 2002-01-09 | Last Revised: 2002-03-15


A vulnerability exists in the Apache Procedural Language/Structured Query Language (PL/SQL) module used by Oracle9i Application Server (iAS) in which the module does not properly decode double URL encoded strings. This vulnerability could allow an intruder to read files outside the web server's root directory.


NGSSoftware has released Insight Security Research Advisory #NISR20122001 describing two vulnerabilities in the Apache PL/SQL module used by Oracle9i Application Server (iAS). The second of these vulnerabilities, improper URL decoding, is discussed in this document.

Oracle iAS uses the Apache HTTP Server to provide web services, including access to stored procedures via the Oracle PL/SQL module (modpplsql or mod_plsql). In iAS, PL/SQL is used to communicate with the database and generate HTML that can be interpreted by a web browser. The PL/SQL module also provides the ability to remotely administer the Database Access Descriptors (DAD) and access help pages. While access to the DADs is restricted by username and password, access to the help pages is not and they can be accessed by any user.

According to RFC 1738 and RFC 2396, certain characters must be encoded in order to be used in URLs, and any character may be encoded. This process is called URL encoding. While parsing a URL, the PL/SQL Apache module only performs one decoding pass, and therefore does not properly decode double URL encoded strings. As a result, a crafted HTTP request for a help page containing double URL encoded characters may be decoded in to a representation of ../, allowing access to files outside the root of the web server.

The vulnerable PL/SQL module may also be used by Oracle9i Database and Oracle8i Database.


An unauthenticated remote intruder could read files outside the root of the web server with the privileges of the Apache process. Since the Apache service typically runs with SYSTEM privileges on Windows NT and Windows 2000, an intruder may be able to read any file on the system that can be displayed in a web browser.


Apply Patch
Apply the appropriate patch referenced in Oracle Security Alert #25.

Disable Vulnerable Service

Disable the PL/SQL service (modplsql or mod_plsql in Apache).

Vendor Information


Oracle Affected

Updated:  March 12, 2002



Vendor Statement

Oracle has released Oracle Security Alert #25.

Vendor Information

The vendor has not provided us with any further information regarding this vulnerability.


The CERT/CC has no additional comments at this time.

If you have feedback, comments, or additional information about this vulnerability, please send us email.

CVSS Metrics

Group Score Vector



The CERT/CC thanks NGSSoftware and Oracle for information used in this document.

This document was written by Art Manion.

Other Information

CVE IDs: CVE-2001-1217
Severity Metric: 3.99
Date Public: 2001-12-13
Date First Published: 2002-01-09
Date Last Updated: 2002-03-15 20:23 UTC
Document Revision: 28

Sponsored by CISA.