ÔÚ/homeÏ ȥ·¢ÏÖÖ»ÓÐoracleµÄÎļþ ûÓÐmysqlµÄÎļþ
ÔÚlinuxÀï°²×°ÁË oracle mysql ¶¼³É¹¦¡£
ÔÚ/homeÏ ȥ·¢ÏÖÖ»ÓÐoracleµÄÎļþ ûÓÐmysqlµÄÎļþ
ÁíÍâÎÒadduser li£¬ ÄÜÔÚ/homeÏ ·¢ÏÖÓÐliÎļþ¡£
ʲôÔÒòµ¼ÖÂÎÒÖ»ÄÜ¿´¼ûoracle ²»¼ûmysqlÎļþ£¿£¿
mysqlÓû§Ö÷Ŀ¼ where??
ind / -name "mysql" -print
Ö´ÐÐÍêµÃµ½ÏÂÁнá¹û
/var/lib/mysql
/var/log/mysql
££££££££££££££ Õâ2¸öÊÇÎÒÔÚmy.cnfÀïÅäÖõÄdatadir log-bin
/usr/share ??? Õâ¸ö¿ÉÄÜÐԺܴó ÄѵÀÊÇÕâ¸ö £¿£¿£¯
ȷʵÊÇ /var/lib/mysql
¼ì²é/etc/passwd
²Î¿¼À´×Ô
linuxÐÞ¸ÄÓû§Ö÷Ŀ¼µÄ·½·¨
Submitted by wayswang on 2008, November 27, 2:49 PM. Linux
ÎÒÓÐÁ½ÖÖ°ì·¨£¬½ö¹©²Î¿¼¡£
µÚÒ»£ºÐÞ¸Ä/etc/passwdÎļþ
µÚ¶þ£ºusermodÃüÁî
Ïêϸ˵Ã÷ÈçÏ£º
µÚÒ»ÖÖ·½·¨£ºvi /etc/passwd
ÕÒµ½ÒªÐ޸ĵÄÓû§ÄǼ¸ÐУ¬Ð޸ĵô¼´¿É¡£´Ë·¨ºÜ±©Á¦£¬½¨ÒéÉ÷Óá£
µÚ¶þÖÖ£ºusermod
usermod -d /usr/newfolder -u uid
-uºóÃæÒ»¶¨Òª½Óuid°¡£¬²»ÊÇusername
¸½£ºusermodÏêϸ²ÎÊý
Óï¡¡¡¡·¨£ºusermod [-LU][-c <±¸×¢>][-d <µÇÈëĿ¼>][-e <ÓÐЧÆÚÏÞ>][- f <»º³åÌìÊý>][-g <Ⱥ×é>][-G <Ⱥ×é>][-l <ÕʺÅÃû³Æ>][-s ][-u ] [Óû§ÕʺÅ]
²¹³ä˵Ã÷£ºusermod¿ÉÓÃÀ´ÐÞ¸ÄÓû§Õʺŵĸ÷ÏîÉ趨¡£
²Î¡¡¡¡Êý£º
-c <±¸×¢> ¡¡ÐÞ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......