Terminating the instance due to error 119

RAC installation process all normal, after the shutdown restart, GI boot normal, the instance did not rise.

[Email protected] network-scripts]# crsctl stat res-t

--------------------------------------------------------------------------------

NAME TARGET State SERVER State_details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

Ora. Data.dg

Online online Rac1

Online online Rac2

Ora. Fra.dg

Online online Rac1

Online online Rac2

Ora. Listener.lsnr

Online online Rac1

Online online Rac2

Ora. Ocr.dg

Online online Rac1

Online online Rac2

Ora.asm

Online online Rac1 Started

Online online Rac2 Started

Ora.gsd

OFFLINE OFFLINE Rac1

OFFLINE OFFLINE RAC2

Ora.net1.network

Online online Rac1

Online online Rac2

Ora.ons

Online online Rac1

Online online Rac2

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

Ora. Listener_scan1.lsnr

1 Online Online Rac1

Ora. Listener_scan2.lsnr

1 Online Online Rac2

Ora. Listener_scan3.lsnr

1 Online Online Rac2

Ora.cvu

1 Online Online Rac2

Ora.oc4j

1 Online Online Rac2

Ora.rac.db

1 ONLINE OFFLINE Instance Shutdown

2 ONLINE OFFLINE Instance Shutdown

Ora.rac1.vip

1 Online Online Rac1

Ora.rac2.vip

1 Online Online Rac2

Ora.scan1.vip

1 Online Online Rac1

Ora.scan2.vip

1 Online Online Rac2

Ora.scan3.vip

1 Online Online Rac2

Check the database log immediately, the following discovery

[Email protected] trace]$ tail-200f Alert_rac1.log

USER (ospid:3610): Terminating the instance due to error 119

Instance terminated by USER, PID = 3610

Forcing the line to start?

[Email protected] ~]# srvctl start database-d RAC

PRCR-1079: Unable to start resource ora.rac.db

Crs-5017:the Resource Action "ora.rac.db start" encountered the following error:

ORA-00119:INVALID specification for system parameter Remote_listener

Ora-00132:syntax error or unresolved network name ' rac-scan.us.oracle.com:1521 '

. For details refer to "(: CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac2/agent/crsd/oraagent_oracle/oraagent_ Oracle.log ".

Crs-5017:the Resource Action "ora.rac.db start" encountered the following error:

ORA-00119:INVALID specification for system parameter Remote_listener

Ora-00132:syntax error or unresolved network name ' rac-scan.us.oracle.com:1521 '

. For details refer to "(: CLSN00107:)" in "/u01/app/11.2.0/grid/log/rac1/agent/crsd/oraagent_oracle/oraagent_ Oracle.log ".

Crs-2674:start of ' ora.rac.db ' on ' RAC2 ' failed

Crs-2674:start of ' ora.rac.db ' on ' Rac1 ' failed

Crs-2632:there is no more servers to try to place resource ' ora.rac.db ' on the would satisfy its placement policy

Notice that the error message mentions Ora-00132:syntax error or unresolved network name ' rac-scan.us.oracle.com:1521 ', isn't it?

Anyway, with the network, first tnsping.

[Email protected] ~]$ tnsping RAC2

TNS Ping Utility for linux:version 11.2.0.4.0-production on 09-dec-2015 00:56:12

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

Used parameter files:

/u01/app/11.2.0/grid/network/admin/sqlnet.ora

Used Ezconnect Adapter to resolve the alias

Attempting to contact (description= (connect_data= (service_name=)) (Address= (PROTOCOL=TCP) (host=192.168.56.12) (PORT =1521)))

OK (0 msec)

Looks like there's no problem with listening.

Don't worry, take another look Tnsnames.ora

[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.

RAC =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = rac-scan.us.oracle.com) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = RAC)

)

)

[[email protected] ~]# Ping rac-scan.us.oracle.com

Ping:unknown Host Rac-scan.us.oracle.com

This is a problem, I am configured in the DNS domain name how can not be reached? All functions are normal at the time of installation!

[email protected] ~]# nslookup rac-scan.us.oracle.com

Server:192.168.1.1

Address:192.168.1.1#53

* * Server can ' t find Rac-scan.us.oracle.com:nxdomain

More problematic, how does the DNS server become 192.168.1.1?

Against all DNS configuration files, an exception was found for the

[Email protected] ~]# cat/etc/resolv.conf

; Generated By/sbin/dhclient-script

NameServer 192.168.1.1

NameServer 192.168.0.1

How did you get back to the initial configuration of the operating system? This will refer to a different configuration file

[email protected] network-scripts]# cat Ifcfg-eth0

Device=eth0

Type=ethernet

Onboot=yes

Nm_controlled=yes

Bootproto=dhcp

Defroute=yes

Peerdns=yes

Peerroutes=yes

Ipv4_failure_fatal=yes

Ipv6init=no

Name= "System eth0"

Userctl=no

Notice the Peerdns=yes one of these?

In the 5.0 era the DNS server was written in the/etc/resolv.conf file, but in the 6.0 era DNS can be written in/etc/resolv.conf but at this point it needs to be in/etc/sysconfig/network-scripts/ The Peerdns=no configuration is added to the Ifcfg-eth0 file, or the contents of the/etc/resolv.conf file are rewritten each time the NIC is restarted.

Http://blog.chinaunix.net/uid-26495963-id-3230810.html

Terminating the instance due to error 119