ÓïÑÔÈë¿Ú£º¼òÌåÖÐÎÄ | English | ±±ÑDz©¿Í
 
    
 
±±ÑÇLinuxÊý¾Ý»Ö¸´

Ê×ϯ¹¤³Ìʦ£ºÕÅÓî

ÊÖ»ú£º18600440055

×ù»ú£º4006505646-801

´«Õ棺4006505646-809

Email:zy@datahf.net

µØÖ·£º±±¾©Êк£µíÇøÓÀ·á»ùµØ·á»ÛÖз7ºÅвÄÁÏ´´Òµ´óÏÃB×ù205ÊÒ
QQ£ºµã»÷ÕâÀï¸øÎÒ·¢ÏûÏ¢
µ±Ç°Î»ÖãºÊ×Ò³>>LinuxÐÞ¸´ÖªÊ¶>>Linux·ÖÇøÐÞ¸´>>ÕýÎÄ
LinuxÐÞ¸´ÖªÊ¶

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

ÉÏһƪ£ºoracleͨ¹ýµ¼³ö·½Ê½±¸·Ý
ÏÂһƪ£ºÈçºÎÐÞ¸ÄOracleÓû§ÃÜÂëµÄ¾÷ÇÏ
JFSÎļþϵͳ¼ò½é
XFSÎļþϵͳ¼ò½é
ReiserfsÎļþϵͳ¼ò½é
EXT3Îļþϵͳ¼ò½é
³£¼ûLinuxÎļþϵͳ¼ò½é
GRUB¼ò½éÓëÅäÖÃ
LILOµÄʹÓúÍÅäÖÃ
Linuxµ¥Óû§Ä£Ê½Î¬»¤ÏµÍ³
Òýµ¼¼ÓÔØ³ÌÐò¼ò½é
ÖØÖÃLinuxÓû§¿ÚÁî
¡¡¡¡°æÈ¨ËùÓÐ@±±¾©±±ÑÇʱ´ú¿Æ¼¼ÓÐÏÞ¹«Ë¾¡¡¡¡ ¾©ICP±¸09039053ºÅ ¡¡¡¡¡¡
¡¡¡¡×ܲ¿µç»°£º£¨010£©82488636 ¡¡Öйú¡¤±±¾©¡¤º£µíÇøÖйشåEÊÀ½çC×ù8²ã879ÊÒ¡¡ ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Õ¾µãµØÍ¼ ¡¡¡¡ÁªÏµÎÒÃÇ¡¡¡¡RSSÔĶÁ
þ