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

Çë½Ì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µÄ¼àÌý¡£¼ÈÈ»Èç´Ë£


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ