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Êý¾Ý¿â³É¹¦£¬²»Äܵǽ¹ÊÕÏÅųý¡£
Ïà¹ØÎĵµ£º
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¡¡¡¡¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ¼ÆËã»úÒÔÆäÇ¿´óµÄËٶȴ¦ÀíÄÜÁ¦£¬È¡´úÁ˺ܶàÈËΪµÄ¹¤×÷£¬µ«ÊÇ£¬ÍùÍùºÜ¶àʱºò£¬ËüÓÖÊÇÄÇôÈõ²»½û·ç£¬Ö÷°åÉϵÄоƬ¡¢Ö÷°åµç·¡¢ÄÚ´æ¡¢µçÔ´µÈÈκÎÒ»Ïî²»ÄÜÕý³£¹¤×÷£¬¶¼»áµ¼Ö¼ÆËã»úϵͳ²»ÄÜÕý³£¹¤×÷¡£µ±È»£¬ÕâЩË𻵿ÉÒÔÐÞ¸´£¬²»»áµ¼ÖÂÓ¦Óú ......
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹Øϵ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹Øϵ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµ ......
µÚ1Ò³
1. Oracle µÄʹÓÃ
1.1. SQLPLUS µÄÃüÁî
³õʼ»¯±íµÄλÖãº
set
NLS_LANG=american_america.us7ascii (ÉèÖñàÂë²Å¿ÉÒÔʹÓÃÏÂÃæ½Å±¾)
cd
$ORACLE_HOME/rdbms cd demo summit2.sql
********* ......
OS :RHEL AS 4 oracle 10g
0±¸·Ý½Å±¾
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/ora ......