天空极速

启动mysql提示Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
或
110818  7:20:33 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 481 error messages.
Check that the above file is the right version for this program!
110818  7:20:33 [ERROR] Aborting

根据错误提示，发现是errmsg.sys文件和升级后的软件版本不一致导致。
解决：
1、查看本机安装的mysql版本，然后到http://downloads.mysql.com/archives.php寻找下载对应的mysql版本，解压后，将mysq-x.x.x/sql/share/english/errmsg.sys拷贝到系统的/usr/share/mysql/english/下，覆盖同名errmsg.sys文件（建议覆盖前备份一份）即可。

2、执行

3、启动mysql

安装oracle 10g的过程中弹出窗口提示：
Error in invoking target 'all_no_orcl ihsodbc' of makefile
'/oracle/product/10g/rdbms/lib/ins_rdbms.mk'.
See '/oracle/oraInventory/logs/installActions2009-12-01_11-55-10AM.log' for details.

原因：
这个错误是和编译有关的，检查日志发现果然缺少了一个C的类库：
INFO: /usr/lib/libstdc++.so.5: No such file or directory

解决：安装compat-libstdc++-33
# yum install compat-libstdc++-33

Retry即可。

在Linux的X window里安装oracle，弹出的oracle界面为乱码（方块）
原因：oracle安装默认没有中文语言包，只有用英文了。
解决：
1、临时解决：
$ export LANG=en_US
2、永久解决：
# vi /etc/sysconfig/i18n
LANG="en_US"（不会出现乱码）
LANG="zh_cn.UTF-8"（中文，安装oracle会出现界面乱码的现象）

下载到oracle10g的压缩包，文件名为：10201_database_linux_x86_64.cpio.gz
第一次遇到这种格式的压缩包，不知道怎样解压。
网上搜了一下，现在知道该怎么解包了：
1、
解压后会被替换成10201_database_linux_x86_64.cpio文件。
2、展开10201_database_linux_x86_64.cpio

最后得到的是一个叫database的目录，即解包成功。

使用迅雷新建任务下载地址填写

就可以下载到你想要的补丁了。

9.2.0.4  = 3095277
9.2.0.5  = 3501955
9.2.0.6  = 3948480
9.2.0.7  = 4163445
9.2.0.8  = 4547809（9i最终）
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189
10.2.0.5 = 8202632


下载补丁时，可进入cmd，使用ftp命令直接登录网站下载。相同版本，针对不同的操作系统，会有不同的补丁。每个补丁大小约在500MB~1.3GB之间。下面以oracle 10.2.0.2 补丁为例：
ftp updates.oracle.com
user metalib_user 输入密码
cd 4547817
dir

p4547817_10202_AIX64-5L.zip
p4547817_10202_HP64.zip
p4547817_10202_HPUX-IA64.zip
p4547817_10202_LINUX.zip
p4547817_10202_Linux-IA64.zip
p4547817_10202_Linux-x86-64.zip
p4547817_10202_MVS.zip
p4547817_10202_SOLARIS.zip
p4547817_10202_SOLARIS64.zip
p4547817_10202_WINNT.zip
p4547817_10202_WINNT64.zip

使用mget命令下载即可。

结合迅雷,可以取得事半功倍的效果,链接如下：

oracle 9206 patchset:
ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip

oracle 9207patchset:
ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-x86-64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_MVS.zip
ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS.zip
ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip
ftp://updates.oracle.com/4163445/p4163445_92070_WINNT64.zip (无)

oracle 9208 patch:
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip

下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz

Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip

Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip

oracle 10.2.0.4 patch:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip

Oracle Database 10g、11g Release
http://www.oracle.com/technology/software/products/database/index.html

Oracle Database 11g Release 1(11.1.0.6.0)
下载地址: http://www.oracle.com/technology/software/products/database/index.html
文档：http://www.oracle.com/technology/global/cn/documentation/index.html

Oracle9i下载地址
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip

Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip

Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz

Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk3.cpio.gz

Oracle9i Database Release 2 Enterprise/Standard Edition for AIX - Based 4.3.3 Systems (64-bit)
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk1.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk2.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk3.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk4.cpio.gz

Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99332-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99333-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99334-01.zip

Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit)
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk3.cpio.gz

Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit)
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk3.cpio.gz



###########################

oracle 11g 11.2.0.2 patch

###########################

AIX 64bit (6.8G)

ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_1of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_2of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_3of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_4of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_5of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_6of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_AIX64-5L_7of7.zip

HP-UX IA64 (6.6G)

ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_1of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_2of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_3of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_4of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_5of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_6of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_HPUX-IA64_7of7.zip

Linux 32bit (4.8G)

ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_1of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_2of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_3of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_4of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_5of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_6of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_LINUX_7of7.zip


Linux 64bit (4.7G)

ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_1of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_2of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_3of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_4of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_5of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_6of7.zip
ftp://updates.oracle.com/10098816/p10098816_112020_Linux-x86-64_7of7.zip



###########################

oracle 11g 11.1.0.7 patch

###########################

ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_AIX5L_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-64_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_1of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_HPUX-IA64_2of2.zip
ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86-64.zip
ftp://updates.oracle.com/6890831/p6890831_111070_Linux-x86.zip
ftp://updates.oracle.com/6890831/p6890831_111070_MSWIN-x86-64.zip


###########################

oracle 10.2.0.5 patch

###########################

ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86-64.zip
ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86.zip
ftp://updates.oracle.com/8202632/p8202632_10205_MSWIN-x86-64.zip
ftp://updates.oracle.com/8202632/p8202632_10205_WINNT.zip


###########################

ooracle 10.2.0.4 patch

###########################

ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_LINUX.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip



###########################

ooracle 10.2.0.3 patch

###########################

ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_AIX5L.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86-64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_HPUX-IA64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_LINUX.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86.zip



###########################

ooracle 10.2.0.2 patch

############################

ftp://updates.oracle.com/4547817/p4547817_10202_AIX64-5L.zip
ftp://updates.oracle.com/4547817/p4547817_10202_HP64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_HPUX-IA64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_LINUX.zip
ftp://updates.oracle.com/4547817/p4547817_10202_Linux-IA64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_Linux-x86-64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_MVS.zip
ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS.zip
ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_WINNT.zip
ftp://updates.oracle.com/4547817/p4547817_10202_WINNT64.zip



###########################

oracle 9208 patch

###########################

ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip


############################

oracle 9207 patch

###########################

ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-x86-64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_MVS.zip
ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS.zip
ftp://updates.oracle.com/4163445/p4163445_92070_SOLARIS64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_WINNT.zip


###########################

oracle 9206 patch

###########################

ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip