ÔÚFedora 10ÉÏ°²×°Oracle£¨10.2.0£©[³Ï®]
ÔÚFedora 10ÉÏ°²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
1. Ñé֤ϵͳҪÇó
ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂÃüÁ
# grep MemTotal /proc/meminfo
MemTotal:512236 kB
# grep SwapTotal /proc/meminfo
SwapTotal:1574360 kB
ËùÐè×îС RAM Ϊ 512MB£¬¶øËùÐè×îС½»»»¿Õ¼äΪ 1GB¡£¶ÔÓÚ RAM СÓÚ»òµÈÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÁ½±¶£»¶ÔÓÚ RAM ´óÓÚ 2GB µÄϵͳ£¬½»»»¿Õ¼äӦΪ RAM ÊýÁ¿µÄÒ»µ½Á½±¶¡£ Oracle 10g Èí¼þ»¹ÐèÒª 2.5GB µÄ¿ÉÓôÅÅ̿ռ䣬¶øÊý¾Ý¿âÔòÁíÐè 1.2GB µÄ¿ÉÓôÅÅ̿ռ䡣/tmp Ŀ¼ÖÁÉÙÐèÒª 400MB µÄ¿ÉÓÿռ䡣Ҫ¼ì²éϵͳÉϵĿÉÓôÅÅ̿ռ䣬ÔËÐÐÒÔÏÂÃüÁ
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 6.8G 1.3G 5.2G 20% /
/dev/sda1 99M 17M 77M 18% /boot
¸ÃʾÀý±íÃ÷£¬/tmp Ŀ¼ûÓÐ×Ô¼ºµÄÎļþϵͳ¡££¨¶Ô±¾Ö¸Ä϶øÑÔ£¬ËüÊǸùÎļþϵͳµÄÒ»²¿·Ö¡££©
2. ÐÞ¸ÄϵͳÄں˲ÎÊý¡£¼ÓÒÔϵÄÄÚÈݵ½Îļþ/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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
×¢Ò⣺ÈçÒâÉèÖôíÎó°²×°¹ý³ÌÖлá³öÏÖ´íÎóÌáʾ£¬°´ÌáʾÐ޸ļ´¿É!
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
²ì¿´listener.log È·ÈÏûÓÐÎÊÌâ
# find / -name listener.log
/home/oracle/app/OraHome_1/network/log/listener.log
λÖÃÔÚ$ORACLE_HOME/network/log/listener.log
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 29-DEC-2009 15:12:15
Copyright (c) 1991, 2007, Oracle. All ......
°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......
¿ØÖÆÎļþºÍREDOLOGͬʱË𻵵ÄORACLEÊý¾Ý¿â»Ö¸´Ò»Àý
Ò»¸ö¿Í»§´òµç»°¸øÎÒ£¬ËµËûÃÇÒ»¸ö²âÊÔÊý¾Ý¿âÆð²»À´ÁË£¬ÈÃÎÒ¹ýÈ¥¿´¿´£¬
µ½¿Í»§ÏÖ³¡·¢ÏÖÊý¾Ý¿âÒѾDOWNÁË£¬ÊÔ×ÅÆô¶¯Ò»ÏÂ
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 7 10:33:29 2008
Copyright (c) 1982, 2006, Oracle. All Rig ......