Solution for stopping ORACLE10g listener after startup

 

Today, I encountered a listener startup problem. The problem was that there was no problem when oracle was installed on the original machine. After the machine name was changed, the listener could no longer be started, the problem is located due to the machine name. The solution is actually very simple:

1. Change your machine name back.

2. modify the configuration file in the listener. Edit % ORACLE_HOME \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ listener. in the ora file, find the following HOST value: administrator-PC. This is the machine name. Change it to your current machine name, such as Tiwen-pc. Then restart the oracle listener. OK.

 

# Listener. ora Network Configuration File: D: \ Database \ 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 = D: \ Database \ oracle \ product \ 10.2.0 \ db_1)

(PROGRAM = extproc)

)

)

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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

(ADDRESS = (PROTOCOL = TCP) (HOST = administrator-PC) (PORT = 1521 ))

)

)

 

From Tian Wen's column