9i On Rhel 5

Environment: Red Hat Enterprise Linux 5 (RHEL5), Oracle9i (9.2.0.4.0) Below the $ orders are from the beginning of the implementation of the oracle # Ordered by the beginning of the implementation of the root 1. Create users and groups ------------------------Add installation process needed for users and groups $ Su # Groupadd oinstall # Groupadd dba # Useradd-g oinstall-G dba oracle # Passwd oracle 2. Create directory -------------------------We will assume that home directory is / opt / oracle directory: # Mkdir-p / opt/app/oracle/9.2.0 # Chown-R oracle.oinstall / opt / app / oracle 3. System configuration -------------------------A) a core parameters Edit / etc / sysctl.conf Kernel.shmmax = 536870912 set to physical memory here half a memory of G: 512 × 1024 × 1024 Kernel.shmmni = 2G memory of 4096: 1024 × 1024 × 1024 Kernel.shmall = 2097152 Kernel.sem = 250 32000 100128 Other values are not fixed Fs.file-max = 65536 Net.ipv4.ip_local_port_range = 1024 65000 Sem four parameters were SEMMSL (each user has the largest number of signal); SEMMNS (maximum number of signals); SEMOPM (each operating system calls semopm few); SEMMNI (system hard for the largest number of sets). Shmmax largest shared memory to 2 GB of physical memory so if small, can be configured to 536870912. Shmmni smallest shared memory 4096KB. Shmall all memory size. Sysctl amended to reflect the implementation of core parameters to take effect immediately, could reopen # Sysctl-p Can be in the running order changes through the implementation of the following core parameters: # Echo 250 32000 100128> / 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) the establishment of the documentation requirements for oracle 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) setting up the environment variables In / home / oracle / .bash_profile add the following line: Zhang = export ORACLE_SID 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: / lib: / usr / 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 = Oracle export ORACLE_OWNER 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. Patches -------------------------------------------------- -----------------------------------------------A) patch: P3006854_9204_LINUX.zip before installation of the patch to win P2617419_210_GENERIC.zip play after the installation (this is only a patch with, as long as it's set up Environment variable) P3238244_9204_LINUX.zip play after the installation of the 9204 patch, patch repair agent wrong. Http://www.opennet.ru/soft/ora_inst/ Compat-libcwait-2.0-2.i386.rpm LINUX AS 4 patch will be installed before the fight Compat-oracle-rhel4-1.0-5.i386.rpm LINUX AS 4 patch will be installed before the fight, but I did not install it Http://oss.oracle.com/projects/compat-oracle/files/RedHat/ B) a p3006854_9204_LINUX.zip # Unzip p3006854_9204_LINUX.zip # Chmod + x 3006854/rhel3_pre_install.sh # 3006854/rhel3_pre_install.sh C) Installation of compat-libcwait-2.1-1.i386.rpm # Rpm-ivh compat-libcwait-2.1-1.i386.rpm

D) some of the needs of packages, these packages can be found from the system after # 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 E) gnome-libs-1.4.2-7.rhel5.i386.rpm and some rely on the packets These packets can be found online # 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 F) Create Links # Ln-s / usr / lib / libstdc + +-libc6.2-2.so.3 / usr / lib / libstdc + +-libc6.1-1.so.2 5. Start the installation oracle -------------------------------------------------- -------------------------------1) preparation Download oracle 9i Http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html Decompression $ 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) Please restart X then oracle landing system, otherwise they will be out some errors, such as: xhost +, environment variables, etc $ Disk1/runInstaller Did not specify according to the default settings, according to the interface tips, and then Next or OK can be. Oracle install group: oinstall Global Database Name: ox0spy.org (which can be filled out according to your situation) This process will emerge two tips to let you run the script directory specified, in accordance with tips can be done on the 3) should now be installed Configuration Tools, and if this error, suggesting that the failure to install Configuration Tools, Do not worry, we still have two patches did not fight it. Fact accurate that is a patch, only p2617419_210_GENERIC.zip With a patch, I do not need this, just completed manually Agent Configuration Assistant solve installation failure

$ Unzip p3238244_9204_LINUX.zip $ Cp 3238244/files/lib/stubs / * $ ORACLE_HOME / lib / stubs / $ Cd $ ORACLE_HOME / network / lib / $ F ins_oemagent.mk install make Oracle Net Configuration Assistant solution, Oracle Database Configuration Assistant installation failure $ 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 Configuration Tools successfully installed, the installation will be over ... ================================================== * Tips: (This problems appeared in the process of installation and solutions) ================================================== 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-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. Several packets of the needs of the path =========================== 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 to X11 window server using ': 0.0' as the value of the DISPLAY variable. At sun.awt.X11GraphicsEnvironment.initDisplay (Native Method) At Sun.awt.X11GraphicsEnvironment. (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: 58) At java.awt.Window. (Window.java: 188) At java.awt.Frame. (Frame.java: 315) At java.awt.Frame. (Frame.java: 262) At oracle.sysman.oii.oiic.OiicInstaller.main (OiicInstaller.java: 593) ================================================== ============== Solution: (xhost +) 1. Oracle user using x-window Or 2. Run by root users # Xhost + 6. Fatal: Stack size too small. Use 'ulimit-s' to increase default Stack size. ========================== The second run on normal 7. Dbca $ / / dbca not boot, suggesting that mistakes are 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 Could not create Java VM ========================== Solution: (Refer to the latest chill of Fedora installation Oracle9204 Notes 7) $ Cd / opt/app/oracle/product/9.2.0 $ Ls-l JRE Lrwxrwxrwx an 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. Fast Zhuangkuan time: Parameter "orahome" = / home/oracle/product/9.2.0 Parameter "nodeinfo" = NO_value Tip failure. ================================================== ===== Solution: Branded install the patches p3238244_9204_LINUX.zip Unzip p3238244_9204_LINUX.zip Cd 3238244 Manually 3238244 / files / lib / stubs directory of all documents copied to the / Oracle/product/9.2.0/lib/stubs / directory can be, as follows: Cp files / lib / stubs / * $ ORACLE_HOME / lib / stubs / Re-link compiler "Agent" related procedures Cd $ ORACLE_HOME / network / lib / Make-f ins_oemagent.mk install Patience to wait for success compiler. And click on the installation program in front of the oracle "Agent Configuration Assistant," and click "Retry" re-run configuration tools procedures Guoyihui should be successful, from installation 9. / Opt/app/oracle/9.2.0/Apache/Apache/bin/apachectl startssl: httpd Could not be started / Opt/app/oracle/9.2.0/Apache/Apache/bin/httpd: error while loading Shared libraries: libdb.so.2: cannot open shared object file: No such File or directory ================================================== ===== Solution: Install gnome-libs-1.4.2-7.rhel5.i386.rpm and its reliance on package 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 Written in the final, in order to more easily install, I wrote three simple script +++++++++++++++++++++++++++++++++++++++++++ + In order to make installation easier, I wrote three simple script: + BeforeInstallOracle.sh, + Patch_before_install.sh, + Patch_configuration_tools.sh +++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++

+ Patch directory structure is as follows: ++++++++++++++++++++ C: \> tree / f D: \ patch Volume PROGRAM folder PATH List Volume serial number for 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-296-138.i386.rpm │ libXpm-devel-3.5.5-3.i386.rpm │ └ ─ 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