error while connecting with oracle 9

[ravindra patil]

i am getting following error

"
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:mydsn

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.j ................


please give the solution

[Shailesh Chandra]

Check if listener is created & running

Shailesh

[Chris Hendy]

I think the listener must be running for it to refuse the connection.

Looking at your connect string, localhost indicates a database running on your local machine, and mydsn is the SID (System identifier) of the specific database.

So, do you have an Oracle database called mydsn installed and running on your local machine?

[Martin Simons]

Originally posted by Chris Hendy:
So, do you have an Oracle database called mydsn installed and running on your local machine?

And a listener configured for it?