ÔÚ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
×¢Ò⣺ÈçÒâÉèÖôíÎó°²×°¹ý³ÌÖлá³öÏÖ´íÎóÌáʾ£¬°´ÌáʾÐ޸ļ´¿É!
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
²ì¿´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 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅҪΠ......
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal I ......
ʹÓÃnulls first »òÕßnulls last Óï·¨
Nulls firstºÍnulls lastÊÇOracle Order byÖ§³ÖµÄÓï·¨
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls firstÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îÇ°(²»¹ÜÊÇasc »¹ÊÇ desc)
Èç¹ûOrder by ÖÐÖ¸¶¨Á˱í´ïʽNulls lastÔò±íʾnullÖµµÄ¼Ç¼½«ÅÅÔÚ×îºó (²»¹ÜÊÇasc »¹ÊÇ desc)
ʹÓÃÓï·¨ÈçÏ£º
--½«nulls ......