RedHat AS 4.0×îа²×°Oracle9204ÊÖ¼Ç
RedHat AS 4.0×îа²×°Oracle9204ÊÖ¼Ç Linux as 2.6.9-15.ELsmp Ò»£¬½âѹËõOracle9204µÄ°²×°Îļþ 1£® Oracle 9iR2 (9.2.0.4) (1) ¼ò»¯¹ý³Ì£¨ÒÔoracleµÇ¼£¬ÊͷŰ²×°Îļþ,ʹÓøüÉٵĴÅÅ̿ռ䣬Ëٶȸü¿ì£© ÔÚ°²×°LINUXʱ×îºÃ·ÖÒ»¸öÇø/orasetup,ÕâÑùÒ»À´¼´Ê¹ÏµÍ³»µÁË,Ò²Ö»ÊÇÖØ×°ÏµÍ³,¶øÎÞÐëÖØÐ¿½±´Êý¾Ý¿â°²×°Îļþ. 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 (2) ½â°üºÍ½âѹ¹ý³ÌÖУ¬×Ô¶¯´´½¨ÁË3¸ö°üº¬°²×°ÎļþµÄĿ¼£º Disk1 Disk2 Disk3 Ö®ºó¾Í¿ÉÒÔ°²×°Oracle9iR2ÁË¡£ ¶þ£¬°²×°Ç°µÄ¼ì²éºÍ×¼±¸¹¤×÷£» 1£¬ ²é¿´ÕâЩ¿ª·¢°üÊÇ·ñÒѰ²×°£» °²×°ÐèÒªµÄÈí¼þ°üºÍ²¹¶¡°ü: p4198954_21_linux.zip ÔÚÔËÐÐ runInstaller ֮ǰ´ò. p3238244_9204_LINUX.zip ÐÞ¸´agent´íÎóµÄ²¹¶¡. p2617419_210_GENERIC.zip ´ò3238244²¹¶¡ËùÐèÒªµÄ²¹¶¡. 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 ÆäÖÐcompat-oracle-rhel4ºÍcompat-libcwait¿ÉÒÔÔÚÈçÏÂÍøÕ¾: http://oss.oracle.com/projects/comp...e/files/RedHat/
# rpm -qa | grep ¡®compat¡¯ Èý£¬´´½¨Êý¾Ý¿â°²×°µÄ×¼±¸¹¤×÷£» 1£¬´´½¨user/group£» #groupadd dba #groupadd oinstall #useradd oracle -g oinstall -G dba #passwd oracle 2£¬½¨Á¢oracle°²×°Îļþ¼Ð£» # mkdir -p /ora/app/oracle/product/9.2.0.4 # mkdir /ora/cwdata # chmod 777 /ora/cwdata # chown oracle.dba /ora/cwdata # chown oracle.dba /orasetup # chmod 777 /orasetup # chown -R oracle.dba /ora/app/oracle/product/9.2.0.4 # chmod -R 777 /ora/app/oracle/product/9.2.0.4 2£¬ ÅäÖû·¾³±äÁ¿£» ÒÔrootÓû§µÇ¼£¬ÉèÖÃrootÓû§µÄ»·¾³´ò¿ª.bash_profileÎļþ£¬½«ÈçÏÂÄÚÈݼÓÈ룺 export ORACLE_BASE=/ora/app/oracle export ORACLE_HOME=/ora/app/oracle/product/9.2.0.4 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin export ORACLE_OWNER=oracle export ORACLE_SID=oradb ʹÓÃOracleÓû§µÇ½: #su ¨C 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=/ora/app/oracle export ORACLE_BASE=/oradata export ORACLE_HOME=/ora/app/oracle/product/9.2.0.4 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin export ORACLE_OWNER=oracle export ORACLE_SID=oracdr 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.zhs16gbk" #export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export DISPLAY=10.37.16.107:0 export LANG=zh_CN.GBK export GDM_LANG=zh_CN.GBK export LC=zh_CN.GBK export PATH unset USERNAME 4£¬ ÉèÖÃϵͳ²ÎÊý£» #su ¨C 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( 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 = 1073741824 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 ¨CpÃüÁîʹµÃÄں˸ıäÁ¢¼´ÉúЧ£» ÒëÕß×¢£ºÒ»°ãÇé¿öÏ¿ÉÒÔÉèÖÃ×î´ó¹²ÏíÄÚ´æÎªÎïÀíÄÚ´æµÄÒ»°ë£¬Èç¹ûÎïÀíÄÚ´æÊÇ 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 ¨C 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/comp...e/files/RedHat/ ÏÂÔØ²¹¶¡ compat-libcwait-2.0-2.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm.ΪÁËÓ¦ÓÃÕâ¸ö²¹¶¡£¬¿ÉÒÔÔËÐУº $su ¨C 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%] ËÄ£¬¿ªÊ¼°²×°oracle9iR2 //ÖÐÎÄ×Ö·ûÂÒÂëÎÊÌ⣺ 1¡¢ÐÞ¸Ä Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/font.properties.zh Îļþ ½«ÆäÖÐ-tlc-song Ìæ»»Îª-misc-SimSun 2¡¢ÔÚDisk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/fonts.dir ÎļþÖмÓÈë"simsun.ttc -misc-SimSun-medium-r-normal--0-0-0-0-c-0-gbk-0"ÐРͬʱ½«¿ªÍ¨µÄ72¸ÄΪ73 3¡¢½«simsun.ttc¿½ÈëDisk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/Ŀ¼ÖÐ £¨Ò»£©¿ªÊ¼°²×°£º ½« 1.ÒÔoracleÓû§µÇ¼ϵͳ£¬½øÐÐOracleµÄ°²×°£º $ cd Disk1 $ ./runInstaller¹ýÒ»»á¶ù¾Í»á³öÏÖOracleµÄ°²×°½çÃæ 2.Ò»²½Ò»¸ö½ÅÓ¡°²×°ÏÂÈ¥¾ÍÐÐÁË£¡ 3,°²×°Íêºó´ò²¹¶¡£º Çл»µ½root£º#su ¨C 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:/home/hamcc/oracle_1/OPatch:/sbin (ÐÞ¸ÄPATHʱҪҪ°üÀ¨½âѹËõ³öÀ´µÄOpatch ºÍ sbinĿ¼) # unzip p3238244_9204_LINUX.zip # cd 3238244 # opatch apply Èç¹ûÌáʾHOME±äÁ¿´íÎó¿ÉÖ´ÐÐÓï¾ä£º #export ORACLE_BASE=/oradata #export ORACLE_HOME=/ora/app/oracle/product/9.2.0.4 ³öÏÖsuccessµÄÌáʾ¾ÍÈ«²¿°²×°³É¹¦. ²¹¶¡´òÍêºó£¬»¹ÒªrelinkedÒ»¸ö.mkÎļþ£¬Çл»µ½oracleÓû§´°¿Ú cd $ORACLE_HOME/network/lib make ¨Cf ins_oemagent.mk install Ö®ºó¾Í¿ÉÒÔÆô¶¯Agent·þÎñÁË. 4, ×îºóÖ´ÐÐ #dbca ½¨oracleÊý¾Ý¿â 21£¬µã»÷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, Êý¾Ý¿â´´½¨Íê³Éºó£¬ÐÞ¸Ä/etc/oratab£¬°ÑbossÄÇÒ»ÐÐ×îºóµÄN¸Ä³ÉY£¬È»ºóÖ´ÐÐdbstartÆô¶¯Êý¾Ý¿âÊý¾Ý¿â¿ÉÄÜÎÞ·¨Æô¶¯£¬±¨¸æCan¡¯t find init file ¡µÄ´íÎó£¬ÐèÒª¸´ÖÆÒ»¸ö³õʼ»¯Îļþ: cp /u01/app/oracle/admin/oradb/pfile/init.ora.* /u01/app/oracle/product/9.2.0/dbs/initoradb.ora ÖØÐÂÖ´ÐÐdbstart¾Í¿ÉÒÔÁË¡£ ΪÁË·½±ã¹ÜÀí£¬¿ÉÒÔдһ¸öÆô¶¯½Å±¾ora9i£º ÒÔrootÉí·Ý½øÈ룬±àдÒÔϽű¾£º #!/bin/bash #start and stop the oracle instance # chkconfig ¨Clevel 5 --add ora9i #chkconfig: 345 91 19 # des cription: starts the oracle listener and instance export ORACLE_HOME="/u01/app/oracle/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µÄÆô¶¯ºÍÍ£Ö¹ÁË¡£Èç¹ûÒª½«Õâ¸ö½Å±¾¼ÓÈ뵽ϵͳÖÐʹÆä¿É¿ª»úÔËÐУ¬ÄÇôҪÔËÐÐÒÔÏÂÃüÁ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 "/u01/app/oracle/product/9.2.0.4/bin/lsnrctl start" su - oracle -c "/u01/app/oracle/product/9.2.0.4/bin/dbstart start" 6, ¹ØÓÚÊý¾Ý¿âɾ³ýÖØÐ°²×°µÄÎÊÌâ: °ÑORACLE°²×°Ä¿Â¼É¾³ý¼°/etc/ora*.*ɾ³ý¾ÍÐÐÁË #rm ¨Cf /etc/ora*.* 7,¹ØÓÚÔÚLINUXÖÐÔËÐйÜÀíÈí¼þ #oemapp
±¾ÎÄÀ´×ÔChinaUnix²©¿Í£¬Èç¹û²é¿´ÔÎÄÇëµã£ºhttp://blog.chinaunix.net/u/21012/showart_143478.html |