Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Æô¶¯·þÎñÏê½âÒÔ¼°ÊÖ¶¯¿ØÖÆ

OracleÆô¶¯Ê±ÐèÒªµÄ·þÎñ£º
Ô­ÌûµØÖ·£ºhttp://www.blogjava.net/sidanzhou/archive/2008/03/03/183507.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ ......

Oracle DB Link


Êý¾Ý¿âÖ®¼äµÄÁ´½Ó½¨Á¢ÔÚDATABASE LINKÉÏ¡£Òª´´½¨Ò»¸öDB LINK£¬±ØÐëÏÈÔÚÿ¸öÊý¾Ý¿â·þÎñÆ÷ÉÏÉèÖÃÁ´½Ó×Ö·û´®¡£
  
1¡¢ ÅäÖÃTNS £¬ $ORACLE_HOME/NETWORK/ADMIN/tnsname.ora
10gstandby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = HFCC-KF-3068)(PORT = ......

linux¹ØÓÚ$ORACLE_HOME/root.shºÍ/etc/oratab

1.°²×°Ê±ÒªÖ´ÐÐÁ½¸ö½Å±¾£¬root.shÊÇÆäÖÐÒ»¸ö¡£
   ÐèÒªÓÃrootÓû§Ö´ÐÐroot.shÈ¥Éú³É/etc/oratabÎļþ¡£————1.dbcaÖв»»áÓÐɾ³ýÑ¡Ïî(ÒòΪÔËÐÐʱÐèÒª/etc/oratab)
                   & ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ