Install Oracle 9i/10g on RHEL as 3

Oracle
Install Oracle 9i/10g on RHEL as 3

Author: ern (yaoyongping@gmail.com)

This article describes the steps and knowledge necessary to install Oracle 9i/10g on red Hat Enterprise Linux Advanced Server 3 (RHEL as 3). A lot of related articles, this article mainly focuses on the collation and summary of the user (especially fenng) documents, Red Hat Company's Rhel related white paper, Oracle Company's technical documents and white papers, compare two versions in as 3 similarities and differences, as far as possible to give complete installation instructions. Installation of the OS will no longer be repeat. The overall discussion is dominated by a 10g process, but the differences in 9i are inserted in the box.

Hardware requirements:

Check the content minimum check command reference physical memory 512m# grep memtotal/proc/meminfo Swap Space 1.0 GB or twice Times memory # grep swaptotal/proc/meminfo/tmp Space MB # df-k/TM P Software Required space 2.5 GB # DF-K database file 1.2 GB # Df-k




Software Requirements and Configuration


Operating system version: Red Hat Enterprise Linux as Release 3 (Taroon) Update 3
For 9i, Kernel 2.4.21-4el (general as 3 is satisfied) is required, and kernel 2.4.21-15el is required for 10g.

Verify that the following RPM packages are installed:

make-3.79.1gcc-3.2.3-34glibc-2.3.2-95.20
compat-db-4.0.14.5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
Compat-libstdc++-devel-7.3-2.96.128openmotif21-2.1.30-8setarch-1.3-1
The current RPM package of the machine can be viewed by following instructions Rpm-qa | grep compat
Rpm-qa | grep openmotif
Rpm-qa | grep Setarch Gcc-v
Rpm-q glibc
If the individual package is not installed, locate the specific package (most on the third CD) in the system installation CD, and then use the following command to install the appropriate package:

RPM-IVH compat.....rpm

Note: These packages are dependent on each other in order to find a good, or you will report the error can not be installed.

The above hardware and software inspection is for 10g, general as 3 U3 can be achieved, 9i requirements will be more relaxed, but in 9i please note:

GCC should use version 2.96, so perform before installation:

mv/usr/bin/gcc/usr/bin/gcc323
Ln-s/USR/BIN/GCC296/USR/BIN/GCC
mv/usr/bin/g++/usr/bin/g++323
Ln-s/usr/bin/g++296/usr/bin/g++

After the installation is complete:

rm/usr/bin/gcc
mv/usr/bin/gcc32/usr/bin/gcc

Set Core parameters

Vi/etc/sysctl.conf

At the end of the file, add the following:


#----------------------------------------
# Parameters for oracle10g
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
#----------------------------------------


After editing, save, execute the/sbin/sysctl-p command to make the change take effect.

Note: The above Kernel.shmmax/kernel.sem are typical core parameter configurations that may require appropriate changes to the actual environment. The following table can be used to get the current set value, if the set value is larger than the above example, the set value is preserved. The Kernel.shmmax should be set to half the system memory, which specifies the size of the maximum shared memory segment (Segment) allowed by the kernel, and Oracle will request a segment for the SGA after Oracle is installed. If the system memory exceeds the 8G installation error, please refer to the Appendix large memory processing.
Parameter command Semmsl,semmns,semom & SEMMNI/SBIN/SYSCTL-A | grep Semshmall,shmmax & Shmmni/sbin/sysctl-a | grep shmfile-max/sbin/sysctl-a | grep file-maxip_local_port_range/sbin/sysctl-a | grep ip_local_port_range
9i, should also be added at the end of the file: # Disables packet forwarding
Net.ipv4.ip_forward = 0
# Enables source Route verification
Net.ipv4.conf.default.rp_filter = 1
# Disables the MAGIC-SYSRQ key
KERNEL.SYSRQ = 0

Creating users and related groups

/usr/sbin/groupadd DBA
/usr/sbin/groupadd Oper
/usr/sbin/groupadd Oinstall
/USR/SBIN/USERADD-G oinstall-g Dba,oper Oracle
/USR/SBIN/PASSWD Oracle

Set Shell limits

For performance reasons, you also need to increase the limit for Oracle users by increasing the Nofile (maximum number of file descriptors that can be opened) and Nproc (the maximum number of processes available to a single user).

Vi/etc/security/limits.conf
Add the following line:

Oracle Soft Nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard Nofile 65536
Add the following line to/etc/pam.d/login file:
Session required/lib/security/pam_limits.so



Edit the/etc/profile file and add the following section:
if [$USER = "Oracle"]; Then if [$SHELL = "/bin/ksh"]; Then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fi fi
After that, perform $ unlimit verification.

Check and adjust environment variables

Log on as an Oracle user
Su–oracle
Cd
VI. bash_profile

Add the following parameters, the specific value of the actual environment.

Export Oracle_base=/u/app/oracle
Export Oracle_home= $ORACLE _base/product/10.1.0/db_1
Export Oracle_sid=test
Export path= $PATH: $HOME/bin: $ORACLE _home/bin
Export Ld_library_path= $ORACLE _home/lib:/usr/lib
Export Lc_ctype=en_us. UTF-8

And then execute
source. bash_profile
Make the environment variable effective. /u/app/oracle and other related directories should be established and properly licensed.


Start installation

Mount Mount disk, general online download is compressed file, execute

Cp/mnt/cdrom/ship.db.cpio.gz/u/install

Gunzip ship.db.cpio.gz
CPIO-IDMV < Ship.db.cpio
Sh/u/install/disk1/uninstaller

If the installation screen does not appear, view the FAQ later in this article.

10g installation compared to the previous step of a Checking operating system certification. The installation file automatically detects the required conditions. If there is a failure, the installer will report it to you, and will give you specific reasons to reduce the likelihood of error.
Here's what to check for a successful output:

Checking Operating System Certification
Expected Result:one of redhat-2.1,redhat-3,unitedlinux-1.0
Actual result:redhat-3
Check complete. The overall result of this check is:passed
=======================================================================

Checking Kernel Parameters
Checking for version=2.4.9.25; Found version=2.4.21. Passed
Checking for shmall=2097152; Found shmall=2097152. Passed
Checking for shmseg=10; Found shmseg=4096. Passed
Checking for semmsl=250; Found semmsl=250. Passed
Checking for semmni=128; Found semmni=128. Passed
Checking for filemax=65536; Found filemax=65536. Passed
Checking for shmmni=4096; Found shmmni=4096. Passed
Checking for semmns=32000; Found semmns=32000. Passed
Checking for semopm=100; Found semopm=100.passed
Checking for Shmmin=1; Found Shmmin=1. Passed
Checking for shmmax=2147483648; Found shmmax=2147483648. Passed
Check complete. The overall result of this check is:passed
=======================================================================

Checking Recommended Operating System packages
Checking for make-3.79; Found MAKE-3.79.1-17. Passed
Checking for binutils-2.11.90.0.8-12; Found binutils-2.14.90.0.4-26. Passed
Checking for gcc-2.96; Found gcc-3.2.3-20. Passed
Checking for openmotif-2.1.30-11; Found openmotif-2.2.2-16. Passed
Check complete. The overall result of this check is:passed
=======================================================================

Checking Recommended GLIBC version
Expected result:2.2.4.31.7
Actual result:2.3.2.95.3
Check complete. The overall result of this check is:passed
=======================================================================

Validating oracle_base location (if set)
Check complete. The overall result of this check is:passed
=======================================================================

The other steps are clear and no longer repeat.

Finally the system will prompt you to run root.sh file, follow the prompts to do so.
9i installation process and 10g is basically consistent, in addition to the lack of procedures to check the OS requirements, but also pay attention to handling the following errors. 1. When starting oui libcwait.so error login with Oracle user, and set up files in their home directory libcwait.c as follows/*
Gcc-o2-shared-o $HOME/libcwait.so-fpic
$HOME/libcwait.c
*/
#include
#include
#include
#include
pid_t
__libc_wait (int *status)
{
int res; ASM volatile ("PUSHL%%ebx\n\t"
"Movl%2,%%ebx\n\t"
"Movl%1,%%eax\n\t"
"Int $0x80\n\t"
"Popl%%ebx"
: "=a" (res)
: "I" (__NR_WAIT4), "0" (Wait_any), "C" (status), "D" (0), "S"
(0));
return res;
Use the Gcc-02-shared-o $HOME/libcwait.so-fpic $HOME/libwait.c compilation. Set related environment variables: Export ld_assume_kernel=2.4.19
Export ld_preload= $HOME/libcwait.so Another solution is to metalink.oracle.com download P3006854_9204_linux.zip. 2. When the link error first relates to $oracle_home/network/lib/ins_oemagent.mk, simply comment the file as follows: # Ldflags = $ (stdmode)-l$ (libhome)-l$ (  Oracle_home)/rdbms/lib-l $ (oracle_home)/network/lib then click "Retry" to continue the installation. The second error is $oracle_home/ctx/lib/ins_ctx.mk because/usr/bin/ld:ctxhx:hidden symbol ' stat ' in/usr/lib/libc_nonshared.a (  Stat.os), can be directly ignored. The above link errors can also be resolved by downloading binutils-2.11.90.8.8-13.i386.rpm on the Oracle Metalink Web site, but it is recommended that you replace the version of the original Rhel with the package and complete the database installation.
Appendix:

A. FAQ

1. Unable to start the installation interface

Running the RUNINSTALLER hint message is similar to the following:

Xlib:connection to "localhost:0.0" refused by server
Xlib:client is isn't authorized to connect to server

Exception in thread "main" Java.lang.InternalError:can ' t connect to X11 Window server using ' localhost:0.0 '
At .....

Solution: Set your display environment parameters.

Export display= your_ipaddress:0.0

or use root to simply execute the # Xhost + (Note that there will be security risks).


2. Installation interface shows a lot of "mouth" like garbled

Workaround: View locale output
# locale
Lang=en_us. UTF-8
Lc_ctype=zh_cn. GB18030
Lc_numeric= "en_US. UTF-8 "
Lc_time= "en_US. UTF-8 "
Lc_collate= "en_US. UTF-8 "
Lc_monetary= "en_US. UTF-8 "
Lc_messages= "en_US. UTF-8 "
Lc_paper= "en_US. UTF-8 "
Lc_name= "en_US. UTF-8 "
Lc_address= "en_US. UTF-8 "
Lc_telephone= "en_US. UTF-8 "
Lc_measurement= "en_US. UTF-8 "
Lc_identification= "en_US. UTF-8 "
Lc_all=


Perform #export Lc_ctype=en_us. UTF-8 and then invokes the installer again.


3. Use IE login Linux server on the em appear garbled

Successfully installed Oracle 10g in Linux (Unix) environment, log on to 10g's em with IE browser from windows, the button is "mouth" box.

Solution: Refer to http://www.dbanotes.net/Oracle/Oracle-10g-font.properties.htm or refer to this http://www.linuxsir.org/bbs/ showthread.php?s=&threadid=98591 The latter is quite thorough, the former compares "Quick & Dirty".


4. A ORA-03113 error occurred while creating the database

Workaround: See if the core parameters are adjusted correctly. Reference http://www.dbanotes.net/Oracle/ORA-03113.htm


5. RedHat 9/FC1 System 10g does not support how to install?

Workaround: Install 10g solutions on 10g Linux distributions that are not supported

1 run Runinstaller-ignoresysprereqs, this will skip the check

2) excerpt from www.puschitz.com modified/etc/redhat-release file:

#su-root
#cp/etc/redhat-release/etc/redhat-release.backup
#cat >/etc/redhat-release << EOF
Red Hat Enterprise Linux as Release 3 (Taroon)
Eof

After installation, perform the following actions:
#su-root
#cp/etc/redhat-release.backup/etc/redhat-release

3). http://www.dbanotes.net/Oracle/10G-Beta-Install-Bug.htm

The same idea, we can modify Oracle's Install/oraparam.ini file to achieve the goal


6 How to turn off those ocssd.bin processes?

Workaround: Edit the/etc/inittab file (backup is done)

Comment out this line:

H1:3:RESPAWN:/ETC/INIT.D/INIT.CSSD Run >/dev/null 2>&1 </dev/null

B. Configuration of large memory

First, the following materials are from install Oracle on RHEL as 2.1 white paper, possibly as 3 for large memory, but the author of this article mainly from the review and edit several documents, the specific installation is limited to hardware also failed to test. Therefore, if there is an error on as 3, you may wish to refer to the following.

Shmmax maximum value is 4gb-1. In order to create a SGA larger than 1.7GB, you must use the Shared memory file system (SHMFS). The instructions are as follows and can be added to the/etc/rc.local, or you can use/etc/fstab to create the Shmfs, commenting out the existing/DEV/SHM entries before adding/DEV/SHM.

Mount-t SHM Shmfs-o Size=32g/dev/shm

Or

Mount-t SHM Shmfs-o Nr_blocks=8388608/dev/shm

Using SHMFS,SGA on a 8GB system can be adjusted to a maximum of 7GB. Need to adjust Init.ora, increase:

Use_indirect_data_buffers=true

Another way to use the large SGA is to use lower mapped Base, which can grow from 1.7GB to 2.7GB. You can refer to the Oracle White Paper in a specific way.

C. Configuration of large pages

As the 4MB large page (rather than the normal 4KB), which can reduce the page table entries, the SGA locked in memory, more for the large SGA or multi-user. This feature exists in the Enterprise kernel.

The number of large pages can be viewed Cat/proc/meminfo.

The configuration steps are as follows:

1. In the/etc/rc.local

Echo 2 >/proc/sys/kernel/shm-use-bigpages (Use large page in Shmfs)

echo 1 >/proc/sys/kernel/shm-use-bigpages (Use large page in SysV)

echo 0 >/proc/sys/kernel/shm-use-bigpages (do not use large pages)

2. Add the following parameters to the boot section of/etc/lilo.conf, reconfigure Lilo and reboot the system

Append= "BIGPAGES=XXXXMB"

The SGA for 4GB can be set to 4100MB, and for 2GB, it can be set to 2100MB.

The SGA Max is 5.4GB on the 8GB machine.


Reference information


Installing Oracle 10g on RHEL as 3 step-by-step by fenng
Http://www.dbanotes.net/Oracle/Install-Oracle10g-RHEL3.htm

Tips & Techniques-install & Configure oracle9i & RHEL as

Deploying Oracle9i Database on Red Hat Enterprise Linux V.3

The above two articles can be #rhel找到 in http://www.redhat.com/solutions/info/whitepapers/

Oracle Database Quick Installation Guide G Release 1 (10.1) for Linux x86
Http://download-west.oracle.com/docs/html/B10813_01/toc.htm

Oracle Database Installation Guide G Release 1 (10.1) for UNIX Systems
Http://download-west.oracle.com/docs/html/B10811_02/toc.htm