Shulou(Shulou.com)06/01 Report--

This article mainly introduces oracle listener start 1067 error handling method, has certain reference value, need friends can refer to the next. I hope you all have a lot of success after reading this article. Let's take a look at it together.

Error 1067 occurs because the IP address in the listening files listener.ora and tnsnames.ora is different from that of the local computer (the address is easy to change when the network is connected). The solution can be to modify the oracle configuration file and modify the listening configuration. Start-> Enter Net manager to open the listening configuration program.

Configure the host name (localhost written by myself, localhost configured by me) and port number, and then search for the files listener.ora and tnsnames.ora in the Oracle installation directory (for example, my F:\oracle\product\10.2.0), respectively view and modify the Host item in these two files (after configuring the host name and port with net manager, the Oraclelistener.ora file will automatically change) to the modified host name: tnsnames.ora. You need to modify it yourself. OK, now restart OraDb10g_home1TNSLister service to start.

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:

This is because the program cannot connect to the database without the database name (SID). Open Oracle's listener.ora file: The original text is as follows

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

)

Add the following code:

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)

(SID_NAME = ORCL)

)

Become:

#listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = /app/oracle/oracle/product/10.2.0/db_1)

(SID_NAME = ORCL)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

)

Then restart OracleOradb10g_home1TNSListener service!

Thank you for reading this article carefully, hope Xiaobian share oracle listener start 1067 error handling method content to help everyone, but also hope that everyone more support, pay attention to the industry information channel, encounter problems to find, detailed solutions waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.