I have a two computer (server/client) set up. If the machines are connected through the LAN (Intranet) the client Java program is able to query the server Oracle database. BUT when the client tries to connect over a dial-up I get 12500, 12505, 12560. What am I missing?
D:a>java -cp .;ojdbc14.jar MyOraApp
before class oracle.jdbc.OracleDriver
after class oracle.jdbc.OracleDriver
about to connect to jdbc:oracle:thin:@22.214.171.124:1521:anil
Error Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
There's a lot of details involved here that I am curious about. Working from the server end, I'd first watch the listener log during the connection attempt and see if the listener ever received contact from your client. It will be important for you to know what your client's IP address is at the time of connection (ipconfig should show you).
If that is successful (not likely), then you probably need to open a TAR because there's probably something else in the details of your client configuration that is making the connection fail.
Make sure that after you dialup, you can contact the database server with tools like ping (at your command prompt) or the Oracle utility tnsping to determine if your client can make contact with the database server at all. I would anticipate that the ping and/or tnsping utilities will not be successful which will mean that your dialup connection is not equivalent to the LAN connection. That's common on many networks since LAN security is usually handled differently than dialup connectivity and so you may be able to access some common servers (like e-mail, file/print, etc.), but database servers may not be accessible from some dialup networks. Check with your network administrator to determine if your dialup network is supposed to be able to access the database server.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.