Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.
Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.
TNS listener could not find available handler for requested type of server.
This error is related with out of available Oracle processes.
Then Increase the value of the PROCESSES initialization parameter.
Solution:Step-1SQL> select current_utilization, limit_value ,resource_name
From v$resource_limit
Where resource_name IN ('sessions','processes');
CURRENT_UTILIZATION LIMIT_VALU RESOURCE_NAME
------------------- ---------- ------------------------------
199 200 processes
203 328 sessions
Step-2
SQL>alter system set processes=400 scope=spfile;Step-3
SQL>shut immediateStep-4
SQL>startupStep-5
SQL> select current_utilization, limit_value ,resource_name
From v$resource_limit
Where resource_name IN ('sessions','processes');
CURRENT_UTILIZATION LIMIT_VALU RESOURCE_NAME
------------------- ---------- ------------------------------
23 400 processes
23 624 sessions
Announcing Oracle Database 23ai: Unleashing the Power of AI for Next-Gen Data Management After years of dedicated development, Oracle is thrilled to unveil the latest milestone in database technology: Oracle Database 23ai. This release marks Read more…
Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection. Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener Read more…
What’s New in OGG 21c(21.3.0) All Databases–Heartbeat TARGETONLY is supported for heterogeneous database targets. Parallel Replicat is supported for Heterogeneous Databases Integration with External Identity Management (IdM) system using OpenID/OAuth2.0 DB2 LUW–Capture and delivery for Read more…
0 Comments