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

Oracle¡¡ORA 12541:TNS:no listener´íÎó½â¾ö·½·¨

ǰÌì×°ºÃµÄ£Ï£ò£á£ã£ì£å£¬×òÌìͻȻ²»ºÃÓÃÁË£¬´ÓOracleµÄ´íÎóÌáʾÀ´¿´,ÊÇ˵TNS:no listener £¬¹À¼ÆÊÇijÖÖ·þÎñûÓÐÆô¶¯£¬´ò¿ªwindows¹ÜÀí¹¤¾ß->·þÎñ£¬Ò»¿´£¬ÓÐÒ»¸öOracleOraHome90TNSListenerÕâÑùµÄ·þÎñ£¬ºÍ´íÎóÐÅÏ¢ÌâÊÇÒ»Ö£¬»ù±¾¾Í¿ÉÒԿ϶¨ÊÇÕâ¸ö·þÎñËùÒý·¢µÄÎÊÌâ¡£ÔÙÒ»¿´£¬¸Ã·þÎñûÓÐÆô¶¯£¬ËìÊÖ¹¤Æô¶¯£¬Ë¢ÐºóÒ»¿´£¬¸Ã·þÎñ¾ÓÈ»ÂíÉϾÍ×Ô¶¯¹Ø±ÕÁË¡£ÖØÊÔN´Î£¬½á¹ûÒ»Ñù¡£µ½GoogleËÑË÷¿´¿´£¬Ã»Ïëµ½Õ⻹ÊÇÒ»¸öÆÕ±éµÄÎÊÌ⣬ÓÐÒ»¸öÈËÌá³ö£¬°Ñ°²×°Ä¿Â¼ÏµÄlistener.ora´ò¿ª²ì¿´¡£È磺d:\oracle\ora90\network\admin\listener.ora¡£
´ò¿ª¸ÃÅäÖÃÎļþºó·¢ÏÖÈçÏÂÒ»¶ÎÅäÖÃÐÅÏ¢£º
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = IBMThinkPad)(PORT = 1521))
      )
    )
  )
 
    µ±¿´µ½ÕâÒ»ÐÐHOST=IBMThinkPadµÄʱºò£¬ÎÊÌâ½â¾öÁË¡£Ô­À´ÊÇÓÉÓÚ¼¸Ìì×°ºÃOracleºó£¬ÓÖ¸ÄÁËWindowsµÄ¼ÆËã»úÃû£¬¶øÕâ¸öÅäÖÃÎļþÖмǼµÄ¼àÌýÖ÷»úÃû»¹ÊÇÔ­À´µÄÃû³Æ£¬ÕâÒ²¾Í¹Ö²»µÃ£¬OracleOraHome90TNSListener·þÎñÎÞ·¨Æô¶¯ÁË£¬ÂíÉÏÐÞ¸ÄΪÏÖÔڵļÆËã»úÃû£¬ÔÙ´ÎÆô¶¯OracleOraHome90TNSListener·þÎñ³É¹¦£¬PL/SQL DeveloperÁ¬½ÓOracleÊý¾Ý¿â³É¹¦£¬²»Äܵǽ¹ÊÕÏÅųý¡£


Ïà¹ØÎĵµ£º

Oracle 10G Êý¾Ý±Ãѧϰ¼ÍÒª£¨expdp/impdp£©

ʵÀý£º
    1¡¢Í¨¹ýDBLINKµÄ·½Ê½£º±í¿Õ¼ä²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG network_link=to_crm_7 schemas=MCMDB  REMAP_TABLESPACE=table_space11:table_space12,table_space21:table_space22
    2¡¢Í¨¹ýDBLINKµÄ·½Ê½£º·½°¸£¨schemas£©²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG net ......

ORACLE+SQLÐÔÄÜÓÅ»¯ÏµÁÐ

ORACLE SQLÐÔÄÜÓÅ»¯ÏµÁÐ
 
1. ·ÃÎÊTableµÄ·½Ê½
ORACLE ²ÉÓÃÁ½ÖÖ·ÃÎʱíÖмǼµÄ·½Ê½:
a. È«±íɨÃè
È«±íɨÃè¾ÍÊÇ˳ÐòµØ·ÃÎʱíÖÐÿÌõ¼Ç¼. ORACLE²ÉÓÃÒ»´Î¶ÁÈë¶à¸öÊý¾Ý¿é(database block)µÄ·½Ê½ÓÅ»¯È«±íɨÃè.
b. ͨ¹ýROWID·ÃÎʱí
Äã¿ÉÒÔ²ÉÓûùÓÚROWIDµÄ·ÃÎÊ·½Ê½Çé¿ö,Ìá¸ß·ÃÎʱíµÄЧÂÊ, , ROWID°üº¬Á˱íÖмǼµ ......

Oracle 9i LogMiner¹¤¾ßʹÓÃ˵Ã÷

Ô­ÎĵØÖ·£ºhttp://oracle.chinaitlab.com/induction/725752.html
Ò»¡¢logminerµÄÓÃ;
¡¡¡¡ÈÕÖ¾ÎļþÖдæ·Å×ÅËùÓнøÐÐÊý¾Ý¿â»Ö¸´µÄÊý¾Ý£¬¼Ç¼ÁËÕë¶ÔÊý¾Ý¿â½á¹¹µÄÿһ¸ö±ä»¯£¬Ò²¾ÍÊǶÔÊý¾Ý¿â²Ù×÷µÄËùÓÐDMLÓï¾ä¡£
¡¡¡¡logminer ¹¤¾ß¼´¿ÉÒÔÓÃÀ´·ÖÎöÔÚÏߣ¬Ò²¿ÉÒÔÓÃÀ´·ÖÎöÀëÏßÈÕÖ¾Îļþ£¬¼´¿ÉÒÔ·ÖÎö±¾Éí×Ô¼ºÊý¾Ý¿âµÄÖØ×÷ÈÕÖ¾ÎÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ