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.
![](https://programmerah.com/wp-content/uploads/2020/11/a2f60b0265002a831cf4a81d63c83d19.png)
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
![](https://programmerah.com/wp-content/uploads/2020/11/f38a88779c3a371458a0d061c6789ddf.png)
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)
![](https://programmerah.com/wp-content/uploads/2020/11/439f3eee6f2b56d4b46aebd6ce278e66.png)
Make sure that both services are started, or if not, start both services first.
![](https://programmerah.com/wp-content/uploads/2020/11/a2f60b0265002a831cf4a81d63c83d19.png)
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
![](https://programmerah.com/wp-content/uploads/2020/11/f38a88779c3a371458a0d061c6789ddf.png)
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)
![](https://programmerah.com/wp-content/uploads/2020/11/439f3eee6f2b56d4b46aebd6ce278e66.png)
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 problem of [connection lost contact] after C # code connecting Oracle database for a period of time
- Navicate premium Connecting to a remote Oracle,ORA-12514: TNS:listener does not currently know of service requested in c
- Oracle database file is damaged, Error:ORA-01033 :ORACLE initialization or shutdown in progress
- The solution of PL / SQL can’t connect to the remote server after installing Oracle locally
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- 2059 error in connecting to database by Navicat premium
- Solve the error of ora-12514 when Navicat connects to Oracle Database
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- An error is reported when kettle connects Oracle database and MySQL database
- Oracle login error: Oracle error 6 initializing SQL * plus (normal before)
- Oracle 12C installation process related errors and Solutions
- Oracle11gr2 database suddenly “TNS no listener” protocol adapter error
- The solution to the problem that the method of interacting with database in the servlet class is invalid after the servlet submits 404, 500 refresh and becomes 404, and after connecting to the data pool
- Pikachu vulnerability is installed in the shooting range, and an error is reported when connecting to the MySQL database
- Compilation errors and warnings encountered in QT and their solutions
- [Solved] SpringBoot Integrating Oracle reports errors: ORA-12504, TNS:listener was not given the SID in CONNECT_DATA
- After Oracle 11g is installed, SQL_ Plus.exe The problem of Chinese garbled in command window
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- Talking about the errors encountered in installing MySQL ODBC (error 1918)
- Oracle can’t start the database due to deleting DBF file by mistake