Installing Oracle 10g on RHEL as 3 step-by-step

Oracle
Installing Oracle 10g on RHEL as 3 step-by-step--Reprint

Author: fenng

Installing Oracle 10g on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) V 0.21

Oracle's 10g database and Oracle RAC have created a new world in the Tpc-h benchmark in the US-California headquarters recently.
. This is a shocking news. Because this test was done on the platform of Linux (Red Hat Enterprise linux Advanced Server 3).
This fully demonstrates Oracle's ability to efficiently manage large data warehouses on Low-cost Linux cluster servers, as well as the advantages of Linux for performance-price ratios,
Indicates that Linux has matured in large-scale enterprise applications.

I believe many friends have been eager to 10g, now from here let us start the 10g journey.

This article describes the necessary steps and knowledge for installing Oracle 10g on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3). This article assumes that
Your Linux operating system is installed and you should have a background on Unix operating systems.


Configure Redhat as 3

Operating system version: Red Hat Enterprise Linux as Release 3 (Taroon)
Kernel 2.4.21-4.el on a i686

Follow the usual installation of the operating system, and remember to install the development tools (necessary tools such as GCC).


Necessary Hardware information check:
Check the content minimum check command reference physical memory 512m# grep memtotal/proc/meminfo Swap Space 1.0 GB or twice times memory size # grep swaptotal/proc/meminfo/tmp Space MB # df-k /TMP software required space 2.5 GB # DF-K (the greater the space the better, if it is a formal system, should be detailed planning) database files 1.2 GB # df-k (the larger the space the better, if the formal system, should be detailed planning)

After checking as above, you should modify the core parameters. Execute the following command:

#vi/etc/sysctl.conf
#注释: #表示使用root用户操作, $ represents an operation with an Oracle user. The blue section behind the prompt indicates the command that needs to be entered, below.

At the end of the file, add the following:

#-----------Begin--------------------------------------
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
#--------------End--------------------------------------------

After editing, save and execute the #/sbin/sysctl-p command operation to make the changes we have made effective.

Note: The above kernel.shmmax/kernel.sem is a typical core parameter configuration. You may need to make appropriate changes to your actual environment.

Instructions for these core parameters are in Oracle's oracle9i installation Guide Release 2 (9.2.0.1.0) for UNIX Systems
In a very detailed description. (http://download-west.oracle.com/docs/html/A96167_01/toc.htm)

Then, you should check to see if the above operation is correct:

#/sbin/sysctl-a | grep sem
#/sbin/sysctl-a | grep SHM
#/sbin/sysctl-a | grep File-max
#/sbin/sysctl-a | grep ip_local_port_range


Set the shell limit for Oracle users

In general, for performance reasons, the following settings need to be set up to improve the Oracle user's Nofile (open file
Maximum number of descriptors) and Nproc (maximum number of processes available to a single user)

# vi/etc/security/limits.conf
# Add the following line

* Soft Nproc 2047* hard nproc 16384* soft nofile 1024* 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 install the relevant patches

To install Oracle on this version of Rhel, you must have several packages. Verify that the following RPM packages are installed:

make-3.79
binutils-2.11
Openmotif-2.2.2-16
Setarch-1.3-1
compat-db-4.0.14.5
compat-gcc-7.3-2.96.122
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122

# Rpm-qa | grep compat
# The output on my machine is as follows:
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122
compat-glibc-7.x-2.2.4.32.5
Compat-db-4.0.14-5
compat-gcc-7.3-2.96.122

# Rpm-qa | grep openmotif
Openmotif-devel-2.2.2-16
Openmotif-2.2.2-16

# Rpm-qa | grep setarch
Setarch-1.3-1

The content shown above is the result of the author having installed the specific RPM package. In general, the output on your system differs from this. If a
Do not pack the installation, install the system CD mount, find the specific package (most on the third CD), and then use the following command to install the corresponding
The package:

# RPM-IVH compat.....rpm

The extra note is that these packages are dependent and sequential in order. Otherwise, errors that cannot be installed are reported.

In addition, it is best to verify the GCC and glibc versions (requirements are gcc-3.2.3-2 or higher)

#gcc-V
#rpm-Q glibc

Creating users and related groups

#/usr/sbin/groupadd Oinstall
#/usr/sbin/groupadd DBA
#/USR/SBIN/USERADD-G OINSTALL-G dba Oracle

If it's just for testing purposes, it's OK not to create oinstall groups. But it's better to be normative. If the Oracle user and the DBA group are already present, make
The appropriate adjustment can be.

Check and adjust environment variables

Log on as an Oracle user
# su–oracle
$ cd
$ vi. Bash_profile

#添加如下内容, your exact value should not be exactly the same as this one.

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. Directories such as/u/app/oracle should be established and properly licensed.


Start installation 10g

Mount your installation disk. (I usually copy files to a specific location in the system, such as/u/install). Perform

$ sh/u/install/runinstaller

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

It is highly commendable that the 10g installation is more than a previous step of Checking operating system certification. Especially practical.
The installation file automatically detects the required conditions. If there is a problem, the installer will report it to you. and will give specific reasons. Greatly 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, you will be prompted to run the root.sh file. Follow the prompts.

FAQ (more common with Oracle installed on Linux platforms)

1. The installation interface cannot be started. Run the RUNINSTALLER hint message 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 to replace your_ipaddress with your IP. or
Simple execution with root # Xhost + (Note that this will have security implications)


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 http://www.puschitz.com/modify/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


Reference information

Werner Puschitz's 10g Installation Guide http://www.puschitz.com/InstallingOracle10g.shtml
Werner Puschitz Site of the article is very informative, if you encounter the article did not clarify the problem, you can go to see there. This article has borrowed a lot of content from this site.

Itpub Forum 10g Kamus and so on the Masterpiece Http://www.itpub.net/forumdisplay.php?s=&forumid=70

For information about core parameters, please find Google http://www.google.com/

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

Dbanotes.net My site includes a lot of information about Oracle http://www.dbanotes.net/

Original source:
Http://www.dbanotes.net/Oracle/Install-Oracle10g-RHEL3.htm

Back Page



I would welcome any feedback.
Please send questions, comments or corrections to Fenng@itpub.net.