Notes: oracle FAQs

Note: oracle FAQ listening problem: the listening service is the most important service used in an Oracle database, but this service often encounters errors, in the future, this service will also encounter errors, so the following two common error solutions are provided. error 1: The registry uses the optimization software and related items are deleted. Each system service is actually saved in the registry. The registration items of the listener service: HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ OracleOraDb10g_home1TNSListener. There is an "ImagePath" option in it. This option may be automatically deleted when optimization software is used. If it is deleted, create a new item and write the corresponding content as follows. When you start the service again after deletion, the following error occurs: Error 2: In Oracle10g, if the network environment changes, the network with the original configuration may not work properly. You must manually modify the network configuration. the most recent change in the network environment refers to the change in the computer name: My computer ---- properties ---- computer name ---- change the host name teacher and then restart. it is found that the listener service has not been actually started (refresh is gone), because the network environment has changed, and this problem is one of the most frequently encountered problems in learning and development, to solve this problem, you must modify the listener in the NETWORK configuration file path: F: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN. ora and tnsnames. ora modifies listtener. ora File

# 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) (ADDRESS = (PROTOCOL = TCP) (HOST = teacher) (PORT = 1521) Modify tnsnames. ora file # tnsnames. ora Network Configuration File: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = teacher) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl ))) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO )))

 

Then restart the listening service again. However, if you use a program to connect to Oracle10g in the future, the above configuration may still not be able to access the database normally. At this time, you can proceed to step 2, register the database name. select Net Manager to go to the network configuration page and save the file. then the listening service can be used.