Skip to main content

oracle setting

 

ORA-12518, TNS:listener could not hand off client connection

Services required to run oracle in windows

OracleOraDB19Home1TNSListener
OracleServiceorcl

If one of the services is down, create it manually :
Open command prompt
cd C:\Users\blue_\Downloads\oracle19c\bin
oradim -list
oradim -new -sid orcl -startmode auto -pfile C:\Users\blue_\Downloads\oracle19c\database\init.ora
sqlplus / as sysdba
Startup
alter system register (optional);

Check listener status
lsnrctl status
lsnrctl start
lsnrctl stop