¡¡¡¡ÏµÍ³ÊÇRedHat AS4.0(X86)£¬Ö÷ÒªÊÇΪÁË°²×°Oracle9i£¬½áºÏÍøÉϵÄһЩ×ÊÁÏ×ܽáһϣ¬ÕûÀí³öÀ´£¬Ï£Íû¶Ô´ó¼ÒÓÐÓá£
¡¡¡¡ÓÉÓÚÍøÉϵÄ×ÊÁϺܶ࣬µ«ÓÉÓÚ´ó¼ÒµÄ´«ÔÄתÔØ£¬Óв»ÉÙ¶¼ÓÐЩÎó²îÁË£¬ÎÒÔÚÕâÀïÒ²ËãÊÇУ¶Ôһϰɣ¬¶ÔÕâЩÔʼ×ÊÁϵĴ´×÷È˱íʾ¾´Òâ¡£
¡¡¡¡Ò»£¬×¼±¸¹¤×÷
¡¡¡¡1£¬ÏÈ°²×°ºÃRedHat AS4.0£¬±£³ÖϵͳµÄ¸É¾»¡£
¡¡¡¡ÔÚoracle¹Ù·½ÍøÕ¾ÉÏÏÂÔØOracle 9iµÄ°²×°Îļþ:
¡¡¡¡ship_9204_linux_disk1.cpio.gz¡¡
¡¡¡¡ship_9204_linux_disk2.cpio.gz¡¡
¡¡¡¡ship_9204_linux_disk3.cpio.gz¡¡´ò3238244²¹¶¡
¡¡¡¡Í¬Ê±ÒªÏÂÔØÈý¸ö²¹¶¡£º¡¡¡¡p4198954_21_linux.zip ¡¡¡¡¡¡¡¡ ÔÚÔËÐÐ runInstaller ֮ǰ´ò
¡¡¡¡p2617419_220_GENERIC.zip¡¡¡¡ÐÞ¸´agent´íÎóµÄ²¹¶¡
¡¡¡¡p3238244_9204_LINUX.zip¡¡¡¡ ´ò3238244²¹¶¡
¡¡¡¡ÓÉÓÚ°²×°oracleÐèÒªºÜ¶àϵͳÈí¼þ°ü£¬ÉÙÒ»Ñù¶¼²»ÐУ¬ÕæÊÇÒ»¸ö¶¼²»ÄÜÉÙ¡£¿ªÒ»¸öÖնˣ¬ÒÔrootÓû§ÔËÐУº
¡¡¡¡# rpm -qa | grep compat
¡¡¡¡¼ì²éµ±Ç°ÏµÍ³Ëù°²×°µÄcompatÈí¼þ°üÊÇ·ñÒÑÓÐ:
¡¡¡¡compat-db-4.1.25-9
¡¡¡¡compat-gcc-32-3.2.3-47.3
¡¡¡¡compat-gcc-32-c++-3.2.3-47.3
¡¡¡¡compat-oracle-rhel4-1.0-3
¡¡¡¡compat-libcwait-2.0-1
¡¡¡¡compat-libgcc-296-2.96-132.7.2
¡¡¡¡compat-libstdc++-296-2.96-132.7.2
¡¡¡¡compat-libstdc++-33-3.2.3-47.3
¡¡¡¡gcc-3.4.3-9.EL4
¡¡¡¡gcc-c++-3.4.3-9.EL4
¡¡¡¡gnome-libs-1.4.1.2.90-44
¡¡¡¡gnome-libs-devel-1.4.1.2.90-44
¡¡¡¡libaio-devel-0.3.102-1
¡¡¡¡libaio-0.3.102-1
¡¡¡¡make-3.80-5
¡¡¡¡openmotif21-2.1.30-11
¡¡¡¡xorg-x11-deprecated-libs-devel-6.8.1-23.EL
¡¡¡¡xorg-x11-deprecated-libs-6.8.1-23.EL
¡¡·¢Èç¹ûÉÙÁËÉÏÊý°ü£¬¿É°´ÏÂÃæµÄÃüÁîºÍËùÊôAS4¹âÅÌ°²×°RPM°ü(×îºóÁ½¸öÓÉOralce²¹¶¡p4198954_21_linux.zip½âѹ²úÉú)
¡¡¡¡rpm -ivh sysstat-5.0.5-1.i386.rpm disk4
¡¡¡¡rpm -ivh openmotif21-2.1.30-11.RHEL4.2.i386.rpm disk3
¡¡¡¡rpm -ivh libaio-0.3.102-1.i386.rpm disk3
¡¡¡¡rpm -ivh libaio-devel-0.3.102-1.i386.rpm disk3
¡¡¡¡rpm -ivh freetype-devel-2.1.9-1.i386.rpm disk3
¡¡¡¡rpm -ivh fontconfig-devel-2.2.3-7.i386.rpm disk3
¡¡¡¡rpm -ivh xorg-x11-devel-6.8.1-23.EL.i386.rpm disk3
¡¡¡¡rpm -ivh xorg-x11-deprecated-libs-devel-6.8.1-23.EL.i386.rpm disk3
¡¡¡¡rpm -ivh glib-devel-1.2.10-15.i386.rpm disk4
¡¡¡¡rpm -ivh ORBit-devel-0.5.17-14.i386.rpm disk4
¡¡¡¡rpm -ivh gtk+-devel-1.2.10-33.i386.rpm disk4
¡¡¡¡rpm -ivh alsa-lib-devel-1.0.6-4.i386.rpm disk3
¡¡¡¡rpm -ivh audiofile-devel-0.2.6-1.i386.rpm disk3
¡¡¡¡rpm -ivh esound-devel-0.2.35-2.i386.rpm disk3
¡¡¡¡rpm -ivh libjpeg-devel-6b-33.i386.rpm disk3
¡¡¡¡rpm -ivh libtiff-devel-3.6.1-7.i386.rpm disk3
¡¡¡¡rpm -ivh libungif-devel-4.1.3-1.i386.rpm disk3
¡¡¡¡rpm -ivh imlib-devel-1.9.13-23.i386.rpm disk3
¡¡¡¡rpm -ivh gnome-libs-devel-1.4.1.2.90-44.1.i386.rpm disk4
¡¡¡¡rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm (p4198954_21_linux.zip)
¡¡¡¡rpm -ivh compat-libcwait-2.0-2.i386.rpm (p4198954_21_linux.zip)
¡¡¡¡¶þ£¬´´½¨Ïà¹Ø°²×°Ä¿Â¼ºÍ»·¾³±äÁ¿
¡¡¡¡1£¬´´½¨user/group£»
¡¡¡¡#groupadd dba
¡¡¡¡#groupadd oinstall
¡¡¡¡#useradd oracle -g oinstall -G dba
¡¡¡¡#passwd oracle
¡¡¡¡2£¬½¨Á¢oracle°²×°Îļþ¼Ð£»
¡¡¡¡# mkdir -p /opt/ora9/product/9.2.0.4
¡¡¡¡# mkdir /var/opt/oracle
¡¡¡¡# chmod oracle.dba /var/opt/oracle
¡¡¡¡# chown -R oracle.dba /opt/ora9
¡¡
3£¬ÅäÖû·¾³±äÁ¿£»
ÒÔrootÓû§µÇ¼£¬ÉèÖÃrootÓû§µÄ»·¾³´ò¿ª.bash_profileÎļþ£¬½«ÈçÏÂÄÚÈݼÓÈ룺
export ORACLE_BASE=/opt/ora9
export ORACLE_HOME=/opt/ora9/product/9.2.0.4
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin
export ORACLE_OWNER=oracle
export ORACLE_SID=oradb //´Ë´¦ÎªÄãµÄsid
¡¡Ê¹ÓÃOracleÓû§µÇ½:
¡¡#su - oracle
¡¡$vi .bash_profile
¡¡ÒÔÏÂÊÇÅäÖÃÎļþµÄÄÚÈÝ
¡¡# .bash_profile
¡¡# Get the aliases and functions
¡¡if [ -f ~/.bashrc ]; then
. ~/.bashrc
¡¡fi
¡¡# User specific environment and startup programs
¡¡PATH=$PATH:$HOME/bin
¡¡export ORACLE_BASE=/opt/ora9
¡¡export ORACLE_HOME=/opt/ora9/product/9.2.0.4
¡¡export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin
¡¡export ORACLE_OWNER=oracle
¡¡export ORACLE_SID=oradb
¡¡export ORACLE_TERM=xterm
¡¡export LD_ASSUME_KERNEL=2.4.19
¡¡export THREADS_FLAG=native
¡¡export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
¡¡export NLS_LANG=¡±American_america.utf8¡±
¡¡export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
¡¡export PATH
¡¡unset USERNAME
¡¡4£¬ÉèÖÃϵͳ²ÎÊý£»
#su - rootÇл»µ½rootÓû§
a) ÐÞ¸Ä#vi /etc/sysctl.conf, ÒÔÏÂÊÇÅäÖÃÎļþµÄÄÚÈÝ£¨ÆäÖкìÉ«×ÖÌåΪÌí¼ÓµÄÄÚÈÝ£©£º
# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.
# Controls IP packet forwarding
net.ipv4.ip_forward = 0
# Controls source route verification
net.ipv4.conf.default.rp_filter = 1
# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0
# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
¡¡¡¡Ð޸ĺóÔËÐÐ#sysctl -pÃüÁîʹµÃÄں˸ıäÁ¢¼´ÉúЧ£»
¡¡¡¡£¨ÒëÕß×¢£ºÒ»°ãÇé¿öÏ¿ÉÒÔÉèÖÃ×î´ó¹²ÏíÄÚ´æΪÎïÀíÄÚ´æµÄÒ»°ë£¬Èç¹ûÎïÀíÄÚ´æÊÇ 2G£¬Ôò¿ÉÒÔÉèÖÃ×î´ó¹²ÏíÄÚ´æΪ 1073741824£¬ÈçÉÏ£»ÈçÎïÀíÄÚ´æÊÇ 1G£¬Ôò¿ÉÒÔÉèÖÃ×î´ó¹²ÏíÄÚ´æΪ 512 * 1024 * 1024 = 536870912£»ÒÔ´ËÀàÍÆ¡££©
½¨ÒéÓÀ¾ÃµØÔö¼Ó shmmax ÉèÖá£
¡¡¡¡sem 4¸ö²ÎÊýÒÀ´ÎΪSEMMSL(ÿ¸öÓû§ÓµÓÐÐźÅÁ¿×î´óÊý)£»SEMMNS(ϵͳÐźÅÁ¿×î´óÊý)£»SEMOPM(ÿ´Îsemopmϵͳµ÷ÓòÙ×÷Êý)£»SEMMNI(ϵͳÐÁ¿àÁ¿¼¯Êý×î´óÊý).Shmmax ×î´ó¹²ÏíÄڴ棬¹Ù·½Îĵµ½¨ÒéÊÇÄÚ´æµÄ1/2,Shmmni ×îС¹²ÏíÄÚ´æ 4096KB.Shmall ËùÓÐÄÚ´æ´óС ¡£
b) ÉèÖÃoracle¶ÔÎļþµÄÒªÇó£º
±à¼Îļþ£º#vi /etc/security/limits.conf ¼ÓÈëÒÔÏÂÓï¾ä£º
oracle ¡¡¡¡¡¡soft ¡¡¡¡¡¡nofile ¡¡¡¡ 65536
oracle ¡¡¡¡¡¡hard ¡¡¡¡ nofile¡¡¡¡¡¡65536
oracle ¡¡¡¡¡¡soft ¡¡¡¡¡¡nproc ¡¡¡¡ 16384
oracle ¡¡¡¡¡¡hard ¡¡¡¡ nproc ¡¡¡¡ 16384
c) gcc½µ¼¶
#su - root
#mv /usr/bin/gcc /usr/bin/gcc34
#ln -s /usr/bin/gcc32 /usr/bin/gcc
#mv /usr/bin/g++ /usr/bin/g++34
#ln -s /usr/bin/g++32 /usr/bin/g++
5£¬°²×°oracle²¹¶¡
µ±Äã´Ó Oracle 9iR2 ¹âÅÌÖ´ÐÐ runInstaller ʱ£¬»á³öÏÖ´íÎóÐÅÏ¢£º
Error occurred during initialization of VM
Unable to load native library:
/tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386
/libjava.so symbol _libc_wait, version GLIBC_2.0 not
defined in file libc.so.6 with link time reference
ΪÁ˽â¾ö _libc_wait ·ûºÅÎÊÌ⣬
´Óhttp://oss.oracle.com/projects/compat-oracle/files/RedHat/ ÏÂÔز¹¶¡
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm.ΪÁËÓ¦ÓÃÕâ¸ö²¹¶¡£¬¿ÉÒÔÔËÐУº
$su - root
# cd /orasetup
#ls compat*.rpm
compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm
# rpm -Uvh compat*.rpm
Preparing... ########################################### [100%]
1:compat-libcwait-2.0-2.i386.rpm ##################################### [ 50%]
2:compat-oracle-rhel4-1.0-5.i386.rpm#################################### [100%]
Èý£¬¿ªÊ¼°²×°Oracle9i
1,½âѹÏÂÔصݲװÎļþ:
zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv
zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv
zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv
½â°üºÍ½âѹ¹ý³ÌÖУ¬×Ô¶¯´´½¨ÁË3¸ö°üº¬°²×°ÎļþµÄĿ¼£º
Disk1
Disk2
Disk3
.ÒÔoracleÓû§µÇ¼ϵͳ£¬½øÐÐOracleµÄ°²×°£º
$ cd Disk1
$ ./runInstaller¹ýÒ»»á¶ù¾Í»á³öÏÖOracleµÄ°²×°½çÃæ
- Welcome Screen: Click Next
- Inventory Location: Click Next
- Unix Group Name: Use "oinstall" and click Next
When asked to run /tmp/orainstRoot.sh, run it before you click Continue
- At the end of the installation, exit runInstaller.
2.Ò»²½Ò»¸ö½ÅÓ¡°²×°ÏÂÈ¥¾ÍÐÐÁË£¡
3,°²×°Íêºó´ò²¹¶¡£º
Çл»µ½root£º#su - root Ê×ÏÈ°²×° opatch.
#cd /orasetup
#unzip p2617419_210_GENERIC.zip
Archive: p2617419_210_GENERIC.zip
creating: OPatch/
creating: OPatch/docs/
inflating: Opatch/docs/FAQ
......
inflating: README.txt
#export PATH=$PATH:/orasetup/OPatch:/sbin
(ÐÞ¸ÄPATHʱҪҪ°üÀ¨½âѹËõ³öÀ´µÄOpatch ºÍ sbinĿ¼)
# unzip p3238244_9204_LINUX.zip
# cd 3238244
# opatch apply
Èç¹ûÌáʾHOME±äÁ¿´íÎó¿ÉÖ´ÐÐÓï¾ä£º
#export ORACLE_BASE=/opt/ora9
#export ORACLE_HOME=/opt/ora9/product/9.2.0.4
³öÏÖsuccessµÄÌáʾ¾ÍÈ«²¿°²×°³É¹¦.
²¹¶¡´òÍêºó£¬»¹ÒªrelinkedÒ»¸ö.mkÎļþ£¬Çл»µ½oracleÓû§´°¿Ú
cd $ORACLE_HOME/network/lib
make -f ins_oemagent.mk install
Ö®ºó¾Í¿ÉÒÔÆô¶¯Agent·þÎñÁË.
4, ×îºóÖ´ÐÐ #dbca ½¨oracleÊý¾Ý¿â
µã»÷OK£¬È»ºóÍ˳ö¼´¿É,Õý³£µÇ½²¢Æô¶¯Êý¾Ý¿âµÄ²Ù×÷¡£
[oracle@oracle oracle]$ lsnrctl start
[oracle@oracle oracle]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Mar 12 22:58:53 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>; connect / as sysdba
Connected.
SQL>; shutdown immediate ¹Ø±ÕÊý¾Ý¿â
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>; startup; Æô¶¯Êý¾Ý¿â
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
5, ΪÁË·½±ã¹ÜÀí£¬¿ÉÒÔдһ¸öÆô¶¯½Å±¾ora9i£º
ÒÔrootÉí·Ý½øÈ룬±àдÒÔϽű¾£º
#!/bin/bash
#start and stop the oracle instance
# chkconfig -level 5 --add ora9i
#chkconfig: 345 91 19
# description: starts the oracle listener and instance
export ORACLE_HOME="/opt/ora9/product/9.2.0.4"
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER="oracle"
export ORACLE_SID=oradb
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo "oracle startup:cannot start"
exit 1
fi
case "$1" in
start)
#startup the listener and instance
echo -n "oracle startup: "
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo "finished"
;;
stop)
# stop listener, apache and database
echo -n "oracle shutdown:"
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo "finished"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: ora9i [start|stop|reload|restart]"
exit 1
esac
exit 0
´æΪora9iºó£¬È»ºóÓÃchmod a+x ora9,¼´¿ÉÔÚÒÔºóÒÔrootÉí·ÝÔËÐÐ/etc/rc.d/init.d/ora9i start |stop À´¹ÜÀíoracleµÄÆô¶¯ºÍÍ£Ö¹ÁË¡£Èç¹ûÒª½«Õâ¸ö½Å±¾¼ÓÈ뵽ϵͳÖÐʹÆä¿É¿ª»úÔËÐÐ(²»¹ý¹Ù·½ÊDz»½¨Ò鿪»ú×Ô¶¯ÔËÐеÄ)£¬ÄÇôҪÔËÐÐÒÔÏÂÃüÁchkconfig --level 3(»òÕßÊÇ5) --add ora9i
»òÕßÒÔrootÓû§Ö´ÐÐÈçÏÂÃüÁî:
#cp /orasetup/ora9i /etc/rc.d/init.d/
#chmod a+x /etc/rc.d/init.d /ora9
#cd /etc/rc.d/rc5.d
#ln -s /etc/rc.d/init.d/ora9i S99ora9i
#cd /etc/rc.d/rc0.d
#ln -s /etc/rc.d/init.d/ora9i K99ora9i
Ò²¿É×ÔÆô¶¯oracle9i!
»òÕß¿ÉÔÚ/etc/rc.d/rc.localÖмÓÈëÈçÏ£º
su - oracle -c "/opt/ora9/oracle/product/9.2.0.4/bin/lsnrctl start"
su - oracle -c "/opt/ora9/oracle/product/9.2.0.4/bin/dbstart start"
6,
¹ØÓÚÊý¾Ý¿âɾ³ýÖØа²×°µÄÎÊÌâ:
°ÑORACLE°²×°Ä¿Â¼É¾³ý¼°/etc/ora*.*ɾ³ý¾ÍÐÐÁË
#rm -f /etc/ora*.*
okÁË£¬ÏÖÔÚÒ»ÇÐÒ²¾Í²î²»¶àÁË£¬ÄãÒѾ¿ÉÒÔ½¨Òé×Ô¼ºµÄÊý¾Ý¿â¡£