I'm using Oracle 11gR2 in RHEL5. Now a days my application, during run time, is showing exception as below.
Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
It happens only during the peak time.
Where can I find the reason? Somewhere it might be logging all. Where is it? I checked the
alert_db.log as well as
log.xml inside the tnslsnr, but couldn't find anything relating this.