Redhat6.4 64位安装Oracle10.2.0.564位数据库

yanfangsheng123

实验环境：
操作系统：Redhat 6.4 64位
数据库：Oracle10.2.0.1 64位安装包 + Oracle10.2.0.5 64位升级包

一、安装前环境准备
1、安装Redhat6.4操作系统
操作系统的具体安装在这里我就不再说了

2、安装介质的准备
Oracle10.2.0.1的安装包：10201_database_linux_x86_64.cpio.gz
Oracle10.2.0.5的升级包：p8202632_10205_Linux-x86-64.zip

3、软硬件环境检查
（1）内存和交换空间检查
[root@seiang10g~]# grepMemTotal /proc/meminfo
MemTotal:        2726460 kB
[root@seiang10g~]# grepSwapTotal /proc/meminfo
SwapTotal:       2736120 kB
[root@seiang10g~]# free -m
             total       used       free    shared    buffers     cached
Mem:      2662       1753        909       0     19         1510
-/+buffers/cache:        222       2440
Swap:         2671          0       2671

（2）磁盘空间检查
[root@seiang10g~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_seiang10g-lv_root
                       47G  4.2G  40G  10% /
tmpfs                 1.4G   72K 1.4G   1% /dev/shm
/dev/sda1             485M   37M 423M   9% /boot
/dev/sr0              3.5G 3.5G     0 100% /mnt/dvd

（3）CPU及系统架构检查
[root@seiang10g~]# grep"model name" /proc/cpuinfo
model name      : Intel(R) Xeon(R) CPU           X3430  @ 2.40GHz
[root@seiang10g~]# uname -a
Linuxseiang10g.comsys.com 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013x86_64 x86_64 x86_64 GNU/Linux

（4）必须安装包的检查
[root@ seiang10gdatabase]# firefoxwelcome.html

官方文档要求如下：

　　    从文档中可以看出Oracle10g只支持到Red Hat Enterprise Linux4.0，并没有明确表示支持Red Hat Enterprise Linux6.0以上的版本. 这是因为Oracle官方并没有在4以后的版本测试过Oracle10g。根据要求，安装相应的安装包。
[root@seiang10g~]# yum installbinutils* compat* control-center* gcc* glibc* gnome-libs* libstdc* make*sysstat* xscreensaver* unixODBC* lib*

4、环境准备
（1）创建组和用户
[root@seiang10g~]# groupaddoinstall
[root@seiang10g~]# groupadd dba
[root@seiang10g~]# useradd -goinstall -G dba oracle
[root@seiang10g~]# passwdoracle
Changing passwordfor user oracle.
New password:
BAD PASSWORD: itis based on a dictionary word
BAD PASSWORD: istoo simple
Retype newpassword:
passwd: allauthentication tokens updated successfully

（2）创建相关目录
[root@seiang10g~]# mkdir -p/u01/app/oracle
[root@seiang10g~]# chown -Roracle:oinstall /u01/app/oracle
[root@seiang10g~]# chmod -R 775/u01/app/oracle
　　
（3）配置Linux内核参数及环境限制
[root@seiang10g~]# vim/etc/sysctl.conf
kernel.shmall =4294967296
kernel.shmall =2097152
kernel.shmmax =2147483648
kernel.shmmni =4096
kernel.sem = 25032000 100 128
fs.file-max =65536
net.ipv4.ip_local_port_range= 1024 65000
net.core.rmem_default= 262144
net.core.rmem_max= 262144
net.core.wmem_default= 262144
net.core.wmem_max= 262144

[root@seiang10g~]# vim/etc/security/limits.conf
oracle           soft    nproc  2047
oracle           hard    nproc  16384
oracle           soft    nofile 1024
oracle           hard    nofile 65536

[root@seiang10g~]# vi/etc/pam.d/login
session    required    /lib/security/pam_limits.so
session    required    pam_limits.so

（4）修改Oracle用户环境变量
[oracle@seiang10g~]$ vim.bash_profile
# .bash_profile
# Get the aliasesand functions
if [ -f ~/.bashrc]; then
        . ~/.bashrc
fi
# User specificenvironment and startup programs
PATH=$PATH:$HOME/bin
export PATH

exportORACLE_SID=seiang
exportORACLE_BASE=/u01/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10.2/dbhome_1
exportORACLE_OWNER=oracle
exportPATH=$ORACLE_HOME/bin:$PATH
umask 022
（5）禁用SELinux和关闭防火墙
[root@seiang10g~]# vim/etc/selinux/config
# This filecontrols the state of SELinux on the system.
# SELINUX= cantake one of these three values:
#     enforcing - SELinux security policy isenforced.
#     permissive - SELinux prints warningsinstead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= cantake one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

[root@seiang10g~]# serviceiptables stop
iptables: Flushingfirewall rules:                        [  OK  ]
iptables: Settingchains to policy ACCEPT: filter         [  OK  ]
iptables:Unloading modules:                              [  OK  ]
[root@seiang10g~]# serviceiptables status
iptables: Firewallis not running.
[root@seiang10g~]# chkconfigiptables off
[root@seiang10g~]# chkconfigiptables --list
iptables        0:off  1:off   2:off   3:off  4:off   5:off   6:off

（6）修改/etc/hosts文件
[root@seiang10g~]# vim/etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4localhost4.localdomain4
::1         localhost localhost.localdomainlocalhost6 localhost6.localdomain6

• 10.1.1.47       seiang10g.comsys.com   seiang10g
  

二、安装Oracle软件
1、解压安装包
[root@seiang10gsoftware]# gunzip10201_database_linux_x86_64.cpio.gz
[root@seiang10gsoftware]# cpio-idmv < 10201_database_linux_x86_64.cpio
[root@seiang10gsoftware]# unzipp8202632_10205_Linux-x86-64.zip
解压出来的目录为database和Disk1
[oracle@seiang10g~]$ cd/u01/software/database/
[oracle@seiang10gdatabase]$ ll
total 36
drwxrwxr-x 9 9411042424  4096 Oct 20  2005 doc
drwxr-xr-x 5 9411042424  4096 Oct 23  2005 install
drwxr-xr-x 2 9411042424  4096 Oct 23  2005 response
-rwxr-xr-x 1 9411042424  1326 Oct 23  2005 runInstaller
drwxrwxr-x 9 9411042424 12288 Oct 23  2005 stage
-rw-rw-r-- 1 9411042424  5416 Oct 20  2005 welcome.html

2、执行./runInstaller
[oracle@seiang10g database]$ exportDISPLAY=10.1.1.123:0.0

报错信息1：
[oracle@seiang10g database]$./runInstaller
Starting OracleUniversal Installer...

Checking installerrequirements...

Checking operatingsystem version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6,UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 orSuSE-11
                                      Passed

All installerrequirements met.

Preparing tolaunch Oracle Universal Installer from /tmp/OraInstall2017-07-11_10-49-36AM.Please wait ...[oracle@seiang10g Disk1]$ Oracle Universal Installer, Version10.2.0.5.0 Production
Copyright (C)1999, 2010, Oracle. All rights reserved.

Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2017-07-11_10-49-36AM/jre/1.4.2/lib/i386/libawt.so:libXp.so.6: cannot open shared object file: No such file or directoryoccurred..
java.lang.UnsatisfiedLinkError:/tmp/OraInstall2017-07-11_10-49-36AM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6:cannot open shared object file: No such file or directory
        atjava.lang.ClassLoader$NativeLibrary.load(Native Method)
        atjava.lang.ClassLoader.loadLibrary0(Unknown Source)
        atjava.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(UnknownSource)
        at java.lang.System.loadLibrary(UnknownSource)
        atsun.security.action.LoadLibraryAction.run(Unknown Source)
        atjava.security.AccessController.doPrivileged(Native Method)
        atsun.awt.NativeLibLoader.loadLibraries(Unknown Source)

错误原因：
一般是却少libXp的包
解决办法：
[root@seiang10gPackages]# rpm-qa libXp*
[root@seiang10gPackages]# yuminstall libXp*

报错信息2：
[oracle@seiang10g database]$ ./runInstaller
Starting OracleUniversal Installer...

Checking installerrequirements...

Checking operatingsystem version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5,redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4,enterprise-5 or SuSE-11
                                      Passed

All installerrequirements met.

Preparing tolaunch Oracle Universal Installer from /tmp/OraInstall2017-07-11_10-57-11AM.Please wait ...[oracle@seiang10g Disk1]$ Oracle Universal Installer, Version10.2.0.5.0 Production
Copyright (C)1999, 2010, Oracle. All rights reserved.

Exception java.lang.UnsatisfiedLinkError:/tmp/OraInstall2017-07-11_10-57-11AM/jre/1.4.2/lib/i386/libawt.so:libXtst.so.6: cannot open shared object file: No such file or directoryoccurred..
java.lang.UnsatisfiedLinkError:/tmp/OraInstall2017-07-11_10-57-11AM/jre/1.4.2/lib/i386/libawt.so:libXtst.so.6: cannot open shared object file: No such file or directory
        atjava.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(UnknownSource)
        atjava.lang.ClassLoader.loadLibrary(Unknown Source)
        atjava.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(UnknownSource)

错误原因：
一般是却少libXtst的包
解决办法：
[root@seiang10gPackages]# rpm-qa libXtst*
[root@seiang10gPackages]# yuminstall libXtst*

报错信息3：
[oracle@seiang10g database]$./runInstaller
Starting OracleUniversal Installer...

Checking installerrequirements...

Checking operatingsystem version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5,redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4,enterprise-5 or SuSE-11
                                      Passed

All installerrequirements met.

Preparing tolaunch Oracle Universal Installer from /tmp/OraInstall2017-07-11_11-00-09AM.Please wait ...[oracle@seiang10g Disk1]$ Oracle Universal Installer, Version10.2.0.5.0 Production
Copyright (C)1999, 2010, Oracle. All rights reserved.

Can't connect to X11 window server using'10.1.1.123:0.0' as the value of the DISPLAY variable.
10.1.1.123:0.0
10.1.1.123:0.0
OUI-10025:Unableto start an interactive install session because of the following error:Can'tconnect to X11 window server using '10.1.1.123:0.0' as the value of the DISPLAYvariable. The DISPLAY environment variable should be set to <hostname or IPaddress>:<screen>, where the <screen> is usually '0.0'.
OUI-10026:Dependingon the Unix Shell, you can use one of the following commands as examples to setthe DISPLAY environment variable:
- For csh:                      % setenv DISPLAY192.168.1.128:0.0
- For sh, ksh andbash:         $DISPLAY=192.168.1.128:0.0; export DISPLAY
Use the followingcommand to see what shell is being used:
        echo $SHELL
Use the followingcommand to view the current DISPLAY environment variable setting:
        echo $DISPLAY
- Make sure thatclient users are authorized to connect to the X Server.
OUI-10027:Toenable client users to access the X Server, open an xterm, dtterm or xconsoleas the user that started the session and type the following command:
% xhost +
To test that theDISPLAY environment variable is set correctly, run a X11 based program thatcomes with the native operating system such as 'xclock':
        % <full path to xclock... seebelow>
If you are notable to run xclock successfully, please refer to your PC-X Server or OS vendorfor further assistance.
Typical path for'xclock': '/usr/X11R6/bin/xclock'

出现这个错误是由于当前用户不是oracle或者环境变量设置的不正确导致的，因为每次都是用oracle用户解压，安装，没有遇到这个问题，所以也没有仔细研究过这个错误。经过在网上查询相关的资料找到了出错的原因：
可以参考一下http://blog.sina.com.cn/s/blog_73582d750100ppto.html（链接内容如下：）
cause:
X-Windows emulation is not yet correctly configured or is being mis-used.
solution:
1.Make sure that "DISPLAY” is set properly as either:
     <ip address of the DBA desktop PC>:0.0
          or
     <hostname of the DBA desktop PC>:0.0
note:In this example, ip_address/hostnameis the host name or IP address ofthe system that you want to use to display Oracle Universal Installer (yourworkstation or PC).
eg.[root@rac1 ~]# xhost +
access control disabled, clients can connect from any host
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ export DISPLAY=192.16.2.98:0.0
[oracle@rac1 ~]$ cd database/
[oracle@rac1 database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4,UnitedLinux-1.0, asianux-1 or asianux-2
                                      Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from/tmp/OraInstall2009-03-05_03-36-28PM. Please wait ...[oracle@rac1 database]$Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
2. Oracle Customer Support has seeninstances where use of the UNIX/Linux “su” command, even “su - oracle” hascaused this “Can't connect to X11 window server” error. Therefore, please besure that you are LOGGED ON as the oracle account. Log directly into theinstall session. Do not use any variety of “su”.
     use oracle log on , not "su - oracle"
eg. [oracle@rac1 database]$ ./runInstaller
3.Oracle Customer Support has seeninstances where the incorrect “ulimit” setting for number of files (aka “-n”,aka “nofiles”) has caused this “Can't connect to X11 window server” error.Therefore, please be sure that your values for “nofiles” in the output of“ulimit -a” is at least 65536.
备注：前2个办法只需要满足其中一个就可以避免这个错误了：直接用oracle登陆，不能su- oracle  or 设置display=ip_address_thatyou want to use to display Oracle Universal Installer：0.0
通过直接使用oracle用户登录解决了上面所产生的问题；
下面开始oracle10.2.0.1；

[oracle@seiang10g database]$ ./runInstaller
　　

　　

　　

　　

　　在安装到83%的时候报如下错误

在安装到83%的时候，报如上错误：进入持续运行状态之后，在link步骤Oracle终止操作，报错说link失败，然后查看安装的所产生的日志信息：
　　
　　[root@seiang10g~]# tail -60/u01/app/oraInventory/logs/installActions2017-07-11_04-01-22PM.log
　　INFO:mv ctxlc /u01/app/oracle/product/10.2.0/dbhome_1/bin/ctxlc
　　
　　INFO:chmod 751 /u01/app/oracle/product/10.2.0/dbhome_1/bin/ctxlc
　　
　　INFO:gcc -m32 -o ctxhx -L/u01/app/oracle/product/10.2.0/dbhome_1/ctx//lib32/-L/u01/app/oracle/product/10.2.0/dbhome_1/lib32/ -L/u01/app/oracle/product/10.2.0/dbhome_1/lib32/stubs/ /u01/app/oracle/product/10.2.0/dbhome_1/ctx/lib/ctxhx.o-L/u01/app/oracle/product/10.2.0/dbhome_1/ctx/lib/ -ldl -lm -lctxhx-Wl,-rpath,/u01/app/oracle/product/10.2.0/dbhome_1/ctx/lib -lsnls10 -lnls10  -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10-lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10  `cat /u01/app/oracle/
　　INFO:product/10.2.0/dbhome_1/lib/sysliblist`
　　
　　INFO:/usr/bin/ld: crt1.o: No such file: No such file or directory
　　collect2:ld returned 1 exit status
　　
　　INFO:make: *** [ctxhx] Error 1
　　
　　INFO:End output from spawned process.
　　INFO:----------------------------------
　　INFO:Exception thrown from action: make
　　ExceptionName: MakefileException
　　ExceptionString: Error in invoking target 'install' of makefile'/u01/app/oracle/product/10.2.0/dbhome_1/ctx/lib/ins_ctx.mk'.
　　See'/u01/app/oraInventory/logs/installActions2017-07-11_04-01-22PM.log' fordetails.
　　ExceptionSeverity: 1
　　
报错原因：
查询后，发现是安装依赖包的问题glibc-devel。在32bit环境下，我们使用rpm直接安装或者yum安装时，只安装32bit版本就可以了。但是在64bit环境下，是需要将两个版本的均进行安装。这个过程中是需要严格遵守文档对安装包的要求。

　　解决方法：
　　[root@seiang10gPackages]# yuminstall glibc*

Retry之后又出现上面的报错信息，然后查看相关安装日志：
　　INFO:make[1]: Leaving directory `/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib'
　　
　　INFO:make[1]: *** [/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib/libnmemso.so]Error 1
　　make:*** [libnmemso] Error 2
　　
　　INFO:End output from spawned process.
　　INFO:----------------------------------
　　INFO:Exception thrown from action: make
　　ExceptionName: MakefileException
　　ExceptionString: Error in invoking target 'agent nmo nmb' of makefile'/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib/ins_sysman.mk'.
　　See'/u01/app/oraInventory/logs/installActions2017-07-11_04-01-22PM.log' for details.
　　ExceptionSeverity: 1
　　
　　点击continue;

　　INFO:make[1]: Leaving directory `/u01/app/oracle/product/10.2.0/dbhome_1/rdbms/lib'
　　
　　INFO:make[1]: *** [/u01/app/oracle/product/10.2.0/dbhome_1/rdbms/lib/extproc32]Error 1
　　make:*** [extproc32] Error 2
　　
　　INFO:End output from spawned process.
　　INFO:----------------------------------
　　INFO:Exception thrown from action: make
　　ExceptionName: MakefileException
　　ExceptionString: Error in invoking target 'all_no_orcl' of makefile'/u01/app/oracle/product/10.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk'.
　　See'/u01/app/oraInventory/logs/installActions2017-07-11_04-01-22PM.log' fordetails.
　　ExceptionSeverity: 1
　　
　　点击continue;

　　INFO:make[1]: Leaving directory `/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib'
　　
　　INFO:make[1]: *** [/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib/nmccollector]Error 1
　　make:*** [nmccollector] Error 2
　　
　　INFO:End output from spawned process.
　　INFO:----------------------------------
　　INFO:Exception thrown from action: make
　　ExceptionName: MakefileException
　　ExceptionString: Error in invoking target 'collector' of makefile'/u01/app/oracle/product/10.2.0/dbhome_1/sysman/lib/ins_emdb.mk'.
　　See'/u01/app/oraInventory/logs/installActions2017-07-11_04-01-22PM.log' fordetails.
　　ExceptionSeverity: 1
这个问题是比较复杂的，笔者查询了很多资料也没有一个确切的回应。最后在网络上检索到一位前辈的解决之道。
首先点击ignore跳过步骤，后面就可以直接完成runInstaller脚本执行。在$ORACLE_HOME/bin目录下，修改oracle文件为oracle.bin。
创建文件oracle在相同目录，内容如下：
#!/bin/bash
export DISABLE_HUGETLBFS=1
exec $ORACLE_HOME/bin/oracle.bin $@
EOF
保存后使用chmoda+x oracle命令对文件进行权限修改。经过这种策略修改之后，Oracle后续的dbca过程创建数据库执行正常。

[root@seiang10g~]#/u01/app/oracle/oraInventory/orainstRoot.sh
　　Changingpermissions of /u01/app/oracle/oraInventory to 770.
　　Changinggroupname of /u01/app/oracle/oraInventory to oinstall.
　　Theexecution of the script is complete
　　
　　[root@seiang10g~]#/u01/app/oracle/product/10.2.0/dbhome_1/root.sh
　　RunningOracle10 root.sh script...
　　
　　Thefollowing environment variables are set as:
　　    ORACLE_OWNER= oracle
　　    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/dbhome_1
　　
　　Enterthe full pathname of the local bin directory: [/usr/local/bin]:
　　   Copying dbhome to /usr/local/bin ...
　　   Copying oraenv to /usr/local/bin ...
　　   Copying coraenv to /usr/local/bin ...
　　
　　Creating/etc/oratab file...
　　Entrieswill be added to the /etc/oratab file as needed by
　　DatabaseConfiguration Assistant when a database is created
　　Finishedrunning generic part of root.sh script.
　　Nowproduct-specific root actions will be performed.
　　

　　三、安装Oracle10.2.0.5.0
安装升级Oracle10.2.0.5是为了后面数据库运行的稳定，避免出现诸多的bug
　　

如果在环境检查的时候出现这个问题，如下所示：

　　环境检查中具体的报错信息如下所示：
　　Checking forOracle Home incompatibilities ...
　　
　　Actual Result:NEW_HOME
　　Check complete.The overall result of this check is: Failed <<<<
　　
　　Problem: Thissoftware can only be installed into an existing Oracle Database 10g OracleHome.
　　
　　Recommendation:Choose an existing Oracle Database 10g Oracle Home for installing thissoftware.
　　
原因是由于oracle10.2.0.5是升级包，必须要在已有的数据库前提下进行安装，报错的原因是没有已经存在的数据库


正确的情况下：
　　

　　

　　

　　

安装进度完成后也需要执行一个脚本，注意这里执行的时候设计到覆盖重写的问题，全部选择YES
　　[root@seiang10g~]#/u01/app/oracle/product/10.2.0/dbhome_1/root.sh
　　RunningOracle 10g root.sh script...
　　
　　Thefollowing environment variables are set as:
　　    ORACLE_OWNER= oracle
　　    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/dbhome_1
　　
　　Enterthe full pathname of the local bin directory: [/usr/local/bin]:
　　Thefile "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
　　[n]:y
　　   Copying dbhome to /usr/local/bin ...
　　Thefile "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
　　[n]:y
　　   Copying oraenv to /usr/local/bin ...
　　Thefile "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
　　[n]:y
　　   Copying coraenv to /usr/local/bin ...
　　
　　Entrieswill be added to the /etc/oratab file as needed by
　　DatabaseConfiguration Assistant when a database is created
　　Finishedrunning generic part of root.sh script.
　　Nowproduct-specific root actions will be performed.

　　四、创建数据库
　　

　　

　　

　　

　　至此，Oracle10.2.0.5全部安装完成！！！历经好多的问题，最终还是安装成功了，可喜可贺！！！



作者：SEian.G（苦练七十二变，笑对八十一难）
◇本文在ITPUB：http://blog.itpub.net/31015730/
      51CTO：http://seiang.blog.51cto.com/上有同步更新
◇本文itpub地址：http://blog.itpub.net/31015730/viewspace-2141989/
◇本文51CTO地址：http://seiang.blog.51cto.com/10819863/1946087