Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Strange ORA-12545 message
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
![]() |
![]() |