专注业务连续性支持与数据保护
2013-11-17技术合集

关于VIP的奇怪故障一例已关闭评论

关于VIP的奇怪故障一例

OS：HP-UX 11.31 DB:Oracle 10.0.2.5 RAC （2nodes）

问题描述：节点二在服务启动后，经过1分钟至3分钟会发生VIP导致的服务切换，切换后节点二VIP在节点一上启动，检查日志主要报错为：

1

Invalid parameters, or failed to bring up VIP (host=essrzc2)

经过检查，系统网关配置正常，响应速度正常，系统日志无异常。开启服务debug后收获如下日志：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121

2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] Checking interface existance
Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] Calling getifbyip
Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] getifbyip:  started for 132.42.37.144
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] Completed getifbyip lan900:801
Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] Completed with initial interface test
Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] Broadcast = 132.42.37.255
<span id="more-707"></span>
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: Mon Dec 16 14:57:03 EAT 2013 [ 21730 ] checkIf: start for if=lan900
Mon Dec 16 14:57:07 EAT 2013 [ 21730 ] checkIf: RX packets checked if=lan900 ok
Mon Dec 16 14:57:07 EAT 2013 [ 21730 ] checkIf: end for if=lan900
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: Mon Dec 16 14:57:07 EAT 2013 [ 21730 ] main: interface is okay, exit success
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/oracle/product/10.2/crs
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcexecut: cmd = /oracle/product/10.2/crs/bin/racgeut -e _USR_ORA_DEBUG=5 54 /oracle/product/10.2/crs/bin/racgvip check essrzc2
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcexecut: rc = 0, time = 4.624s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction: restyp=0 act_typ=2 stat=0
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction: return CLSR_CAA_SUCCESS
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction:  init 0.000s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction:  action ok, 4.653s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction:  post 0.000s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcaction: all 4.653s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: end for resource = ora.essrzc2.vip, action = check, status = 0, time = 4.692s
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrccln: exiting ora.essrzc2.vip refcount=1
 
2013-12-16 14:57:08.192: [    RACG][1] [21721][1][ora.essrzc2.vip]: clsrcprsrgter: gctx-&gt;prsrcfgref_clsrcgctx = 0
2013-12-16 14:57:38.420: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcprsrgini: gctx-&gt;prsrcfgref_clsrcgctx = 0
2013-12-16 14:57:38.420: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcini_ext: starting ora.essrzc2.vip refcount=1 global
 
2013-12-16 14:57:38.421: [    RACG][1] [21974][1][ora.essrzc2.vip]: begin for resource = ora.essrzc2.vip, action = check
 
2013-12-16 14:57:38.428: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrccssgetctx: all 0.007s
 
2013-12-16 14:57:38.436: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcgetprsrctx: all 0.015s
 
2013-12-16 14:57:38.448: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcnodeapp: prsr num_env = 0
 
2013-12-16 14:57:38.449: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcnodeapp: setting ORACLE_CONFIG_HOME=/oracle/product/10.2/crs
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Unable to get IPv6 interface information.
Permission denied to 127.0.0.1
cmviewcl: Cannot view the cluster configuration: Permission denied.
This user doesn't have access to view the cluster configuration.
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] Checking interface existance
Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] Calling getifbyip
Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] getifbyip:  started for 132.42.37.144
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] Completed getifbyip lan900:801
Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] Completed with initial interface test
Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] Broadcast = 132.42.37.255
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Mon Dec 16 14:57:38 EAT 2013 [ 21979 ] checkIf: start for if=lan900
Mon Dec 16 14:57:42 EAT 2013 [ 21979 ] checkIf: RX packets checked if=lan900 failed
Interface lan900 checked failed (host=essrzc2)
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Mon Dec 16 14:57:42 EAT 2013 [ 21979 ] checkIf: end for if=lan900
Mon Dec 16 14:57:42 EAT 2013 [ 21979 ] Performing CRS_STAT testing
Mon Dec 16 14:57:42 EAT 2013 [ 21979 ] Completed CRS_STAT testing
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Mon Dec 16 14:57:43 EAT 2013 [ 21979 ] Completed second gateway test
Mon Dec 16 14:57:43 EAT 2013 [ 21979 ] Interface tests
Mon Dec 16 14:57:43 EAT 2013 [ 21979 ] DEBUG: FAIL_WHEN_ALL_LINK_DOWN = 1 and IF_USING = lan900
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: Invalid parameters, or failed to bring up VIP (host=essrzc2)
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/oracle/product/10.2/crs
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcexecut: cmd = /oracle/product/10.2/crs/bin/racgeut -e _USR_ORA_DEBUG=5 54 /oracle/product/10.2/crs/bin/racgvip check essrzc2
 
2013-12-16 14:57:43.181: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcexecut: rc = 1, time = 4.731s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcaction: restyp=0 act_typ=2 stat=1
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcaction:  init 0.000s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcaction:  action failed, 4.761s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcaction:  post 0.000s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcaction: all 4.761s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: end for resource = ora.essrzc2.vip, action = check, status = 1, time = 4.801s
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrccln: exiting ora.essrzc2.vip refcount=1
 
2013-12-16 14:57:43.182: [    RACG][1] [21974][1][ora.essrzc2.vip]: clsrcprsrgter: gctx-&gt;prsrcfgref_clsrcgctx = 0
2013-12-16 14:57:43.434: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcprsrgini: gctx-&gt;prsrcfgref_clsrcgctx = 0
2013-12-16 14:57:43.434: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcini_ext: starting ora.essrzc2.vip refcount=1 global
 
2013-12-16 14:57:43.435: [    RACG][1] [22058][1][ora.essrzc2.vip]: begin for resource = ora.essrzc2.vip, action = stop
 
2013-12-16 14:57:43.466: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrccssgetnodename: all 0.030s
 
2013-12-16 14:57:43.466: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcnodeapps: calling FAILSRVSA
2013-12-16 14:57:43.483: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcrundetach: cmd = /oracle/product/10.2/crs/bin/racgmain ora.essrzc2.vip rundetach  1 failsrvsa essrzc2, rc = 0, time = 0.016s
 
2013-12-16 14:57:43.483: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcnodeapps: Posting PNWDOWN_EVENT
 
2013-12-16 14:57:43.484: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrccssgetnodename: all 0.000s
 
2013-12-16 14:57:43.484: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrccssgetnodename: all 0.000s
 
2013-12-16 14:57:43.484: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcssgetrhost: using cached local host name
 
2013-12-16 14:57:43.486: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrccssgetlhost: all 0.002s
 
2013-12-16 14:57:43.493: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcpostevt: EvmEventPost 1 0.001s
 
2013-12-16 14:57:43.493: [    RACG][1] [22058][1][ora.essrzc2.vip]: clsrcposthaevt: forward to EVM
2013-10-23技术合集

MySQL在ARM平台上的编译错误一例已关闭评论

MySQL在ARM平台上的编译错误一例

由于ARM平台开发板CPU本身处理能力有限，这样在MySQL编译的时候过程非常漫长，更可恶的还出现了错误，如下：

1
2
3
4
5
6
7
8
9
10

[ 68%] Building C object libmysql/CMakeFiles/clientlib.dir/__/sql-common/client_plugin.c.o
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c: In function ‘mysql_client_plugin_init’:
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c:252:5: error: incompatible type for argument 5 of ‘add_plugin’
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c:120:1: note: expected ‘va_list’ but argument is of type ‘int’
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c: In function ‘mysql_client_register_plugin’:
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c:310:5: error: incompatible type for argument 5 of ‘add_plugin’
/root/lnmp1.0-full/mysql-5.5.28/sql-common/client_plugin.c:120:1: note: expected ‘va_list’ but argument is of type ‘int’
make[2]: *** [libmysql/CMakeFiles/clientlib.dir/__/sql-common/client_plugin.c.o] Error 1
make[1]: *** [libmysql/CMakeFiles/clientlib.dir/all] Error 2
make: *** [all] Error 2

处理方法如下应用下面Patch，文件名arm_fix_client_plugin.patch，内容：
继续阅读 »

2013-09-12技术合集

ORA-65086: cannot open/close the pluggable database已关闭评论

ORA-65086: cannot open/close the pluggable database

在Oracle 12C中执行卸载命令后，如果执行PDB的OPEN操作，将会提示错误，如下：

1
2
3
4
5
6
7
8

SQL> alter pluggable database pdb01 unplug into '/opt/oracle/pdb01.xml';
 
Pluggable database altered.
 
SQL> ALTER PLUGGABLE DATABASE pdb01 OPEN;
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database

继续阅读 »

2013-09-05关注学习

Windows 7 自定义锁屏、登录背景已关闭评论

Windows 7 自定义锁屏、登录背景

1. 进入注册表，找到“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Authentication\LogonUI\
Background”，找到一个名为“OEMBackground”的DWORD，修改值为“1”。

2. 在“运行”中输入gpedit.msc，打开组策略编辑器，在目录“计算机配置-管理模块-系统-登录”中找到“始终使用自定义登录背景”项，哈哈，终于找到这个隐藏的家伙了，双击，在编辑页面选择“已启用”，保存设置。

3. 接下来就是用自选的壁纸替代系统默认的那张了，先找到放锁屏壁纸的目录，原来他在这里：C:\Windows\System32\oobe\info\backgrounds；默认情况下info\backgrounds目录是不存在的，我们需要自己新建这两个文件夹

4. 将自选的锁屏壁纸命名为backgroundDefault.jpg，放入第3步说明的backgrounds文件夹中，OK! 无需重启电脑，即刻生效

2013-08-31技术合集

crs_stop 错误一列已关闭评论

crs_stop 错误一列

grid 与 oracle 版本为11.2.0.4，为两节点RAC，在通过crs_stop -all命令关闭oracle服务时出现下面问题：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

[oracle@rac01 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE               
ora.FRA.dg     ora....up.type OFFLINE   OFFLINE               
ora....ER.lsnr ora....er.type OFFLINE   OFFLINE               
ora....N1.lsnr ora....er.type OFFLINE   OFFLINE               
ora.OCR.dg     ora....up.type OFFLINE   OFFLINE               
ora.asm        ora.asm.type   OFFLINE   ONLINE    rac02       
ora.cvu        ora.cvu.type   OFFLINE   OFFLINE               
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type OFFLINE   OFFLINE               
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE               
ora.ons        ora.ons.type   OFFLINE   OFFLINE               
ora.rac.db     ora....se.type OFFLINE   OFFLINE               
ora....SM1.asm application    OFFLINE   ONLINE    rac01       
ora....01.lsnr application    OFFLINE   OFFLINE               
ora.rac01.gsd  application    OFFLINE   OFFLINE               
ora.rac01.ons  application    OFFLINE   OFFLINE               
ora.rac01.vip  ora....t1.type OFFLINE   OFFLINE               
ora....SM2.asm application    OFFLINE   ONLINE    rac02       
ora....02.lsnr application    OFFLINE   OFFLINE               
ora.rac02.gsd  application    OFFLINE   OFFLINE               
ora.rac02.ons  application    OFFLINE   OFFLINE               
ora.rac02.vip  ora....t1.type OFFLINE   OFFLINE               
ora....ry.acfs ora....fs.type OFFLINE   OFFLINE               
ora.scan1.vip  ora....ip.type OFFLINE   OFFLINE

继续阅读 »

2013-06-27技术合集

Oracle Database 12C 体验已关闭评论

Oracle Database 12C 体验

oracle版本：12.1.0.1.0
redhat版本：RedHat EL5.6 x64

安装过程分以下四个步骤

一，安装准备
二，下载安装
三，过程详解
四，常见错误

一，安装准备
1，创建oracle用户
继续阅读 »

2013-05-18关注学习

开放硬件平台已关闭评论

开放硬件平台

最近开始对开发板关注起来，罗列一下

1、Raspberry Pi
中文名：树莓派
基本配置：700MHz处理器，带有GPU，512MB内存，双USB口，一个100M网络接口，HDMI接口。
特性特点：基于linux的卡片大小的微电脑，可播放高清视频，有USB、网络、HDMI接口。
参考价格：280人民币 （红色为国内生产，较便宜，绿色版为英国生产）
购买地址：http://detail.tmall.com/item.htm?spm=a230r.1.14.3.R7cDm7&id=17337394004
官方网站：http://www.raspberrypi.org/
中文社区：http://www.eeboard.com/bbs/forum-43-1.html

2、Cubieboard
基本配置：1GHz处理器，带有GPU，1GB内存，双USB口，一个100M网络接口，HDMI接口，SATA接口。
特性特点：基于linux的卡片大小的微电脑，可播放高清视频，比Raspberry Pi多个sata硬盘接口。
参考价格：350人民币
购买地址：http://item.taobao.com/item.htm?spm=a230r.1.14.90.W4aJR2&id=22173848049
官方网站：http://cubieboard.org/
继续阅读 »

« 更早的文章 较新的文章 »