ORACLEÀ䱸·Ý¼°»Ö¸´
±¸·Ý
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradata(datafile£¬ controlfile£¬redo)¡¢flash_recovery_areaÈý¸öÎļþ¼Ð£¬db_1Ŀ¼ÏÂdatabase(PWDfile¡¢pfile)¡¢dbs(spfile)¡¢NETWORK\ADMIN(listener.ora¡¢tnsnames.ora)£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.Í£Ö¹Êý¾Ý¿â shutdown immediate£»
3. ¸´Öư²×°Ä¿Â¼ÏµÄadmin¡¢oradata¡¢flash_recovery_area¸²¸Ç£¬¸´ÖÆdatabase(PWDfile¡¢pfile) ¸²¸Ç
4. Æô¶¯Êý¾Ý¿â startup;
·½·¨¶þ£º£¨²»Ð轨¿â£¬ÉÔÂé·³µã£©
(1)£º²Ù×÷ÏµÍ³ÖØ×°£¬Èç¹û×öÀ䱸»Ö¸´£¬Òª±£Ö¤Ïàͬ²Ù×÷ϵͳ£¬ÏàͬµÄÊý¾Ý¿â°æ±¾¡£
(2)£ºÕý³£°²×°oracleÈí¼þ£¬Ö»ÐèÒª°²×°Èí¼þ£¬²»Óý¨ÊµÀý¡£
(3)£ºÊý¾Ý¸²¸Ç£¬°üÀ¨Êý¾ÝÎļþ¡¢²ÎÊýÎļþ¡¢¿ØÖÆÎļþ¡¢ÈÕÖ¾Îļþ¡¢pwdÎļþ£¬·ÅÔÚÓëÔϵͳÏàͬµÄĿ¼¡£Èç¹ûĿ¼ÓÐËù¸Ä±ä£¬ÔòÐèÒªÁíÍ⽨Á¢¿ØÖÆÎļþ£¬ÐÞ¸Äpfile¡£
(4)£º½¨Á¢·þÎñ£ºÊ¹ÓÃoradim ÃüÁî cmdÏ oradim -new -sid gbicc £¬±íʾ½¨Á¢Ò»¸ö·þÎñ£¬sidΪgbicc¡£Èç¹ûÊÇÔÚlinuxÏ£¬²»ÐèÒª´Ë²½¡£
(5)£º½¨Á¢¼àÌý£º net configuration assintant À´½¨Á¢(½¨Ò齫ԴϵͳµÄnetworkϵÄÎļþ¿½¹ýÀ´£¬¸ù¾Ýʵ¼ÊÇé¿öÐÞ¸Ä)¡£
(6)£º´ò¿ªÊý¾Ý¿â£º cmd
set oracle_sid=gbicc;
sqlplus /nolog;
Conn / as sysdba;
startup;
ÖÁ´Ë£¬À䱸·Ý»Ö¸´³É¹¦¡£
Ïà¹ØÎĵµ£º
֮ǰ¸ø´ó¼Ò½éÉÜÁËÔÚWIN7ÉÏOracle 10gµÄ°²×°·½·¨£¬½ÓÏÂÀ´¾Í¸Ã¸ø´ó¼Ò½éÉÜËüµÄÐ¶ÔØ·½·¨ÁË¡£ºÜ¶àÈ˲»¸Ò°²×°Oracle¾ÍÊǵ£Ðݲװºó»áÐ¶ÔØ²»¸É¾»£¬Æäʵµ±³õÎÒÒ²ÓйýÕâ¸ö¹ËÂÇ£¬ºÇºÇ¡£µ«ºóÀ´·¢ÏÖ£¬ÆäÊµÐ¶ÔØÊǺÜÈÝÒ×µÄÊ¡£¾Í¼¸²½¶øÒÑ£¬²»ÐžÍÇë¿´£º
¿ÉÒÔʹÓòúÆ·×Ô´øµÄÐ¶ÔØ¹¤¾ßÈ¥Ð¶ÔØ¡£
1£® ......
±¸×¢£º
±¾²©ÄÚÈÝÊdzнÓÉÏÆÚÄÚÈݵÄÑÓÐø£¬ÓÉÓÚÄÚÈݹý³¤£¬Òò´Ë²ÉÓ÷ֶÎ˵Ã÷£¬ÒÔÃâ´ó¼Ò¿´ÆðÀ´Æ£¾ë£¬ÈôÁ˽â¸ü¶àÏêϸµÄ°²×°Á÷³Ì£¬Çë¼ÌÐø¹Ø×¢±¾²©¡£²ÎÕÕÔ°æ°²×°ÊÖ²á¶ÔÕÕ°²×°¡£
4£®Configure Oracle Installation Owner Shell Limits
<1>ÅäÖÃlimits.confÎļþ£¬ºìÉ«±êעΪÔö¼ÓµÄÅäÖÃÄÚÈÝ¡£
[root@myli ......
Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔÒò¡£ÔÚÕâÆªÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖÆµÄ»ù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......
oracleѧϰ±Ê¼Ç_´¥·¢Æ÷
´¥·¢Æ÷
ÊÇÌØ¶¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬µ«ÊÇÓû§²»ÄÜÖ±½Óµ÷ÓÃËûÃÇ¡£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖÆ¶Ô±íµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼ÆºÍÈÕÖ¾¼Ç¼
5¡¢ ·ÀÖ¹ÎÞЧµÄÊÂÎñ´¦Àí
6¡¢ ÆôÓø´ÔÓµÄÒµÎñÂß¼
¿ªÊ¼
create trigger biufe ......
1¡¢Ê¹ÓÃLR×Ô´øµÄ¼à¿ØÒýÇæ
¡¡¡¡ÔÚLRµÄcontrollerÉϰ²×°oracle¿Í»§¶Ë£º
¡¡¡¡ÕâÒ»²½¾Í²»ÓÃ˵ÁË£¬°²×°Ö±½ÓSetup£¬°²×°¾ÍOKÁË¡£
¡¡¡¡1)°²×°Íêºó£¬ÏÈÅäÖÃÒ»ÏÂNet Configuration Assistant¡£¼ÇסÅäÖõķþÎñÃû¡£
¡¡¡¡ÅäÖóɹ¦»áÏÔʾ£ºÕýÔÚÁ¬½Ó...²âÊԳɹ¦¡£
¡¡¡¡2)ÓÃsqlplusÁ¬½Óһϣ¬¿´ÊÇ·ñ¿ÉÒÔÁ¬½Ó³É¹¦£¬´ò¿ªsqlplusÊäÈëorac ......