Ïë×ÔѧOracle - À©³ä»°Ìâ / ¹àË®ÀÖÔ°
ÎÒÏë×ÔѧOracle£¬ÎÒÖªµÀÔõôȥѧ£¬ÒªÑ¡ÄǸö°æ±¾µÄ²ÅºÃ¡£
ÎÒѧ¹ýMS SQL server2000
9i 10G
ºÍг½Ó·Ö
9i 10G 11G
¶¼¿ÉÒÔ¡¡
¼ÈÈ»ÓÐÆäËûÊý¾Ý¿â¾Ñ飬sql 99±ê×¼Ó¦¸ÃºÜÇå³þÁË
¿´¿´¾«Í¨plsql ±à³Ì
²î²»¶àÁË
¹¤×÷¹»Óã¡
ÀͶ¯½ÚµÄ¿ìÀÖÔÚÓÚ²»ÀͶ¯¡£¡£¡£
WHAT A HAPPY DAY!
µÍµ÷½Ó·Ö~~
¶¼ÊÇÇ¿ÈËѽ£¬µÍµ÷½Ó·Ö¶ù
ÿÌì»ØÌû¼´¿É»ñµÃ10·Ö¿ÉÓ÷Ö
ÿÌì»ØÌû¼´¿É»ñµÃ10·Ö¿ÉÓ÷Ö
ºÍг½Ó·Ö¡£
¼ÓÓÍ++
not easy. ±Èsql serverÄÑÐí¶à°¡¡£±ØÐëºÜͶÈëµÄ°É£¬ÎÒÏë¡£
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......