问题：

数据库启动报错：ORA-00119、ORA-00132等

环境：

DB:Oracle 11.2.0.4.0

OS:Redhat 6.5

问题现象：

启动数据库报错：

[grid@rac01 ~]$ srvctl start database -d cjcdb

PRCR-1079:Failedtostartresourceora.cjcdb.dbCRS-5017:Theresourceaction"ora.cjcdb.dbstart"encounteredthefollowingerror:ORA-00119:invalidspecificationforsystemparameterREMOTE_LISTENERORA-00132:syntaxerrororunresolvednetworkname'rac-scan.cjc.com:1521'.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/11.2.0/grid/log/rac02/agent/crsd/oraagent_oracle/oraagent_oracle.log".CRS-5017:Theresourceaction"ora.cjcdb.dbstart"encounteredthefollowingerror:ORA-00119:invalidspecificationforsystemparameterREMOTE_LISTENERORA-00132:syntaxerrororunresolvednetworkname'rac-scan.cjc.com:1521'.Fordetailsreferto"(:CLSN00107:)"in"/u01/app/11.2.0/grid/log/rac01/agent/crsd/oraagent_oracle/oraagent_oracle.log".CRS-2674:Startof'ora.cjcdb.db'on'rac02'failedCRS-2674:Startof'ora.cjcdb.db'on'rac01'failedCRS-2632:Therearenomoreserverstotrytoplaceresource'ora.cjcdb.db'onthatwouldsatisfyitsplacementpolicy

其中remote_listener参数值为：rac-scan.cjc.com:1521

怀疑DNS解析SCAN失败

登录到rac01执行nslookup rac-scan.cjc.com

[root@rac01bin]#nslookuprac-scan.cjc.com;;connectiontimedout;tryingnextorigin;;connectiontimedout;noserverscouldbereached

查看resolv.conf配置信息被清空了，实际上每次服务器重启网卡resolv.conf配置都会被自动清空

[root@rac01bin]#cat/etc/resolv.conf#GeneratedbyNetworkManagernameserver8.8.8.8

检查网卡配置文件里没有指定90的DNS，手动添加90DNS。

[root@rac02bin]#cd/etc/sysconfig/network-scripts/[root@rac02network-scripts]#vimifcfg-eth0DNS1="192.168.31.90"

重新添加resolv.conf配置信息

[root@rac01bin]#vim/etc/resolv.conf#GeneratedbyNetworkManagernameserver8.8.8.8domaincjc.comnameserver192.168.31.90optionsrotateoptionstimeout:2optionsattempts:5

可以正常解析了

[root@rac01bin]#nslookuprac-scan.cjc.comServer:192.168.31.90Address:192.168.31.90#53Name:rac-scan.cjc.comAddress:192.168.31.60Name:rac-scan.cjc.comAddress:192.168.31.70Name:rac-scan.cjc.comAddress:192.168.31.50

启动数据

[root@rac01bin]#./srvctlstartinstance-dcjcdb-icjcdb1[root@rac01bin]#./srvctlstartinstance-dcjcdb-icjcdb2

检查实例状态

[root@rac01bin]#./srvctlstatusdatabase-dcjcdbInstancecjcdb1isrunningonnoderac01Instancecjcdb2isrunningonnoderac02

欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！