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

OracleÊý¾Ý¿â·þÎñÆô¶¯Óë¹Ø±Õ

¿ªÆô£º
net start oracledbconsoleorcl
net start oracleOraDb10g_home1iSQL*Plus
net start oracleOraDb10g_home1TNSListener
net start oracleServiceORCL
net start oraclejobschedulerorcl //¿ÉÒÔ½ûÓÃ
¹Ø±Õ£º
net stop oracledbconsoleorcl
net stop oracleOraDb10g_home1iSQL*Plus
net stop oracleOraDb10g_home1TNSListener
net stop oracleServiceORCL
net stop oraclejobschedulerorcl//¿ÉÒÔ½ûÓÃ
¶ÔÓ¦·þÎñÀïÃæµÄÃû³Æ services.msc


Ïà¹ØÎĵµ£º

Oracle»ØÊÕÕ¾£¬ora 38301´íÎó

ora-38301´íÎó,»ØÊÕÕ¾
Ç°¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎó¡£Æð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......

ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä


ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐÐ ......

ORACLEµ¼Èëµ¼³öÃüÁî½âÎö

±¾ÎĶÔOracleÊý¾ÝµÄµ¼Èëµ¼³ö imp ,exp Á½¸öÃüÁî½øÐÐÁ˽éÉÜ, ²¢¶ÔÆäÏàÓ¦µÄ²ÎÊý½øÐÐÁË˵Ã÷,È»ºóͨ¹ýһЩʾÀý½øÐÐÑÝÁ·,¼ÓÉîÀí½â.
ÎÄÕÂ×îºó¶ÔÔËÓÃÕâÁ½¸öÃüÁî¿ÉÄܳöÏÖµÄÎÊÌâ(ÈçȨÏÞ²»¹»,²»Í¬oracle°æ±¾)½øÐÐÁË̽ÌÖ,²¢Ìá³öÁËÏàÓ¦µÄ½â¾ö·½°¸;
±¾ÎIJ¿·ÖÄÚÈÝժ¼×ÔÍøÂç,¸ÐлÍøÓѵľ­Ñé×ܽá;
Ò».˵Ã÷
   oracle µÄexp/i ......

ÔÚWindows 7Ï°²×°Oracle ½â¾ö·½·¨

Ê×ÏÈÕÒµ½Â·¾¶£º
E:\Oracle Enterprise_Standard Edition_11.1.0.7\database\stage\prereq\db\refhost.xml
ÈçϽڵ㣺
  <!--Microsoft Windows Vista-->
     <OPERATING_SYSTEM>
      <VERSION VALUE="6.0"/>
    </OPERAT ......

Oracle·ÖÇø¼¼Êõ

ORACLEµÄ·ÖÇø(Partitioning Option)ÊÇÒ»ÖÖ´¦Àí³¬´óÐͱíµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩÁË¿ÉÉìËõµÄÐÔÄÜ¡£·ÖÇøͨ¹ý½«²Ù×÷·ÖÅä¸ø¸üСµÄ´æ´¢µ¥Ôª£¬¼õÉÙÁËÐèÒª½øÐйÜÀí²Ù×÷µÄʱ¼ä£¬²¢Í¨¹ýÔöÇ¿µÄ²¢Ðд ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ