developers

    Forum Stats

  • 3,874,065 Users
  • 2,266,670 Discussions
  • 7,911,715 Comments

Discussions

Unable to connect to 19c DB through Sql Developer - TNS:protocol adapter error No listener error

gg
gg Member Posts: 156 Bronze Badge
edited Jan 29, 2022 3:48PM in General Database Discussions

Hi Everyone,

I installed Oracle 19c Database 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

Tagged:

Answers

developers