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.