ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rhel 6.1 64位上Oracle 10G R2 安装与常见错误解决办法

rhel 6.1 64位上Oracle 10G R2 安装与常见错误解决办法

原创 Linux操作系统 作者:wzhalal 时间:2013-07-24 11:42:24 0 删除 编辑
[root@EJingCha soft]# uname -a
Linux EJingCha 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
[root@EJingCha soft]  mount    /dev/cdrom  /mnt
[root@EJingCha soft]# vim /etc/yum.repos.d/rhel-source.repo 

[rhel-source]
name=Red Hat Enterprise Linux $releasever - $basearch - Source
baseurl=file:///mnt
enabled=1
#gpgcheck=1
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release

[root@EJingCha soft]rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils glibc glibc-common libaio libgcc libstdc++ make ksh libgomp sysstat kernel-headers libstdc++-devel elfutils-libelf-devel mpfr libXmu libXt libXxf86misc glibc-headers libXxf86vm glibc-headers libXxf86vm xorg-x11-xauth cpp libtool-ltdl unixODBC cloog-ppl ppl libmcpp mcpp xorg-x11-server-utils compat-db42 compat-db43 libdmx libXv libXxf86dga libIDL ORBit2 GConf2 libbonobo gtk2-engines shared-mime-info libdaemon avahi avahi-glib gnome-vfs2 xorg-x11-utils compat-libstdc++-33 celt051 libXp ConsoleKit-x11 xorg-x11-xinit glibc-devel gcc compat-gcc-34 ncurses-devel gcc-c++ libgnome readline-devel compat-db libaio-devel compat-gcc-34-c++ 

[root@EJingCha soft] rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' libgcc nss-softokn-freebl glibc libaio libstdc++ ncurses-libs readline libICE libtool-ltdl libSM libuuid unixODBC libXau libX11 libxcb libXext libXi compat-libstdc++-33 libXt libXtst libaio-devel unixODBC-devel glibc-devel 

[root@EJingCha soft]yum install -y libaio-0.3.107-10.el6.i686 ncurses-libs-5.7-3.20090208.el6.i686 readline-6.0-3.el6.i686 libICE-1.0.6-1.el6.i686 libtool-
ltdl-2.2.6-15.5.el6.i686 libSM-1.1.0-7.1.el6.i686 libuuid-2.17.2-12.el6.i686 unixODBC-2.2.14-11.el6.i686 libXau-1.0.5-1.el6.i686 libX11-1.3-2.el6.i686 
libxcb-1.5-1.el6.i686 libXext-1.1-3.el6.i686 libXi-1.3-3.el6.i686 compat-libstdc++-33-3.2.3-69.el6.i686 libXt-1.0.7-1.el6.i686 libXtst-1.0.99.2-3.el6.i686 
libaio-devel-0.3.107-10.el6.i686 unixODBC-devel-2.2.14-11.el6.i686 glibc-devel-2.12-1.25.el6.i686 unixODBC-devel-2.2.14-11.el6.i686 libXp-1.0.0-15.1.el6.i686

[root@EJingCha soft]yum install -y celt051 libXp compat-gcc-34 libaio-devel unixODBC-devel compat-gcc-34-c++ libaio-0.3.107-10.el6.i686 ncurses-libs-5.7-
3.20090208.el6.i686 readline-6.0-3.el6.i686 libICE-1.0.6-1.el6.i686 libtool-ltdl-2.2.6-15.5.el6.i686 libSM-1.1.0-7.1.el6.i686 libuuid unixODBC-2.2.14-
11.el6.i686 libXau-1.0.5-1.el6.i686 libX11-1.3-2.el6.i686 libxcb-1.5-1.el6.i686 libXext-1.1-3.el6.i686 libXi-1.3-3.el6.i686 compat-libstdc++-33-3.2.3-
69.el6.i686 libXt-1.0.7-1.el6.i686 libXtst-1.0.99.2-3.el6.i686 libaio-devel-0.3.107-10.el6.i686 unixODBC-devel-2.2.14-11.el6.i686 glibc-devel-2.12-
1.25.el6.i686 ksh-20100621-6.el6.x86_64


[root@EJingCha soft]# groupadd dba
[root@EJingCha soft]# groupadd oinstall
[root@EJingCha soft]# useradd -g oinstall -G dba -d /u01/oracle oracle 
[root@EJingCha soft]# passwd oracle 

[root@EJingCha soft]# mkdir -p /u01/app/oracle/product/10.2/db_1
[root@EJingCha soft]# chown -R oracle:oinstall /u01/app/oracle/
[root@EJingCha soft]# df -lh
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_system-LogVol_Root
                       35G  5.0G   28G  16% /
tmpfs                 3.9G  264K  3.9G   1% /dev/shm
/dev/sda1             485M   50M  410M  11% /boot
/dev/mapper/vg_data-LogVol00
                      345G  195M  327G   1% /data
/dev/sr0              3.4G  3.4G     0 100% /mnt

[root@EJingCha /]# cd /data

[root@EJingCha data]# mkdir -p /data/u01/app/oracle/product/10.2/db_1

[root@EJingCha data]# chown -R oracle:oinstall /data/u01/app/oracle/

[root@EJingCha data]# getenforce    --SELINUX  关闭
Disabled 

[root@EJingCha data]# /etc/init.d/iptables stop   --IPTABLES 关闭

[root@EJingCha data]# /etc/init.d/iptables status
iptables: Firewall is not running.


[root@EJingCha data]# su - oracle

[oracle@EJingCha ~]$ vim ~/.bash_profile 
# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_BASE=/data/u01/app/oracle
export ORACLE_HOME=/data/u01/app/oracle/product/10.2/db_1
export ORACLE_SID=dmsdb
export LANG=en
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export PATH


[oracle@EJingCha ~]$ exit

[root@EJingCha ~]# vim /etc/sysctl.conf 
# net.bridge.bridge-nf-call-ip6tables = 0   在这行前加# 
# net.bridge.bridge-nf-call-iptables = 0    在这行前加# 
# net.bridge.bridge-nf-call-arptables = 0   在这行前加# 
#kernel.shmmax = 2147483648 单个进程能使用的最大共享内存
kernel.shmmni = 4096       单个共享内存段的最小值
#kernel.shmall = 2097152    可用的共享内存总量(单位是页4k)
kernel.sem = 250 32000 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@EJingCha ~]# sysctl -p

[root@EJingCha ~]]# vim /etc/security/limits.conf 

# End of file      加入以下内容: 
oracle soft nproc 2047 
oracle hard nproc 16384 
oracle soft nofile 1024 
oracle hard nofile 65536 

[root@EJingCha ~]# vi /etc/pam.d/login 

-session   optional     pam_ck_connector.so   加入以下内容: 
session    required     /lib/security/pam_limits.so 
session    required    pam_limits.so 

 
[root@EJingCha ~]# vi /etc/profile 

unset pathmunge   加入以下内容: 
if [ $USER = "oracle" ]; then 
        if [ $SHELL = "/bin/ksh" ]; then 
                ulimit -p 16384 
                ulimit -n 65536 
        else 
                ulimit -u 16384 -n 65536 
        fi 
fi 
 

[root@EJingCha ~]# id oracle
uid=501(oracle) gid=503(oinstall) groups=503(oinstall),502(dba)

[root@EJingCha ~]# echo "502" > /proc/sys/vm/hugetlb_shm_group 

 
 

[root@EJingCha ~]# chown -R oracle:oinstall /soft/

[root@EJingCha ~]# su - oracle
[oracle@EJingCha ~]$ cd /soft/
[oracle@EJingCha soft]$ ls
10201_database_linux_x86_64.cpio  p6810189_10204_Linux-x86-64.zip
oracle                            rlwrap-0.37-1.el5.x86_64.rpm
oracle_install.txt
[oracle@EJingCha soft]$ cpio -idmv<10201_database_linux_x86_64.cpio 

[oracle@EJingCha soft]$ unzip p6810189_10204_Linux-x86-64.zip

[oracle@EJingCha database]$ ./runInstaller 
./runInstaller: /soft/database/install/.oui: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

[root@EJingCha Packages]# yum install glibc-2.12-1.25.el6.x86_64.rpm 

[root@EJingCha Packages]# yum install libXtst* -y
yum install libXp*
yum install libaio*
yum install gcc-* gcc-c++-* make-* setarch-*

[root@EJingCha Packages]# vim /etc/redhat-release 
#Red Hat Enterprise Linux Server release 6.1 (Santiago)
Red Hat Enterprise Linux Server release 4 (Santiago)

[root@EJingCha Packages]xhost+


[root@EJingCha Packages]su - oracle 

[oracle@EJingCha database]$ ./runInstaller     ---利用图像界面安装 可以参考我以前的文章利用 Telnet服务,VNC配置,Xmanager 配置,samba挂载,FTP配置 



错误集锦:
备注:
: 
---------------------------------------------------------------------------------------------------------------------------- 
一、Error in invoking target 'collector' of makefile '/data/u01/oracle/sysman/lib/ins_emdb.mk'.  解决方法
1、这个错误可以忽略,完成安装后再修改: 
[oracle@EJingCha database]$ cd $ORACLE_HOME/bin 
[oracle@EJingCha bin]$ mv oracle oracle.bin 
[oracle@EJingCha bin]$ vi oracle 
#!/bin/bash 
export DISABLE_HUGETLBFS=1 
exec $ORACLE_HOME/bin/oracle.bin $@ 
EOF 
再使用DBCA 创建数据库

2、可以不创建数据库 直接打补丁升级到10.2.0.4或者10.2.0.5解决该错误问题

具体原因:

http://forums.oracle.com/forums/thread.jspa?messageID=2478830

Tested installation on Fedora 8 x86_64. I've got the same error during linking of nmccollector.

In fact you don't need nmccollector as:

1) you are installing Oracle on non certified system for Oracle so it will be not probably in production

2) You can use "SQL Access" mode instead of "Memory Access" mode to check performance.

So you can ignore this error. If you apply patchset 10.2.0.3 or 10.2.0.4 then relink of nmccollector will be succesfull.

More about Memory Access Mode:

http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part2.html

http://www.oracle.com/technology/pub/articles/10gdba/nanda_10gr2dba_part3.html

http://tonguc.wordpress.com/2007/08/20/memory-access-mode-of-oracle-enterprise-manager/

将此错误忽略继续安装可以正常完成。


结束后,直接打补丁至10.2.0.4

对数据库进行更新操作,否则会出现ORA-01092错误,大约需要40分钟。。。
SQL>startup upgrade

SQL>@?/rdbms/admin/catupgrd.sql

SQL>shutdown immediate

SQL>startup

结束
用以下SQL检查升级是否成功。
SQL> select comp_name,version,status from dba_registry;


 
 
二、
 
INFO: mv -f /oracle/app/product/10.2.0/db_1/bin/ctxlc /oracle/app/product/10.2.0/db_1/bin/ctxlcO 
 
INFO: mv ctxlc /oracle/app/product/10.2.0/db_1/bin/ctxlc 
 
 
INFO: chmod 751 /oracle/app/product/10.2.0/db_1/bin/ctxlc 
 
INFO: gcc -m32 -o ctxhx -L/oracle/app/product/10.2.0/db_1/ctx//lib32/ -L/oracle/app/product/10.2.0/db_1/lib32/ -L/oracle/app/product/10.2.0/db_1/lib32/stubs/ 

/oracle/app/product/10.2.0/db_1/ctx/lib/ctxhx.o -L/oracle/app/product/10.2.0/db_1/ctx/lib/ -ldl -lm -lctxhx -Wl,-

rpath,/oracle/app/product/10.2.0/db_1/ctx/lib -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 

-lcore10 -lnls10 `cat /oracle/app/product/10.2.0/db_1/lib/sysliblist` 
 
INFO: /usr/bin/ld: crt1.o: No such file: No such file or directory 
 
INFO: collect2: ld returned 1 exit status 
 
INFO: make: *** [ctxhx] Error 1 
 
INFO: End output from spawned process. 
INFO: ---------------------------------- 
INFO: Exception thrown from action: make 
Exception Name: MakefileException 
Exception String: Error in invoking target 'install' of makefile '/oracle/app/product/10.2.0/db_1/ctx/lib/ins_ctx.mk'. See 

'/oracle/app/oraInventory/logs/installActions2010-11-23_12-04-56PM.log' for details. 
Exception Severity: 1 
 
解决方法:rpm -ivh glibc-devel-2.5-49.i386.rpm
 
三、
 
linux 64位安装Oracle 10g时e2eme报错的解决规划是本文我们首要要介绍的内容,错误的具体的日记文件如下:
INFO: reference to `ldxnbeg’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2i.o)(.text+0×231): In function `lxecg2i’:  
: undefined reference to `ldxdtd’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2i.o)(.text+0×314): In function `lxecg2i’:  
: undefined reference to `ldxnbeg’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2i.o)(.text+0×340): In function `lxecg2i’:  
: undefined reference to `ldxdfd’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2l.o)(.text+0 x13f): In function `lxecg2l’:  
: undefine  
INFO: d reference to `ldxnbeg’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2l.o)(.text+0 x16f): In function `lxecg2l’:  
: undefined reference to `ldxdtd’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2l.o)(.text+0 x48b): In function `lxecg2l’:  
: undefined reference to `ldxnbeg’  
/app/oracle/product/10/db_1/lib32//libnls10.a(lxecg2l.o)(.text+0 x4b7): In function `lxecg2l’:  
: undefined reference to `ldxdfd’  
/app/oracle/product/10/db_1/lib32//libunls10.a(lxu4tstc.o)(.text+0 x8b4): In function `lxu4TstClsXMLPub  
INFO: idChar0′:  
: undefined reference to `lxpTstClsXMLPubidCharTbl’  
/app/oracle/product/10/db_1/lib32//libunls10.a(lxu4dec.o)(.text+0 x18b): In function `lxu4Decomposition’:  
: undefined reference to `lxujmd’  
collect2: ld returned 1 exit status  
make[1]: *** [/app/oracle/product/10/db_1/sysman/lib/e2eme] Error 1  
make: *** [e2eme] Error 2  
INFO: End output  spawned process.  
INFO: ———————————-  
INFO: Exception thrown  action: make  
Exception Name: MakefileException  
Exception String: Error in invoking target ‘agent nmo nmb’ of makefile ‘/app/oracle/product/10/db_1/sysman/lib/ins_sysman.mk’.  
See ‘/app/oracle/oraInventory/logs/installActions2011-07-08_09-25-48PM.log’ for details. 
解决办法:
1.搜检须要的包有没有完全安装。
rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common   
gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver libaio openmotif21 
2.搜检内核参数有没有添加,有没有错误。
查看或者编辑 /etc/sysctl.conf文件
kernel.shmall = 2097152 
kernel.shmmax = 2147483648 
kernel.shmmni = 4096 
kernel.sem = 250 32000 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 
运行如下号令,是内核参数生效。
/sbin/sysctl -p
 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH   
./proc   
 
测试proc

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28894640/viewspace-767004/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-06-06

  • 博文量
    60
  • 访问量
    250209