Oracle³£¼û´íÎó——TNS 01150
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.26)(PORT = 1521)
)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ora92)
(ORACLE_HOME = /opt/oracle/product/9.2)
)
)
LOGGING_LISTENER = OFF
ÎÒ²¹³äÕûÀíһϣ¬listener.oraÀï´´½¨µÄÿ¸ölistener¶ÔÓ¦2¸ö²¿·Ö£¬·Ö±ðÊÇ£º
NAME=
ºÍ
SID_LIST_NAME=
Á½¸ö²¿·ÖÃû³Æname±ØÐëÒ»Ö£¬LZ¹À¼ÆÊÇÊÖ¹¤ÐÞ¸ÄÁËÃû³Æ¡£
Ïà¹ØÎĵµ£º
¡¡¡¡
¡¡¡¡±¾Êé×÷Ϊһ±¾´´×÷Ö®³õ¾Í¶¨Î»ÓÚ¼¼ÊõÓ¦ÓõÄʵ¼ù²Î¿¼Ê飬ËäȻǰǰºóºó´®ÁªÁËOracleÊý¾Ý¿âÖÐÊ®Óà¸ö³£ÓÃÌØÐÔ»ò¹¤¾ß£¬µ«ÔÚÕ½ڵÄÉè¼ÆÉÏÍêÈ«×ñÑÕâÒ»ÀíÄî¡£ÔÚÉæ¼°ÌØÐÔ»ò¹¤¾ßÓ¦ÓõÄÿһ¸öÕ½ڣ¬¾ùÓÐÏà¹ØÊµÀýÑÝʾÈçºÎÓ¦Óã¬ËùÓÐʾÀýµÄ×îÖÕÄ¿µÄ£¬¾ÍÊÇÏ£ÍûÔĶÁ±¾ÊéµÄÅóÓÑ£¬Äܹ»½«Ë«ÊÖ½â·Å³öÀ´£¬×ÔÐÅÁé»îµØÊ¹ÓÃÊéÖнéÉܵĸ÷Ï ......
OracleÊý¾Ý¿â³öÏÖ»µ¿éÏÖÏóÊÇÖ¸£ºÔÚOracleÊý¾Ý¿âµÄÒ»¸ö»ò¶à¸öÊý¾Ý¿é£¨Ò»¸öÊý¾Ý¿éµÄÈÝÁ¿ÔÚ´´½¨Êý¾Ý¿âʱÓÉdb_block_size²ÎÊýÖ¸¶¨£¬È±Ê¡Îª8K£©ÄÚ³öÏÖÄÚÈÝ»ìÂÒµÄÏÖÏó¡£ÓÉÓÚÕý³£µÄÊý¾Ý¿é¶¼Óй̶¨µÄºÏ·¨ÄÚÈݸñʽ£¬»µ¿éµÄ³öÏÖ£¬µ¼ÖÂÊý¾Ý¿â½ø³ÌÎÞ·¨Õý³£½âÎöÊý¾Ý¿éµÄÄÚÈÝ£¬½ø¶øÊ¹Êý¾Ý¿â½ø³Ì±¨´íÄËÖÁ¹ÒÆð£¬²¢¼¶Áªµ¼ÖÂÕû¸öÊý¾Ý¿âʵÀý³ ......
ÒÔÏ»شðÊôÓÚ×ªÔØ£º
¾³£¿´µ½Ò»Ð©ÅóÓÑÎÊORACLE×Ö·û¼¯·½ÃæµÄÎÊÌ⣬ÎÒÏëÒÔµü´úµÄ·½Ê½À´½éÉÜһϡ£
µÚÒ»´Îµü´ú£ºÕÆÎÕ×Ö·û¼¯·½ÃæµÄ»ù±¾¸ÅÄî¡£
ÓÐЩÅóÓÑ¿ÉÄÜ»áÈÏΪÕâÊǶà´ËÒ»¾Ù£¬µ«Êµ¼ÊÉÏÕýÊÇÓÉÓÚ¶ÔÏà¹Ø»ù±¾¸ÅÄî°ÑÎÕ²»Ç壬²Åµ¼ÖÂÁËÖî¶àÎÊÌâºÍÒÉÎÊ¡£
Ê×ÏÈÊÇ×Ö·û¼¯µÄ¸ÅÄî¡£
ÎÒÃÇÖªµÀ£¬µç×Ó¼ÆËã»ú×î³õÊÇÓÃÀ´½øÐпÆÑ§¼ÆËãµÄ£¨Ë ......
net use \\ip\ipc$ " " /user:" " ½¨Á¢IPC¿ÕÁ´½Ó
net use \\ip\ipc$ "ÃÜÂë" /user:"Óû§Ãû" ½¨Á¢IPC·Ç¿ÕÁ´½Ó
net use h: \\ip\c$ "ÃÜÂë" /user:"Óû§Ãû" Ö±½ÓµÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØÎªH:
net use h: \\ip\c$ µÇ½ºóÓ³Éä¶Ô·½C£ºµ½±¾µØÎªH:
net use \\ip\ipc$ /del ɾ³ýIPCÁ´½Ó
net use h: /del ɾ³ýÓ³Éä¶Ô·½µ½±¾µ ......
ǰÑÔ
ÿһ¸öDBAÔÚ½øÐÐÊý¾Ý¿â¹ÜÀíµÄ¹ý³ÌÖв»¿É±ÜÃâµÄÒªÓöµ½ÐÎÐÎɫɫµÄ´íÎó(ORA-1547 ,ORA-904,ORA-1578 ......)¡£ÓÐЩ´íÎóÓÉÓÚÆµ·±³öÏÖ¡¢ÔÒò¸´ÔÓ¶ø±» Oracle DBA ÃÇÏ·³ÆÖ®Îª"¾µäµÄ´íÎó"¡£ÆäÖÐORA-3113 "end of file on communication channel" ¾ÍÊÇÕâÑùµÄÒ»¸ö¡£
ÎÒÃÇ¿ÉÒÔ¼òµ¥µÄ°ÑÕâ¸ö´íÎóÀí½âΪOracle¿Í»§¶Ë½ø³ÌºÍÊý¾Ý¿ ......