oracle impÃüÁîÐеÄʹÓÃ
ÒÔǰ¾³£Ê¹ÓÃoracleµÄ¿Í»§¶Ë¹¤¾ßtoadÀ´½øÐÐÊý¾Ý¿âµÄµ¼ÈëºÍµ¼³ö£¬Æäʵ¸öÈ˵¹²»Ï²»¶ÓÃÕâ¸ö¿Í»§¶Ë¹¤¾ß£¬¸Ð¾õ¹¦ÄܺÜÇ¿´óµÄÒ»¸ö¹¤¾ß£¬dbaÊÊÓ᣿ª·¢»¹ÊÇÓÃpl/sql±È½ÏºÃ£¬¼ò½àµÄ½çÃæ¡£
C:\Users\Administrator>imp nwgis/pass file=e:/nwgis20100529.DMP log=dible_db full=y ignore=y
Æô¶¯ÃüÁîÐУ¬ÐÞ¸ÄÏÂÏà¹ØµÄ²ÎÊý£¬¼´¿ÉÒÔ°´ÕÕÓû§À´½øÐÐÕû¸Ä¿âµÄµ¼È빤×÷¡£
¼òµ¥µÄ½éÉÜÏ£¬ÒªÉîÈëÁ˽⣬»¹µÃ¶ÁÕß×êÑС£
ÕâÀï¸ø×Ô¼º¼Ç¸ö±Ê¼Ç¡£
Ïà¹ØÎĵµ£º
TkprofÊÇÒ»¸öÓÃÓÚ·ÖÎöOracle¸ú×ÙÎļþ²¢ÇÒ²úÉúÒ»¸ö¸ü¼ÓÇåÎúºÏÀíµÄÊä³ö½á¹ûµÄ¿ÉÖ´Ðй¤¾ß¡£Èç¹ûÒ»¸öϵͳµÄÖ´ÐÐЧÂʱȽϵͣ¬Ò»¸ö±È½ÏºÃµÄ·½·¨ÊÇͨ¹ý¸ú×ÙÓû§µÄ»á»°²¢ÇÒʹÓÃTkprof¹¤¾ßʹÓÃÅÅÐò¹¦Äܸñʽ»¯Êä³ö£¬´Ó¶øÕÒ³öÓÐÎÊÌâµÄSQLÓï¾ä¡£
Ò». TKPROF ÃüÁîÓï·¨£º
TKPROF filename1, filename2  ......
1£®top
topÃüÁî¿ÉʵʱµØÏÔʾLinuxϵͳµÄ½ø³Ì¡¢CPU¡¢ÄÚ´æ¡¢¸ºÔصȵÄÐÅÏ¢¡£ËüÊÇÎÒÃÇÁ˽âϵͳÕûÌå״̬×îºÃµÄ¹¤¾ß¡£
topÃüÁîµÄÔËÐÐ״̬ÊÇÒ»¸öʵʱµÄÏÔʾ¹ý³Ì£¬ÎÒÃÇ¿ÉÔÚÕâ¸ö½çÃæ¼à¿ØÏµÍ³ÔËÐÐÇé¿ö¡£ÎÒÃÇ¿Éͨ¹ý¼¸¸ö°´¼üÀ´¿ØÖÆtopÃüÁÈç°´q¿ÉÍ˳ötopÃüÁî״̬£¬°´s¿ÉÊäÈëÐÅÏ¢µÄ¸üÐÂÆµÂʵȡ£ÕâЩÃüÁî¿É°´h°ïÖú¼ü²éѯ¡£
2£®Ps ......
Ò»£º»Ø¹ö¶Î¸ÅÊö
¡¡¡¡»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐÅÏ¢¡£Ò»¸öÊÂÎñÖ»ÄÜʹÓÃÒ»¸ö»Ø¹ö¶ÎÀ´´æ·ÅËüµÄ»Ø¹öÐÅÏ¢£¬¶øÒ»¸ö»Ø¹ö¶Î¿ÉÒÔ´æ·Å¶à¸öÊÂÎñµÄ»Ø¹öÐÅÏ¢¡£
»Ø¹ö¶ÎµÄ×÷ÓÃ
¡¡¡¡ÊÂÎñ»Ø¹ö£ºµ±ÊÂÎñÐ޸ıíÖÐÊý¾ÝµÄʱºò£¬¸ÃÊý¾ÝÐÞ¸ÄǰµÄÖµ£¨¼´Ç°Ó°Ïñ£ ......
°²×°…………
ÒýÓõÄhttp://mamaoyuan625.javaeye.com/blog/617502
°²×°oracle 10gºó£¬µÇ¼ ³öÏÖ
the account is locked
Õâ¸ö´íÎ󼸺õËùÓеijõѧÕß¶¼»áÓöµ½.
Æäʵ½â¾ö°ì·¨·Ç³£¼òµ¥.
ÇëÊäÈëÓû§Ãû: SYSTEM
ÊäÈë¿ÚÁî:admin(×¢Òâ,Õâ¸öÃÜÂëÊÇÄãÔÚ°²×°oracleʱµÚÒ»²½ÉèÖõÄ)
È»ºóϵͳ»áÏÔ ......
·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link --Á´½ÓÃû
connect to Óû§Ãû identified by ÃÜÂë
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......