Oracle Error modification and listening Configuration

Configuration when a listener error occurs:

|-Error 1: Oracle Database listening services often encounter errors. The Registry is deleted when the optimization software is used.

Registration items of the listener service:

HKEY_LOCAL_MACHINE \ SYSTEM \ controlset002 \ Services \ oracleoradb10g_home1tnslistener

View the registration option in the Registry: regedit

If an error occurs after optimization, it is generally because the numeric data in ImagePath is incorrect. You only need to modify the data:

The data path in ImagePath is as follows: you only need to change the value data in ImagePath to D: \ oracle \ product \ 10.1.0 \ db_1 \ bin \ tnslsnr to fix the error.

|-Error 2: the network environment is changed. Changing the network environment refers to changing the computer name. After the network environment changes, the original configuration of the network will not work properly. In this case, you must manually modify the network configuration.

Modify the computer name to observe service changes: [my computer]-> [properties]-> [computer name]-> [change host name]

After modification, restart the computer, and then start the database service. oracleoradb10g_home1tnslistener is found.

The service cannot be started normally. Even if it is started on the surface, a refresh will show that the service is not started, indicating that the service is not actually started, because the name of the computer, that is, the network environment, has been changed. To modify this problem, you must modify the network configuration files tnsnames. ora and listener. ora. The path of the configuration file:D: \ oracle \ product \ 10.1.0 \ db_1 \ Network \ admin

Open the configuration file listener. ora.

# Listener. ora network configuration file: D: \ oracle \ product \ 10.1.0 \ db_1 \ Network \ admin \ listener. ora # Generated by Oracle configuration tools. Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (ORACLE_HOME = D: \ oracle \ product \ 10.1.0 \ db_1) (Program = EXTPROC) ) ) Listener = (Description_list = (Description = (Address_list = (Address = (Protocol = IPC) (Key = EXTPROC )) ) (Address_list = (Address = (Protocol = TCP)(Host = taobao.114so.cn)(Port = 1521 )) ) ) )

Change the host name to the computer name.

Open the listener. ora configuration file, and modify the host value as above.

Then restart the database service. If the above configuration does not allow normal access to the database, you need to perform the second step, that is, register the database name. The operation is as follows: choose [all programs]-[Oracle-oradb10g_home1]-[configuration and migration tools]-[net manager] To go to the network configuration page:

Visible, the listening location is:

Click Add Database: Global Database Name: mldn Sid: mldn name should be the same as the previous one.

In addition, a listener status check command is also provided in Oracle: LSNRCTL. exe

D: \ oracle \ product \ 10.1.0 \ db_1 \ bin \ LSNRCTL. exe