Shulou(Shulou.com)06/01 Report--

Question:

Database startup error: ORA-00119, ORA-00132, etc.

Environment:

DB:Oracle 11.2.0.4.0

OS:Redhat 6.5

Problem phenomenon:

Start the database error:

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

PRCR-1079: Failed to start resource ora.cjcdb.dbCRS-5017: The resource action "ora.cjcdb.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENERORA-00132: syntax error or unresolved network name 'rac-scan.cjc.com:1521'. For details refer to "(: CLSN00107:)" in "/ u01/app/11.2.0/grid/log/rac02/agent/crsd/oraagent_oracle/oraagent_oracle.log" .CRS-5017: The resource action "ora.cjcdb.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENERORA-00132: syntax error or unresolved network name 'rac-scan.cjc.com:1521'. For details refer to "(: CLSN00107:)" in "/ u01/app/11.2.0/grid/log/rac01/agent/crsd/oraagent_oracle/oraagent_oracle.log" .CRS-2674: Start of 'ora.cjcdb.db' on' rac02' failedCRS-2674: Start of 'ora.cjcdb.db' on' rac01' failedCRS-2632: There are no more servers to try to place resource 'ora.cjcdb.db' on that would satisfy its placement policy

Where the parameter value of remote_listener is: rac-scan.cjc.com:1521

Suspect that DNS failed to parse SCAN

Log in to rac01 to execute nslookup rac-scan.cjc.com

[root@rac01 bin] # nslookup rac-scan.cjc.com;; connection timed out; trying next origin;; connection timed out; no servers could be reached

Check that the resolv.conf configuration information is emptied. In fact, every time the server restarts the Nic resolv.conf configuration will be emptied automatically.

[root@rac01 bin] # cat / etc/resolv.conf# Generated by NetworkManagernameserver 8.8.8.8

Check the DNS that does not specify 90 in the network card configuration file, and add the 90DNS manually.

[root@rac02 bin] # cd / etc/sysconfig/network-scripts/ [root@rac02 network-scripts] # vim ifcfg-eth0DNS1= "192.168.31.90"

Re-add resolv.conf configuration information

[root@rac01 bin] # vim / etc/resolv.conf# Generated by NetworkManagernameserver 8.8.8.8domain cjc.comnameserver 192.168.31.90options rotateoptions timeout:2options attempts:5

It can be parsed normally.

[root@rac01 bin] # nslookup rac-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

Startup data

[root@rac01 bin] #. / srvctl start instance-d cjcdb-I cjcdb1 [root@rac01 bin] #. / srvctl start instance-d cjcdb-I cjcdb2

Check instance status

[root@rac01 bin] #. / srvctl status database-d cjcdbInstance cjcdb1 is running on node rac01Instance cjcdb2 is running on node rac02

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.