ºìÁªLinuxÃÅ»§
Linux°ïÖú

RedHat AS4.0£¨64룩ÏÂOracle 10G R2

·¢²¼Ê±¼ä:2007-11-09 00:00:42À´Ô´:ºìÁª×÷Õß:lznljyjc
×¢Ò⣺˵Ã÷ÊÖ²áÖÐÔËÐÐÃüÁî´ø¡®#¡¯ºÅµÄ±íÃ÷ÒÔrootÓû§µÄÉí·ÝµÇ¼ϵͳ£»´ø¡®$¡¯ºÅµÄ±íÃ÷ÒÔoracleÓû§Éí·ÝµÇ¼¡£

Ò»¡¢¼ì²éÓ²¼þÊÇ·ñÂú×ãÒªÇó¡£

ÖÁÉÙÐèÒª512MÄÚ´æ

SWAP¿Õ¼ä´óÓÚµÈÓÚÄÚ´æµÄ1±¶£¨8192MÄÚ´æÒÔÄÚ£¬³¬¹ý8192MʱΪÄÚ´æµÄ0.75

400MÒÔÉϵÄ/tmpĿ¼

1.5Gµ½3.5GµÄÓ²Å̿ռäÓÃÓÚ°²×°OracleÈí¼þ£¨²»°üÀ¨Êý¾Ý¿âµÄÊý¾ÝÎļþ£©

1¡¢²é¿´ÄÚ´æ´óСµÄÃüÁ

# grep MemTotal /proc/meminfo

2¡¢²é¿´SWAP´óСµÄÃüÁ

# grep SwapTotal /proc/meminfo

3¡¢²é¿´RAMºÍSWAP¿ÉÓÿռäÃüÁ

# free

4¡¢²é¿´/tmp´óСµÄÃüÁ

# df -k /tmp

5¡¢²é¿´Ó²Å̿ռäµÄÃüÁ

# df -k

6¡¢²é¿´¼ÆËã»úCPUÇé¿öµÄÃüÁ

# grep "model name" /proc/cpuinfo

¶þ¡¢¼ì²éϵͳÈí¼þÊÇ·ñÂú×ã°²×°ÒªÇó¡£

LinuxµÄÄں˰汾£ºRed Hat Enterprise Linux 4.0 2.6.9-11.EL

Õë¶ÔRedhat AS4.0£¬¼ÆËã»úËù°²×°µÄϵͳ£¨»ò¿ª·¢£©Èí¼þÐè°üº¬ÒÔϰ汾µÄ°ü£º

binutils-2.15.92.0.2-10.EL4

compat-db-4.1.25-9

control-center-2.8.0-12

gcc-3.4.3-9.EL4

gcc-c++-3.4.3-9.EL4

glibc-2.3.4-2

glibc-common-2.3.4-2

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-9.EL4

libstdc++-devel-3.4.3-9.EL4

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

×¢Ò⣺ÒÔÉÏÄÚÈÝÖ±½Ó´ÓOracleÊý¾Ý¿âµÄ°²×°ÊÖ²áÉϵõ½£¬ÆäʵÕâ¸öÇåµ¥¼´Ê¹°²×°ÍêÈ«£¬Ò²²¢²»×ãÒÔʹoracleÊý¾Ý¿âµÄ°²×°Ë³ÀûÍê³É¡£Òò´ËÔÚ°²×°Linux²Ù×÷ϵͳʱ£¬ÔÚ²»ÊǷdz£Á˽âËùÐèµÄ±Ø±¸Èí¼þ°üµÄÇé¿öÏ£¬½¨ÒéÑ¡Ôñ°²×°È«²¿¿É°²×°µÄÈí¼þ¡£

n Redhat4.0ÐèÒª°²×°Gcc3.2.3°æ±¾£¬SUN JDK1.5.0ÒÔÉϰ汾¡£

1¡¢²é¿´LinuxµÄ°²×°°æ±¾ÃüÁ

# cat /proc/version

2¡¢²é¿´LinuxµÄÄں˰汾ÃüÁ

# uname -r

3¡¢²é¿´ÒѾ­°²×°µÄ°üµÄ°æ±¾µÄÃüÁ

# rpm -q package_name

Èç¹ûϵͳÏÔʾµÄ°²×°°æ±¾²»·ûºÏÒªÇó£¬ÐèÒªµ½RedhatµÄ¹Ù·½ÍøÕ¾ÏÂÔØËùÐèrpm£¬¸üм´¿É£»Èç¹ûϵͳÏÔʾËùÐèÈí¼þûÓа²×°£¬ÔòÓ¦Á¢¼´°²×°¡£

£¨°²×°rpm°ü£¬ÐèÒª½âѹËõLinux¸ñʽµÄһЩrpm°ü£ºtar -xvf °üÃû£»Ç¿Öư²×°°ü£ºrpm -Uvh °üÃû£¬ÒÔÉϲÙ×÷ÐèÒÔrootÓû§Éí·ÝÍê³É¡£ÁíÍ⣬Óеİü»¹¾ßÓÐÏà¹ØÐÔ£¬ÐèÒªÏÂÔØÏà¹ØµÄ°ü²ÅÄܰ²×°£¬È磺Äں˰üµÄÉý¼¶ÐèÒª°²×°mkinitrd°ü²Å¿ÉÒÔ£©



Èý¡¢¼ì²éÍøÂçÉèÖÃÊÇ·ñÂú×ã°²×°ÒªÇó

ÍøÂçÉèÖÃÒ»°ãÔÚ°²×°Ê±°´ÕÕ¾ßÌåÇé¿ö½øÐÐÅäÖü´¿É¡£µ±ÒòÎªÍøÂçÇé¿öÒýÆð°²×°ÎÊÌâʱ£¬Ó¦°´ÕÕ°²×°ÊÖ²áµÄ˵Ã÷¶ÔÍøÂçÇé¿ö½øÐмì²é¡£Ò²¿ÉÒÔÔÝʱ²»¿¼ÂÇÍøÂçÒòËØ¡£



ËÄ¡¢´´½¨°²×°ËùÐèµÄ²Ù×÷ϵͳ×éºÍÓû§

±ØÐëÌí¼ÓµÄϵͳ×éÓУºoinstall¡¢dba(´óСдÃô¸Ð)¡£oper×é²»ÊôÓÚ±ØÐë°²×°Ñ¡Ïî¡£

n ´´½¨OracleÊ×Òª×éoinstall¡£

1¡¢ÓÃÃüÁî²é¿´oracleÊ×Òª×éµÄ°²×°Çé¿ö£º

# more /etc/oraInst.loc

Èç¹ûÓÐÐÅÏ¢Êä³ö±íÃ÷Ê×Òª×é´æÔÚ£¬·ñÔò¾ÍÐèÒª´´½¨¡£ÃüÁîΪ£º

# /usr/sbin/groupadd oinstall

2¡¢ÓÃÃüÁî²é¿´oracle dba×éµÄÊÇ·ñ´æÔÚ£º

# grep dba /etc/group

Èç¹û²»´æÔÚ£¬ÓÃÒÔÏÂÃüÁî´´½¨£º

# /usr/sbin/groupadd dba

3¡¢´´½¨oper×éµÄÃüÁ

# /usr/sbin/groupadd oper



n ´´½¨oracleµÄÊôÖ÷Óû§£¨oracle£©

1¡¢²é¿´oracleÓû§µÄÇé¿ö£º

# id oracle

2¡¢´´½¨oracleÓû§ÃüÁ

# /usr/sbin/useradd -g oinstall -G dba oracle

3¡¢ÐÞ¸ÄoracleÊý¾Ý¿âÊôÖ÷Óû§£¨oracle£©µÄÊôÐÔ£¬Ê¹oinstall×÷ΪoracleÓû§µÄÊ×Ñ¡×飺

# /usr/sbin/usermod -g oinstall -G dba oracle

4¡¢ÒªÈ·ÈÏnobodyÓû§´æÔÚ£¬Èç¹û²»´æÔÚ´´½¨Ëü¡£

# id nobody

# /usr/sbin/useradd nobody



Îå¡¢ÅäÖÃÄں˲ÎÊý

ҪʹÄãµÄ²Ù×÷ϵͳÉÏËùÉèÖõÄÄں˲ÎÊý´óÓÚµÈÓÚÒÔÏÂÏàÓ¦Öµ£º

semmsl 250

semmns 32000

semopm 100

semmni 128

shmall 2097152

shmmax ÎïÀíÄÚ´æµÄÒ»°ë

shmmni 4096

file-max 65536

ip_local_port_range Minimum:1024 Maximum:65000

rmem_default 262144

rmem_max 262144

wmem_default 262144

wmem_max 262144

1¡¢ÓÃÒÔÏÂÃüÁî²é¿´ÏàÓ¦µÄ²ÎÊýÖµ

££/sbin/sysctl -a | grep sem£¨²ÎÊýÃû£©

Èç¹û²ÎÊýÖµ´ï²»µ½ÉÏÊöÒªÇó£¬ÔòÐèÒªÐÞ¸Ä/etc/sysctl.confÎļþ£¬ÔÚÆäÖÐÌí¼Ó»òÐÞ¸ÄÒÔÏÂÄÚÈÝ£º

kernel.shmall = 2097152

kernel.shmmax = ÎïÀíÄÚ´æµÄÒ»°ë£¨1024*1024*ÎïÀíÄڴ棩

kernel.shmmni = 4096

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

×¢Ò⣺Èôʹ´Ë²ÎÊýÅäÖÃÉúЧ£¬ÐèÒªÖØÆô²Ù×÷ϵͳ¡££¨ÔÚsuse linuxÏÂÔò²»ÐèÒª£©

2¡¢ÎªoracleÓû§ÉèÖÃshellÏÞÖÆ£º

u Ê×ÏÈÔÚ/etc/security/limits.confÎļþÖÐÌí¼ÓÒÔÏÂÄÚÈÝ£º

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

u È»ºóÔÚ/etc/pam.d/loginÎļþÖÐÌí¼ÓÒÔÏÂÄÚÈÝ£º

session required pam_limits.so

u ÔÚ/etc/profileÏÂÌí¼ÓÒÔÏÂÄÚÈÝ£º

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

Áù¡¢È·ÈϽ«Òª°²×°µÄµÄÈí¼þĿ¼

n oracleÊ×ѡĿ¼һ°ãΪ£ºoracle_base/oraInventory

n oracle homeĿ¼һ°ãΪ£ºoracle_base/product/10.2.0

n È·Èϲ¢Éú³Éoracle baseĿ¼£¨ÔÚÎҵݲװ¹ý³ÌÖУ¬oracle baseĿ¼ÊÇ/usr/oracle£©

ÉÏÊö¾ßÌåĿ¼ÓÉÄã×Ô¼ºÈ·¶¨¡£

1¡¢ÓÃÒÔÏÂÃüÁî²é¿´oracleÊ×ѡĿ¼ÊÇ·ñ´æÔÚ

# more /etc/oraInst.loc

Èç¹û´æÔÚ£¬ÔòÓëÒÔϸñʽÀàËÆ£º

inventory_loc=/usr/oracle/oraInventory

inst_group=oinstall

2¡¢¿´oracle homeĿ¼ÊÇ·ñ´æÔÚ

# more /etc/oratab

Èç¹û´æÔÚ£¬ÔòÓëÒÔϸñʽÀàËÆ£º

*:/usr/oracle/product/10.2.0:N

*:/opt/orauser/infra_904:N

*:/oracle/9.2.0:N

3¡¢´´½¨oracle baseĿ¼

ÔÚ´´½¨Ö®Ç°£¬ÐèҪȷÈÏÄãËù´´½¨µÄĿ¼Âú×ãoracleµÄ°²×°¿Õ¼äÐèÒª¡£´´½¨Àý×ÓΪ£º

#mkdir £­p /usr/oracle

´´½¨Íê±Ï£¬ÐèÒª½«¸ÃĿ¼µÄÊôÖ÷ÏÞÊÚÓèoracleÊ×Ñ¡×飬²¢¸Ä±äÆä²Ù×÷ȨÏÞ£¬Àý×ÓÈçÏ£º

# chown -R oracle:oinstall /usr/oracle

# chmod -R 775 /usr/oracle

×¢£º¶ÔÓÚʹÓÃÂãÉ豸ºÍASM£¨×Ô¶¯´æ´¢¹ÜÀí£©µÄoracleÊý¾Ý¿âµÄÌØ±ð°²×°ÅäÖã¬Ôڴ˲»×÷ÌØ±ð˵Ã÷£¬Èç¹ûÐèÒª£¬¿É²Î¿¼oracleÊý¾Ý¿âµÄÍêÕû°²×°Êֲᡣ



Æß¡¢ÅäÖÃÓû§»·¾³±äÁ¿

1¡¢É趨maskºÍDISPLAY»·¾³±äÁ¿¡£

ÔÚoracleÓû§µÄ¸ùĿ¼ÏµÄÎļþ.bash_profileÖÐÌí¼ÓÈçÏÂÄÚÈÝ£º

umask 022

DISPLAY =(hostname):0.0; export DISPLAY

¿ÉÒÔ²»Ìí¼ÓÀ¨ºÅÄÚµÄÄÚÈÝ£¬¼´Ö±½Óд³É£ºDISPLAY =:0.0;export DISPLAY¡£

Ô¶³Ì°²×°µÄ£¬»¹ÐèÒªÔÚÔËÐа²×°³ÌÐò֮ǰ¡£ÔÚ¸ùÓû§ÏÂÔËÐÐxhost + rlinux.localdomain(ÄãµÄÍêÕû»úÆ÷Ãû)¡£Èç¹ûORACLE_SID, ORACLE_HOME, »ò ORACLE_BASEµÈ»·¾³±äÁ¿ÔÚprofileÎļþÖÐÒѾ­´æÔÚ£¬Çë×¢ÊÍ»òɾ³ýµôÏàÓ¦ÄÚÈÝ¡£

2¡¢É趨ÁÙʱĿ¼µÄ»·¾³±äÁ¿

Ê×ÏÈÐèҪȷÈÏÁÙʱĿ¼µÄλÖᢴóСÊÇ·ñÂú×ã°²×°ÒªÇ󣬲¢¸Ä±äÁÙʱĿ¼µÄ¶ÁдȨÏÞ¡£

¸Ä±ä¶ÁдȨÏÞµÄÃüÁîÈçÏ£º

# chmod a+wr /tmp

ÔÚprofileÎļþÖÐÌí¼Ó£º

TEMP=/mount_point/tmp

TMPDIR=/mount_point/tmp

export TEMP TMPDIR

ʹÐÂÔö¼Óµ½profileÖеÄÄÚÈÝÔÚµ±Ç°Öжˣ¨tty£©ÉúЧµÄ°ì·¨ÊÇÔËÐÐÒ»ÏÂprofileÎļþ¼´¿É£º$ . ./.profile¡£

3¡¢ÔËÐÐÒÔÏÂÃüÁʹoracleµÄһЩ²ÎÊýÉúЧ£º(²»ÒªÌí¼Óµ½profileÖУ¬°²×°Íê³ÉºóÔÙÌí¼Ó²»³Ù)

$ ORACLE_BASE=/usr/oracle

$ ORACLE_SID=o10g

$ export ORACLE_BASE ORACLE_SID

4¡¢ÔËÐÐÒÔÏÂÃüÁʹµ±Ç°µÄһЩ²ÎÊýʧЧ¡£

$ unset ORACLE_HOME

$ unset TNS_ADMIN



°Ë¡¢°²×°

ÔÚ°²×°Ä¿Â¼ÏÂÔËÐа²×°³ÌÐò£º

$./runInstaller

°²×°¹ý³ÌÈ«²¿ÊÇÓû§Í¼ÐνçÃæ£¬ÓëÔÚwindows»·¾³Ïµİ²×°½çÃæÃ»Óжà´óÇø±ð£¬Óû§°´ÕÕϵͳҪÇóºÍÄã×Ô¼º¼ÆËã»úµÄÇé¿öÍê³É¼´¿É¡£°²×°¹ý³ÌÖУ¬ÐèҪעÒâµÄÊÇoracleÊ×Ñ¡×éµÄÑ¡Ôñ¡¢oracle homeµÄÊäÈëÒÔ¼°¿ÉÄܳöÏֵĴíÎóÌáʾºÍ½â¾ö°ì·¨¡££¨¾ßÌå³ö´íÌáʾºÍ½â¾ö°ì·¨²Î¿¼±¾Êֲḽ´øÄÚÈÝ£©¡£ÁíÍ⣬°²×°¹ý³ÌÖУ¬°²×°³ÌÐò»á¼ì²âÄãΪϵͳÅäÖõIJÎÊýÊÇ·ñ´æÔÚÎÊÌâ²¢ÏÔʾ½á¹û±¨¸æ£¬Èç¹û½á¹û´æÔÚÎÊÌ⣬ӦÏÈÍ˳ö£¬´ýÐÞÕýÎÊÌâÒÔºóÔÙÆô¶¯°²×°¡£

°²×°½áÊøÇ°£¬°²×°½çÃæ»áµ¯³ö´°¿Ú£¬ÐèÒªÒÔrootÓû§Éí·ÝÔËÐÐÁ½¸öÃüÁ

# /home/oracle/oraInventory/orainstRoot.sh

# $ORACLE_HOME/root.sh

°²×°Íê³É£¬ÐèÒªÁ¢¼´±¸·Ýroot.shÎļþ£¬ÒԱ㽫À´°²×°ÐµÄoracle²úƷʱʹÓá£Èç¹ûҪɾ³ýoracleÊý¾Ý¿â£¬ÐèҪͨ¹ýÔËÐÐdbcaÃüÁîÊ×ÏÈɾ³ýoracleÊý¾Ý¿âʵÀý£¬È»ºóÔÙÔËÐÐ$ORACLE_HOME/oui/install/runInstallerÃüÁ½øÈë°²×°½çÃæ£¬¸ù¾ÝÐèҪѡÔñɾ³ýÈ«²¿»òÐèҪɾ³ýµÄ²¿·ÖÈí¼þ¼´¿É¡£



¾Å¡¢°²×°Íê³ÉºóµÄÅäÖÃ

n oracle°²×°Íê³Éºó£¬ÐèÒªÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿£¬¼´½«»·¾³±äÁ¿Ìí¼Óµ½.bash_profileÖС£

ORACLE_HOME=/usr/oracle/product/10.2.0

export ORACLE_HOME

ORACLE_SID=o10g

export ORACLE_SID

NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export NLS_LANG

TNS_ADMIN=$ORACLE_HOME/network/admin

export TNS_ADMIN

ORA_NLS33=$ORACLE_HOME/nls/data

export ORA_NLS33

PATH=$PATH:$ORACLE_HOME/bin

export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

export LD_LIBRARY_PATH

CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Export CLASS_PATH
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ