Problem solve Get help with specific problems with your technologies, process and projects.

Errors connecting over dial-up

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:@
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.