oracle 11gr2 Rac for linux因节点未做DNS解析造成实例无法启动的问题,分析与解决过程
[oracle@rhel1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DBFILE.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.FRA.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.LISTENER.lsnr
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.OCRVDISK.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.asm
ONLINE ONLINE rhel1 Started
ONLINE ONLINE rhel2 Started
ora.eons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.gsd
OFFLINE OFFLINE rhel1
OFFLINE OFFLINE rhel2
ora.net1.network
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.ons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.registry.acfs
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rhel1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rhel2
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rhel2
ora.oc4j
1 OFFLINE OFFLINE
ora.rac.db
1 ONLINE ONLINE rhel1 Open
2 ONLINE OFFLINE Instance Shutdown
ora.rhel1.vip
1 ONLINE ONLINE rhel1
ora.rhel2.vip
1 ONLINE ONLINE rhel2
ora.scan1.vip
1 ONLINE ONLINE rhel1
ora.scan2.vip
1 ONLINE ONLINE rhel2
ora.scan3.vip
1 ONLINE ONLINE rhel2
rhel2实例状态为 instance shutdown
vi /home/app/oracle/diag/rdbms/rac/rac2/trace/alert_rac2.log
......
......
Sat Nov 17 06:36:06 2012
NOTE: Volume support enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
Using parameter settings in server-side pfile /home/app/oracle/product/11.2.0/db_1/dbs/initrac2.ora
System parameters with non-default values:
processes = 150
spfile = "+DBFILE/rac/spfilerac.ora"
memory_target = 804M
control_files = "+DBFILE/rac/controlfile/current.260.799089935"
control_files = "+FRA/rac/controlfile/current.256.799089939"
db_block_size = 8192
compatible = "11.2.0.0.0"
cluster_database = TRUE
db_create_file_dest = "+DBFILE"
db_recovery_file_dest = "+FRA"
db_recovery_file_dest_size= 2000M
thread = 2
undo_tablespace = "UNDOTBS2"
instance_number = 2
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=racXDB)"
remote_listener = "rhel-cluster-scan.grid.example.com:1521"
audit_file_dest = "/home/app/oracle/admin/rac/adump"
audit_trail = "DB"
db_name = "rac"
open_cursors = 300
diagnostic_dest = "/home/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
10.10.10.2
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Sat Nov 17 06:37:46 2012
USER (ospid: 7878): terminating the instance due to error 119
报error 119的错误
通过sqlplus 去分步启动实例,看看有何报错
[oracle@rhel2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 17 07:31:37 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup nomount;
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'rhel-cluster-scan.grid.example.com:1521'
SQL>
问题找到了,是初始化服务器参数有问题
看一下rhel2节点2的/etc/hosts
[oracle@rhel2 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#public IP
192.168.1.61 rhel1 rhel1.example.com
192.168.1.62 rhel2 rhel2.example.com
#private IP
10.10.10.1 rhel1-priv
10.10.10.2 rhel2-priv
#virtual IP
192.168.1.161 rhel1-vip
192.168.1.162 rhel2-vip
根本的问题已经找到,DNS服务器未在节点2上做解析
添加解析如下:
vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#public IP
192.168.1.61 rhel1 rhel1.example.com rhel-cluster-scan.grid.example.com
192.168.1.62 rhel2 rhel2.example.com
#private IP
10.10.10.1 rhel1-priv
10.10.10.2 rhel2-priv
#virtual IP
192.168.1.161 rhel1-vip
192.168.1.162 rhel2-vip
重新启动实例
[root@rhel2 trace]# su - oracle
[oracle@rhel2 ~]$ srvctl start instance -d rac -i rac2
[oracle@rhel2 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DBFILE.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.FRA.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.LISTENER.lsnr
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.OCRVDISK.dg
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.asm
ONLINE ONLINE rhel1 Started
ONLINE ONLINE rhel2 Started
ora.eons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.gsd
OFFLINE OFFLINE rhel1
OFFLINE OFFLINE rhel2
ora.net1.network
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.ons
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
ora.registry.acfs
ONLINE ONLINE rhel1
ONLINE ONLINE rhel2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rhel1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rhel2
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rhel2
ora.oc4j
1 OFFLINE OFFLINE
ora.rac.db
1 ONLINE ONLINE rhel1 Open
2 ONLINE ONLINE rhel2 Open
ora.rhel1.vip
1 ONLINE ONLINE rhel1
ora.rhel2.vip
1 ONLINE ONLINE rhel2
ora.scan1.vip
1 ONLINE ONLINE rhel1
ora.scan2.vip
1 ONLINE ONLINE rhel2
ora.scan3.vip
1 ONLINE ONLINE rhel2
[oracle@rhel2 ~]$
问题得到了解决,11gr2的rac处于正常工作状态!
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/40976/viewspace-1059786/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/40976/viewspace-1059786/