How to install ORACLE 11g R2 on CentOS 5.5

Install ORACLE 11g R2 on CentOS 5.5. Tutorial 1: prerequisites 1. Prepare CentOS. First, what is the most important: partition is the most important. Obviously, the larger the partition, the better, especially the larger the SWAP space, at least 2 GB. Second, for beginners, there are two points to note. First, it is best to install the software in full compliance; second, remove the firewall, SElinux, and so on to install the software smoothly. 2. Basic preparation first, the preparation software: linux_11gr2_database_1of2.ziplinux_11gr2_databasesilicate f2.zip second, prepare two tools: FileZilla_3.3.3_win32-setup.exe Putty, FileZilla can transmit some files to the virtual machine, it is very convenient; putty is a remote logon tool that allows you to easily log on to CentOS. The preparation is complete. 2. Preparations before installing ORACLE. 1. Additional software is installed on the system: yum-y install binutils compat-libstdc ++-cancelfutils-libelf-devel glibc-common glibc-devel gccgcc-c ++ libaio-devel libaio libgcc stlibdc + libstdc ++ -devel make sysstatunixODBC unixODBC-devel pdksh numactl-devel glibc-headers/sbin/ldconfig 2. Adjust Kernel Parameters First vi/etc/sysctl. conffs. file-max = 6815744kernel. shmall = 2097152kernel. shmmax = 536670912kernel. shmmni = 4096kernel. sem = 250 32000 100. net. ipv4.ip _ local_port_range = 9000 65500net. core. rmem_default = 262144net. core. rmem_max = 4192134net. core. wmem_default = 262144net. core. wmem_max = 1048576fs. aio-max-nr = 1048576 # Make the Kernel Parameter take effect sysctl-p, and # modify limits. confvi/etc/security/limits. conf # oracle settingsoracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 then: # modify the system version (Redhat 5. X Series Systems skipped this step) cp /Etc/redhat-release/etc/redhat-release.bkvi/etc/redhat-release # modified to: Red Hat Enterprise Linux AS release 5 (Taroon) # modified/etc/pam. d/login # Add the following content: session required/lib/security/pam_limits.sosession required pam_limits.so: # Modify/etc/profilevi/etc/profile # Add the following content: if [$ USER = "oracle"]; then if [$ SHELL = "/bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifi # Modify/etc/csh. Loginvi/etc/csh. login # Add the following content: if ($ USER = "oracle ") then limit maxproc 16384 limit deors 65536 endif 3. Create an ORACLE user first groupadd oinstallgroupadd dbauseradd-g oinstall-G dba oraclepasswd oracle #753951 mkdir-p/data/oraclemkdir-p/data/oralnventorymkdir -p/data/softwarechown-R oracle: oinstall/data/oraclechown-R oracle: oinstall/data/softwarechown-R oracle: oinstall/data/oralnventory then, set the environment Environment Variable # su-oracle $ vi. bash_profile # Add the following content: ORACLE_SID = kerry; export ORACLE_SIDORACLE_BASE =/data/oracle; export ORACLE_BASEORACLE_HOME = $ ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOMEPATH = $ PATH: $ ORACLE_HOME/bin: $ HOME/bin; export PATH $ source. bash_profile Note: it is best to add the host address to/etc/hosts: [root @ localhost/] # cat/etc/hosts # Do not remove the following line, or variousprograms # that require network functio Nality willfail.127.0.0.1 localhost. localdomain localhost192.168.1.103 localhost. localdomain localhost #: 1 localhost6.localdomain6 localhost6 4. will install and upload the file soon # upload the oracle Installation File to the/data/software Directory, decompress cd/data/softwareunzip unzip linux_11gr2_databasetimely f2.zip, xhost local: oracle (this command is run by the root user. You must perform the following two steps. If the command is not run, the graphical installation interface cannot be started.) 3. Start installation: 1. log on to [ORACLE @ localhost ~] using oracle $ Cd/fantlam/database [oracle @ localhost database] $./runInstallerOK enter the graphical interface for installation. Installation Optiong installdatabase software only Grid Options Singleinstance database installation Product Versions ages English Database Edition EnterpriseEdition (3.95) Installation Location OracleBase:/u01 SoftwareLoacation:/u01/oracle prompt: yes Create Inventory mkdir/oraInventory chown-R oracle: oinstall oraInventory Operating System Groups Next Prerequis ite Checks IgnoreAll Summary Finish Insta Ll Product installation is complete, prompt to execute 2 scripts/oraInventory/orainstRoot. sh/u01/oracle/root. sh press enter directly. By default, you can Finish Theinstallation of Oracle Database was successful installation !! 2. The above is only installed with software, the database is not created, and the Listener netca configuration Listener is always the Next step by default. Well, Finish ps-ef and check whether the Listener is configured successfully --------- dbca is always Next, both Global Database Name and SID are input wilson and select User theSame ..... all Accounts password: 123456 select SampleSchemas Memory allocation, the CharacterSets can be selected by default Use Unicode (AL32UTF8) and then continue Next, and a Confirmation will pop up at the end of Finish. Click OK, then install and install it to the/u01/oradata/wilson/u01/directory... You will find many more files. -------------------- Then you can modify vi/etc/inittab so that when centos5.5linux is started, you can directly enter the character Interface id: 5: initdefault: changed to id: 3: initdefault: Save and exit, restart the system. 3. Test the remote login using an oracle user. Then, $ sqlplus/nolog SQL> conn/as sysdba Connected to an idle instance. error SQL> startup [oracle @ localhost ~] $ Sqlplus/nolog SQL * Plus: Release 11.2.0.1.0 Production onFri Jun 25 15:05:54 2010 Copyright (c) 1982,200 9, Oracle. all rights reserved. SQL> conn/as sysdbaConnected. SQL> create table testUser (idinteger, name char (10); Table created. SQL> insert into testUservalues (0, 'jack'); 1 row created. SQL> commit; Commit complete. SQL> select * from testUser; id name ---------- 0 Jack closes Database SQL> shutdown immediate SQL> quit