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
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…
The non-CDB architecture was deprecated in Oracle Database 12c (12.10.2). It is desupported in Oracle Database 20c. Oracle Database 20c was the first CDB-PDB release. Now there is no Oracle Database 20c. Hence, Oracle 21c will be Read more…
0 Comments