Ora-12505. TNS Listener does not currently know of SID given in connection descriptor

 

Often Times I receive the following error on my Oracle XE database . This happens sometimes on reboot. 

 

Status: Failure – test Failed: Listener refused the connection with the following error Ora-12505. TNS Listener does not currently know of SID given in connection descriptor

 

 

This issue is fixed after referencing the database . Login as SYSDBA ans executed teh following SQL’s 

 

Credit: Stack Exchange  

 

alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=both;

alter system register;

 

govindan Ora-12505 -  TNS Listener does not currently know of SID given in connection descriptor | Oracle XE | Localhost
Connect me