十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
实验环境:
站在用户的角度思考问题,与客户深入沟通,找到昂昂溪网站设计与昂昂溪网站推广的解决方案,凭借多年的经验,让设计与互联网技术结合,创造个性化、用户体验好的作品,建站类型包括:网站建设、成都做网站、企业官网、英文网站、手机端网站、网站推广、申请域名、网页空间、企业邮箱。业务覆盖昂昂溪地区。
操作系统: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
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':
%
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:
or
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