ÈçºÎÔÚ´úÂëÖж¯Ì¬´´½¨ORACLEÊý¾Ý¿â
ÎÒÔÚ×öÒ»¸öÏîÄ¿µÄ°²×°³ÌÐò£¬ÎªÁ˼ò»¯Ê¹Óã¬ÐèÒªÓôúÂëµÄ·½Ê½´´½¨Ò»¸öOralceµÄÊý¾Ý¿â£¬µ±È»Ç°ÌáÊÇÒѾ°²×°ÁËORACLE¡£
ÎÒÏÖÔÚʹÓõķ½Ê½Êǵ÷ÓÃsqlplusÖ´ÐÐÏàÓ¦µÄ½Å±¾ÊµÏÖ¡£µ«ÎÊÌâÊÇ£¬ÎҵĴúÂëÖв»ºÃÅжϽű¾µÄÖ´Ðнá¹û¡£
ÄÄλ¸ßÊÖ½éÉܵ㷽·¨¡£
Ò²¿ÉÒÔ½«ÄãµÄ½Å±¾µ¼³öΪ¡£dmpºó£¬ÔÙµ¼Èë
½«ÄãËùÓеĽŲ½µ¼³ö£¨±í½á¹¹¡¢º¯Êý¡¢´æ´¢¹ý³Ì¡¢ÊÓͼ¡¢ÐòÁеȵȣ©
ÔÙµ¼³öÄãµÄ³õʼֵ
×îºó°´Ë³ÐòÖ´ÐÐÄãµÄ½Å²½
µ«ÎÊÌâÊÇ£¬ÎҵĴúÂëÖв»ºÃÅжϽű¾µÄÖ´Ðнá¹û¡£
--
Õâ¸öȷʵ²»ºÃÅжϣ¬µ«ÊÇ¿ÉÒÔ¶à´Î·´¸´²âÊÔÄãµÄ½Å±¾£¬±£Ö¤²»³öÎÊÌâ
spool on¼Ç¼ִÐÐÈÕÖ¾£¬È»ºó·ÖÎöÈÕÖ¾ÄÚÈÝʵÏÖ¿É·ñ£¿
Èç¹ûÄãʹÓõÄORACLE10gÊý¾Ý¿âϵͳµÄ»°£¬Äã×îºÃ²»ÒªÔÚ³ÌÐòÖÐÓôúÂëÈ¥´´½¨Êý¾Ý¿â¡£Õâ²»ÊÇÒ»¸öºÃµÄ·½·¨¡£Èç¹ûÊÖ¹¤´´½¨Êý¾Ý¿âµÄ»°£¬Óкܶ๦ÄÜÊDz»»á±»×Ô¶¯¿ªÆôµÄ£¬¸øÊý¾Ý¿âµÄ¹ÜÀí´øÀ´Âé·³¡£
ÔÙ˵ÁË£¬ÄãÔÚʵʩµÄÏîĿʱ£¬¶Ô·½µÄDBAÒ²²»»áÈÃÄãÔÚ³ÌÐòÖÐÓôúÂëÈ¥´´½¨Êý¾Ý¿âµÄ¡£
1£¬ÔÚ´æ´¢¹ý³ÌÀïÃæÐ´¶¯Ì¬sql£¬Ö´Ðд´½¨oracleÊý¾Ý¿â£¬´æ´¢¹ý³Ì·µ»ØÖ´Ðнá¹ûÐÅÏ¢¡£
2£¬ÔÚ´úÂëÀïÃæµ÷Óô洢¹ý³Ì£¬²é¿´Ö´Ðнá¹ûÐÅÏ¢¡£
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£
ûÓÐORACLE ERPµÄ¾Ñé,ÓÐÓÃÓѺÍTIPTOP¾Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......