Home page logo

pen-test logo Penetration Testing mailing list archives

Re: Oracle TNS Listener
From: Pete Finnigan <plsql () peterfinnigan demon co uk>
Date: Mon, 5 Sep 2005 20:13:03 +0100


Try checking the listener.ora file for a SID_LIST_LISTENER section, you
have only shown the ADDRESS_LIST section. Do you have both sections in
your listener.ora file, you need both sections. 

The fact that you have sent a service name to the listener probably
means that you have a tnsnames.ora file with that service name in it.
You need the two files (listener.ora on the server and tnsname.ora on
the client) to have matching sections. 

Try using the TNSPING utility first to check the TNS connection first.
This is like ping but for Oracle. The TNS-????? numbers are Oracle error
numbers and are well documented - check with http://tahiti.oracle.com -
The Oracle documentation site both for the error and also how to
configure TNS.

Also try setting the ORACLE_SID, TNS_ADMIN, ORACLE_HOME and PATH to
point at the right directories on the client.


kind regards

Pete Finnigan (email:pete () petefinnigan com)
Oracle Security Web Site: http://www.petefinnigan.com
Oracle Security Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Audit your website security with Acunetix Web Vulnerability Scanner: 

Hackers are concentrating their efforts on attacking applications on your 
website. Up to 75% of cyber attacks are launched on shopping carts, forms, 
login pages, dynamic content etc. Firewalls, SSL and locked-down servers are 
futile against web application hacking. Check your website for vulnerabilities 
to SQL injection, Cross site scripting and other web attacks before hackers do! 
Download Trial at:


  By Date           By Thread  

Current thread:
[ Nmap | Sec Tools | Mailing Lists | Site News | About/Contact | Advertising | Privacy ]