Installing Oracle 10g on RHEL AS 3 Step-by-Step Author: Fenng
Installing Oracle 10g On Red Hat Enterprise Linux Advanced Server 3 (RHEL 3) V 0.21 Not long ago, Oracle (Oracle) company announced in the US California, Oracle 10G database created a new world in TPC-H benchmark test This is a shocking message. Because this test is performed on the platform of Linux (Red Hat Enterprise Linux Advanced Server 3). This fully shows Oracle to efficiently manage large-scale data warehouses on low-cost Linux cluster servers. Ability, also indicates that Linux has the advantage of performance prices, marking Linux has been mature in large-scale enterprise applications. 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 in accordance with regular, remember to install the development tool (GCC and other necessary tools).
The 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 to the following: # ----------- Begin from here --------------------------- ----------- 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 Here ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------- 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, check if the above operation is correct: # / sbin / sbin / sbin / sysctl -a | grep file-max # / sbin / sysctl -a | grep ip_local_port_range to set the shell for Oracle users Generally, for performance considerations, it is necessary to make the following settings to improve the Nofile of the Oracle user (open file descriptor. Maximum number) and NPROC (maximum number of processes available for single users) # vi /etc/security/limits.conf # Add as follows * 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. Verify that the following rpm packs have been installed: make-3.79binutils-2.0.14.5.compat -GCC-7.3-2.96.122Compat-GCC-C - 7.3-2.96.122compat-libstdc - 7.3-2.96.122compat-libstdc - devel-7.3-2.96.122 # rpm -qa | grep compat # Output on my machine As follows: Compat-GCC-C - 7.3-2.96.122compat-libstDC - 7.3-2.96.122compat-libstDC - Devel-7.3-2.96.122Compat-Glibc-7.x-2.2.4.32.5compat-DB-4.0.14- 5COMPAT-GCC-7.3-2.96.122
# rpm -qa | grep openmotif openmotif-devel-2.2.2-16openmotif-2.2.2-16
# rpm -qa | grep setarchsetarch-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
It is necessary to note that these packages are dependent, and the order in order is to be found. Otherwise, the error will not be installed.
In addition, it is best to verify the version of GCC and GLIBC (requires GCC-3.2.3-2 or higher) #GCC -V # rpm -q glibc
Creating users and related groups # / usr / sbin / groupadd dba # / usr / sbin / uSradd DBA # / usr / sbin / useradd -g oinstall -g dba oracle If only test purposes, there is nothing to create an Oinstall group. But Still a good specification. If the Oracle user and the DBA group have existed, make appropriate adjustments.
Check and adjust environment variables
Log in to Oracle User # SU - Oracle $ CD $ VI .BASH_PROFILE
# Add the following, your specific value should not be the same as this.
export ORACLE_BASE = / u / app / oracleexport ORACLE_HOME = $ ORACLE_BASE / product / 10.1.0 / db_1export ORACLE_SID = TESTexport PATH = $ PATH: $ HOME / bin: $ ORACLE_HOME / binexport LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / usr / libexport LC_CTYPE = en_us.utf-8
Then perform $ source .bash_profile to make the environment variable take effect. / U / app / oracle and other directories should establish and do appropriate licenses.
Start installing 10g
Mount Your installation disk. (I usually copy the file to a specific location in the system, such as / u / install). Perform $ SH / U / Install / RunInstaller If the installation screen does not appear, see the 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.
Greatly reducing the possibility of error below is the content check is 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. Passedcheck completion. 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 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 Overall Result of this check is: passed =============================================================================================================================================================================== ============================================================================================================================================================================================================= ======= Other steps are relatively clear, no longer repeat it. The final system prompts you to run the root.sh file. Follow the prompts. FAQ (more common in the Linux platform)
1. Cannot start the installation interface. Running the RunInstaller prompt 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 not connect to x11 window server using "localhost: 0.0" at. ......
Workaround: Set your Display environment parameters. # @ E 0 0 0 0 i 0 0 0 或者 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简 简Interface Display Many "Oral" garbled solutions: View Locale Output # localelang = en_us.utf-8lc_cType = zh_cn.gb18030lc_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 re-call the installer. 3. Use IE Log in to the Linux server appears garbled in the Linux (UNIX) environment to successfully install Oracle 10G, log in with IE Browser under Windows 10g EM, buttons are "oral" boxes. 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 more thorough, the former compares "Quick & Dirty" .4. When you create a database, an error solution that appears in ORA-03113: Viewing the core parameters is correct. Reference Http://www.dbanotes.net/oracle/ora-03113.htm5. REDHAT 9 / FC1 and other systems 10G do not support how to install? Solution: 10G Solution 1 is installed on 10G unsupported Linux issues 1). Running Runinstaller -ignoreSysPrereqs, this will skip inspection 2). Excerpted from 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 installation, execute 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 Install / ORAPARAM.INI file to achieve the purpose 6 how to turn off the Ocssd.bin process? Workaround: Edit / etc / inittab file (do a good backup) Note This line: H1: 3: Respaw: /etc/init.d/init.cssd Run> / dev / null 2> & 1
Original source: http://www.dbanotes.net/oracle/install-oracle10g-rhel3.htm Back Home
I would Welcome Any Feedback.Please Send Questions, Comments or Corrections to Fenng@itpub.net.
