Solution and steps for oracle listening failure

Solution and steps for oracle listening failure I described the failure to start Oracle listening is a solution that can be started normally after the installation is complete, because the network ip address is changed or the computer name cannot be started after modification. I have met both of these situations. We recommend that you use localhost or 127.0.0.1 as the listener name when installing Oracle. Do not use changeable names, such as ip addresses or computer names. When these parameters are changed, the listener cannot be started. Here are the solutions and steps: Note: My database sid = orcl, if your sid varies with the file suffix. In the following step, "* _ orcl" equals "original computer name or ip_orcl" www.2cto.com 1. Find E: \ oracle \ product \ 10.2.0 \ db_1 under the "* _ orcl" (for example, jadethao_orcl) directory, modify the following three directories: 1, 127.0.0.1 _ orcl or localhost_orcl (recommended) 2. Now the computer name _ orcl (not recommended) 3. ip_orcl (used with caution, cannot be started when the network ip address is changed) 2. Enter * _ orcl \ sysman \ config, modify the content of the four files: 1. emagentlogging. properties 2, emd. properties 3. emoms. properties 4. emomslogging. properties Changes the file with "* _ orcl" to * _ orcl (for example, if the previous file is changed to 127.0.0.1 _ orcl The content in the file "* _ orcl" is modified to '20180101. 0.0.1 _ orcl ') www.2cto.com 3. Modify listener under E: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN. ora file: SQL code LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = computer name or 127.0.0.1 (localhost) (PORT = 1521 )))) www.2cto.com restarts the Oracle listener, and everything is normal.