Oracle½ø³Ì½á¹¹
Oracle½ø³Ì½á¹¹
1. Oracle½ø³Ì¼ò½é
ÿ¸öÁ¬½Óµ½OracleµÄÓû§ÐèÒªÔËÐÐÁ½¸öÄ£¿é²ÅÄÜ·ÃÎÊOracleʵÀý¡£
¡£Ó¦ÓóÌÐò»òOracle¹¤¾ß£ºÊý¾Ý¿âÓû§ÐèÒªÔËÐÐÊý¾Ý¿âÓ¦ÓóÌÐò»òOracle¹¤¾ß£¨ÀýÈçSQL*Plus£©£¬ÏòOracleÊý¾Ý¿â·þÎñÆ÷Ìá½»SQLÓï¾ä¡£
¡£OracleÊý¾Ý¿â·þÎñÆ÷Ä£¿é£ºÎªÓû§Ìṩ·þÎñµÄOracleÊý¾Ý¿â³ÌÐò£¬¸ºÔð½âÊÍÖ´ÐÐÓ¦ÓóÌÐòÌá½»µÄSQLÓï¾ä¡£
1.1 ¶à½ø³ÌOracleϵͳ
ÔÚ¶à½ø³ÌOracleϵͳÖУ¨¶àÓû§Oracleϵͳ£©£¬´æÔÚÊý¸ö½ø³Ì·Ö±ðÔËÐÐOracleϵͳµÄ²»Í¬Ä£¿é£¬ÒÔ¼°ÒÔ¼°Óû§Ê¹ÓõĽø³Ì----ÿ¸öÓû§Ê¹ÓÃÒ»¸ö½ø³Ì»ò¶à¸öÓû§¹²ÏíÒ»¸ö½ø³Ì¡£¾ø´ó¶àÊýÊý¾Ý¿âϵͳ¶¼ÊǶàÓû§µÄ¡£
1.2 ½ø³ÌµÄÖÖÀà
OracleÖи÷ÖÖ½ø³Ì¿ÉÒÔ±»·ÖΪÁ½Àࣺ
¡£Ö´ÐÐÓ¦ÓóÌÐò»òOracle¹¤¾ß´úÂëµÄÓû§½ø³Ì£¨user process£©
¡£Ö´ÐÐOracleÊý¾Ý¿â·þÎñÆ÷´úÂëµÄOracle½ø³Ì£¬ÆäÖаüÀ¨·þÎñ½ø³ÌºÍºǫ́½ø³Ì¡£
OracleΪÁ¬½Óµ½ÏµÍ³µÄÓû§Ìṩ·þÎñµÄÄ£¿é¿ÉÒÔ±»ÅäÖÃΪרÓ÷þÎñÆ÷»ò¹²Ïí·þÎñÆ÷¡£
רÓ÷þÎñÆ÷Ϊÿ¸öÁ¬½Óµ½·þÎñÆ÷µÄÓû§ÔËÐÐÒ»¸ö¶ÀÁ¢µÄÓû§½ø³Ì¡£
¹²Ïí·þÎñÆ÷µÄ·þÎñ½ø³Ì¿ÉÒÔΪ¶à¸öÓû§½ø³ÌÌṩ·þÎñ¡£
2 Óû§½ø³Ì¸ÅÊö
Óû§ÔËÐÐÒ»¸öÓ¦ÓóÌÐò»òOracle¹¤¾ßʱ£¬Oracle½«´´½¨Ò»¸öÓû§½ø³ÌÀ´ÔËÐÐÓû§µÄÓ¦ÓóÌÐò¡£
2.1 Á¬½ÓÓڻỰ
Á¬½ÓÓë»á»°ÊÇÁ½¸ö²»Í¬µÄ¸ÅÄî¡£
Á¬½ÓÊÇÓû§½ø³ÌºÍOracleʵÀý¼äµÄͨÐÅÐŵÀ¡£Õâ¸öͨÐÅÐŵÀÊÇͨ¹ý½ø³Ì¼äµÄͨÐÅ»úÖÆ»òÍøÂçÈí¼þ½¨Á¢µÄ¡£
»á»°ÊÇÓû§Í¨¹ýÓû§½ø³ÌÓëOracleʵÀý½¨Á¢µÄÁ¬½Ó¡£´ÓÓû§¿ªÊ¼Á¬½Óµ½Óû§¶Ï¿ªÁ¬½ÓÆÚ¼ä£¬»á»°Ò»Ö±³ÖÐø¡£
µ±ÏµÍ³Ã»ÓÐÔËÐÐÔÚ¹²Ïí·þÎñģʽÏÂʱ£¬OracleΪÿ¸öÓû§»á»°´´½¨Ò»¸ö·þÎñ½ø³Ì¡£¶øµ±ÏµÍ³ÔËÐÐÔÚ¹²Ïí·þÎñģʽÏÂʱ£¬¶à¸öÓû§»á»°¿ÉÒÔ¹²Ïíͬһ¸ö·þÎñ½ø³Ì¡£
3 Oracle½ø³Ì¸ÅÊö
OracleÓÐÁ½ÖÖÔËÐÐÊý¾Ý¿â·þÎñÆ÷Ä£¿éµÄ½ø³Ì£¨·þÎñ½ø³Ì£¨server process£©ºÍºǫ́½ø³Ì£¨background process£©£©£¬Í¬Ê±¸ú×ÙÎļþ£¨trace file£©¼°¸æ¾¯ÈÕÖ¾£¨alert log£©ÎªOracle½ø³Ì¼Ç¼Êý¾Ý¿âʼþ¡£
3.1 ·þÎñ½ø³Ì
OracleÐèÒª´´½¨·þÎñ½ø³Ì£¨server process£©À´´¦ÀíÁ¬½Óµ½ÊµÀýµÄÓû§½ø³Ì£¨user process£©Ìá½»µÄÇëÇó¡£ÎªÓû§Ó¦ÓóÌÐò´´½¨µÄ·þÎñ¿ÉÒÔÍê³ÉÒÔϹ¤×÷£º
¡£½âÎö¡¢ÔËÐÐÓ¦ÓóÌÐòÌá½»µÄSQLÓï¾ä
¡£Èç¹ûÊý¾ÝÔÚSGAÖв»´æÔÚ£¬Ôò½«ËùÐèµÄÊý¾Ý¿é´Ó´ÅÅÌÉϵÄÊý¾ÝÎļþ¶ÁÈëSGAµÄÊý¾Ý»º³åÇø
¡£ÒÔÓ¦ÓóÌÐòÄÜÀí½âµÄÐÎʽ·µ»ØSQLÓï¾äÖ´Ðнá¹û¡£
3.2 ºǫ́½ø³Ì
ΪÌṩ¶àÓû§ÌØÐÔÇÒ±£Ö¤ÏµÍ³ÐÔÄÜ£¬ÔÚÒ»¸ö¶à½ø³ÌOracleϵͳÖУ¬´æÔÚ¶à¸ö±»³ÆÎªºǫ́½ø³ÌµÄOracle½ø³Ì¡£Ò»¸öOracleʵ
Ïà¹ØÎĵµ£º
WIN7µÄϵͳ½çÃæºÜƯÁÁ£¬Ê¹ÓÃÆðÀ´È·ÊµºÜ²»´í£¬¿ÉÊÇÈ´Ò²¸øÎÒµÄѧϰ´øÀ´¹ý²»ÉÙÂé·³¡£ÓÈÆäÊÇÕâ´Î×°Oracle£¬±ðÈËÓõÄÊÇXPµÄϵͳºÜÈÝÒ×¾Í×°ÉÏÁ˵ģ¬¿ÉÊÇÎÒÈ´ÔõôҲװ²»ÉÏ¡£ÎªÁËÈÃͬÑùϲ°®WIN7µÄÅóÓÑÉÙ×ßЩÍä·£¬ÏÂÃæ¾Í½éÉÜÒ»ÏÂÔÚwin7Éϰ²×°Oracle10gµÄ·½·¨°É£¬ÄÇ¿ÉÊDZ¾ÈËÓÃÁË8Ììʱ¼ä£¬²»Í ......
֮ǰ¸ø´ó¼Ò½éÉÜÁËÔÚWIN7ÉÏOracle 10gµÄ°²×°·½·¨£¬½ÓÏÂÀ´¾Í¸Ã¸ø´ó¼Ò½éÉÜËüµÄÐ¶ÔØ·½·¨ÁË¡£ºÜ¶àÈ˲»¸Ò°²×°Oracle¾ÍÊǵ£Ðݲװºó»áÐ¶ÔØ²»¸É¾»£¬Æäʵµ±³õÎÒÒ²ÓйýÕâ¸ö¹ËÂÇ£¬ºÇºÇ¡£µ«ºóÀ´·¢ÏÖ£¬ÆäÊµÐ¶ÔØÊǺÜÈÝÒ×µÄÊ¡£¾Í¼¸²½¶øÒÑ£¬²»ÐžÍÇë¿´£º
¿ÉÒÔʹÓòúÆ·×Ô´øµÄÐ¶ÔØ¹¤¾ßÈ¥Ð¶ÔØ¡£
1£® ......
---´´½¨±í¿Õ¼ä
create tablespace ±í¿Õ¼äÃû×Ö datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss01.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\wsdata\yss02.dbf' size 4096M;
alter tablespace ±í¿Õ¼äÃû×Ö add datafile 'F:\oracle\product\10.2.0\oradata\w ......
oracle 9i
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
oracle 9i ÔÚÏßÎĵµ
http://download.oracle.com/docs/cd/B10501_01/nav/docindex.htm
oracle 10g/11g ÏÂÔØ
http://www.oracle.com/technology/software/products/database/index.html ......
½¨SEQUENCEÐòÁÐ
CREATE SEQUENCE ÐòÁÐÃû×Ö£¨ÀýÈ磺"URLIMAGE_SEQ"£© MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER NOCYCLE ;
½¨trigger ´¥·¢Æ÷
create or replace trigger ´¥·¢Æ÷Ãû×Ö£¨ÀýÈ磺URLIMAGE_TRI £©
before ins ......