Strange ORA-12545 message

From: durang <durang_at_ureach.com>
Date: 9 Feb 2006 16:27:28 -0800
Message-ID: <1139531248.163597.248800@g44g2000cwa.googlegroups.com>

I'm trying to run SQLPLUS from within a Tomcat CGI script. I have had no trouble running this same script on Apache and IIS web servers but in this case I've been told to use Tomcat as a Standalone server. (OS is Win2003 Enterprise Ed. ; DB is 9i)

It looks like Tomcat has no path information available (not even to find the SQLPLUS executable) so after failing with the usual "user/pass_at_host" format I tried this:

d:\oracle\ora92\bin\SQLPLUS
testxxx/passxxx@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=something.edu)(PORT=1521)))(CONNECT_DATA=(SID=OURDATA)))

That works fine when I run it from a command line logged in as myself - OR logged in as the account Tomcat is running under.

But when I run it from the Tomcat CGI script I get:

ORA-12545: Connect failed because target host or object does not exist

If I change the host name to its IP address I get:

ORA-12560: TNS:protocol adapter error

Anybody have any ideas on this one ? Received on Thu Feb 09 2006 - 18:27:28 CST