oracle-db-tools icon indicating copy to clipboard operation
oracle-db-tools copied to clipboard
verified publisher icon oracle

Getting IO Error when trying to connect sql developer

Open Priyanka493-My opened this issue 4 years ago • 2 comments

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=xnQiEstFRNCH3EAi7zdv3g==)

The following is from the listener.ora file LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1539)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) )

and this is from tsanames.ora file

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=xnQiEstFRNCH3EAi7zdv3g==)

How to resolve the issue. Can anybody help resolve this.

Priyanka493-My avatar Dec 21 '21 14:12 Priyanka493-My

Can anybody please check on this

Priyanka493-My avatar Dec 27 '21 13:12 Priyanka493-My

try this article from Tim. It lines out what should be in those files and how to test them before you connect with SQLDeveloper.

bamcgill avatar Jan 21 '22 11:01 bamcgill