Lisenter cannot listen to service after changing host name

Environment Description, Linux redhat5.4 + Oracle 11.2.0.1

Host Name: Zky.zhan

Host ip:192.168.214.10

Example Sid:zky

Problem presentation

If you change the listening address (host = Zky.zhan) parameter in the Listenter.ora to the Listening Host network address (host= 192.168.214.10). The discovery service does not listen to the server, always displays no server, and cannot log on to the database through the Network service.

View Tnsname.ora Parameters

[Email protected]/]$ Cat/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. Zky = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.214.10) (PORT = 1521)) ) (Connect_data = (service_name = Zky) ) )

View Listener.ora Parameters

We will change the default Zky.zhan to IP address

[Email protected]/]$ Cat/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Listener.ora Network Configuration File:/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora # Generated by Oracle configuration tools. Enable_global_dynamic_endpoint_listener1 = On LISTENER = (Description_list = (DESCRIPTION = # (ADDRESS = (PROTOCOL = TCP) (HOST = Zky.zhan) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.214.10) (PORT = 1521)) ) ) Adr_base_listener =/u01/app/oracle

Start monitoring

Discover the listener supports no services, has been monitoring not to service

[[email protected]/]$ lsnrctl start Lsnrctl for linux:version 11.2.0.1.0-production on 24-apr-2016 05:34:11 Copyright (c) 1991, Oracle. All rights reserved. Starting/u01/app/oracle/product/11.2.0/grid/bin/tnslsnr:please wait ... Tnslsnr for Linux:version 11.2.0.1.0-production System parameter File Is/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora Log messages Written To/u01/app/oracle/diag/tnslsnr/zky/listener/alert/log.xml Listening on: (Description= (Address= (protocol=tcp) (host=192.168.214.10) (port=1521))) Connecting to (Description= (address= (protocol=tcp) (host=192.168.214.10) (port=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version Tnslsnr for Linux:version 11.2.0.1.0-production Start Date 24-apr-2016 05:34:11 Uptime 0 days 0 hr. 0 min. 0 sec Trace level off Security on:local OS Authentication SNMP OFF Listener Parameter File/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora Listener Log File/u01/app/oracle/diag/tnslsnr/zky/listener/alert/log.xml Listening Endpoints Summary ... (Description= (address= (protocol=tcp) (host=192.168.214.10) (port=1521))) The listener supports no services The command completed successfully

Database login also shows no listening

[Email protected]/]$ sqlplus System/[email protected] Sql*plus:release 11.2.0.1.0 Production on Sun APR 24 05:37:17 2016 Copyright (c) 1982, Oracle. All rights reserved. ERROR: Ora-12514:tns:listener does not currently know of service requested in Connect Descriptor

Workaround

After a tangle of days, it is found that the default resolution is 127.0 when using ping hostname Zky.zhan. 0.1. So in the state of temptation to modify the local parsing 127.0.0.1 to 192.168.214.10 after the discovery can be used normally.

Change host

[Email protected]/]# cat/etc/hosts # don't remove the following line, or various programs # that require network functionality would fail. #127.0.0.1 Zky.zhan Zky localhost.localdomain localhost #::1 localhost6.localdomain6 Localhost6 192.168.214.10 Zky.zhan Zky localhost.localdomain localhost

After restarting the listening service, I heard the monitor.

[Email protected]/]$ lsnrctl status Lsnrctl for linux:version 11.2.0.1.0-production on 24-apr-2016 05:43:40 Copyright (c) 1991, Oracle. All rights reserved. Connecting to (Description= (address= (protocol=tcp) (host=192.168.214.10) (port=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version Tnslsnr for Linux:version 11.2.0.1.0-production Start Date 24-apr-2016 05:34:11 Uptime 0 days 0 hr. 9 min. sec Trace level off Security on:local OS Authentication SNMP OFF Listener Parameter File/u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora Listener Log File/u01/app/oracle/diag/tnslsnr/zky/listener/alert/log.xml Listening Endpoints Summary ... (Description= (address= (protocol=tcp) (host=192.168.214.10) (port=1521))) Services Summary ... Service "+asm" has 1 instance (s). Instance "+asm", status ready, have 1 handler (s) for the This service ... Service "Zky" has 1 instance (s). Instance "Zky", status ready, have 1 handler (s) for the This service ... Service "Zkyxdb" has 1 instance (s). Instance "Zky", status ready, have 1 handler (s) for the This service ... The command completed successfully

Login Database Successful

[Email protected]/]$ sqlplus System/[email protected] Sql*plus:release 11.2.0.1.0 Production on Sun APR 24 05:44:59 2016 Copyright (c) 1982, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production With the partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Sql> Show Parameter name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Db_file_name_convert string Db_name string Zky Db_unique_name string Zky Global_names Boolean FALSE instance_name string Zky Lock_name_space string Log_file_name_convert string Service_names string Zky

This article from the "7154288" blog, reproduced please contact the author!

Lisenter cannot listen to service after changing host name