Re: Strange ORA-12545 message

durang wrote:
>
> 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
>

That indicates HOST=something.edu does not exist (at least, from within your cgi environment)

> 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 ?
>

That is weird - all the Oracle environment variables know within cgi? oracle_home, oracle_sid and tns_admin jump to mind as being the most important.
Regard cgi as a (sub-)shell - you must provide all the variables, used by Oracle

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...