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

[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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28894640/viewspace-767004/