linux½ø³ÌºÍÏß³Ì
ÕâÁ½ÌìÒ»Ö±ÔÚ¿´linxu½ø³ÌºÍÏ̵߳Ķ«Î÷£¬×ÜÊÇЧÂʱȽϵͣ¬Õâôһµã»ù´¡µÄ¶«Î÷»¹¿´ÁËÕâô¾Ã¡£¸Ã×ÔÎÒ·´Ê¡Ò»Ï¡£
Ê×ÏÈÀ´¿´¿´½ø³Ì¡£½ø³Ì·ÖΪÈý¸ö²¿·Ö£¬½ø³Ì¿ØÖƿ飬³ÌÐò¶ÎºÍÊý¾Ý¶Î¡£½ø³ÌÊÇÒ»¸öÓÐÉúÃüµÄʵÌ壬³ÌÐòÊÇÒ»¸öûÓÐÉúÃüµÄʵÌå¡£Ö»ÓÐCPU¸³Óè³ÌÐòÉúÃüµÄʱºò£¬³ÌÐò²Å³ÉΪһ¸ö»î¶¯µÄʵÌ壬ÎÒÃdzÆÖ®Îª“½ø³Ì”¡£Ã¿Ò»¸ö½ø³Ì¶¼ÓÐ×Ô¼ºµÄµØÖ·¿Õ¼ä¡£Ò»°ã°üÀ¨Îı¾Çø£¨´úÂëÇø£©£¬Êý¾ÝÇø£¬¶ÑÕ»¡£Îı¾Çø´æ´¢³ÌÐòÖ´ÐеĴúÂ룻Êý¾ÝÇø´æ´¢±äÁ¿ºÍ¶¯Ì¬·ÖÅäµÄÄÚ´æ£»Õ»Çø´æ´¢»î¶¯¹ý³Ìµ÷ÓõÄÖ¸ÁîºÍ¾Ö²¿±äÁ¿¡£½ø³ÌÊÇ×ÊÔ´¹ÜÀíµÄ×îСµ¥Ôª¡£
ÔÙÀ´¿´¿´Ï̡߳£Ïß³ÌÓÖ±»³ÆÎªÇáÁ¿¼¶½ø³Ì¡£²»Í¬µÄ½ø³ÌÖ®¼äÓв»Í¬µÄ´úÂë¿Õ¼äºÍÊý¾Ý¿Õ¼ä£¬µ«ÊÇͬһ¸ö½ø³ÌÖ®ÄÚµÄÏß³ÌÈ´¹²Ïí¸Ã½ø³ÌµÄÊý¾Ý¿Õ¼äºÍ´úÂë¿Õ¼ä¡£²»½öÈç´Ë£¬ËüÃÇ»¹¹²Ïí½ø³Ì´ò¿ªµÄÎļþÃèÊö·û£¬Ðźžä±ú£¬ÐźŴ¦ÀíÆ÷ºÍµ±Ç°Ä¿Â¼×´Ì¬£¬ÒÔ¼°½ø³ÌIDºÍ½ø³Ì×éID¡£µ«ÊÇÿ¸öÏß³ÌÒ²ÓÐ×Ô¼º¶ÀÕ¼µÄ×ÊÔ´£¬°üÀ¨£ºÏß³ÌID£¬Ï̶߳ÑÕ»£¬³ÌÐò¼ÆÊýÆ÷ºÍ´íÎó·µ»ØÂ룬Ïß³ÌÓÅÏȼ¶£¬ÐÅºÅÆÁ±ÎÂëµÈ¡£
Ïà¹ØÎĵµ£º
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ· ......
Ϊ
¸ãÇå³þÈçºÎÔÚϵͳÆô¶¯Ê±×Ô¶¯¼ÓÔØÄ£¿é£¬ËÑË÷Á˺þã¬ÍøÉÏÓкܶàÈËÌá³öÕâ¸öÎÊÌ⣬µ«¶¼Ã»ÓÐÕýÈ·µÄ´ð°¸£¬ÎÞÂÛÊÇÖÐÎÄÉçÇø»¹ÊÇÓ¢ÎÄÉçÇø£¬´ó¼ÒµÄ»Ø´ð¶¼Ã»Óн²µ½µã
×ÓÉÏ£¬ÎÞ·ÇÊÇÎ§ÈÆ modprobe.conf¡¢modprobe½²À´½²È¥µÄ£¬Òª²»¾ÍÊÇÕë¶ÔÌØ¶¨ÎÊÌâ³¢ÊÔ²»Í¬µÄ·½·¨¡£ÓеϹ½¨Òé°Ñmodprobe
modulenameдÈërc.local£¬È´²»ÔøÏë ......
mysql ½ØÈ¡Ä³Ò»¸öʱ¼ä(datetimeÀàÐÍ)µÄÈÕÆÚ£º
·½·¨1£ºselect date(row_name) from table_name where row = row1;
·½·¨2£ºselect left(row_name, 10) from table_name where row = row1;
·½·¨3£ºselect cast(row_name as char[10]) from table_name where row = row1;
È¡µÃij¸öÈÕÆÚµÄtime_tÊýÖµ£ºselect unix_times ......
¸Õ²ÅÔĶÁ´úÂëµÄʱºò¿´µ½ÁËÒ»¸ö×Ö½ÚÅÅÐòº¯Êý£¬Ò»Ê±Ïë²»Æð¾ßÌåÓ÷¨ÁË¡£ÏëÏëѧϰlinuxϵÄÍøÂç±à³ÌÒ²²»ÉÙʱ¼äÁË£¬ÕâЩ×Ö½ÚÅÅÐòºÍת»»µÄº¯Êý»¹ÊDz»Ì«Çå³þ£¬ÈÝÒ×»ìÏý¡£½ñÌìË÷ÐÔ°ÑÕâ·½ÃæµÄ֪ʶ»ã×Üһϣ¬ÕùÈ¡ÒÔºóÄܹ»ÊìÁ·µÄÈÏʶºÍÔËÓá£
×Ö½Ú˳Ðòº¯Êý£º
С¶Ë×Ö½ÚÐò£º½«µÍÐò×Ö½Ú´æ´¢ÔÚÆðʼµØÖ·¡£(linux)
´ó¶Ë×Ö½ÚÐò£º½«¸ßÐò×Ö½Ú ......