Problem connecting to database

[Mathews P Srampikal]

Hi all,

I am getting the following exception while connecting to databse.

1. driver is loaded
2. Database server is running
what can be the problem. i gave ip address instead of machine name in place of URL

the code is:

Class.forName("oracle.jdbc.driver.OracleDriver");//works fine
System.out.println("Oracle driver loaded: ");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@mats:1521:ORCL", "system", "orcl");
System.out.println("Connecting to oracle database: ");

The Exception is:

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

[Cameron Wallace McKenzie]

Can you ping the IP address and connect on that port? You might have a proxy or something blocking that port. Any firewalls?

-Cameron McKenzie

[Avi Abrami]

Mathews,
When I did an Internet search on your error message I got over 4,000 hits.
Did none of them answer your question?
The cause of the error is usually one (or more) of the following:

Database server is not running.

Database connection listener is not running.

Connection URL is incorrect.

Check first one via SQL*Plus.
Check second one via "lsnrctl" utility.
Refer to documentation for correct syntax of third one and then check TNS configuration to verify the correct parameters required.

Good Luck,
Avi.