Saturday, January 25, 2020

ORA-12560 Error Solved

Auto-start database
1. go to the command prompt. (as administrator)
Check all your instances running
C;> lsnrctl status

2. Set the Oracle system ID (SID) to
C:> set oracle_sid=ORCL.
3. Run the Net Start command (
C:>net start oracleserviceORCL).

This should resolve the ORA-12560 error in this situation
Reference
Tutorial for Starting Oracle Listener