How to solve 1067 error in oracle

Solution: 1. Enter "$NETWORKADMIN" and modify the IP address information in the "listener.ora" file to be correct; 2. Use Net Manager to modify the listening location in the local listening program. Just the correct IP address.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to solve 1067 error in oracle

Cause: The local ip or host name has been changed after installing oracle and needs to be changed back.

1. Open the oracle installation directory (Search oracle in the beginning to find the location of the file).

Enter $NETWORKADMIN and modify the corresponding local ip (temporary recommendation) or host name in listener.ora and tnsnames.ora.

Modify the information about the IP address in the listener.ora file

listener.ora file: The original text is as follows

Add the following Code:

(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME =
/app/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = ORCL)
)

becomes:

Then restart the OracleOraDb10g_home1TNSListener service and that’s it!

2, or use Net Manager->Local->Listener, change the listening location to the correct IP address and save it. Error

Extension Knowledge:

1067 error occurs because the IP addresses in the listening files listener.ora and tnsnames.ora are different from those of the local machine (addresses are prone to change when connected to the network). The solution can be as follows Modify the oracle configuration file and modify the listening configuration, start -> enter Net manager to open the listening configuration program.

Configure the host name (written by yourself, my configured localhost) and port number, and then search for the file listener in the oracle installation directory (such as my F:\oracle\product\10.2.0) .ora and tnsnames.ora files, view and modify the Host items in these two files respectively (after configuring the host name and port with net manager, the listener.ora file will automatically change) to the modified host name: tnsnames. You have to modify it yourself in ora. Okay, now you can restart the OracleOraDb10g_home1TNSListener service.

After startup, the following error will be reported when connecting:

java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:

At this time, the program cannot connect to the database because there is no database name (SID).

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to solve 1067 error in oracle. For more information, please follow other related articles on the PHP Chinese website!