Category Archives: SQL

ORA-12519: TNS:no appropriate service handler found

The number of database processes that can run in Oracle DB is set to 150 as default which can be viewed from v$resource_limit. select * from v$resource_limit where resource_name = ‘processes’; RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ————- ——————- ————— —————— … Continue reading

Posted in ARTICLES, HOWTO, SQL, TIPS & T RICS | Tagged , , | Leave a comment