Nethence Documentation Lab Webmail Your IP BBDock  


Those documents are obsolete, please use the Nethence Documentation instead.

HomeUnixWindowsOracleObsoleteHardwareDIYMechanicsScriptsConfigsPrivate

Oracle 10gR2/11gR1 installation
 
 
Note. once the system prerequesties are done (see other docs).
 
 
Installation
Enable FTP on the server (faster than sftp),
chkconfig vsftpd on
service vsftpd start
 
Upload the oracle archives as oracle user,
#10201_database_linux32.zip
#p6810189_10204_Linux-x86.zip
B24792-01_1of5.zip
p6810189_10204_Linux-x86-64.zip
 
Connect as oracle user through SSH with X11 forwarding enabled and prepare your environment,
cd ~/
vi .bashrc
add,
PATH=$PATH:/usr/X11R6/bin
export PATH

ORACLE_BASE=/oracle
TMP=$ORACLE_BASE/tmp
TMPDIR=$TMP
NLS_LANGUAGE=american
NLS_TERRITORY=america
NLS_LANG=american_america.utf8
export ORACLE_BASE TMP TMPDIR NLS_LANGUAGE NLS_TERRITORY NLS_LANG

ORACLE_HOME_NAME=ora102
ORACLE_HOME=$ORACLE_BASE/ora102
#ORACLE_HOME_NAME=ora111
#ORACLE_HOME=$ORACLE_BASE/ora111
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
export ORACLE_HOME_NAME ORACLE_HOME PATH
PS1='$LOGNAME> '
alias sql='sqlplus / as sysdba'
note. TMP will be created automaticly
note. ".bashrc" is always read while ".bash_profile" only applies for a login shells (doesn't work on Solaris 10 tho)
note. you may also define ORACLE_HOSTNAME=host.example.net
note. updating PATH to X11R6 for xclock
apply,
source .bashrc
note. alternatively,
#NLS_LANG=american_america.we8iso8859p15
 
Extract the archives,
#unzip 10201_database_linux32.zip
#unzip p6810189_10204_Linux-x86.zip
#rm -f 10201_database_linux32.zip p6810189_10204_Linux-x86.zip
unzip B24792-01_1of5.zip
unzip p6810189_10204_Linux-x86-64.zip
rm -f B24792-01_1of5.zip p6810189_10204_Linux-x86-64.zip
rm -rf README.html welcome.html doc/
#unzip linux_11gR1_database_1013.zip
#rm linux_11gR1_database_1013.zip
Note. although it's preferable to use the Oracle archives from E-Delivery, which really contains all possibles features
 
Make sure those are defined,
echo $ORACLE_BASE
echo $ORACLE_HOME_NAME
echo $ORACLE_HOME
 
Eventually check for X11 forwarding (http://xming.sf.net/),
xclock
 
Launch OUI,
cd ~/database/
unset TNS_ADMIN
./runInstaller -record -destinationFile ~/10g.rsp
Note. '-help' to review all options
Note. '-ignoreSysPrereqs' to force startup on RHEL5, or directly tweak 'install/oraparam.ini'.
 
For 10gR2/11gR1 answer e.g.,
installation method: advanced Installation
inventory directory: /oracle/ora102_Inventory
#inventory directory: /oracle/ora111_Inventory
operationg system group name: oinstall
installation type : standard or enterprise edition
note. you might have to change some kernel parameters at this point. e.g. for ora102,
cd /etc/
cat >> sysctl.conf <<EOF9

kernel.sem = 250 32000 100 128
kernel.shmmax = 536870912
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
EOF9
or e.g. for ora111,
cd /etc/
cat >> sysctl.conf <<EOF9

kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
EOF9
apply,
sysctl -p
retry and proceed,
install database software only
 
When finished, check,
ls -l /etc/oraInst.loc
ls -l /etc/oratab
clean-up oratab comments,
cd /etc/
mv oratab oratab.dist
sed '/^$/d; /^#/d' oratab.dist > oratab
chown oracle:root oratab
and check permissions,
ls -l oratab*
 
 
Enable the listener
Enable the listener (with X11 forwarding enabled),
netca
make sure it is started,
lsnrctl status
 
It may be further configured when creating databases. Same for tnsnames.
 
 
Automatic startup & shutdown on Redhat
As 'oracle' user check those variables and executables are available,
echo $ORACLE_BASE
echo $ORACLE_HOME
which dbstart
which dbshut
which lsnrctl
fix the Oracle dbstart scripts,
vi /oracle/ora102/bin/dbstart
change,
#ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
ORACLE_HOME_LISTNER=$ORACLE_HOME
 
As 'root' user, configure the oracle init script,
cd /etc/init.d/
vi dbora
like,
#!/bin/sh
# chkconfig: 345 99 10
# description: oracle listener and databases

case "$1" in
start) echo -n starting oracle and listener...
su - oracle -c "dbstart \$ORACLE_HOME" && echo done
#Oracle 9i
#su - oracle -c "lsnrctl start"
;;
stop) echo -n shutting down oracle and listener...
su - oracle -c "dbshut \$ORACLE_HOME" && echo done
;;
#Oracle 9i
#su - oracle -c "lsnrctl stop"
;;
*) echo "${0##*/} <start|stop>" ;;
esac
note. this also starts/stops the listener (since 10g)
note. for 9i, uncomment to start/stop the listener too
fix perms and enable,
chmod 750 dbora
chkconfig --add dbora
chkconfig --list | grep ora
check,
service dbora stop
service dbora start
 
Check /etc/oratab for databases you want to startup automaticly,
vi /etc/oratab
 
 
Misc
Note. if it's ISO images you're dealing with,
mkdir -p Disk1
mkdir -p Disk2
mkdir -p Disk3
# as root,
mount -o loop Disk1.iso Disk1
mount -o loop Disk2.iso Disk2
mount -o loop Disk3.iso Disk3
and once you're finished,
umount Disk1
umount Disk2
umount Disk3
 

Last update: Jul 08, 2011