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