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