Dns resolution causes opiodr aborting process unknown ospid (7266) as a result of a ORA-609 similar error

A large number of similar OPIODR aborting process unknown ospid (7266) as a result of ORA-609 errors appear in the database alert log
Tue Oct 27 07:51:10 2015
OPIODR aborting process unknown ospid (7266) as a result of ORA-609
Tue Oct 27 08:16:56 2015
OPIODR aborting process unknown ospid (7660) as a result of ORA-609
Tue Oct 27 08:17:16 2015
OPIODR aborting process unknown ospid (7666) as a result of ORA-609
Tue Oct 27 08:21:50 2015
OPIODR aborting process unknown ospid (7725) as a result of ORA-609
Tue Oct 27 08:37:43 2015
OPIODR aborting process unknown ospid (7940) as a result of ORA-609
Tue Oct 27 08:51:25 2015
OPIODR aborting process unknown ospid (8126) as a result of ORA-609
Tue Oct 27 09:07:16 2015
OPIODR aborting process unknown ospid (8359) as a result of ORA-609
Tue Oct 27 09:26:09 2015
OPIODR aborting process unknown ospid (8600) as a result of ORA-609
Test tnsping
[Oracle@sql admin]$ tnsping ORCL

TNS Ping Utility for linux:version 11.2.0.1.0-production on 28-oct-2015 01:40:55

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES Adapter to resolve the alias
Attempting to contacts (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = 192.168.2.162) (PORT = 1521)) (Connect_data = (serv ER = dedicated) (Service_Name = Orcl. Sql.xifenfei.com)))
OK (20120 msec)
[Oracle@sql admin]$ tnsping ORCL

TNS Ping Utility for linux:version 11.2.0.1.0-production on 28-oct-2015 01:42:35

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES Adapter to resolve the alias
Attempting to contacts (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = 192.168.2.162) (PORT = 1521)) (Connect_data = (serv ER = dedicated) (Service_Name = Orcl. Sql.xifenfei.com)))
OK (41600 msec)
Hosts file configuration
[Oracle@sql admin]$ vi/etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
192.168.2.162 Sql.xifenfei.com
:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6
While testing Lsnrctl Start/stop/status is slow, ping localhost very quickly, proving that the problem is on the monitor. Search keyword lsnrctl slow/tnsping keyword found related documents:
Bug 8307164:tnsping 11G USING DNS and not HOSTS FILE
Listener Startup or Connections Hang in 11g (Doc ID 803838.1)
11g:remote connections Take Very Long to establish (Doc ID 856820.1)
These documents allow you to know that the resolution of the host name in Oracle 10g uses the gethostbyname () function, and the use of the getaddrinfo () function is used in 11g. This function is for/etc/ Nsswitch.conf calls are not the same as ethostbyname (), resulting in such problems. According to official recommendations:
Linux
hosts:files [notfound=continue] DNS OR Hosts:files/dns

HPUX and Solaris
ipnodes:files [notfound=continue] DNS
This solution
Because there is no need to configure this for a database environment that is not used to a DNS server, it is estimated that the installation of Yum was not cleaned up at the time.
Vi/etc/nsswitch.conf
Hosts:files NDS-->hosts:files
Test Tnsping,lsnrctl and other commands, speed OK
[Oracle@sql "]$ tnsping ORCL

TNS Ping Utility for linux:version 11.2.0.1.0-production on 28-oct-2015 01:58:30

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES Adapter to resolve the alias
Attempting to contacts (DESCRIPTION = (address = (PROTOCOL = TCP) (HOST = 192.168.2.162) (PORT = 1521)) (Connect_data = (serv ER = dedicated) (Service_Name = Orcl. Sql.xifenfei.com)))
OK (Ten msec)
For this type of slow listening problem, you can further trace the client/server end trace
Trace_level_client = 16
Trace_file_client = Client/server
trace_directory_client = [Any valid DIRECTORY path]
Trace_timestamp_client = On
Diag_adr_enabled=off

Contact: Mobile Phone (13429648788) QQ (107644445) QQ Advisory Cherish Division fly
Title: Http://www.xifenfei.com/2015/10/dns parsing causes opiodr-aborting-process-unknown-ospid-7266-as-a-result-of-ora-609 to resemble an error. html