Çë½Ìoracle¶¯Ì¬¼àÌýµÄÎÊÌ⣡
windows²Ù×÷ϵͳ£¬oracle °æ±¾ 10.2.0.1
Ê×ÏÈÎÒÆô¶¯ÁËÁ½¸ö¼àÌý£ºlsnrctl start list1
lsnrctl start list2
È»ºóÎÒÆô¶¯ÁËʵÁ¦£ºnet start oracleserviceorcl
²é¿´local_listener²ÎÊý£º show parameter local_listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_APP2
È»ºóÎÒÖ´ÐÐÁ˶¯Ì¬×¢²á£º alter system set local_listener=list2£¬±¨´í:
µÚ 1 ÐгöÏÖ´íÎó:
ORA-02097: ÎÞ·¨Ð޸IJÎÊý, ÒòΪָ¶¨µÄÖµÎÞЧ
ORA-00119: ϵͳ²ÎÊý LOCAL_LISTENER µÄ˵Ã÷ÎÞЧ
ORA-00132: Óï·¨´íÎó»òÎÞ·¨½âÎöµÄÍøÂçÃû³Æ 'LIST2'.
ºóÀ´Ñо¿£¬·¢ÏÖÉèÖõIJÎÊý±ØÐëÒªºÍtnsname.ora ÀïµÄÅäÖÃÒ»Ñù£¬²»È»¾Í»á±¨´í¡£ÎªÊ²Ã´°¡£¿£¿£¿£¿£¿
LISTENER_APP2 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = microsof-6dfe7a)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = microsof-6dfe7a)(PORT = 1521))
)
µ«ÊÇÎÒ²»Ã÷°×Õâ¸öLISTENER_APP2ÊÇʲôʱºòÉú³ÉµÄ£¬ÎÒ²¢Ã»ÓÐÅäÖ᣻¹ÓУ¬ÎÒͨ¹ýlsnrctl statusÃüÁî²é¿´£¬²¢Ã»Óз¢ÏÖÃû³ÆÎªLISTENER_APP2µÄ¼àÌý¡£¼ÈÈ»Èç´Ë£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......