隨筆-200  評論-148  文章-15  trackbacks-0

          Oracle Database 10g Release 2 (10.2.0.1) Installation On Red Hat Enterprise Linux 5 (RHEL5)
          In this article I'll describe the installation of Oracle Database 10g Release 2 (10.2.0.1) on Red Hat Enterprise Linux 5 (RHEL5). The article is based on a server installation similar to this, with a minimum of 2G swap, secure Linux disabled and the following package groups installed:

          GNOME Desktop Environment
          Editors
          Graphical Internet
          Text-based Internet
          Development Libraries
          Development Tools
          Legacy Software Development
          Server Configuration Tools
          Administration Tools
          Base
          Legacy Software Support
          System Tools
          X Window System ?
          Alternative installations may require more packages to be loaded, in addition to the ones listed below.

          Download Software
          Unpack Files
          Hosts File
          Set Kernel Parameters
          Setup
          Installation
          Post Installation
          Download Software
          Download the following software:

          Oracle Database 10g Release 2 (10.2.0.1) Software
          Unpack Files
          Unzip the files:

          unzip 10201_database_linux32.zipYou should now have a single directory containing installation files. Depending on the age of the download this may either be named "db/Disk1" or "database".

          Hosts File
          The /etc/hosts file must contain a fully qualified name for the server:

          <IP-address>??<fully-qualified-machine-name>??<machine-name>

          Set Kernel Parameters
          Add the following lines to the /etc/sysctl.conf file:

          kernel.shmall = 2097152
          kernel.shmmax = 2147483648
          kernel.shmmni = 4096
          # semaphores: semmsl, semmns, semopm, semmni
          kernel.sem = 250 32000 100 128
          fs.file-max = 65536
          net.ipv4.ip_local_port_range = 1024 65000
          net.core.rmem_default=262144
          net.core.rmem_max=262144
          net.core.wmem_default=262144
          net.core.wmem_max=262144

          Run the following command to change the current kernel parameters:

          /sbin/sysctl –p

          Add the following lines to the /etc/security/limits.conf file:

          oracle?? ?? ??? soft? ? nproc? ?2047
          oracle ? ?? ??? hard? ? nproc? ?16384
          oracle ? ?? ??? soft? ? nofile??1024
          oracle ? ?? ??? hard? ? nofile??65536

          Add the following line to the /etc/pam.d/login file, if it does not already exist:

          session? ? required? ???/lib/security/pam_limits.so

          Disable secure linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows:

          SELINUX=disabled

          Alternatively, this alteration can be done using the GUI tool (System > Administration > Security Level and Firewall). Click on the SELinux tab and disable the feature.

          Setup
          Install the following packages:

          # From RedHat AS5 Disk 1
          cd /media/cdrom/Server
          rpm -Uvh setarch-2*
          rpm -Uvh make-3*
          rpm -Uvh glibc-2*
          rpm -Uvh libaio-0*
          cd /
          eject

          # From RedHat AS5 Disk 2
          cd /media/cdrom/Server
          rpm -Uvh compat-libstdc++-33-3*
          rpm -Uvh compat-gcc-34-3*
          rpm -Uvh compat-gcc-34-c++-3*
          rpm -Uvh gcc-4*
          rpm -Uvh libXp-1*
          cd /
          eject

          # From RedHat AS5 Disk 3
          cd /media/cdrom/Server
          rpm -Uvh openmotif-2*
          rpm -Uvh compat-db-4*
          cd /
          eject
          Create the new groups and users:

          groupadd oinstall
          groupadd dba
          groupadd oper

          useradd -g oinstall -G dba oracle
          passwd oracleCreate the directories in which the Oracle software will be installed:

          mkdir -p /u01/app/oracle/product/10.2.0/db_1
          chown -R oracle.oinstall /u01Login as root and issue the following command:

          xhost +<machine-name>Edit the /etc/redhat-release file replacing the current release information (Red Hat Enterprise Linux Server release 5 (Tikanga)) with the following:
          redhat-4

          Login as the oracle user and add the following lines at the end of the .bash_profile file:

          # Oracle Settings
          TMP=/tmp; export TMP
          TMPDIR=$TMP; export TMPDIR

          ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
          ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
          ORACLE_SID=TSH1;

          export ORACLE_SID
          ORACLE_TERM=xterm;

          export ORACLE_TERM
          PATH=/usr/sbin:$PATH;

          export PATH
          PATH=$ORACLE_HOME/bin:$PATH; export PATH

          LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;

          export LD_LIBRARY_PATH
          CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

          export CLASSPATH

          if [ $USER = "oracle" ]; then
          ??if [ $SHELL = "/bin/ksh" ]; then
          ? ? ulimit -p 16384
          ? ? ulimit -n 65536
          ??else
          ? ? ulimit -u 16384 -n 65536
          ??fi
          fi

          Installation
          Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

          DISPLAY=<machine-name>:0.0; export DISPLAYStart the Oracle Universal Installer (OUI) by issuing the following command in the database directory:

          ./runInstallerDuring the installation enter the appropriate ORACLE_HOME and name then continue installation. For a more detailed look at the installation process, click on the links below to see screen shots of each stage.

          Select Installation Method
          Specify Inventory Directory and Credentials
          Select Installation Type
          Specify Home Details
          Product-Specific Prerequisite Checks
          Select Configuration Option
          Select Database Configuration
          Specify Database Configuration Options
          Select Database Management Option
          Specify Database Storage Option
          Specify Backup and Recovery Options
          Specify Database Schema Passwords
          Summary
          Install
          Configuration Assistants
          Database Configuration Assistant
          Database Configuration Assistant Password Management
          Execute Configuration Scripts
          End Of Installation
          Post Installation
          Edit the /etc/redhat-release file restoring the original release information:

          Red Hat Enterprise Linux Server release 5 (Tikanga)

          ?

          Edit the /etc/oratab file setting the restart flag for each instance to 'Y':

          TSH1:/u01/app/oracle/product/10.2.0/db_1:Y

          ?

          ?

          vi $ ORACLE_HOME/bin/dbstart

          modify following:

          ORACLE_HOME_LISTNER= /u01/app/oracle/product/10.2.0/db_1

          Oracle Auto Start Setting:

          cp /u01/app/oracle/admin/express/pfile/init.ora.* $ORACLE_HOME/dbs/initexpress.o

          ra

          cp oracle /etc/init.d

          chmod 755 /etc/init.d oracle

          chkconfig –add oracle

          oracle file:

          #!/bin/bash

          #

          # oracle??????? This shell script takes care of starting and stopping

          #?????????????? oracle server.

          #

          # chkconfig:?? 35 89 10

          # description: Oracle is a Database Server

          # processname: oracle

          ?

          # Source function library.

          #/etc/init.d/oracle

          . /etc/rc.d/init.d/functions

          prog="oracle"

          ?

          export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

          export ORACLE_SID=express

          export PATH=$PATH:$ORACLE_HOME/bin

          ?

          ORA_OWNR="oracle"

          # if the executables do not exist -- display error

          if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]

          then

          echo "Oracle startup: cannot start"

          exit 1

          fi

          # depending on parameter -- startup, shutdown, restart

          # of the instance and listener or usage display

          case "$1" in

          start)

          # Oracle listener and instance startup

          echo -n "Starting Oracle: "

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart"

          touch /var/lock/oracle

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/emctl start dbconsole"

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/isqlplusctl start"

          echo "OK"

          ;;

          stop)

          # Oracle listener and instance shutdown

          echo -n "Shutdown Oracle: "

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/emctl stop dbconsole"

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/isqlplusctl stop"

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbshut"

          su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"

          rm -f /var/lock/oracle

          echo "OK"

          ;;

          reload|restart)

          $0 stop

          $0 start

          ;;

          *)

          echo "Usage: `basename $0` start|stop|restart|reload"

          exit 1

          esac

          exit 0

          posted on 2007-05-17 08:42 無聲 閱讀(2735) 評論(1)  編輯  收藏 所屬分類: 職場生活

          評論:
          # re: Oracle Database 10g Release 2 Installation On Red Hat Enterprise Linux 5 2008-07-14 23:59 | 老丁8621
          喜歡,頂一下

          我采用oracle linux ,感覺oracle占用CPU過大,空載時也有7%的CPU 占用。是oracle在占用。

          cat /proc/version
          Linux version 2.6.9-67.0.0.0.1.ELsmp (mockbuild@ca-build15.us.oracle.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-3)) #1 SMP Sun Nov 18 01:06:10 EST 2007

          計劃換redhat5, 據說,
          HP ProLiant ML370 G5 Quad-Core Intel Xeon processor X5460 3.16GHz (2 processors/8 cores/8 threads), 2x6MB L2 cache, 1333 MHz, 64GB memory, Oracle 10G, Red Hat ELinux (RHEL 5). 273,666 tpmC   回復  更多評論
            
          主站蜘蛛池模板: 崇明县| 锡林郭勒盟| 阜平县| 简阳市| 大邑县| 临邑县| 游戏| 邻水| 土默特右旗| 东源县| 大石桥市| 巴南区| 建湖县| 尉氏县| 玉林市| 青铜峡市| 仙游县| 五河县| 砀山县| 来宾市| 巨野县| 临朐县| 无为县| 体育| 教育| 博白县| 潞城市| 丰台区| 永福县| 望都县| 鹤山市| 鄂伦春自治旗| 荆州市| 定陶县| 芷江| 龙川县| 会泽县| 安达市| 邛崃市| 马边| 界首市|