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

2007-05-17

279

Must read

The database trying to be connected to is not running. Ensure the Oracle database is running and that the TNS entry you are using is correct.

Windows start the OracleServiceXE service.

Linux login as oracle and run dbstart.

To test TNS run tnsping on the command line and give it the TNS name you are trying to use:

tnsping <tns name>