Oracle XE 213 version error ORA-12518: TNS:listener could not hand off client connection

when install local Oracle XE 213 sometime gets the below errors

Status : Failure -Test failed: ORA-12518: TNS:listener could not hand off client connection (CONNECTION_ID=rzg9qX9ZQ5KtVyGMZx5jqQ==) https://docs.oracle.com/error-help/db/ora-12518/

Error ORA-12514: The listener does not currently know of service requested in connect descriptor

TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error TNS-00534: Failed to grant connection ownership to child 64-bit Windows Error: 10022: Unknown error

for this error:

1. fix the IP address or localhost correctly in <ORACLE_XE_LOCATION>\OraDB21Home1\network\admin\listener.ora<ORACLE_XE_LOCATION>\OraDB21Home1\network\admin\tnsnames.ora
2. update hostname/ip address/localhost

listener.ora

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )

tnsnames.ora

XE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = XE) ) )

2. goto services list — windows -> services -> open

3. open OracleOraDB21Home1TNSListener ->goto Log on Tab

select “Local System account” and check allow service to interact with desktop

4. restart listener and oracle service xe

5. then you can connect SQL developer and connection will be successful.