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 <SPAN style = "COLOR: # ff0000"> </SPAN> 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
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