OracleÊý¾Ý¿âÍêȫжÔØ
1¡¢ Í£Ö¹oracleËùÓеķþÎñ£¨¿ªÊ¼--ÔËÐÐ--ÊäÈëservices.msc£©
2¡¢ ɾ³ý×¢²á±íÉϵÄORACLEµÄÓйؼüÖµ(¿ªÊ¼-->ÔËÐÐ-->ÊäÈëregedit£©½«HKEY_LOACAL_MACHINE/SOFTWAREϵÄÖ÷¼üORACLEÈ«²¿É¾³ý¡£
3. ÏÂÃæɾ³ýOracle·þÎñ£º½øÈëHKEY_LOACAL_MACHINE/SYSTEMÖ÷¼üÏ£¬ÔÚControlSet001¡¢ControlSet002¡¢CurrentControlSet-->ServiceÖÐɾ³ýÏà¹ØµÄOracle·þÎñ¡££¨Ò²¿ÉÒÔÔÚ×¢²á±íÖÐɾ³ýoracle,orcl,ora´òÍ·µÄ×¢²áÏ¿ÉÄÜÓв¿·Öɾ³ý²»ÁË£¬²»Óùܣ©
4. ɾ³ýOracleÈí¼þËùÔÚµÄĿ¼£¨OracleÈí¼þµÄÓÐЩÅäÖÃÐÅÏ¢´æ´¢ÔÚÕâ¸öĿ¼£¨C:Program Files\Oracle£©£© È»ºóÔÙɾ³ýÈí¼þ°²×°µÄʵ¼ÊĿ¼£¬Èç¹ûɾ³ýÖУ¬³öÏÖ²»ÄÜɾ³ýµÄÎļþ£¬Çë¸øËü¸ÄÃû£¬È»ºóÖØÐÂÆô¶¯²Ù×÷ϵͳ£¬ ÔÙɾ³ýÕâЩÎļþ¡£ÕâÑùÎÒÃǾͳ¹µ×ɾ³ýÁËÓйصÄÎļþ£¬¶ÔÒÔºó°²×°OracleÊý¾Ý¿âûÓÐÈκÎÓ°Ïì¡£ Èç¹ûÄãÓÃOracleµÄжÔسÌÐò£¬Ê×ÏÈ£¬ÓÃdatabase configuration assistant¹¤¾ßɾ³ýËù½¨Á¢µÄÊý¾Ý¿â£¬ÕâÑù¾Íɾ³ýÁËÊý¾Ý¿âµÄÊý¾ÝÎļþ£¬ µ«ÊDz»ÄÜɾ³ýOracle¿ÉÖ´ÐеÄÎļþ¡£Èç¹ûÏëɾ³ýµÄ¸É¸É¾»¾»£¬ÓÃÉÏÃæµÄ·½·¨¡£
Ïà¹ØÎĵµ£º
1. ·ÖÇø±í
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐ ......
רÓ÷þÎñÆ÷£ºÒ»¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì
¹²Ïí·þÎñÆ÷£º¶à¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì£¬·þÎñÆ÷¶Ë´æÔÚÒ»¸ö½ø³Ìµ÷¶ÈÆ÷À´¹ÜÀí¡£
OracleȱʡÓõÄÊÇרÓ÷þÎñÆ÷ģʽ£¬Oracle¿ÉÒÔͬʱ֧³Ö¹²Ïí·þÎñÆ÷ºÍרÓ÷þÎñÆ÷ģʽ£¬¿ÉÒÔÖ¸¶¨Ò»¸ö»á»°Ê¹ÓÃרÓ÷þÎñÆ÷£¬ÁíÒ»¸ö»á»°Ê¹Óù²Ïí·þÎñÆ÷¡£
¹²Ïí·þÎñÆ÷¾ßÓÐÒÔÏÂһЩȱµã£º
1)¹² ......
1. ´´½¨ÆÕͨÓû§
>create user username identified by username;
>grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
>create temporary tablespace DB_TEMP
tempfile '/opt/oracle/oradata/mydb/t ......
1. ½«Êý¾Ý¿âÍêÈ«µ¼³ö
Óû§Ãûsystem ÃÜÂësystem µ¼³öµ½OracleÓû§Ä¿Â¼ÏµÄtestdb20100522.dmpÎļþÖÐ
#exp system/system@testdb file=testdb20100522.dmp full=y
2. ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
#exp system/system@testdb file= testdb20100522.d ......
Ò»¡¢ Hibernate½éÉÜ
HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØϵӳÉ䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØϵÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateÄ¿Ç°ÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......