Installing Oracle 9i on OEL/RHEL 4.8 64bit


June 16, 2012 |  No Comments#######################################################
################    PART A (Logged in as root)    #################
#######################################################
# Update date : 16/06/2012

1. Disabling SELinux  Disable SELinux now (If you couldn＊t disable it during installation).
cat /etc/selinux/config

## === And make sure to set the SELINUX Flag disabled.
SELINUX=disabled

2. Installing missing libraries - You don＊t know whether you have the required packages installed or not. Right! Don＊t sweat. Run following commands to check whether you have those packages or not. If they are installed, the command prompt will return you their version, else ＆Not installed＊ message.

rpm -q compat-db compat-gcc-32 compat-gcc-32-c++ compat-libcom_err compat-libcwait compat-libgcc-296 compat-libstdc++-296 compat-libstdc++-33 gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers glibc-kernheaders libgcc make

# Required packages for 64bit (x86_64) architecture:
binutils-2.15.92.0.2-21.x86_64
compat-db-4.1.25-9.i386
compat-db-4.1.25-9.x86_64
compat-gcc-32-3.2.3-47.3.x86_64
compat-gcc-32-c++-3.2.3-47.3.x86_64
compat-libcom_err-1.0-5.i386
compat-libcom_err-1.0-5.x86_64
compat-libgcc-296-2.96-132.7.2.i386
compat-libstdc++-296-2.96-132.7.2.i386
compat-libstdc++-33-3.2.3-47.3.i386
compat-libstdc++-33-3.2.3-47.3.x86_64
gcc-3.4.6-3.1.x86_64
gcc-c++-3.4.6-3.1.x86_64
glibc-2.3.4-2.25.i686
glibc-2.3.4-2.25.x86_64
glibc-common-2.3.4-2.25.x86_64
glibc-devel-2.3.4-2.25.i386
glibc-devel-2.3.4-2.25.x86_64
glibc-headers-2.3.4-2.25.x86_64
glibc-kernheaders-2.4-9.1.98.EL.x86_64
libgcc-3.4.6-3.1.i386
libgcc-3.4.6-3.1.x86_64
make-3.80-6.EL4.x86_64

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el4.repo

[oracle@localhost igdbg]$ cd /etc/yum.repos.d/
[oracle@localhost yum.repos.d]$ cat rhel48.repo
[Server]
name=Server
baseurl=http://10.148.8.235/rhel48/
enabled=1
gpgcheck=0
gpgkey=


package compat-db is not installed
package compat-libcom_err is not installed
package compat-libgcc-296 is not installed
package compat-libstdc++-296 is not installed
package gcc is not installed
package gcc-c++ is not installed

yum -y install compat-gcc-32 compat-gcc-32-c++ compat-gcc-32-c++ glibc-devel libaio-devel xorg-x11-deprecated-libs-devel compat-libcom_err compat-libgcc-296 compat-libstdc++-296 gcc gcc-c++


*******
安裝yum   32位
wget http://10.148.8.235/repos/yum_forAS4.tar.gz
tar xfz yum_forAS4.tar.gz
cd yum_forAS4
rpm -ivh *.rpm
********

3. Installing patches  You need to download three patches and install it. These patches are:

#Location :
http://oss.oracle.com/projects/compat-oracle/files/RedHat/

wget http://oss.oracle.com/projects/compat-oracle/dist/files/RedHat/compat-libcwait-2.1-1.i386.rpm
wget http://oss.oracle.com/projects/compat-oracle/dist/files/RedHat/compat-libcwait-2.1-2.x86_64.rpm
wget http://oss.oracle.com/projects/compat-oracle/dist/files/RedHat/compat-oracle-rhel4-1.0-5.i386.rpm

## === Navigate to the location where you have stored the downloaded file.

# rpm -Uvh compat-libcwait-2.1-1.i386.rpm
# rpm -Uvh compat-libcwait-2.1-2.x86_64.rpm
# rpm -Uvh compat-oracle-rhel4-1.0-5.i386.rpm

********
ERROR: ld.so: object '/lib/libcwait.so'报错解决
此文来自：http://www.cnblogs.com/snigoal/archive/2012/07/17/2596569.html
在RH Linux AS4 x86-64 安装Oracle9.2.0.4前打补丁Patch 4198954中的compat-libcwait-2.1-1.i386.rpm 报如下的错误：

[root@oracle8 oracle]# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm
ERROR: ld.so: object '/lib/libcwait.so' from /etc/ld.so.preload cannot be preloaded: ignore

Google了半天找到解决办法：
# echo "" > /etc/ld.so.preload
64位系统没有这个文件导致报错
*********

4. ﹞ User and Group Creation  Oracle installer wouldn＊t run as the root user, so you need to create a user. It would be better, if you create a special group for Oracle. To do these, run the following commands in the command prompt.

groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle

5. ORACLE_BASE Directory Creation -Login as root and create base directory for Oracle ($ORACLE_BASE).

mkdir -p /opt/orcl9i
chown -R oracle:oinstall /opt

6. ﹞ Setting up the kernel parameters  You also need to do a little modification in the the kernel parameters. You need to open the sysctl.conf file
# vi /etc/sysctl.conf

## === Add/update the following lines

# Oracle Kernel Setting for Oracle 9i
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.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

## === Save and close the file. You need to run a command to update the parameters
sysctl -p

#Edit the /etc/security/limits.conf file and add following lines:
vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

# Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
vi /etc/pam.d/login

session required pam_limits.so

#Add the following lines to /etc/profile:
if [ $USER = ※oracle§ ]; then
if [ $SHELL = ※/bin/ksh§ ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

#######################################################
#############   PART B (Logged in as oracle)   ####################
#######################################################

7. ﹞ Setting Environment Variables 每 Now since you have created the oracle user, you need to setup its environment variables. For that, you need to update oracle＊s .bash_profile file.

ORACLE_SID=ora9ibpm
ORACLE_BASE=/opt/orcl9i
ORACLE_TERM=xterm
ORACLE_HOME=/opt/orcl9i/product/9.2.4

Open bash profile of Oracle:

#vi ~/.bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/opt/orcl9i
export ORACLE_HOME=/opt/orcl9i/product/9.2.4
export ORACLE_SID=ora9ibpm
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64/

# vi ~/.bashrc

alias dba="sqlplus '/as sysdba'"
alias alert=§tail -100f /opt/orcl9i/admin/ora9ibpm/bdump/alert_ora9ibpm.log

8. Download Oracle 9i - Download the Oracle 9i (9.2.0.4) ,store the files in oracle＊s home directory. Launch the command prompt and navigate there.

wget http://10.148.8.235/ORACLE/ORACLE_SOURCE/ORACLE_64bit/Linux_oracle9i_64/amd64_db_9204_Disk1.cpio.gz
wget http://10.148.8.235/ORACLE/ORACLE_SOURCE/ORACLE_64bit/Linux_oracle9i_64/amd64_db_9204_Disk2.cpio.gz
wget http://10.148.8.235/ORACLE/ORACLE_SOURCE/ORACLE_64bit/Linux_oracle9i_64/amd64_db_9204_Disk3.cpio.gz

## === Unzip the files -

gunzip amd64_db_9204_Disk1.cpio.gz
gunzip amd64_db_9204_Disk2.cpio.gz
gunzip amd64_db_9204_Disk3.cpio.gz

## === Unpack the cpio files -

cpio -idmv < amd64_db_9204_Disk1.cpio
cpio -idmv < amd64_db_9204_Disk2.cpio
cpio -idmv < amd64_db_9204_Disk3.cpio

9. ﹞ Starting Oracle Installer - Now you are all set for Oracle installation. In the command prompt go to the Disk1 directory and run runInstaller file.

cd /opt/source/Disk1
export LD_ASSUME_KERNEL=2.4.19
export DISPLAY=10.148.53.74:0.0
./runInstaller

******
在 Linux x86-64 as4.8 下安装oralce9204到17%时出现卡住，oracle安装文件是amd64_db_9204_Disk1.cpio.gz
左边出现的错误是Error in writing to file
/u01/app/oracle/.....
,右边是在安装过程中，终端里会出现以下内容：
Inside isClusterMode. bCluster bfr is : false
Inside isCluster. bCluster bfr return is : false
Inside isCluster. bCluster bfr return is : false
该问题是由于redhat内核版本比较高的原因，可以通过在ORACLE用户的环境变量中添加LD_ASSUME_KERNEL=2.4.19参数以骗过ORACLE,
export LD_ASSUME_KERNEL=2.4.1
添加完参数后让参数文件重新生效一下，关闭当前安装界面，删除前面安装过程中产生的文件，重新打开一个Terminal进行安装即可通过
经测试：as4.x 64的可以，as5.x 64位的不支持。
*******

- Install Software Only, we＊ll run dbca later.
10. Error during DBCA, when checking sqlplus, getting Sementation Fault.
# ERROR WHEN DBCA/LSNRCTL
Segmentation Fault When Execute Sqlplus, Oracle, Lsnrctl After New/Patchset Install [ID 316746.1]

java.io.IOException: Bad file descriptor
at java.io.FileInputStream.readBytes(Native Method)
at java.io.FileInputStream.read(FileInputStream.java:194)
at sun.nio.cs.StreamDecoder$CharsetSD.readBytes(StreamDecoder.java:408)
at sun.nio.cs.StreamDecoder$CharsetSD.implRead(StreamDecoder.java:450)
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:182)
at java.io.InputStreamReader.read(InputStreamReader.java:167)
at java.io.BufferedReader.fill(BufferedReader.java:136)
at java.io.BufferedReader.readLine(BufferedReader.java:299)
at java.io.BufferedReader.readLine(BufferedReader.java:362)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.run(SQLEngine.java:1985)
at java.lang.Thread.run(Thread.java:534)

# Solution
To implement the solution, please execute the following steps:

Refer to:
1. cd /usr/bin (as root)
2. mv gcc gcc.script
3. mv g++ g++.script
4. ln -s gcc32 gcc
5. ln -s g++32 g++
6. login as oracle software owner (make sure environment is correct)
7. cd $ORACLE_HOME/bin
8. relink all > relink.txt 2>&1 (check relink.txt for errors)

Re-run the dbca


******由9.2.0.4升級到9.2.0.8
wget http://10.148.8.235/ORACLE/ORACLE_SOURCE/ORACLE_64bit/Linux_oracle9i_64/p4547809_92080_Linux-x86-64.zip
unzip p4547809_92080_Linux-x86-64.zip
cd /opt/source/Disk1
export LD_ASSUME_KERNEL=2.4.19
export DISPLAY=10.148.53.74:0.0
./runInstaller

在oui图形界面，指定oracle_home_name(如果oracle_home名指定正确，自动会找到以前oracle安装的路径)和路径，然后next,当提示用root用户运行$ORACLE_HOME/root.sh脚本时，按照提示运行root.sh脚本，然后等安装完成后退出oracle universal installer即可；

查找oracle_home name
cat /opt/orcl9i/oraInventory/ContentsXML/inventory.xml