给同事讲10g RAC，今天是第二天， 每天2小时左右，中间休息10分钟。

现在是脖子也僵硬了，嗓子也疼。

难受啊。这才2天，那些老师，天天过这个日子，怎么过的啊

小徐怎么过的？弱水又怎么过的呢？

你们嗓子不难受啊？

刚刚整理通讯录

发现了一个已经过世的朋友的电话号码，静静的躺在那里。

我一时居然不知如何处理。

留着？恐怕这个号码已经停机了吧。就算没停，难道我还会再打吗？

删除？删除了，这个人就算彻底的再我生活里消失了。以后我都不会想起他。

 

最后，还是删除了。。。

看了看自己以前在blogcn的博客，80多篇文章吧，很多当初没有转过来。现在时过境迁，也没有转的必要了。

想想03年的那段时间，真是感慨万千啊

好像平时的工作就是出差、出差再出差，blog里的文章也经常和出差有关。

 

明天又出差了，这是今年的第一次，大概2天吧。

快4年了，公司的出差补助还是没什么变化。90块的住宿标准，让我去吉林市，都不知道住什么地方好。

由奢如简易，由简入奢难。当年在通化住10块钱一位的人民旅社，也没觉得怎么样。现在恐怕给我钱我都不会去住了。

 

人往往是这样，受苦的时候，并没觉得怎么样，反而乐在其中。事后想起来，才唏嘘不已。

这算是老了的表现吧。

[root@rac1 ocfs]# load_ocfs
/sbin/modprobe ocfs node_name=rac1 ip_address=192.168.3.210 cs=1824 guid=FC91738
 6F59476DBA168000C297C55E3 ip_port=7000 comm_voting=1
modprobe: Can't locate module ocfs
load_ocfs: insmod failed

看提示应该是找不到ocfs模块
[root@rac1 ocfs]# find /lib -name ocfs.o
/lib/modules/2.4.21-47.EL/kernel/drivers/addon/ocfs/ocfs.o
/lib/modules/2.4.21-EL-ABI/ocfs/ocfs.o

 

[root@rac1 ocfs]# vi /sbin/load_ocfs
[root@rac1 ocfs]# load_ocfs
/sbin/insmod /lib/modules/2.4.21-EL-ABI/ocfs/ocfs.o node_name=rac1 ip_address=19
 2.168.3.210 cs=1824 guid=FC917386F59476DBA168000C297C55E3 ip_port=7000 comm_vot
i ng=1
Warning: kernel-module version mismatch
        /lib/modules/2.4.21-EL-ABI/ocfs/ocfs.o was compiled for kernel version 2
 .4.21-27.EL
        while this kernel is version 2.4.21-47.EL
Warning: loading /lib/modules/2.4.21-EL-ABI/ocfs/ocfs.o will taint the kernel: f
 orced load
  See http://www.tux.org/lkml/#export-tainted for information about tainted modu
 les
Module ocfs loaded, with warnings

 

[root@rac1 root]# lsmod
Module                  Size  Used by    Tainted: PF
ocfs                  299104   0  (unused)
mousedev                5524   1  (autoclean)
input                   5888   0  (autoclean) [mousedev]
audit                  89944   2  (autoclean)
usbserial              23292   0  (autoclean) (unused)
usbcore                77600   0  (autoclean) [usbserial]
parport_pc             18756   1  (autoclean)
lp                      8964   0  (autoclean)
parport                36832   1  (autoclean) [parport_pc lp]
autofs4                16248   0  (autoclean) (unused)
ide-cd                 33920   0  (autoclean)
cdrom                  32416   0  (autoclean) [ide-cd]
vmhgfs                 38924   0
vmxnet                  8268   2
floppy                 56624   0  (autoclean)
sg                     36140   0  (autoclean)
microcode               5688   0  (autoclean)
ext3                   85864   2
jbd                    50956   2  [ext3]
mptscsih               40140   3
mptbase                47028   3  [mptscsih]
diskdumplib             4940   0  [mptscsih mptbase]
sd_mod                 14064   6
scsi_mod              107308   3  [sg mptscsih sd_mod]
ocfs模块载入成功。

错误代码：

Red Hat Enterprise Linux AS release 3 (Taroon Update 8)
Kernel 2.4.21-47.EL on an i686
login: oracle
Password:
Last login: Tue Mar  6 13:51:21 from 192.168.3.72
[oracle@shigl oracle]$
[oracle@shigl oracle]$
[oracle@shigl oracle]$ uname -a
Linux shigl 2.4.21-47.EL #1 Wed Jul 5 20:46:55 EDT 2006 i686 i686 i386 GNU/Linux
[oracle@shigl oracle]$ sqlplus / as sysdba

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Mar 6 14:05:31 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod
PL/SQL Release 10.1.0.3.0 - Production
CORE    10.1.0.3.0      Production
TNS for Linux: Version 10.1.0.3.0 - Production
NLSRTL Version 10.1.0.3.0 - Production

SQL> create user shigl identified by shigl;
create user shigl identified by shigl
            *
ERROR at line 1:
ORA-01920: user name 'SHIGL' conflicts with another user or role name

SQL> !     
[oracle@shigl oracle]$ exp shigl/shigl file=test.dmp log=test.log

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_SITES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_LWM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REPCAT_RGT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_TRANSFORM_EXIMP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_TRANSFORM_EXIMP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_AQ_EXP_QUEUE_TABLES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUE_TABLES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_SCHED_EXPORT_CALLOUTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_SCHED_EXPORT_CALLOUTS.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_CDC_EXPDP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_CDC_EXPDP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_AW_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_RULE_EXP_RULES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REPCAT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_LOGREP_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_CDC_EXPVDP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_CDC_EXPVDP.schema_info_exp
. exporting foreign function library names for user SHIGL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SHIGL
About to export SHIGL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SHIGL's tables via Conventional Path ...
. . exporting table                            SYS
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 31:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
. . exporting table                           TEST
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_SITES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_LWM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REPCAT_RGT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_TRANSFORM_EXIMP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_TRANSFORM_EXIMP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_AQ_EXP_QUEUE_TABLES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUE_TABLES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_SCHED_EXPORT_CALLOUTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_SCHED_EXPORT_CALLOUTS.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_CDC_EXPDP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_CDC_EXPDP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_AW_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_RULE_EXP_RULES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REPCAT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_LOGREP_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_CDC_EXPVDP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_CDC_EXPVDP.schema_info_exp
. exporting statistics
Export terminated successfully with warnings.
[oracle@shigl oracle]$ exit
exit

SQL> drop table sys;
drop table sys
           *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> drop table shigl.sys;

Table dropped.

SQL> !
[oracle@shigl oracle]$ exp shigl/shigl file=test.dmp log=test.log

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SHIGL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SHIGL
About to export SHIGL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SHIGL's tables via Conventional Path ...
. . exporting table                           TEST          3 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
[oracle@shigl oracle]$ exit
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

Oracle RAC安装的一个重要准备工作就是双机对等的配置。

其实这个工作很简单，主要分三步。

1.启动相应的服务，比如rlogin和rsh，rexec等。（一般我用到telent，rlogin，rsh，rexec等，已经确定的是，如果不启动rsh服务，则rcp命令不好用）

2.配置/etc/hosts，这个是让主机通过主机名找到相应的ip

3.配置/etc/hosts.equiv，这个是让主机确认那些主机是可以信任的。

   里面直接写可以新人的主机名就行。