Ïë×ÔѧOracle - À©³ä»°Ìâ / ¹àË®ÀÖÔ°
ÎÒÏë×ÔѧOracle£¬ÎÒÖªµÀÔõôȥѧ£¬ÒªÑ¡ÄǸö°æ±¾µÄ²ÅºÃ¡£
ÎÒѧ¹ýMS SQL server2000
9i 10G
ºÍг½Ó·Ö
9i 10G 11G
¶¼¿ÉÒÔ¡¡
¼ÈÈ»ÓÐÆäËûÊý¾Ý¿â¾Ñ飬sql 99±ê×¼Ó¦¸ÃºÜÇå³þÁË
¿´¿´¾«Í¨plsql ±à³Ì
²î²»¶àÁË
¹¤×÷¹»Óã¡
ÀͶ¯½ÚµÄ¿ìÀÖÔÚÓÚ²»ÀͶ¯¡£¡£¡£
WHAT A HAPPY DAY!
µÍµ÷½Ó·Ö~~
¶¼ÊÇÇ¿ÈËѽ£¬µÍµ÷½Ó·Ö¶ù
ÿÌì»ØÌû¼´¿É»ñµÃ10·Ö¿ÉÓ÷Ö
ÿÌì»ØÌû¼´¿É»ñµÃ10·Ö¿ÉÓ÷Ö
ºÍг½Ó·Ö¡£
¼ÓÓÍ++
not easy. ±Èsql serverÄÑÐí¶à°¡¡£±ØÐëºÜͶÈëµÄ°É£¬ÎÒÏë¡£
Ïà¹ØÎÊ´ð£º
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 ÕýÈ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......