ORA – 1205, TNS: listener does not currently know of SID given in connection descriptor

Posted: March 28, 2013 in Database

This error occurred in my code when i was trying to connect oracle 11g using java .

1. Jdbc connectivity code was perfect
2. Oracle service was running
3. Was able to login sqlplus
4. Database startup and shutdown commands were working .
5. All sql queries worked fine

Even thought i was not able to establish connection. After a long search in Google i found that we need to restart tns by this command .

Lsnrctl start

Don’t forget to restart your database.

Shutdown
Startup
Advertisements

Comments are closed.