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

 

 


Revision #1
Created 12 May 2025 09:12:48 by Editor
Updated 12 May 2025 09:12:55 by Editor