After Oracle is installed, the listener becomes unavailable after the ip address is suddenly changed.

A set of Oracle11g is implemented in the Linux6.2 system, which may be because the operating system is not properly installed. For example, each of the magnetic arrays cannot exceed 2 TB, and the rpm requires x86_64.

A set of Oracle 11 GB is implemented in the Linux6.2 system, which may be because the operating system is not properly installed. For example, each disk of the magnetic array cannot exceed 2 TB, and the rpm requires x86_64.

A set of Oracle 11 GB is implemented in the Linux6.2 system, which may be because the operating system is not properly installed. For example, if each disk of a magnetic array cannot exceed 2 TB, the rpm requires x86_64, there are a lot of bugs.

Today, the leader has changed the ip address and the connection cannot be reached.

(Change 192.168.180.5 to 192.168.180.2)

Problem description:

[Oracle @ SE-1 ~] $ Lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0-Production on-2013 13:26:12

Copyright (c) 1991,201 1, Oracle. All rights reserved.

Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
LISTENER STATUS
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Launch date: 26-11-2013 08:53:09
Normal operation time: 0 days, 4 hours, 33 minutes, 3 seconds
Tracking level off
Security ON: Local OS Authentication
SNMP OFF
Listener parameter file/u01/app/grid/product/11.3.0/grid/network/admin/listener. ora
Listener log file/u01/app/grid/diag/tnslsnr/SE-1/listener/alert/log. xml
Listener endpoint overview...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = SE-1) (PORT = 1521 )))
The Listener does not support services.
Command executed successfully

1. Address to be modified

[Oracle @ SE-1 ~] $ More/etc/hosts
127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4
: 1 localhost. localdomain localhost6 localhost6.localdomain6
192.168.180.2 SE-1

2. Modify parameters

Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options

SQL> show parameter LIS

NAME TYPE VALUE
-----------------------------------------------------------------------------
Listener_networks string
Local_listener string (DESCRIPTION = (ADDRESS_LIST = (AD
DRESS = (PROTOCOL = TCP) (HOST = 192.
168.180.5) (PORT = 1521 ))))
Recovery_parallelism integer 0
Remote_listener string
SQL> alter system set local_listener = '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.180.2) (PORT = 1521)' scope = BOTH;

The system has been changed.

SQL> show parameter lis

NAME TYPE VALUE
-----------------------------------------------------------------------------
Listener_networks string
Local_listener string (DESCRIPTION = (ADDRESS_LIST = (AD
DRESS = (PROTOCOL = TCP) (HOST = 192.
168.180.2) (PORT = 1521 ))))
Recovery_parallelism integer 0
Remote_listener string
SQL> exit

-- Solved the problem

[Oracle @ SE-1 ~] $ Lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0-Production on-2013 13:29:48

Copyright (c) 1991,201 1, Oracle. All rights reserved.

TNS-01106: a listener started with the name LISTENER
[Oracle @ SE-1 ~] $ Lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0-Production on-2013 13:29:55

Copyright (c) 1991,201 1, Oracle. All rights reserved.

Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
LISTENER STATUS
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0-Production
Launch date: 26-11-2013 08:53:09
Normal operation time: 0 days, 4 hours, 36 minutes, 45 seconds
Tracking level off
Security ON: Local OS Authentication
SNMP OFF
Listener parameter file/u01/app/grid/product/11.3.0/grid/network/admin/listener. ora
Listener log file/u01/app/grid/diag/tnslsnr/SE-1/listener/alert/log. xml
Listener endpoint overview...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROC1521 )))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = SE-1) (PORT = 1521 )))
Service summary ..
The Service "mobile" contains one instance.
Instance "mobile", status READY, contains 1 handler of this service...
The Service "mobileXDB" contains one instance.
Instance "mobile", status READY, contains 1 handler of this service...
Command executed successfully

Related reading:

Dynamic and Static monitoring features of Oracle listeners

Non-default listeners and port configurations for placing an instance in the Oracle 11g RAC Environment

Configure and manage Oracle listener logs

Oracle error-ORA-12514: TNS: No listener

ORA-12514 listening error solved

Six connection problems and solutions for Oracle listeners

Oracle LISTENER does not listen to Oracle instances. Problem solved

,