cant connect to my database

Here is what comes out of the listener when i enter the command Status…

LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 21.0.0.0.0 - Production Start Date 15-JAN-2022 21:26:26 Uptime 0 days 0 hr. 14 min. 29 sec Trace Level support Security ON: Local OS Authentication SNMP OFF Listener Parameter File D:OraclehomesOraDB21Home1networkadminlistener.ora Listener Log File D:OraclediagtnslsnrDESKTOP-AP5R6E0listeneralertlog.xml Listener Trace File D:OraclediagtnslsnrDESKTOP-AP5R6E0listenertraceora_9660_4068.trc Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-AP5R6E0)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1521ipc))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "ORCLPDB" has 1 instance(s). Instance "orclpdb", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully 

And this is from SQL Plus… SQL Developer gives me the same error…

SQL> connect ot@orclpdb Enter password: ERROR: ORA-12518: TNS:listener could not hand off client connection 

submitted by /u/mistersunman
[link] [comments]


Go to Source of this post
Author Of this post: /u/mistersunman
Title Of post: cant connect to my database
Author Link: {authorlink}