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;