Home > database >  Oracle12c DQL developer connection error: I/o error: The Network Adapter... Supplier code 17002
Oracle12c DQL developer connection error: I/o error: The Network Adapter... Supplier code 17002

Time:09-16

This is an error dialog


This is the listener. The whole content of ora {
# listener. Ora Network Configuration File: E: \ app \ wouldn \ product \ 12.2.0 \ dbhome_1 \ Network \ admin \ listener ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=former)
(ORACLE_HOME=E: \ app \ wouldn \ product \ 12.2.0 \ dbhome_1)
(the PROGRAM=extproc)
(ENVS="EXTPROC_DLLS=ONLY: E: \ app \ wouldn \ product \ 12.2.0 \ dbhome_1 \ bin \ oraclr12 DLL")
)
)

The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=192.168.124.2) (1521) PORT=)
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
)
)

}
This is tnsnames. Ora the entire contents of the {
# tnsnames. Ora Network Configuration File: E: \ app \ wouldn \ product \ 12.2.0 \ dbhome_1 \ Network \ admin \ tnsnames ora
# Generated by Oracle configuration tools.

LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=194.168.124.2) (1521) PORT=)


ORACLR_CONNECTION_DATA=https://bbs.csdn.net/topics/
(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(SID=CLRExtProc)
(the PRESENTATION=RO)
)
)

Former=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=192.168.124.2) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=former)
)
)
}


Something else I didn't move, the two files of the host value is localhost I changed my original host name, I just learn oracle is a Java beginners today, originally can be used well, it's time to use DESC read form is how to also can't read it out (written form is normal), then DQL Developer program is stuck, I had a strong back into it again, please teach, thank you.

CodePudding user response:

LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=194.168.124.2) (1521) PORT=)

This configuration is wrong, the lack of the DESCRIPTION=,,,, a lot of information,
After you remove it, can see the login,

CodePudding user response:

reference 1st floor qq646748739 response:
LISTENER_ORCL=
(ADDRESS=(TCP) PROTOCOL=(HOST=194.168.124.2) (1521) PORT=)

This configuration is wrong, the lack of the DESCRIPTION=,,,, a lot of information,
After you remove it, can see the login,

I tried, still won't do, to the same fault, the DESCRIPTION=,,,, here is not have?

CodePudding user response:

The host name change localhost or 127.0.0.1
  • Related