From: Pete Finnigan (plsql@peterfinnigan.demon.co.uk)
Date: Mon Sep 05 2005 - 15:13:03 EDT
Hi,
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.
hth
kind regards
Pete
-- 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: http://www.securityfocus.com/sponsor/pen-test_050831 -------------------------------------------------------------------------------
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:54:49 EDT