Redhat5 successful Oracle9i Installation

Author: http://ox0spy.blogspot.com/2008/03/oracle9i-92040-installation-on-red-hat.html

1. Create users and groups
------------------------- Add users and groups used during installation
$ Su-
# Groupadd oinstall
# Groupadd DBA
# Useradd-G oinstall-g dba Oracle
# Passwd Oracle

2. Create a directory
--------------------------
We will install everything in the/opt/Oracle directory:
# Mkdir-P/opt/APP/Oracle/9.2.0
# Chown-r oracle. oinstall/opt/APP/Oracle

3. System Configuration
--------------------------
A) Set Kernel Parameters
Edit/etc/sysctl. conf
Kernel. shmmax = 536870912 if it is set to half of the physical memory 1 GB memory, the value is 512x1024x1024.
Kernel. shmmni = 4096 2 GB memory: 1024x1024x1024
Kernel. Shmall = 2097152
Kernel. SEM = 250 32000 100 128 none of other values need to be moved
FS. File-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000

The four parameters of SEM are semmsl (each user has the maximum number of semaphores );
Semmns (maximum number of system semaphores );
Semopm (number of calls to the semopm system each time );
Semmni (the maximum number of hard data sets in the system ).
Shmmax maximum shared memory 2 GB physical memory can be set to 536870912 if it is small.
Shmmni minimum shared memory: 4096kb.
All Shmall memory sizes.

Run sysctl to reflect the modification so that the kernel parameters take effect immediately. You can also restart it.
# Sysctl-P

You can also run the following command to change the kernel parameters:
# Echo 250 32000 100 128>/proc/sys/kernel/SEM
# Echo 268435456>/proc/sys/kernel/shmmax #1/2 * mem_size (m) * 1024*1024
# Echo 4096>/proc/sys/kernel/shmmni
# Echo 524288>/proc/sys/kernel/Shmall # mem_size (m) * 1024
# Echo 65536>/proc/sys/fs/file-max
# Echo 1024 65000>/proc/sys/NET/IPv4/ip_local_port_range

B) Set Oracle file requirements
Modify the file:/etc/security/limits. conf
# Echo Oracle soft nofile 65536>/etc/security/limits. conf
# Echo Oracle hard nofile 65536>/etc/security/limits. conf
# Echo Oracle soft nproc 16384>/etc/security/limits. conf
# Echo Oracle hard nproc 16384>/etc/security/limits. conf

C) Set Environment Variables
Add the following lines to/home/Oracle/. bash_profile:
Export oracle_sid = Zhang
Export oracle_base =/opt/APP/Oracle
Export ORACLE_HOME =/opt/APP/Oracle/9.2.0
Export LD_LIBRARY_PATH =/opt/APP/Oracle/9.2.0/lib:/usr/local/lib:/usr/x11r6/lib
Export tns_admin =/opt/APP/Oracle/9.2.0/Network/admin
Export ora_nls33 =/opt/APP/Oracle/9.2.0/ocommon/NLS/admin/Data
Export oracle_owner = Oracle
Export oracle_term = xterm
Export
Path =/usr/Kerberos/sbin:/usr/Kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin: /usr/sbin:/usr/bin:/root/bin:/opt/APP/Oracle/9.2.0/bin

4. Patch and install the required packages. For the reason for doing this, there will be a tips later, which will show the installation errors and their solution.
Bytes --------------------------------------------------------------------------------------------------
A) patch description:
P3006854_9204_linux.zip patch to be installed
P2617419_210_generic.zip to be played after installation (this is just an accompanying patch, as long as you set it
Environment variable)
P3238244_9204_linux.zip: Install the 9204 patch to fix the agent error.
Http://www.opennet.ru/soft/ora_inst/

Compat-libcwait-2.0-2.i386.rpm Linux as 4 patch is required before installation
Patches for compat-oracle-rhel4-1.0-5.i386.rpm Linux as 4 are required before installation, but I didn't install it
Http://oss.oracle.com/projects/compat-oracle/files/RedHat/

B) p3006854_9204_linux.zip.
# Unzip p3006854_9204_linux.zip
# Chmod + x 3006854/rhel3_pre_install.sh
#3006854/rhel3_pre_install.sh

C) install compat-libcwait-2.1-1.i386.rpm
# Rpm-IVH compat-libcwait-2.1-1.i386.rpm

D) Some required packages, which can be found on the System Disk
# Rpm-IVH compat-db-4.2.52-5.1.i386.rpm
# Rpm-IVH libXp-1.0.0-8.i386.rpm
# Rpm-IVH libXp-devel-1.0.0-8.i386.rpm
# Rpm-IVH openmotif-2.3.0-0.3.el5.i386.rpm
# Rpm-IVH openmotif-devel-2.3.0-0.3.el5.i386.rpm

D) gnome-libs-1.4.2-7.rhel5.i386.rpm and some dependent packages
These packages can be found online or downloaded from http://ox0spy.googlepages.com/download.zip
# Rpm-IVH giflib-4.1.3-8.i386.rpm
# Rpm-IVH glib-1.2.10-26.fc7.i386.rpm
# Rpm-IVH libpng10-1.0.18-2.i386.rpm
# Rpm-IVH ORBit-0.5.17-22.rhel5.i386.rpm
# Rpm-ivh gtk +-1.2.10-57. fc7.i386. rpm
# Rpm-IVH imlib-1.9.15-2.fc7.i386.rpm
# Rpm-IVH gnome-libs-1.4.2-7.rhel5.i386.rpm

E) create a link
# Ln-S/usr/lib/libstdc ++-libc6.2-2. so.3/usr/lib/libstdc ++-libc6.1-1. so.2

Now you can say that the previous two patches have not been installed. Please don't worry. They will be used later.
Okay, let's continue...

5. Start Oracle Installation
----------------------------------------------------------------------------------
1) Preparations
Download Oracle 9i
Http://www.oracle.com/technology... docs/linuxsoft.html

Extract
$ Zcat ship_9204_linux_disk1.cpio.gz | cpio-idmv
$ Zcat ship_9204_linux_disk2.cpio.gz | cpio-idmv
$ Zcat ship_9204_linux_disk3.cpio.gz | cpio-idmv

2) Restart X and use Oracle to log on to the system. Otherwise, some column errors may occur, such as xhost +, environment variables, etc.
$ Disk1/runinstaller
If no special instructions are provided, follow the default settings. Click Next or OK as prompted on the page.
Oracle install group: oinstall
Global Database Name: ox0spy.org (you can enter it based on your situation)
During this process, two prompts will appear, asking you to run the script in the specified directory and follow the prompts.

3) The configuration tools should be installed now. If an error occurs, the system prompts that the configuration tools Installation failed,
Don't worry. We still haven't installed two other patches. In fact, it's exactly a patch. p2617419_210_generic.zip is just
I don't need a patch, just do it manually.
Failed to install agent configuration Assistant
$ Unzip p3238244_9204_linux.zip
$ CP 3238244/files/lib/stubs/* $ ORACLE_HOME/lib/stubs/
$ CD $ ORACLE_HOME/Network/lib/
$ Make-F ins_oemagent.mk install

An error occurred while installing Oracle Net configuration assistant and Oracle Database Configuration assistant.
$ RM $ ORACLE_HOME/JRE
$ Ln-S $ oracle_base/JRE/1.3.1/$ ORACLE_HOME/JRE
$ Ln-S $ ORACLE_HOME/JRE/bin/Java $ ORACLE_HOME/JRE/bin/JRE
$ Ln-S $ ORACLE_HOME/JRE/bin/i386/native_threads/Java $ ORACLE_HOME/JRE/bin/i386/native_threads/JRE

OK, now retry, you can successfully install configuration tools, and the installation is complete...

========================================================== ============
* Tips: (this is a problem that occurs during my installation and its solution)
========================================================== ============

1. Error while loading shared libraries: libstdc ++-libc6.1-1. so.2:
Cannot open shared object file: no such file or directory-after
./Runinstaller execution.
========================================================== ======================================
Solution:
Su-
# Cd/usr/lib
# Ln-s libstdc ++-3-libc6.2-2.10.0.so libstdc ++-libc6.1-1. so.2

2. Oracle 9i patch
======================================
P2617419_220_generic.zip
P3006854_9204_linux.zip
P3238244_9204_linux.zip
Http://www.opennet.ru/soft/ora_inst/

Compat-libcwait-2.0-2.i386.rpm
Compat-oracle-rhel4-1.0-5.i386.rpm
Http://oss.oracle.com/projects/compat-oracle/files/RedHat/

3. Path of several required packages
======================================
Compat-DB -- As5 Disk 3
Compat-gcc-34 -- 2
Compat-gcc-34-c ++ -- 2
Compat-libgcc -- 3
Openmotif -- 3

4. Exception in thread "Main" Java. Lang. unsatisfiedlinkerror:
/Tmp/OraInstall2007-12-06_07-00-08PM/JRE/lib/i386/libawt. So: libxp. so.6:
Cannot open shared object file: no such file or directory
========================================================== ======================================
Solution: Install the follow RPMs
Libxpm -- 1
Libxpm-devel -- 2
Libxp -- 2
Libxp-devel -- 2

5. Exception in thread "Main" Java. Lang. internalerror: Can't connect
X11 window server using ': 100' as the value of the display variable.
At sun. AWT. x11graphicsenvironment. initdisplay (native method)
At
Sun. AWT. x11graphicsenvironment. & lt; clinit> (x11graphicsenvironment. Java: 59)
At java. Lang. Class. forname0 (native method)
At java. Lang. Class. forname (class. Java: 120)
At
Java. AWT. graphicsenvironment. getlocalgraphicsenvironment (graphicsenvironment. Java: 5
At java. AWT. Window. & lt; init> (window. Java: 18
At java. AWT. Frame. & amp; lt; init & gt; (frame. Java: 315)
At java. AWT. Frame. & amp; lt; init & gt; (frame. Java: 262)
At oracle. sysman. OII. oiic. oiicinstaller. Main (oiicinstaller. Java: 593)
========================================================== ========================================================== ======
Solution: (xhost + problem)
1. log on to X-window with an oracle user
Or
2. Run with the root user
# Xhost +

6. Fatal: stack size too small. Use 'ulimit-S' to increase default
Stack size.
======================================
The second operation is normal.

7. $ dbca // dbca cannot be started. The error message is as follows:
/Opt/Oracle/JRE/1.1.8/bin/../lib/i686/green_threads/libzip. So: Symbol
Errno, version glibc_2.0 not defined in file libc. so.6 with Link Time
Reference (libzip. So)
Unable to initialize threads: cannot find class Java/lang/thread
Cocould not create Java VM
======================================
Solution: (refer to the latest installation of oracle9204 in cold wind Fedora 7)
$ CD/opt/APP/Oracle/product/9.2.0
$ LS-l JRE
Lrwxrwxrwx 1 Oracle oinstall 25 dec 7 10:11 JRE->/opt/APP/Oracle/JRE/1.1.8
$ RM JRE
$ Ln-S/opt/APP/Oracle/JRE/1.3.1 JRE
$ Su-
# Cd/opt/APP/Oracle/product/9.2.0/JRE/bin/
# Ln-s Java JRE
# Cd i386/native_threads/
# Ln-s Java JRE

8. There are:
Parameter "orahome" =/home/Oracle/product/9.2.0
Parameter "nodeinfo" = no_value
An error occurred.
========================================================== ====================
Solution:
Install patch p3238244_9204_linux.zip
Unzip p3238244_9204_linux.zip
CD 1, 3238244
Manually copy all files in the 3238244/files/lib/stubs directory
The/Oracle/product/9.2.0/lib/stubs/directory can also be:
CP files/lib/stubs/* $ ORACLE_HOME/lib/stubs/
Reconnect and compile "agent" related programs
CD $ ORACLE_HOME/Network/lib/
Make-F ins_oemagent.mk install
Wait patiently for successful compilation.
Click "Agent configuration assistant" in the Oracle Installation Program, and then click
"Retry" re-run the configuration tool. After a while, it will succeed and exit the installation.

9./opt/APP/Oracle/9.2.0/Apache/bin/apachectl startssl: httpd
Cocould not be started
/Opt/APP/Oracle/9.2.0/Apache/bin/httpd: Error while loading
Shared libraries: libdb. so.2: cannot open shared object file: no such
File or directory
========================================================== ====================
Solution:
Install the gnome-libs-1.4.2-7.rhel5.i386.rpm and its dependent packages
Giflib-4.1.3-8.i386.rpm
Libpng10-1.0.18-2.i386.rpm
Glib-1.2.10-26.fc7.i386.rpm
ORBit-0.5.17-22.rhel5.i386.rpm
Gnome-libs-1.4.2-7.rhel5.i386.rpm
Rpmdb-redhat-4-0.20071031.src.rpm
Imlib-1.9.15-2.fc7.i386.rpm
GTK +-1.2.10-57. fc7.i386. rpm

At the end of the article, I wrote three simple scripts for easier installation.
++ ++
+ To make installation easier, I wrote three simple scripts:
+ Beforeinstalloracle. Sh,
+ Patch_before_install.sh,
+ Patch_configuration_tools.sh
++ ++

++
+ The patch directory structure is as follows:
++
C:/> tree/f d:/patch
Directory path list of volume Program
The serial number of the volume is 0006ee50 d662: 9a5f
D:/patch
│ Beforeinstalloracle. Sh
│ P3006854_9204_linux.zip
│ P3238244_9204_linux.zip
│ Patch_configuration_tools.sh
│ Compat-libcwait-2.1-1.i386.rpm.
│ Patch_before_install.sh
│
─ ── Rpm
│ LibXp-1.0.0-8.i386.rpm.
│ Openmotif-2.3.0-0.3.el5.i386.rpm.
│ Compat-db-4.2.52-5.1.i386.rpm.
│ LibXp-devel-1.0.0-8.i386.rpm.
│ Compat-gcc-34-c +-3.4.6-4. i386.rpm
│ Openmotif-devel-2.3.0-0.3.el5.i386.rpm.
│ Compat-gcc-34-3.4.6-4.i386.rpm.
│ LibXpm-3.5.5-3.i386.rpm.
│ Compat-libgcc-296-2.96-138.i386.rpm.
│ LibXpm-devel-3.5.5-3.i386.rpm.
│
Upload-Download
Gnome-libs-1.4.2-7.rhel5.i386.rpm
ORBit-0.5.17-22.rhel5.i386.rpm
Libpng10-1.0.18-2.i386.rpm
GTK +-1.2.10-57. fc7.i386. rpm
Gnome-libs-devel-1.4.2-7.rhel5.i386.rpm
Glib-1.2.10-26.fc7.i386.rpm
Imlib-1.9.15-2.fc7.i386.rpm
Giflib-4.1.3-8.i386.rpm
Rpmdb-redhat-4-0.20071031.src.rpm

Note: packages under the download directory can be found online.
:
Http://ox0spy.googlepages.com/download.zip
Http://blogimg.chinaunix.net/blog/upfile2/080623102132.zip