VALIDATE STATIC CONNECT IDENTIFIER failed for Primary Database - Dataguard

 I have been encountered below issue while validating static connect identifier.

ORA-12520: TNS:listener could not find available handler for requested type of server

DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR all;

Oracle Clusterware is not configured on database "ORCL11".

Connecting to database "ORCL11" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.164.1.74)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL11)(INSTANCE_NAME=ORCL11)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Unable to connect to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.164.1.74)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL11)(INSTANCE_NAME=ORCL11)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))

ORA-12520: TNS:listener could not find available handler for requested type of server

Failed.

Oracle Clusterware is not configured on database "ORCL11db".

Connecting to database "ORCL11db" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORCL11DBA01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL11DB)(INSTANCE_NAME=ORCL11DB)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Succeeded.

The static connect identifier allows for a connection to database "ORCL11db".

Checked : Below was my listener.ora file which was Dynamic that's why I was getting error  

$ cat listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ORCL11DBA01)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

Solution :- 

I have added entry and made the statis listener 

$ cat listener.ora

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ORCL11DBA01)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

SID_LIST_LISTENER=

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = ORCL11DB)

      (ORACLE_HOME = /applications/oracle/19.3.0.0)

      (SID_NAME =ORCL11DB)

    )

)

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

After this ORA-12520: TNS:listener could not find available handler for requested type of server issue resolved 

DGMGRL> VALIDATE STATIC CONNECT IDENTIFIER FOR all;

Oracle Clusterware is not configured on database "ORCL11".

Connecting to database "ORCL11" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=198.164.1.74)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL11)(INSTANCE_NAME=ORCL11)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Succeeded.

The static connect identifier allows for a connection to database "ORCL11".

Oracle Clusterware is not configured on database "ORCL11db".

Connecting to database "ORCL11db" using static connect identifier "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ORCL11DBA01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL11DB)(INSTANCE_NAME=ORCL11DB)(SERVER=DEDICATED)(STATIC_SERVICE=TRUE)))" ...

Succeeded.

The static connect identifier allows for a connection to database "ORCL11db".

Now I can do switchover and switchback using dgmgrl utility :)

Happy Learning ...!!!