2006年04月18日

oracle 10.2.1 install redhat as 4.0

Oracle Database 10g Release 2 (10.2.0.1) Installation On RedHat Advanced Server 4.0


In this article I'll describe the installation of Oracle Database 10g
Release 2 (10.2.0.1) on RedHat Advanced Server 4.0.
The article is based on a server installation with a minimum of 2G
swap, secure Linux disabled and the following package groups installed:


  • X Window System
  • GNOME Desktop Environment
  • Editors
  • Graphical Internet
  • Text-based Internet
  • Server Configuration Tools
  • Development Tools
  • Administration Tools
  • System Tools


Alternative installations may require more packages to be loaded, in addition to the ones listed below.




Download Software



Download the following software:




Unpack Files



Unzip the files:


unzip 10201_database_linux32.zip

You 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:


*               soft    nproc   2047
* hard nproc 16384
* soft nofile 1024
* 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


Note by Kent Anderson: In the event that pam_limits.so cannot set privilidged limit settings see Bug 115442.





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
(Applications > System Settings > Security Level). Click on the
SELinux tab and disable the feature.


Setup



Install the following packages:


# From RedHat AS4 Disk 2
cd /media/cdrom/RedHat/RPMS
rpm -Uvh setarch-1*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh make-3*
rpm -Uvh glibc-2*

# From RedHat AS4 Disk 3
cd /media/cdrom/RedHat/RPMS
rpm -Uvh openmotif-2*
rpm -Uvh compat-db-4*
rpm -Uvh libaio-0*
rpm -Uvh gcc-3*

# From RedHat AS4 Disk 4
cd /media/cdrom/RedHat/RPMS
rpm -Uvh compat-gcc-32-3*
rpm -Uvh compat-gcc-32-c++-3*


Create the new groups and users:


groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle


Create 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 /u01


Login as root and issue the following command:


xhost +<machine-name>


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
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

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 DISPLAY


Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory:


./runInstaller

During 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.


  1. Select Installation Method
  2. Specify Inventory Directory and Credentials
  3. Select Installation Type
  4. Specify Home Details
  5. Product-Specific Prerequisite Checks
  6. Select Configuration Option
  7. Select Database Configuration
  8. Specify Database Configuration Options
  9. Select Database Management Option
  10. Specify Database Storage Option
  11. Specify Backup and Recovery Options
  12. Specify Database Schema Passwords
  13. Summary
  14. Install
  15. Configuration Assistants
  16. Database Configuration Assistant
  17. Database Configuration Assistant Password Management
  18. Execute Configuration Scripts
  19. End Of Installation



Post Installation



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


Create a file called /etc/init.d/dbora containing the following:


#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#
ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin
HOST=`hostname`
PLATFORM=`uname`
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
if [ "$PLATFORM" = "HP-UX" ] ; then
remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
exit
else
rsh $HOST -l $ORACLE $0 $1 ORA_DB
exit
fi
fi
#
case $1 in
'start')
$ORACLE_HOME/bin/dbstart $ORACLE_HOME &
;;
'stop')
$ORACLE_HOME/bin/dbshut $ORACLE_HOME &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit


Set the appropriate group and access permissions:


chgrp dba /etc/init.d/dbora
chmod 750 /etc/init.d/dbora


Associate the dbora service with the appropriate run levels and set it to auto-start:


chkconfig --level 345 dbora on


The relevant instances should now startup/shutdown automatically at system startup/shutdown.





For more information see:




Hope this helps. Regards Tim...

Posted by my_work at 樂多Roodo! │16:02 │回應(0)引用(1)DB
樂多分類:網路/3C 共同主題:Oracle 工具:編輯本文
Ads by Roodo! 

引用URL

http://cgi.blog.roodo.com/trackback/1433778
引用列表:
Denver celebrex attorney.
Denver celebrex attorney.【Denver celebrex attorney.】 at 2007年08月6日 00:35