OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡÔñ£¬¼´¿Éµ¼Èë¡£
Ïà¹ØÎĵµ£º
1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......
OracleÊý¾Ý¿âµÄ±¸·Ý·ÖΪһÖÂÐԺͷÇÒ»ÖÂÐÔÁ½ÖÖ¡£
Ò»ÖÂÐÔ±¸·Ý£¬¾ÍÊÇÊý¾Ý¿âÔڹرյÄ״̬Ï»òÕßmount״̬ϽøÐеı¸·Ý¡£ÕâʱºòÓÉÓÚÊý¾Ý¿âûÓдò¿ª£¬Ã»ÓÐÊý¾Ý´¦Àí·¢Éú£¬¿ØÖÆÎļþ¡¢Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÖеÄscn±£³ÖÒ»Ö¡£ËùÒÔ³ÉΪһÖÂÐÔ±¸·Ý¡£
²»Ò»ÖÂÐÔ±¸·Ý£¬¾ÍÊÇÊý¾Ý¿âÔÚopen״̬ϽøÐеı¸·Ý£¬ÕâʱºòÓÉÓÚÊý¾ÝÎļþºÍ¿ØÖÆÎļþÒÔ¼° ......
WIN7µÄϵͳ½çÃæºÜƯÁÁ£¬Ê¹ÓÃÆðÀ´È·ÊµºÜ²»´í£¬¿ÉÊÇÈ´Ò²¸øÎÒµÄѧϰ´øÀ´¹ý²»ÉÙÂé·³¡£ÓÈÆäÊÇÕâ´Î×°Oracle£¬±ðÈËÓõÄÊÇXPµÄϵͳºÜÈÝÒ×¾Í×°ÉÏÁ˵ģ¬¿ÉÊÇÎÒÈ´ÔõôҲװ²»ÉÏ¡£ÎªÁËÈÃͬÑùϲ°®WIN7µÄÅóÓÑÉÙ×ßЩÍä·£¬ÏÂÃæ¾Í½éÉÜÒ»ÏÂÔÚwin7Éϰ²×°Oracle10gµÄ·½·¨°É£¬ÄÇ¿ÉÊDZ¾ÈËÓÃÁË8Ììʱ¼ä£¬²»Í ......
±¸×¢£º
±¾²©ÄÚÈÝÊdzнÓÉÏÆÚÄÚÈݵÄÑÓÐø£¬ÓÉÓÚÄÚÈݹý³¤£¬Òò´Ë²ÉÓ÷ֶÎ˵Ã÷£¬ÒÔÃâ´ó¼Ò¿´ÆðÀ´Æ£¾ë£¬ÈôÁ˽â¸ü¶àÏêϸµÄ°²×°Á÷³Ì£¬Çë¼ÌÐø¹Ø×¢±¾²©¡£²ÎÕÕÔ°æ°²×°ÊÖ²á¶ÔÕÕ°²×°¡£
4£®Configure Oracle Installation Owner Shell Limits
<1>ÅäÖÃlimits.confÎļþ£¬ºìÉ«±êעΪÔö¼ÓµÄÅäÖÃÄÚÈÝ¡£
[root@myli ......
Ôì³ÉORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎóµÄÎÊÌâµÄÔÒòÓÐÈý¸ö£º
1.¼àÌý·þÎñûÓÐÆðÆðÀ´¡£windowsƽ̨¸öÒ»ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å,Æô¶¯oraclehome92TNSlistener·þÎñ¡£
2.database instanceûÓÐÆðÆðÀ´¡£windowsƽ̨ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å£¬Æô¶¯oracleserviceXXXX ......