Network Adapter could not establish the connection

[scohan]

We've been running oracle 9i on a linux box and connecting to it through our app servers on our PCs. The listener seemed fin on the linux box. Now we're trying to get the app server (Jboss) running on the linux bos as well. BUt we get the following error:

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

If the listener worked when we accessed the db remotely, what's preventing us from connecting locally (using the same jdbc connection string?

thanks

 

[sedj]

The error could be one of a multitude of posibilities -

Firewall configuration
Proxy server configurtion
LAN settings
IP addresses
Hostname configuration
TNS naming conventions

Plus, the added problem of running JBoss - which really is just an app that runs Tomcat ... the errors could be run from JBoss security settings to internal Tomcat configration settings. Look at server.xml, and your mappings from the LAN/network to JBoss and also how JBoss maps internal IP addresses to Tomcat.

Enjoy !

 

[scohan]

The problem had to do with the hostname config. I'm not sure what needs to be done do be able to refer to it by it's hostname. I can ping it and it's recognized. But in the oracle-service.xml file, the host name does not work as part of the connection url. I switched to the IP address in the xml file and we were able to connect fine.

I'll have to investigate to figure out why the hostname doesn't work in the xml file. Any ideas?

Thanks.