Today, I encountered a series of errors in connecting Oracle database with SQL Developer, which took a lot of time and was finally solved. Now I am writing it down, hoping to give some help to those students who encountered the same mistakes
Make sure that both services are started, or if not, start both services first.

The first is this exception Io exception: The Network Adapter could not establish The Connection, this exception is probably The IP error of The host name of The connection, The host name does not have to be localhost or 127.0.0.1, but should be consistent with The IP name in The Oracle installation directory (my name is The directory H:\app\LBJ\ Product \11.2.0\dbhome_1\ Network \ADMIN) listens. ora file. That is, the IP after HOST in the figure below is consistent

After the modification is completed, restart the Listener service (namely the two services in the figure above), and encounter the Listener union connection with the following error: Ora-12505, TNS: Listener does not currently know of SID Given in Connect Descriptor; after searching the data, it is found that there is a problem with SID. The name in the SID is also not optional. It should be the same as the SID_NAME in the file (listlisteners. Ora) (orcl in this case)

Make sure that both services are started, or if not, start both services first.

The first is this exception Io exception: The Network Adapter could not establish The Connection, this exception is probably The IP error of The host name of The connection, The host name does not have to be localhost or 127.0.0.1, but should be consistent with The IP name in The Oracle installation directory (my name is The directory H:\app\LBJ\ Product \11.2.0\dbhome_1\ Network \ADMIN) listens. ora file. That is, the IP after HOST in the figure below is consistent

After the modification is completed, restart the Listener service (namely the two services in the figure above), and encounter the Listener union connection with the following error: Ora-12505, TNS: Listener does not currently know of SID Given in Connect Descriptor; after searching the data, it is found that there is a problem with SID. The name in the SID is also not optional. It should be the same as the SID_NAME in the file (listlisteners. Ora) (orcl in this case)

Restart the listening service after the modification to see if the problem has been resolved. Again, I encountered an error where I was unable to get more information from the socket. Ora file, as shown in the figure above. Simply comment out the #(PROGRAM = extproc) line and the problem is solved. Now restart the service again and find that you can finally connect, and you’re done.
Read More:
- The solution of PL / SQL can’t connect to the remote server after installing Oracle locally
- Solution to Oracle error 17002
- JDBC connection to Oracle: listener used the connection with the following error: ora-12505
- TNS-12545: Connect failed because target host or object does not exist
- When configuring ROS distributed / Error report solution and command requirements encountered in the process of master-slave computer
- Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently
- Solution: the network can be recovered only when the Ubuntu broadband is disconnected
- Oracle 12C installation process related errors and Solutions
- Job for network.service Failed because the control process exited with error code. See “SystemC
- Oracle error code: 17002 error
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- Oracle error – ora-12519, TNS:no appropriate service handler found
- TCP error code 10061: unable to connect because the target machine actively refused http://localhost :8732/Design_ Time_ Addresses/TeacherHelperServic
- Solution summary of VMware network card without IP and failure to start network card (continuous update)
- Deployment project error: Oracle 11g ora-12505, TNS:listener does not currently know of SID given in connect descriptor
- bug-JAVA call SAP function Connect to SAP gateway failed
- When installing oracle12c, the problem of “unable to check whether the specified location is on CFS” appears
- 【Q&A】Failed to start LSB: Bring up/down networking
- CentOS uses Yum install to report errors
- Oracle database error: fatal Ni connect error 12170