This is also the note I have written on the Monoprot Forum. Today, I will repume it: http://www.delphibbs.com/keylife/iblog_show.asp? XID = 6526 is as follows: --- Install Oracle9 under Redhat Linux9 little experience of .2.0 of: jrq summary: Description of the process Oracle9.2.0 database installed in redhat Linux9 environment. Keywords: Oracle9i Redhat Linux9 kernel parameter environment variable has been using Oracle817 in Redhat Linux7.1, a few days ago, simply upgrade, to install Oracle9i in the Redhat Linux9 environment. After a few days, I found a lot of information and a number of posts online, summoned it, and then I finally successfully installed Oracle9.2.0 (Oracle9i Enterprise Edition Release 9.2.0.1) on RedHat9 (Oracle9i Enterprise Edition Release 9.2.0.1.0). Now record the installation process and refer to the reference. First, the basic situation introduction: My machine configuration: CPU: P4 1.5G memory: 256M hard drive: 40GB hard disk partition situation: Windows partition C, D, E, a total of 25GB. Linux Swap: 1.5GB Linux Ext2: 12GB Operating System: RADHAT9 (Linux Kernel 2.4.20-8) This article INTD How to install Oracle said that Oracle's requirements for Linux's SWAP partitions at least 2 times more memory , 512M size, of course, the better. When I used Oracle817 in Linux7.1, my SWAP partition size has always been 512M, and it is found in the process of installing Oracle9i. When the database phase is created, "Out of Momry" is prompted, the installation process is Forced to stop, it is estimated that SWAP is a bit small, there is no way, and the disk space is re-divided, and the SWAP partition is increased to 1.5GB, installed again, and safe, smooth, error-free. ^ _ ^ Linux file partitions require 7G. Because the conditional demand for the installation of Oracle under Linux is more demanding, I chose to be all installed when I install RedHat Linux9, so that the system does not need to install this package in the back Oracle9i installation, save a lot of trouble. This method is still in the Redhat Linux7.1 to install Oracle817, learn (there is also recommended all installed in the article on the Internet). All installation of Redhat Linux9 requires approximately 4.5G space, while the Oracle9i database requires 2GB of space (Ho, why, in his article, the database system requires 2 ~ 2.5 GB space), so it is almost 7GB. The above data is for reference only, in one sentence, the larger the partition space to Linux, the better the operation of Oracle.
^ _ ^ 2, ready to work: 1. Oracle 9i gets oracle920_for_linux is I am in ftp://ftp.lib.tsinghua.edu.cn/ this site (Tsinghua's FTP server), spent a night to download A total of 3 compressed files, names are: lnx_920_disk1.cpio.gz size is 527 MB (553,607,967 bytes) LNX_920_disk2.cpio.gz size is 561 MB (588,799,187 bytes) LNX_920_disk3.cpio.gz size is 421 MB (442,089,854 bytes) 3 files have a total of 1.47 GB (1,584,497,008 bytes). 2. Remarks Information See the online article introduction, generally said that it is necessary to consider compatibility, you need to install or replace some RPM packages before installation, and determine the dependence of the RPM package, such as: Glibc- 2.3.2-5.i686.2-5.i386.2-5.i386.rpm, etc.. RPM glibc-devel-2.3.2-5.i386.rpm. I think that as long as you choose all installations of Redhat Linux9, don't install or replace these RPM packages (this is not deep research, don't know if you are right, but at least I have no replacement on my machine. RPM package. Other articles say the free downloaded Red Hat9 is an incomplete version. It itself does not have the corresponding version of the GLIBC installation package, you need to install the GLIBC, maybe I downloaded RedHat Linux9 is "Complete", so I didn't have any operations for Glibc. * _ ^ Of course, when I installed the redhat Linux7x, I want to be another matter). In addition, some articles are described when installing Oracle9i, I need to choose the JDK version for installation, and I have not conducted this work. It is directly installed Oracle9i (because Oracle's installer is to have JDK support, estimate Redhat Linux9 selected It is "all installation" mode, which is already installed. Maybe, let friends who have installed Oracle8i under RedHat7x have a bit unsubstantic * _ *). Third, the configuration operation: Since the province has a big piles of pre-installation operations, then the following will come to some substantive operations, from here, it is formally entered the installation process of Oracle9i. 1. Set the kernel parameters, adjust the signal lights and shared memory: Oracle9i uses Linux shared memory, exchange zones, and other resources, if the system's core parameter settings cannot meet Oracle requirements, there will be various types in installation or use. Question, therefore recommend or modify parameters of these system kernels.
Open the /etc/sysctl.conf file, write the following data to the end of sysctl.conf and save: kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.shmall = 2097152 kernel.sem = 250 32000 100 128 fs.file MAX = 65536 Net.IPv4.ip_local_port_range = 1024 65000 where kernel.shmmax is the maximum size of shared memory segments, kernel.Shmmni is the minimum size of shared memory segments. Enter Directory / Proc / Sys / Kernel, you can use commands: #cat shmmax #cat shmmmmmmmmmad view kernel.shmmax, kernel.shmmni, kernel.Shmall. I saw Kernel.Shmmax in an article: kernel.shmmax = 1024 * 1024 * RAM (M) / 2 (at least). Use the command: #cat Sem You can view the value of kernel.sem. The value of the parameter SEMMSL, 32000 is the value of the parameter SEMMNS, 100 is the value of the parameter SEMOPM, and 128 is the value of the parameter SEMMNI. Next, open the /etc/security/limits.conf file, add the following data to the end of Limits.conf: Oracle Soft Nofile 65536 Oracle Hard NFile 65536 Oracle Soft NPROC 16384 Oracle Hard Nproc 16384 This is set Oracle pair file Claim. When you modify the /etc/sectctl.conf file and the /etc/security/limits.conf file, then restart (Reboot) Redhat Linux9 system, which set these parameters to take effect. If you enter the / proc / sys / kernel path at this time, you will see the parameters of the settings have taken effect by viewing the commands described above. 2. Creating an Oracle user account and installation directory If you have installed Oracle 8i for Linux, you should know that you must first add a user named Oracle under the Linux operating system before installing Oracle, and an Oracle DBA. Group. Oracle requires a specific user (non-root user) in installation and use, and three special users and user groups are required to add three special users and user groups in accordance with Oracle standard. In order to easily install, we build two groups, a responsible installation, another responsible management, and return Oracle installation and use to a specific user to complete. Log in with root users, perform the following operations, build two groups (DBA group and Oinstall group) and an Oracle user, the operation commands are as follows: #groupadd dba #groupadd oinstall # iracle #sswd Oracle Set Oracle password. Oracle installations should comply with the OFA (Optimal Flexible Architecture) specification.
Oracle9i's typical installation requires at least two installation points: a basic running program, one is to store the database, and ensure that Oracle users have accessible permissions to these two directories. Run the following command, create an Oracle installation point (Mount Point): #mkdir / opt / oracle9i #MKDIR / OPT / ORACLE9I / Product #MKDIR /OPT/Orcle9i/Product/9.2.0 #Chown -R Oracle.oinStall / OPT / oracle9i #mkdir / var / opt / oracle9i #chown oracle.dba / var / opt / var / opt / oracle9i 3. Setting environment variables log in as Oracle users, open editing /HOME/Orcle/.bash_profile Document, add the following data line and save: export ld_assume_kernel = 2.4.1 export oracle_base = / opt / opt / oracle9i / product / 9.2.0 export oracle_sid = ORCL (Database SID, can modify, suggestions letter capitalized) export ORACLE_TERM = xterm export TNS_ADMIN = $ ORACLE_HOME / network / admin export LANG = en_US export ORA_NLS33 = $ ORACLE_HOME / ocommon / nls / admin / data LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: / usr / local / lib export LD_LIBRARY_PATH export PATH = $ PATH: $ ORACLE_HOME / bin CLASSPATH = $ ORACLE_HOME / JRE: $ ORACLE_HOME / jlib: $ ORACLE_HOME / rdbms / jlib CLASSPATH = $ CLASSPATH: $ ORACLE_HOME / network / Jlib Export ClassPath #EXPORT Display = Hostip: 0.0 This Oracle user has these environment variables each time you log in. Among them: Oracle_Home is the installation directory of the system software, Oracle_SID is the SID of the database, here you can set it. The last sentence "Export Display = Hostip: 0.0", some introduced online in the online article mentioned in the article, I have tried to add it, but when logging in as Oracle, there will be Hostip's error prompt, and it is not possible to log in. I checked some information, I didn't solve it (I know that Linux knows, if you know the reason, please tell me: jrq@educast.com.cn, thank you), so you will fall in the environment variable, fortunately This does not affect the installation of Oracle9i. Friendly Tips ^ _ ^: The configuration of environment variables here is especially important.
Many reasons for installing Oracle failure under Linux because the environment variables are not configured correctly, the configuration of the environment variable directly affects the installation and configuration of the Oracle9i below. So reminding you to pay more when setting the environment variable. After editing and saving the /Home/oracle/.bash_profile file, it is recommended to log out of the Oracle user before logging out, then re-login as an Oracle user, this can test if the configured environment variable is wrong (for example, the Hostip's error mentioned above) . Next, Oracle9.2.0 for Linux can be installed. Fourth, the installation process: 1. Unzip the installation file to log in with the root user, create a new directory / setup, 3 compressed files Oracle920_for_linux: lnx_920_disk1.cpio.gz size is 527 MB (553, 607,967 bytes) LNX_920_disk2.cpio.gz size is 561 MB (588,799,187 bytes) LNX_920_Disk3.cpio.gz size is 421 MB (442, 089, 854 bytes) Copy to Directory / Setup. (If you do not create a / setup directory, please build a & _ &) Go to the / setup directory, decompress these three files, the operation commands are as follows: #CD / setup #gunzip lnx_920_disk1.cpio.gz #gunzip lnx_920_disk1 After. cpio.gz #gunzip lnx_920_disk1.cpio.gz, then generates three files of the following name: lnx_920_disk1.cpio lnx_920_disk1.cpio lnx_920_disk1.cpio then unlock the CPIO file package, perform the following command #CPIO -IDMV < Lnx_920_disk1.cpio #cpio -idmv At this time, Oracle Universal Installer generates an ORAINSTROT.SH file used by Oracle Inventory, pops up a prompt box, you need to use root to perform this /orainstroot.sh file, at which time a new terminal window can be turned on, Follow the directory path written in the prompt window to perform ORAINSTROOT.SH. After the execution is completed, go back to the prompt window, press the "Continue" button to continue the installation. When you encounter a window to enter the Global Database Name and Database SID, it is found that the database's SID is displayed in accordance with Oracle_SID = Your_SID in the settings in the environment variable. Just need to input the global database name. The next installation is performed in accordance with the default settings. When you encounter a form of a character set for setting a database, do not select the default database character type. Character Set is the most important setting when establishing an Oracle database. If the setting is incorrect, it is likely to cause could not access Chinese data normally in use. Here we'd better select the drop-down box of the third option, select SimplifiLled Chinese ZHS16GBK, press Next to enter the next step. Before the Oracle Universal Installer starts copying the installation file, the Oracle9i product summary to install will be displayed. When you confirm, press the "Install" button to install, which will be a longer process, of course, this and The configuration, computation speed and memory space size are all related. Because my installer is on the hard disk, there is no trouble like from the disc installation (for the specific operation of the CD, please check the relevant information in the network. ^ _ ^ Actually I have not installed from the CD ^ _ ^). Two errors occur during the next installation process, I also said in the online article I have seen, I also describe here: The first error is the linking phase, when the installation is 69% At this time, Oracle Universal Installer Tip About this file "/soft/oracle/network/lib/ins_oemagent.mk" has a problem, then we can temporarily do not deserve it, choose "ignore", ignore it, etc. After the process is complete, then solve this problem. (I have seen a lot of information, so I don't understand it. Hey, I really don't understand: (I also have a lot of error prompts when I install Oracle8i under RH7.) The second error is also During the linking phase, when the installation progresses to 84%, the Oracle Universal Installer prompt "Error In Invoking Target Install of Makefile $ Oracle_Home / CTX / lib / INS_CTX.MK" error. Don't choose to ignore this time, you can fix this error, open the $ oracle_home / ctx / lib / env_ctx.mk file for the following editing, position the cursor to 1365, "INSO_LINK =" this line, then "$" (LDLIBFLAG) DL "This sentence is added to" INSO_LINK = -L $ (CTXLIB) $ (LDLibflag) M ", the modification becomes this: INSO_LINK = -L $ (CTXLIB) $ (LDLIBFLAG) M $ (LDLIBFLAG) dl $ (LDLIBFLAG) sc_ca $ (LDLIBFLAG) sc_fa $ (LDLIBFLAG) sc_ex $ (LDLIBFLAG) sc_da $ (LDLIBFLAG) sc_ut $ (LDLIBFLAG) sc_ch $ (LDLIBFLAG) sc_fi $ (LLIBCTXHX) $ (LDLIBFLAG) c -Wl, -rpath , $ (Ctxhome) LIB $ (COMPEOBJS) then saves $ ORACLE_HOME / CTX / lib / env_ctx.mk file, returns to the error prompt window, press the "Retry" button to continue installation. When the database is established, wait for the installer to copy all files to the system, Oracle Universal Installer also pops up a prompt information window requires ROT.SH programs in ROOT identity, and root.sh is located in the directory pointed to by Oracle_home. At this time, you should open a new terminal window (TERMINAL), log in to the Oracle user, run the following command operation command as follows: #SU root #cd /opt/oracle9i/product/9.2.0 #. / Root. after running the system will prompt sh following information: running Oracle9 root.sh script ... / nThe following environment variables are set as: ORACLE_OWNER = oracle ORACLE_HOME = /opt/Oracle9i/product/9.2.0 Enter the full pathname of the local bin Directory: [/ usr / local / bin] Fill in the default directory here: /opt/oracle9i/Product/9.2.0/bin can be. After the execution here, if everything is normal, the OUI will appear "The Installation Oracle9i Database Was Success," The Oracle920 database is installed on the redhat linux9! It's really not easy! * _ ^ If there is also a installation of other content, press the "Next Install" button to install, otherwise, press the "EXIT" button to exit the OUI installation. The last step is to fix the error that is just the error just now, "/soft/oracle/neetwork/lib/ins_oemagent.mk" appears when the LINKING phase is installed. Perform the following commands with Oracle users: #CD $ ORACLE_HOME / Network / lib #make -f INS_NET_CLIENT.MK INSTALL then edits $ Oracle_Home / CTX / lib / ins_ctx.mk files 13-14 lines, by: CTXHX: $ (CTXHXOBJ $ (Link) $ (ctxhxobj) $ (INSO_LINK) Change to: CTXHX: $ (CTXHXOBJ) $ (link) -ldl $ (ctxhxobj) $ (Inso_LINK) Save $ Oracle_Home / CTX / lib / INS_CTX.MK file. Then do the following command: #make -f $ oracle_home / ctx / lib / INS_CTX.MK Install will complete the bug fixes. So far, the Oracle920 database has been fully installed on Redhat Linux9. :) Five, ORACEL9i will automatically start after using the Oracle database installed, and the actual operation can be made. Log in to the database as an Oracle user, you can do a terminal window, perform the following: [Oracle @ Linux Oracle] $ SQLPLUS "/ as sysdba" // Take the following character prompt with the SYSDBA user login database: ----- ------------------------- SQL * Plus: Release 9.2.0.1.0 - Production on Th twu Feb 26 15:53:31 2004 CopyRight (C .) 1982,2002, Oracle Corporation All rights reserved Connected to:. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> ---- -------------------------- Run the shudown command to turn off the database, the operation is as follows: --------------- --------------- SQL> Shutdown Database Closed. Database Dismounted. Oracle Instance Shut Down. SQL> ------------------- ----------- Start Oracle 9i database, the operation is as follows: ------------------------------ [ Oracle @ Linux Oracle] $ SQLPLUS "/ as sysdba" SQL * Plus: Release 9.2.0.1.0 - Production On Thu Feb 26 16:00:59 2004 CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved. Connected To an iDLE Instance. SQL> STA rtup Oracle instance started. Total System Global Area 235999352 bytes Fixed Size 450680 bytes Variable Size 201326592 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> --------------- -------------- Start Oracle 9i listener, the operation is as follows: Description: Oracle's listener is mainly to provide an interface for the client's connection. ------------------------------ [Oracle @ Linux Oracle] $ LSNRCTL LSNRCTL for Linux: Version 9.2.0.1.0 - Production On 26-Feb-2004 16:10:17 Copyright (C) 1991, 2002, Oracle Corporation. All Rights Reserved. Welcome to Lsnrctl, Type "Help" for Information. Lsnrctl> Start Starting /opt/oracle9i/Product/9.2. 0 / bin / tnslsnr: please wait ... TNSLSNR for Linux: Version 9.2.0.1.0 - Production System Parameter File IS /OPT/OrCle9i/Product/9.2.0/neetwork/admin/listener.ora log message Written To / OPT / ORACLE9I / PRODUCT / 9.2.0 / Network / Log / Listener.log Listening ON: (deSCription = (protocol = ipc)) Listening ON: (deSCription = (protocol = TCP) (host = linux))))))) "" = (protocol = ipc)) status of the listener ------------ ------------ Alias Listener Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production Start Date 26-Feb-2004 15:28:23 Uptime 0 Days 0 HR. 0 min. 0 Sec TRACE LEVEL OFF SECURITY OFF SNMP OFF LISTENER Parameter File /opt/oRacle9i/Product/9.2.0/neetwork/admin/9.2.0/und 10/Product/9.2.0/neetwork /LOG/LISTENER.LOG LISTENING Endpoints Summary ... (deScription = (protocol = ipc)) (description = (address = (protocol = tcp) (host = linux) (port = 1521 )) Summary ... Service "Orcl.soft" HAS 1 Instance (s). Instance "Orcl", Status Unknown, HAS 1 Handler (s) for this service ... Service "PLSextProc" HAS 1 Instance (s INSTANCE "PLSEXTPROC" , STATUS UNKNOWN, HAS 1 Handler (s) for this service ... The Command Command Command Command Command Command Command Command Command Command Comned Successful Lsnrctl> -------------------------------------------------------------------------------------------------------------------------------------- - Turn off the Oracle 9i listener, the operation is as follows: ------------------------------ [Oracle @ Linux Oracle] $ LSNRCTL LSNRCTL For Linux: Version 9.2.0.1.0 - Production On 26-Feb-2004 16:15:28 Copyright (C) 1991, 2002, Oracle Corporation. All Rights Reserved. Welcome to Lsnrctl, Type "Help" for Information. lsnrctl> Stop connection = (address = (protocol = ipc)) The Command Complated SuccessFully Lsnrctl> ----------------------- ------- Start Oracle Web Server, the operation is as follows: ------------------------------ [Oracle @ Linux Oracle ] $ cd $ oracle_home / apache / apache / bin [Oracle @ Linux Oracle] $. / StartjServ.sh /opt/racle9i/product/9.2.0/apache/apache/bin/apachectl start: httpd start ----- ------------------------ After launching Oracle Web Server, the default port number is 7777, enter http in the client's browser address bar. xxx.xx.xxx.xxx:7777/ The xxx.xx.xxx.xxx represents the IP address, or uses the network machine name. If the browser appears, the Oracle HTTP Server page shows that Oracle Web Server is running normally. Close Oracle Web Server, the operation is as follows: ------------------------------ [Oracle @ Linux Oracle] $ CD $ ORACLE_HOME / APACHE / Apache / bin [Oracle @ Linux Oracle] $. / StopjServ.sh /opt/racle9i/product/9.2.0/apache/apache/bin/apachectl stop: httpd stopped ------------ ------------------ Start Database Configuration Assistant, the operation command is as follows: ----------------------- ------- [Oracle @ Linux Oracle] $ DBCA & ------------------------------ Start Oracle Net Configuration Assistant The operation command is as follows: ------------------------------ [Oracle @ Linux Oracle] $ NETCA & ------- ----------------------- Start Enterprise Manager Configuration Assistant, the operation commands are as follows: ----------------- ------------- [Oracle @ Linux Oracle] $ EMCA & ----------------------------- - OEMAPP related commands, as follows: ------------------------------ [Oracle @ Linux Oracle] $ OEMAPP DBASTUDIO [Oracle @ Linux Oracle] $ OEMAPP Console [Oracle @ Linux Oracle] $ OEMAPP TXTMGR [Oracle @ Linux Oracle] $ OEMAPP OCMCLI [Oracle @ Linux Oracle] $ OEMAPP LMVIEWER [Oracle @ Linux Oracle] $ OEMAPP OCM [ORA cle @ Linux oracle] $ oemapp esmsrv [oracle @ Linux oracle] $ oemapp opm [oracle @ Linux oracle] $ oemapp cpta [oracle @ Linux oracle] $ oemapp esm [oracle @ Linux oracle] $ oemapp jdbctest [oracle @ Linux oracle] $ oemapp oemutil [oracle @ Linux oracle] $ oemapp topsess [oracle @ Linux oracle] $ oemapp dataguard [oracle @ Linux oracle] $ oemapp worksheet [oracle @ Linux oracle] $ oemapp cp [oracle @ Linux oracle] $ oemapp sdoadvisor [oracle @Linux Oracle] $ OEMAPP PM ------------------------------ 6, additional instructions: I have a word on the Internet, I Excerpt: "Please remember, oracle9.2 is not certified by Red Hat 9,
