Dear Experts, I am facing following problem with oracle 11g while programming.

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

System has four database is connecting through sql developer successfully but ohters are not connected.
When i am again creating same database for correcting error it works well but after some restarts againt it showing
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

Till now i am recreating same database to resolve this which is not a good way of programming.

Please help me out.

How are you connecting to the database? Can you post the Connection String?

What objects are you using to connect? Odbc? ODP.NET?

We need more information in order to help you.