Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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¿ÉÖ´ÐеÄÎļþ¡£Èç¹ûÏëɾ³ýµÄ¸É¸É¾»¾»£¬ÓÃÉÏÃæµÄ·½·¨¡£


Ïà¹ØÎĵµ£º

oracle¿ª·¢ÖªÊ¶µã

1. ·ÖÇø±í
   
Oracle
½¨ÒéÈç¹ûµ¥¸ö±í³¬¹ý2G¾Í×îºÃ¶ÔÆä½øÐзÖÇø¡£
¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£»
    1)
Range·ÖÇø
¡¡¡¡Range·ÖÇøÄØÊÇÓ¦Ó÷¶Î§±È½Ï¹ãµÄ±í·ÖÇø·½Ê½£¬ËüÊÇÒÔÁеÄÖµµÄ·¶Î§À´×öΪ·ÖÇøµÄ»®·ÖÌõ¼þ£¬½«¼Ç¼´æ·Åµ½ÁÐ ......

Oracle רÓ÷þÎñÆ÷Óë¹²Ïí·þÎñÆ÷µÄÇø±ð

רÓ÷þÎñÆ÷£ºÒ»¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì
¹²Ïí·þÎñÆ÷£º¶à¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì£¬·þÎñÆ÷¶Ë´æÔÚÒ»¸ö½ø³Ìµ÷¶ÈÆ÷À´¹ÜÀí¡£
OracleȱʡÓõÄÊÇרÓ÷þÎñÆ÷ģʽ£¬Oracle¿ÉÒÔͬʱ֧³Ö¹²Ïí·þÎñÆ÷ºÍרÓ÷þÎñÆ÷ģʽ£¬¿ÉÒÔÖ¸¶¨Ò»¸ö»á»°Ê¹ÓÃרÓ÷þÎñÆ÷£¬ÁíÒ»¸ö»á»°Ê¹Óù²Ïí·þÎñÆ÷¡£
¹²Ïí·þÎñÆ÷¾ßÓÐÒÔÏÂһЩȱµã£º
1)¹² ......

´´½¨ºÍɾ³ýOracleÊý¾Ý¿âÓû§¡¢±í¿Õ¼ä

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 ......

OracleÊý¾Ý¿â±¸·Ýµ¼Èëµ¼³ö

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Á¬½ÓoracleÊý¾Ý¿âÀý×Ó£¡

Ò»¡¢ Hibernate½éÉÜ
    HibernateÊÇ»ùÓÚ¶ÔÏó/¹ØϵӳÉ䣨ORM£¬Object/Relational Mapping£©µÄÒ»¸ö½â¾ö·½°¸¡£ORM·½°¸µÄ˼ÏëÊǽ«¶ÔÏóÄ£ÐͱíʾµÄ¶ÔÏóÓ³Éäµ½¹ØϵÐÍÊý¾Ý¿âÖУ¬»òÕß·´Ö®¡£HibernateÄ¿Ç°ÊÇORM˼ÏëÔÚJavaÖÐ×î³É¹¦¡¢×îÇ¿´óµÄʵÏÖ¡£ËüÓÚ2001ÄêµÄÄêÄ©·¢²¼µÚÒ»¸ö°æ±¾£¬Á¢¼´ÒýÆðÁ˹㷺µÄ×¢Òâ¡£2003Äê6Ô£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ