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

ѧºÃOracleµÄÁùÌõ×ܽá

·¢²¼Ê±¼ä:2007-06-26 00:10:53À´Ô´:ºìÁª×÷Õß:Comeshappy
¡¡¡¡¾­³£ÓÐһЩOracleµÄ³õѧÕßÎʵ½Õâ¸öÎÊÌ⣬ÕâÀïËãÊÇÒ»¸öͳһ´ð¸´¡£

¡¡¡¡1¡¢Èç¹ûÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡£¬ÖªµÀSQLÊÇÔõô»ØÊ£¬¼´Ê¹Ð´²»³öÀ´¼òµ¥µÄSQL£¬µ«¿ÉÒÔ¿´¶¯ËüÃÇ£¬Äã¾Í¿ÉÒÔÌøµ½2¡£·ñÔòÇëÏÈ¿´Ò»ÏÂÊý¾Ý¿â»ù´¡ºÍSQLÓïÑÔ£¬²»ÐèÒªºÜÉ¸ü²»ÐèҪȥ¼ÇÒäÄÇЩ¸´ÔÓµÄSQLÃüÁÕâЩ¿ÉÒÔÁôÔÚÒÔºó±ßÓ¦Óñßѧϰ¡¢¼ÇÒä¡£

¡¡¡¡2¡¢ÒªÏëѧºÃORACLE£¬Ê×ÏÈҪѧϰORACLEµÄÌåϵ½á¹¹£¬ÏÖÔÚÄã²»ÐèÒªÉîÈëÀí½âËüÃÇ£¬µ«Òª·ÖÇ弸¸ö¹Ø¼üµÄ¸ÅÄ

¡¡¡¡instance & database,

¡¡¡¡memory structure , process & those files ,such as data file, control file, init parameter file etc

¡¡¡¡ÒÔ¼°database , tablespace , data fileºÍtablespace, segmnet, extent & blockËüÃÇÖ®¼äµÄ¹Øϵ¡£

¡¡¡¡µ±È»»¹Òª·ÖÇåundo tablespace & redo log fileµÈ£¬

¡¡¡¡¶ÔÓںܶà³õѧÕßÀ´Ëµ£¬Äܹ»¶ÔÕâЩ¸ÅÄîÓиö½ÏΪÇåÎúµÄÈÏʶ²¢²»ÊÇÒ»¼þÈÝÒ×µÄÊ£¬¶øÕâЩ²¢·ÇOracleµÄÈ«²¿¡£

¡¡¡¡3¡¢2ÊÇÓйØORACLEµÄһЩ»ù±¾¸ÅÄÏÂÃæҪѧϰµÄÊÇһЩ¼òµ¥µÄµÄʵ¼Ê²Ù×÷£¬¾ÍÊÇÈçºÎÈ¥¹ÜÀíORACLEÊý¾Ý¿â£¬µ±È»²»ÊǹÜÀíÈ«²¿µÄORACLE¡£Ôڴ˹ý³ÌÖÐÄ㽫¶ÔSQLºÍORACLEÌåϵ½á¹¹Óиö¸üÉîÈëµÄÁ˽⡣

¡¡¡¡4¡¢µ½ÁËÕâÒ»²½Äã»ù±¾ÉÏËãÊdzõ²½ÕÆÎÕÁËORACLE£¬ÏÂÃ潫Ҫ¸ù¾ÝÄãµÄ·½ÏòÀ´¾ßÌåѧϰÆäËüµÄORACLE֪ʶÁË¡£Èç¹ûÄãÊÇ¿ª·¢ÈËÔ±£¬ÔòÐèÒª¸ü¶àµØȥѧϰPL/SQLÒÔ¼°DEVELOPER£¬¶øÕ⽫ÊÇÒ»ÃÅеĿγ̡£Èç¹ûÄãÊÇÒ»ÃûDBA£¬Çë¼ÌÐø¡£

¡¡¡¡5¡¢ÏÖÔÚÄã¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄʵ¼ÊÇé¿ö£¬½øÐÐÓÐÑ¡ÔñµÄѧϰ£¬Ò²¾ÍÊÇ˵ÏÂÃæµÄÄÚÈÝûÓÐÌرð˳ÐòÒªÇ󡣿ÉÒÔÑ¡ÔñÉîÈëѧϰORACLEµÄ¹ÜÀí¡¢±¸·ÝÓë»Ö¸´¡¢ÐÔÄܵ÷Õû¡¢ÍøÂçµÈ¡£µ±È»ÔÚѧϰÕâЩ֪ʶµÄ¹ý³ÌÖУ¬Èç¹ûÓÐʵ¼ÊµÄ¹¤×÷¸üºÃ£¬ÕâÑùÄã¿ÉÒÔÔÚʵ¼ÊÖгɳ¤£¬Ñ§»áTROUBLE SHOOTING¡£

¡¡¡¡6¡¢µ±È»ÔÚѧϰµÄ¹ý³ÌÖУ¬Äã¿ÉÒÔÔÚÍøÕ¾»òÂÛ̳ÖÐÓëËûÈ˽øÐн»Á÷£¬¿ÉÒÔ¿´±ðÈ˵ÄһЩ¾­ÑéÎÄÕ£¬Ò²¿ÉÒÔ×Ô¼ºÐ´Ò»Ð©ÐĵÃÌå»á¡£¼¼Êõ½ø²½µÄ±¾Éí¾ÍÊǾ­ÑéµÄ»ýÀÛºÍÌáÁ¶¹ý³Ì£¬Ï£Íû´ó¼Ò¹²Í¬³É³¤£¬»¶Ó­´ó¼ÒÏ໥½»Á÷¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 33 ÌõÆÀÂÛ

  1. wout ÓÚ 2011-12-27 10:19:41·¢±í:

    ÏÖÔÚÔÚѧϰOracle¡£Ã¿Ì춼ÔÚѧϰ¡£¸ø×Ô¼º¼ÓÓÍ£¡

  2. tuerqi8 ÓÚ 2011-12-26 14:22:58·¢±í:

    ¹ýÀ´È˵ľ­ÑéÊÇÖµµÃ½è¼øµÄ

  3. xinour ÓÚ 2011-12-03 09:15:44·¢±í:

    ºÜÇ¿´óORACLEÖ§³Ösoft.tlte.com

  4. aokang ÓÚ 2011-10-19 11:30:00·¢±í:

    ºÙºÙ£¬ÎҸоõ×ÔѧÊÇ×îºÃµÄ·½·¨£¬µ«ÊÇÒªÔÚʵ¼ùÖÐ×ÔѧµÄ»°£¬½«»áºÜ¿ìµÄ£¬Ò²»á»ýÀۺܶྭÑéµÄ

  5. dongyichen ÓÚ 2011-08-04 14:55:08·¢±í:

    лл·ÖÏí~

  6. chunleilee ÓÚ 2010-10-08 09:47:23·¢±í:

    ѧϰ

  7. xbonline ÓÚ 2010-09-28 23:01:57·¢±í:

    ÓëMySql£¬Äĸö¸üºÃ¡££¿£¿

  8. zifeiyu-fish ÓÚ 2010-09-16 22:34:13·¢±í:

    ÏÈʵ¼ù£¬ÔÙÀíÂÛ¡«

  9. jihy ÓÚ 2010-08-17 14:40:58·¢±í:

    ·¹ý¡£

  10. ×ÏÜ° ÓÚ 2010-08-17 11:00:55·¢±í:

    {:3_107:}ÎÒ·¹ý

  11. yanlong938 ÓÚ 2010-08-17 01:30:23·¢±í:

    ¾­Ñé̸֮ ²»´í¡£¡£¡£

  12. jihy ÓÚ 2010-08-10 11:03:37·¢±í:

    Ê×ÏȸÐл¥Ö÷µÄ×ܽᣬµ«Ï£ÍûÂ¥Ö÷À´µãʵ¼ÊµÄŶ¡£ÀýÈç×ÊÁÏ£¬µç×ÓÊ鼮ʲôµÄ¡£¡£

  13. wzx8118 ÓÚ 2010-06-14 08:59:34·¢±í:

    µ«ÎÒÈÏΪѧoracle£¬²»Ñ§oracleµÄÌåϵ£¬ÊǺÜÄÑÉîÈëµÄ£¡

  14. lihongniu ÓÚ 2010-04-12 14:07:39·¢±í:

    ÆäʵÎÒ¾õµÃѧϰÕâ¸öOracle¾ÍÊÇ¿¿¶à¶¯ÊÖÈ¥Á· Òª²»¿´ÔÙ¶àµÄÊéÒ²ÊÇ°× Ã»É¶×÷ÓÃ

  15. melvin2005 ÓÚ 2010-03-30 11:04:48·¢±í:

    ²»´íµÄ½¨Òé

  16. zhtlinux ÓÚ 2010-03-15 20:33:18·¢±í:

    ±¾ÈË»¹Ã»½Ó´¥¹ýoracle¡£

  17. bonniezxf ÓÚ 2010-03-15 17:50:40·¢±í:

    ˵µÄÌ«ºÃÁË£¬Ð»Ð»

  18. panda6401 ÓÚ 2010-02-04 16:52:14·¢±í:

    ¸ÕÄܹ»°²×°oracle

  19. xhpzy28 ÓÚ 2010-02-04 16:28:43·¢±í:

    Õý×¼±¸ºÃºÃѧѧORACLE£¬ÊܽÌÁË~~~

  20. Ѫ֮°§ÉË ÓÚ 2009-10-19 10:11:14·¢±í:

    À´Ö§³ÖÏÂ.............

  21. heijunmasd ÓÚ 2009-10-16 10:58:01·¢±í:

    ²»Ñ§PL/SQLÔõôÐУ¿£¿

    ÏÈѧ¿ª·¢£¬ºóѧ¹ÜÀí

  22. jovewu ÓÚ 2009-10-09 09:17:38·¢±í:

    ¶÷£¬ºÜÓеÀÀí£¬¶ÔÓÚ³õѧÕߣ¬°´ÕÕÕâÑùµÄ˼·ѧϰӦ¸Ã²»»á×ßʲôÍä·£¡

  23. lajiduke ÓÚ 2009-09-28 16:42:31·¢±í:

    1# Comeshappy


    hao tie

  24. leajinfeng ÓÚ 2009-09-26 19:13:18·¢±í:

    LZÍƼöһЩÊé¼®°¡

  25. Bruce.Ko ÓÚ 2009-09-24 14:56:34·¢±í:

    ¸Ðл¥Ö÷Äܹ»·ÖÏí³ö×Ô¼º±¦¹óµÄ¾­Ñ飡×ܽáµÄºÜÓмûµØ£¡

  26. shiweimath ÓÚ 2009-09-20 17:04:39·¢±í:

    ÎÒ¾õµÃÓÐÒ»¶¨Ó¢Óï»ù´¡µÄ»°£¬¹Ù·½Îĵµ¾ø¶ÔÊÇ×îºÃµÄ½Ì²Ä£¬¸Ð¾õÆäËû½Ì²Ä¶¼Êdz­ÎĵµµÄ»ò·­Òë¹ýÀ´£¬¶øÇÒûÓÐÏêϸ£¬ºÃ¶à¶¼Êǵ㵽Ϊֹ¡£
    È»ºóÔÚÕÒЩ°¸ÀýÀ´ÊµÑ飬ʵÑéÖÐѧϰ½ø²½¡£Ïë¸üÉîÈëѧϰµÄ»°£¬¸Ç¹úÇ¿µÄÊéÊǸöºÃÑ¡Ôñ£¬¶ÔÎÊÌâÑо¿ÉîÈë½÷É÷¡£
    ÎÒ¾ÍÕâÑù£¬²»¹ýÎÒ¶ÔoracleÌåϵ½á¹¹ÒÑÓÐÒ»¶¨µÄÁ˽⣡
    ¾¹ÊǸöÈËÏë·¨£¡

  27. chengxcwl ÓÚ 2009-09-16 23:04:59·¢±í:

    ²»ÖªµÀÓÐʲôºÃµÄ»ù´¡Êé¼®½éÉܱ¾°¡

  28. begin10010 ÓÚ 2009-09-09 17:22:12·¢±í:

    Çë½Ì£ºÃ»Óл·¾³¡¢ÍêÈ«×ÔѧµÄÌõ¼þÏ£¬ÈçºÎѧºÃOracle°¡£¿

  29. liangonejzh ÓÚ 2009-08-24 21:09:43·¢±í:

    ..........

  30. weiwo ÓÚ 2009-08-20 18:49:46·¢±í:

    °³ÒªºÃºÃѧϰ£¬Ð»Ð»´ó¼Ò

  31. Damon_lan ÓÚ 2009-08-12 14:25:46·¢±í:

    ÎÒÏÖÔÚÔÚѧOralceÄØ¡£¡£ÎÒÖ»ÓÃÒ»±¾Ê飡£¡ÎÒҲûÓÐѧ¹ýSQL¡£¡£

    ÎÒ¾õµÃ¸öÈËÓиöÈ˵ķ½·¨¡£¡£Äã¾õµÃÐеķ½·¨²»Ò»¶¨ÊÇÐеģ¡¡£µ±È» ÎÒ²»·½¶ÔLZºÃµÄÖ÷Òâ¡£ºÇºÇ¡£

  32. xiaoxiao1 ÓÚ 2009-08-11 16:23:54·¢±í:

    À´µãʵ¼ÊµÄàç ....¿Õ̸......Á´½Ó°¡ Îĵµ°¡ ʲôµÄ ·¢µãÀ´°¡~~~~

  33. linuxguy ÓÚ 2007-06-26 23:42:50·¢±í:

    :0L