随笔-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 无声 阅读(2726) 评论(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   回复  更多评论
  

只有注册用户登录后才能发表评论。


网站导航: