OracleÖбíµÄ¹éÊôÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
OracleÖУ¬ÔÚsqlplusÖÐÓÃij¸öÓû§µÇÈëºó£¬È»ºóÔÚ´´½¨Ò»¸ö±í £¬Õâ¸ö±íÊDz»ÊǾÍÊôÓÚÕâ¸öÓû§£¿
Êǵġ£Ö»ÒªÄã²»´øschemaǰ׺µÄ»°
e.g. create table abc(...)£¬ÄÇÕâ¸öabc¾ÍÊôÓÚµ±Ç°Óû§¡£
Èç¹ûÓÐÁ˺ÏÊʵÄȨÏÞÖ®ºó£¬µ±Ç°Óû§Îªscott£¬ËüÓÐȨÏÞÔÚnajiutanÏ´´½¨±í
create table najiutan.abc(...)£¬ÄÇô¸Ã±íÈÔÈ»ÊôÓÚnajiutan¡£
¿ÉÒÔÕâôÈÏΪ
Êǵģ¬ÊÇÕâÑùµÄ
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......