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
Ïà¹ØÎĵµ£º
ora-38301´íÎó,»ØÊÕÕ¾
Ç°¼¸ÌìÓÐͬʸæËßÎÒ£¬ÓÐ̨·þÎñÆ÷Éϵıí¿Õ¼äÎÞ·¨É¾³ý£¬ÈÃÎÒ¿´¿´¡£µÇ¼µ½·þÎñÆ÷£¬É¾³ý±í¿Õ¼ä£¬Êý¾Ý¿âͬʱ±¨ora-00604ºÍora-38301´íÎó¡£Æð³õÒÔΪÊÇÓÐÊý¾Ý¿â¶ÔÏó±»Ëø¶¨£¬ÖØÆôÊý¾Ý¿âºó£¬·¢ÏÖ»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£Googleºó·¢ÏÖ¿ÉÄÜÓë10gµÄÒ»¸öÐÂÌØÐÔ»ØÊÕÕ¾Óйأ¬Çå¿Õ»ØÊÕÕ¾purge recyclebinºó£¬½øÐÐɾ³ý»¹ÊDZ ......
ÈçºÎÐÞ¸Ä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Êý¾ÝµÄµ¼Èëµ¼³ö imp ,exp Á½¸öÃüÁî½øÐÐÁ˽éÉÜ, ²¢¶ÔÆäÏàÓ¦µÄ²ÎÊý½øÐÐÁË˵Ã÷,È»ºóͨ¹ýһЩʾÀý½øÐÐÑÝÁ·,¼ÓÉîÀí½â.
ÎÄÕÂ×îºó¶ÔÔËÓÃÕâÁ½¸öÃüÁî¿ÉÄܳöÏÖµÄÎÊÌâ(ÈçȨÏÞ²»¹»,²»Í¬oracle°æ±¾)½øÐÐÁË̽ÌÖ,²¢Ìá³öÁËÏàÓ¦µÄ½â¾ö·½°¸;
±¾ÎIJ¿·ÖÄÚÈÝժ¼×ÔÍøÂç,¸ÐлÍøÓѵľÑé×ܽá;
Ò».˵Ã÷
oracle µÄexp/i ......
Ê×ÏÈÕÒµ½Â·¾¶£º
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µÄ·ÖÇø(Partitioning Option)ÊÇÒ»ÖÖ´¦Àí³¬´óÐͱíµÄ¼¼Êõ¡£·ÖÇøÊÇÒ»ÖÖ“·Ö¶øÖÎÖ®”µÄ¼¼Êõ£¬Í¨¹ý½«´ó±íºÍË÷Òý·Ö³É¿ÉÒÔ¹ÜÀíµÄС¿é£¬´Ó¶ø±ÜÃâÁ˶Ôÿ¸ö±í×÷Ϊһ¸ö´óµÄ¡¢µ¥¶ÀµÄ¶ÔÏó½øÐйÜÀí£¬Îª´óÁ¿Êý¾ÝÌṩÁË¿ÉÉìËõµÄÐÔÄÜ¡£·ÖÇøͨ¹ý½«²Ù×÷·ÖÅä¸ø¸üСµÄ´æ´¢µ¥Ôª£¬¼õÉÙÁËÐèÒª½øÐйÜÀí²Ù×÷µÄʱ¼ä£¬²¢Í¨¹ýÔöÇ¿µÄ²¢Ðд ......