Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Unable to connect to 19c DB through Sql developer

ggJan 28 2022

Hi Everyone,
I installed Oracle 19c Database after installing another one and I am able to connect through command line to db through sql plus.
However i am not able to connect through Sql developer tool. I am getting the error:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=z/Q7O7w8TReTjDflkD0i5A==)
I saw the listener has not started yet. So after the checking the listener status i got the error message.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GSPC)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory

After trying to start the listener, i am getting the error
Failed to start listener service, error 2: The system cannot find the file specified.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
I am unable to start the service via Windows services as well.
Could some one please help to resolve this connection issue.

Thanks
Gautam

Comments
Post Details
Added on Jan 28 2022
2 comments
1,652 views