Listener

How to Resolve The listener supports no services

Posted on
The Listener Supports Services
The listener supports no services I newly created a database called SMALLDB, but I can’t see any service registered with the new LISTENER2 which is listening to incoming connections from port 1522. The listener showed “The listener supports no services”. In fact, this message tells us that the listener is working fine, but no dynamic […]
Listener

How to Resolve ORA-12560 on Windows Server

Posted on
I have two error patterns on ORA-12560, one is related to ORACLE_SID problem, the other is related to the limitation of PROCESSES. ORA-12560 due to Incorrect ORACLE_SID First of all, allow me reproduce the error ORA-12560 for you. Check the instance name and current status. C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu […]