|
·ÖÀർº½ |
 |
|
|
|
Ì콡ҽԺÐÅϢϵͳ³£¼ûÎÊÌâ½â´ð |
|
×ÊÔ´´óС£º59.14 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
Ò½ÔºÐÅϢϵͳ³£¼ûÎÊÌâ½â´ð
ÔðÈα༠Íõ ½ º« ÐÛ
Ö÷ ±à ³Ì ·å
¸± Ö÷ ±à º« ÐÛ ÁõÃô³¬ ÕÅ öÎ ½¯ ÑÞ
Éó ¸å ÁõÃô³¬ Íô½¨»ª
·âÃæÉè¼Æ Àî³½Ü
±±¾©Ì콡ºã´ï¿Æ¼¼ÓÐÏÞ¹«Ë¾
ǰ ÑÔ 3
Ò»¡¢ ¹«¹²¹ÜÀí 4
£¨Ò»£©ÏµÍ³¹ÜÀí 4
£¨¶þ£©ÏµÍ³³õʼ»¯ 5
£¨Èý£©´Ê¿â 6
¶þ¡¢ ÃÅÕï¹ÜÀí 7
£¨Ò»£©ÃÅÕï¹ÒºÅ 7
£¨¶þ£©ÃÅÕïÊÕ·Ñ 8
Èý¡¢ Èý¡¢×¡Ôº¹ÜÀí 9
£¨Ò»£©×¡ÔºµÇ¼Ç 9
£¨¶þ£©×¡ÔºÊÕ·Ñ 10
£¨Èý£©Ò½Éú¹¤×÷Õ¾ 12
£¨ËÄ£©»¤Àí¹¤×÷Õ¾ 14
£¨Î壩ҽ¼¼¹¤×÷Õ¾ 18
ËÄ¡¢ ËÄ¡¢Îï×ʹÜÀí 18
£¨Ò»£©ÃÅÕïÒ©·¿ 18
£¨¶þ£©ÖÐÒ©·¿ 19
£¨Èý£©ÖÐÐÄÒ©·¿ 20
£¨ËÄ£©²¡·¿Ð¡Ò©¹ñ 22
£¨Î壩ҩ¿â 22
£¨Áù£©Ò½ÁÆÉ豸 24
Îå¡¢ Îå¡¢¾¼Ã¹ÜÀí 25
£¨Ò»£©³É±¾ºËËã 25
£¨¶þ£©ºǫ́»®¼Û 26
Áù¡¢ Áù¡¢²¡°¸¹ÜÀí 29
¸½±íÒ»£ºÒ½Ôº¸÷²¿ÃÅʹÓÃϵͳһÀÀ±í 30
¸½±í¶þ£º¸÷ϵͳ½ÇÉ«¼°È¨ÏÞÒ»ÀÀ±í 32
¸½±íÈý£ºÏµÍ³Ê¹ÓÃÒ»°ãÁ÷³Ì 36
¸½±íËÄ£ºÏµÍ³³õʼ»¯±í 36
ǰ ÑÔ
¸ß¼¶°æÊǾü¶ÓÒ½ÔºÐÅÏ¢»¯½¨ÉèºÍ·¢Õ¹µÄ»ù´¡¹¤³Ì£¬Ò²ÊÇÒ»Ïî±È½Ï¸´ÔÓ¡¢·±Öغͼ¼ÊõÐÔºÜÇ¿µÄ¹¤³ÌÈÎÎñ¡£±ÊÕß½«ÎÒÔºÔÚϵͳÉýǨ¹ý³ÌÖÐÓöµ½µÄһЩ³£¼ûÎÊÌâºÍ½â¾öÎÊÌâµÄ·½·¨£¬ÒÔÎÊ´ðµÄ·½Ê½ÕûÀí²¢»ã±à³ÉÕⱾСÊֲᡣ
¸ÃÊÖ²á´Óϵͳ¹ÜÀí¡¢ÃÅÕï¹ÜÀí¡¢×¡Ôº¹ÜÀí¡¢Îï×ʹÜÀí¡¢²¡°¸¹ÜÀí¡¢¾¼Ã¹ÜÀíÁù²¿·ÖÄÚÈݼÓÒÔÐðÊö¡£ÆäÖÐÓÐϵͳµ÷ÊÔÖеÄÎÊÌ⣬Óгõʼ»¯½×¶ÎµÄÎÊÌ⣬»¹ÓÐÔÚʹÓùý³ÌÖеÄÎÊÌâµÈ¡£µ¼ÖÂÕâЩÎÊÌâµÄ³öÏÖ£¬ÓеÄÊÇÒòΪϵͳûÓа²×°ºÃ£¬ÓеÄÊÇÒòΪ³õʼ»¯²»µ½Î»£¬ÓеÄÊÇÓû§Ê¹Óò»¹æ·¶£¬ÓеÄÊǹÜÀí´ëÊ©²»µ½Î»µÈµÈ¶à·½ÃæÒòËØÔì³ÉµÄ¡£ÔÚ´Ë£¬ÎÒÃǽ«ÕâЩÎÊÌâ»ã¼¯µ½Ò»Æð²¢Ìá³ö½â¾öµÄ²Î¿¼Òâ¼û£¬Õæ³ÏµØÌṩ¸ø¼´½«Ê¹Óø߼¶°æµÄÐֵܵ¥Î»£¬Ï£ÍûÄܶÔÄãÃÇÓÐËù°ïÖú¡£ÔÚÎÊÌâµÄ½â¾ö¹ý³ÌÖУ¬ÎÒÃǵõ½×ܺóÐÅÏ¢Ö§³ÖÖÐÐÄÍô½¨»ª¡¢½â·Å¾ü301Ò½ÔºÁõÃô³¬µÈͬ־µÄ°ïÖúÓëÖ§³Ö£¬Ôڴ˱íʾÖÔÐĵĸÐл¡£
ÓÉÓÚÎÒԺʹÓÃʱ¼ä²»³¤£¬±àдʱ¼ä±È½Ï²Ö´Ù£¬»ã¼¯µÄÎÊÌâÖ»ÊÇÎÒÃÇĿǰËùÓöµ½µÄÒ»²¿·Ö£¬»¹²»ÍêÉÆ£¬²»×ãÖ®´¦¾´Çë¶àÌᱦ¹óÒâ¼û¡£
±à Õß
2001Äê4ÔÂ6ÈÕ
Ò»¡¢ ¹«¹²¹ÜÀí
£¨Ò»£©ÏµÍ³¹ÜÀí
1. µ±ORACLE°²×°Íêºó£¬ÔÚÔËÐÐϵͳʱϵͳÖеĺº×ÖÏÔʾÂÒÂ룬ÕâÊÇÔõô»ØÊ£¿
´ð£ºÔÒòÊÇÔÚ°²×°ORACLE7.1»òORACLE7.3ʱ×Ö·û¼¯Î´ÐÞ¸Ä.½â¾ö°ì·¨: ORACLE7.3ÊÇͨ¹ýÔËÐÐregedit,Ñ¡HKEY-LOCAL-MACHINEϵÄSOFTWARE¡ªORACLEϵÄNLS_LANG,½«AMERICAN_AMERICA.we8isu8859p1¸ÄΪAMERICAN_AMERICA.US7ASCII; ORACLE7.1ÊÇÔÚwindowsĿ¼ÏµÄoracle.iniÎļþÖУ¬Ð޸ĵÄ×Ö·û´®ºÍÇ°ÃæÒ»Ñù¡£
2. µ±Óû§µÇ¼ʱÌáʾ¡°ÎÞ·¨Á¬½Ó·þÎñÆ÷¡±¸ÃÈçºÎ½â¾ö£¿
´ð£ºÅųýÍøÂç·½ÃæµÄÎÊÌ⣬×î¿ÉÄÜÔÒòÊÇÊý¾Ý¿â±ðÃûδÌí¼Ó¡£½â¾ö°ì·¨ÊÇͨ¹ýORACLE FOR WINDOWS95 ÖеÄSQL NET EASY CONFIGURATIONÖÐÌí¼ÓÊý¾Ý¿â±ðÃû£»ÁíÍâ±È½ÏÉÙ¼ûµÄÔÒòÊÇÊý¾Ý¿â²»Äܽ¨Á¢ÐµÄÁ¬½Ó£¬±ÈÈçÊý¾Ý¿â´ïµ½×î´ó½ø³ÌÊý£¬listenerʧЧµÈµÈ¡£ÈôÊÇlistenerʧЧ£¬ÊÇ¿ÉÒÔÏȽ«listener·þÎñÍ£Ö¹ºóÔÙ»Ö¸´¡£
3. Óû§µÇ¼ʱÌáʾ¡°ÕÒ²»µ½ºó׺ÃûΪ.DLLµÄÎļþ£¬ÏµÍ³ÎÞ·¨ÔËÐС±£¬ÕâÊÇΪʲô£¿
´ð£ºÔÒòÊÇPB¶¯Ì¬Á´½Ó¿âδÕýÈ·°²×°¡£½â¾ö·½·¨Êǽ«ÏàÓ¦µÄ¶¯Ì¬¿âÎļþ¿½±´ÖÁ±¾µØ»úÆ÷£¬Èç¹ûµ¥¶À½¨Á¢Ä¿Â¼£¬ÐèÒª´ò¿ªC:AUTOEXEC.BATÎļþ£¬ÐÞ¸ÄINSTDLLºÍPB5DLL32µÄ·¾¶ºóÖØÐÂÆð¶¯¼ÆËã»ú£»Èç¹û¿½±´µ½³ÌÐòËùÔÚĿ¼»òÕßwindowsµÄsystemĿ¼ÏÂÔò²»ÐèÒª×öÈκÎÐ޸ġ£
4. ÈçºÎÅжÏÍøÂçÁ¬½Ó³öÏÖÎÊÌâ?
´ð£ºÏÖÏó£ºÔø¾Õý³£Ê¹Óùý£¬µÇ¼¹ý³Ì¼«ÆäÂþ³¤£¨3·ÖÖÓ×óÓÒ£©£¬ORACLE·µ»ØµÄ´íÎó±íÃ÷²»ÄÜÁ¬½ÓÄ¿µÄµØ£¨ORA-12203: TNS:unable to connect to destination£©¡£
Ê×ÏÈ£ºPING ±¾µØ»úÆ÷µÄIPµØÖ·¡£Èç¹û²»ÄÜÁ¬Í¨Ôò»³ÒÉ»úÆ÷µÄÍøÂçÁÚ¾ÓÅäÖÃÓÐÎó»òÕßÍø¿¨²»ÄÜÕý³£¹¤×÷¡£Çé¿ö±È½ÏÉÙ¼û¡£Äܹ»Á¬Í¨Ôò˵Ã÷±¾µØ»úÆ÷Çé¿öÕý³£¡£
Æä´Î£ºPINGÊý¾Ý¿â·þÎñÆ÷µÄIPµØÖ·¡£Èç¹û²»ÄÜÁ¬Í¨ÔòºÜ¿ÉÄÜÍøÂçÏß³öÏÖÎÊÌ⣬»òÕßËùÁ¬½ÓµÄHUB£¨ÆäËûÔÚ¸Ãͨ·ÉϵÄÍøÂçÉ豸£©²»ÄÜÕý³£¹¤×÷¡£
5. ÔÚÃÅÕïÊÕ·Ñ´¦ÓÐʱ³öÏÖijÓû§ÔÚ½øÐл®¼ÛÊÕ·Ñ¿ªÆ±Ê±ÎÞ·¨´òÓ¡·¢Æ±£¬ÇÒ½çÃæÌáʾ¡°ÕýÔÚ±£´æ¡±£¬µ«»úÆ÷ÒѾÎÞ·¨ÔËת£¬²é¿´¸ÃÊý¾ÝÔò·¢ÏÖδ½øÐпªÆ±´¦Àí£¬ÖØÐÂÆô¶¯ºóÓøÃÓû§µÇ¼ÈÔÎÞ·¨¿ªÆ±£¬»òÓÐʱÔÚÒ½Éú¹¤×÷Õ¾³öÏÖÒ½Öö±£´æ¡°ÌرðÂý¡±£¬ÕâÊÇΪʲô£¿
´ð£ºÔÒò¿ÉÄÜÊDZ»Ëø×¡¡£¿ÉÄÜͬһ¸öÓû§ÓµÓжà¸öactiveµÄ»á»°£¬Óɲ»Õý³£¹Ø»úÔì³É£¬Ç°¶Ëdisconnect£¬ºó¶ËÈÔÔÚÔËÐС£½â¾ö°ì·¨ÊÇÏÈÈøÃÓû§¹Ø»ú£¬¹ÜÀíÔ±ÔÚORACLE¹ÜÀíÖеÄINSTANCE MANAGERÖеÄSESSIONSÖн«¸ÃÓû§µÄ¶à¸öactive»á»°É¾³ý¡£Óû§ÔÙÖØÐÂÆô¶¯»úÆ÷£¬¾Í¿ÉÒÔ½øÐÐϵͳ²Ù×÷¡£
£¨¶þ£©ÏµÍ³³õʼ»¯
6. ÔÚ¹«¹²×Öµä×ÓϵͳÖУ¬µ±Êý¾Ý±íÃûÌ«³¤£¬¸ÃÔõô²éÕÒ£¿
´ð£ºÔÚ´ò¿ªÊý¾Ý±í½çÃæ´¦£¬Èç¹û±íÃûÌ«³¤£¬Êä²»½øÈ¥£¬¿ÉÒÔÓÃSelectÓï¾ä½çÃæÐ´SQL²éѯ¡£
7. ÔÚ¹«¹²×Öµä×ÓϵͳÖУ¬ÊäÈë±íÃûºóµ«²éÕÒ²»µ½¸Ã±í£¬ÕâÊÇΪʲô£¿
´ð£ºÔÒòÊǽøÈ빫¹²×ÖµäʱËùʹÓõÄÓû§ÆäȨÏÞÏÞÖÆ£¬ÒԸñíµÄËùÓÐÕߵǼ£¬¼´¿É´ò¿ª¸Ã±í¡£»òÓ󬼶Óû§µÇ¼µ½¹«¹²×Öµä×ÓϵͳÖУ¬Í¨¹ýSelectÓï¾ä½çÃæÐ´SQL£¬µ«±íÃûǰҪ´øÉϱíµÄËùÓÐÕߣ¬È磺Select * from Comm.drug_price_list¡£
8. ¿ÆÊÒÃû³Æ×Öµä¿âά»¤ÖÐҪעÒâÄÄЩ£¿
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|