[Oracle] Installing Oracle 10g On Rhel As 3 Step-by-Step Squiring: FENNG
Date: 06-APR-2004
Source: http://www.dbanotes.net
Version: 1.01
Not long ago, Oracle's headquarters in California announced that Oracle 10G database created a new world record with Oracle RAC in TPC-H. This is a shocking message. Because this test is in Linux ( The platform of Red Hat Enterprise Linux Advanced Server 3 is performed on the platform of the Oracle to efficiently manage large-scale data warehouses on low-cost Linux cluster servers, but also showing Linux's advantage over the performance price, marking Linux It is already mature in large-scale enterprises.
I believe that many friends have already tested 10g, now let us start 10g from here.
This article describes the necessary steps and related knowledge installed on Red Hat Enterprise Linux Advanced Server 3 (RHEL 3). This article assumes that your Linux operating system is already installed, and you should have a certain UNIX operating system background knowledge.
Configuring Redhat AS 3
Operating system version:
Red Hat Enterprise Linux As Release 3 (Taroon)
KERNEL 2.4.21-4.el on AN i686
Install the operating system according to the regular, remember to install the development tool (GCC and other necessary tools).
Necessary hardware information check
Check content minimum check command reference Physical memory 512M # grep memtotal / proc / meminfo switched space 1.0 GB or 2 times memory size # Grep swaptotal / proc / meminfo / TMP space 400 MB # DF -K / TMP software required Space 2.5 GB # DF -K (the bigger space, the better if it is a formal system, should be a detailed plan) Database file 1.2 GB # DF -K (the bigger space is, if it is a formal system, you should make a detailed plan)
After checking, the core parameters should be modified. Perform the following command:
#vi /etc/sysctl.conf
# Note: #I represents using the root user action, $ represents using the Oracle user. The blue portion behind the prompt indicates the command you need to enter, the following. Add the following:
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 operation to make the changes we do.
Note: The above kernel.shmmax / kernel.sem et al. Is a typical core parameter configuration. You may need to make appropriate changes based on your actual environment.
Description of these core parameters is a detailed description in Oracle's Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems. (Http://download-west.racle.com/docs/html/a96167_01/ Toc.htm then, you should check 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, due to performance considerations, it is necessary to make the following settings to improve the Oracle user's Nofle user's Nofile (maximum number of file descriptors that can be opened) and NPROC (maximum number of processes available for 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 / etc / profile file, add the following:
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, execute $ unlimit verification.
Check and install related patches
Installing Oracle on this version of RHEl, there must be several packages. Make sure the following RPM packages have been 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
# 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 after the author has installed the specific RPM package. In general, the output results on your system are different. If the individual package is not installed, install the system on the disc mount, find specific software Package (most in the third disc), then use the following command to install the corresponding package:
# rpm -ivh compat ..... rpm
Adoption is that these packages are dependent between these packages. Otherwise, you have to be able to install errors. In addition, it is best to verify that GCC and GLIBC version (requires GCC-3.2. 3-2 or higher):
#gcc -v
#rpm -q glibc
Create users and related groups
# / usr / sbin / groupadd oinstall
# / usr / sbin / groupadd dba
# / usr / sbin / usradd -g oinstall -g dba oracle
If it is just a test purpose, there is nothing wrong with the Oinstall group. But it's better to standardize. If the Oracle user and the DBA group already exist, make appropriate adjustments.
Check and adjust environment variables
Log in to Oracle users
# SU - Oracle $ CD
$ vi .bash_profile
# Add the following, your specific value should not be the same as this.
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
Then execute
$ SOURCE .BASH_PROFILE
Enable environment variables to take effect. / U / app / oracle and other directories should be established and appropriate authorization.
Start installing 10g
Mount Your installation disk. (I usually copy the file to a specific location in the system, such as / u / install). Execution:
$ SH / U / Install / Runinstaller
If the installation screen cannot appear, see FAQ behind this article. It is very worthy of that the 10G installation is more than a CHECKING OPERATING SYSTEM CERTIFICATION. Special practical. The installation file will automatically detect the required conditions. If there is a place that does not meet, the installer will report to you. And give specific reasons. It greatly reduces the possibility of error. Below is the content that checks the 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 Overalll 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.PassedChecking for shmmin = 1; Found Shmmin = 1. Passed
Checking for shmmax = 2147483648; Found Shmmax = 2147483648. Passed
Check Complete. The Overalll 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 Overalll 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 Overalll Result of this Check IS: Passed
============================================================================================================================================================================================================= ===================== Validating Oracle_Base Location (if set)
Check Complete. The Overalll Result of this Check IS: Passed
============================================================================================================================================================================================================= =====================
Other steps are relatively clear and will not be described again.
Finally, the system will prompt you to run the root.sh file. You can do it according to the prompt.
FAQ (installing Oracle in the Linux platform is more common)
1. Cannot start the installation interface
Running the RunInstaller prompt information is similar to:
Xlib: Connection To "Localhost: 0.0" Refused by Server
XLIB: Client Is Not Authorized to Connect To Server
Exception in thread "main" java.lang.InternalError:
Can't connect to x11 window server using "localhost: 0.0" At .......
Workaround: Set your Display environment parameters.
# export display = your_ipaddress: 0.0
Change your_Ipaddress to your IP. Or use root to make a simple execution # xhost (to pay attention to this will have a secure hidden danger)
2. The installation interface shows a lot of "mouth".
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_MONTARY = "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 recall the installer.
3. Use IE Log in to the EM on the Linux server appears garbled
In the Linux environment, Oracle 10G is successfully installed, logged into 10G EM from Windows, and the button is "oral" box. Solution: Reference:
http://www.dbanotes.net/oracle/oracle-10g-font.properties.htm
4. Errors in ORA-03113 appear when creating a database
Workaround: Viewing the core parameters is correct. Reference:
http://www.dbanotes.net/oracle/ora-03113.htm
5. REDHAT 9 / FC1 and other systems 10G do not support how to install?
Workaround: Install 10G solution on 10G unsupported Linux release
1). Run Runinstaller -ignoresysPreequ, which will skip check.
2).
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, do the following:
#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 the Oracle's Install / ORAPARAM.INI file to achieve the purpose.
6. How to turn off those Ocssd.bin processes?
Workaround: Edit / etc / inittab file (do a good job) Note This line:
H1: 3: Respawn: /etc/init.d/init.cssd Run> / dev / null 2> ................
