linux¹ØÓÚ$ORACLE_HOME/root.shºÍ/etc/oratab
1.°²×°Ê±ÒªÖ´ÐÐÁ½¸ö½Å±¾£¬root.shÊÇÆäÖÐÒ»¸ö¡£
ÐèÒªÓÃrootÓû§Ö´ÐÐroot.shÈ¥Éú³É/etc/oratabÎļþ¡£————1.dbcaÖв»»áÓÐɾ³ýÑ¡Ïî(ÒòΪÔËÐÐʱÐèÒª/etc/oratab)
2.dbstartÕâ¸ö½Å±¾ÔËÐв»ÁË£¨ÒòΪÔËÐÐʱÐèÒª/etc/oratab£©
2.oratabÎļþÀïÓм¸¸öʵÀý¾ÍÉèÖü¸¸öÑ¡Ï
ÀýÈ磺
¸ñʽ£ºORACLE_SID:ORACLE_HOME:Y
zx:/Oracle/app/Oracle/product/10.2.0/Db_1:y
3.ÓÐÁË/etc/oratabÎļþ»¹Òª¼ÓÈë2ÖеÄÄÚÈÝ¡£
Óм¸¸öʵÀý¼Ó¼¸Ìõ¡£
Èç¹û²»¼Ó——————————————————1.µ±sqlplus / as sysdbaµÇ¼ʱ£¬startup open;¾ÍÎÞ·¨´ò¿ªÊý¾Ý¿â£¬ÏÔʾ´íÎóÁ¬½Ó
oratab
Ïà¹ØÎĵµ£º
2009 Äê 4 ÔÂ 23 ÈÕ
±¾ÎÄÖÐÎÒÃÇÕë¶Ô Linux É϶àÏ̱߳à³ÌµÄÖ÷ÒªÌØÐÔ×ܽá³ö 5 Ìõ¾Ñ飬ÓÃÒÔ¸ÄÉÆ Linux ¶àÏ̱߳à³ÌµÄϰ¹ßºÍ±ÜÃâÆäÖеĿª·¢ÏÝÚå¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃÇ´©²åһЩ Windows µÄ±à³ÌÓÃÀýÓÃÒÔ¶Ô±È Linux ÌØÐÔ£¬ÒÔ¼ÓÉî¶ÁÕßÓ¡Ïó¡£
±³¾°
Linux ƽ̨ÉϵĶàÏ̳߳ÌÐò¿ª·¢Ïà¶ÔÓ¦ÆäËûƽ̨£¨±ÈÈç Windows£©µÄ¶àÏß³Ì API ÓÐһЩϸ΢ ......
ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊǰ²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE ÈÕÆÚ£ ......
Ò»¡¢Ó²ÅÌ·ÖÇøÓëÎļþϵͳ
1) ͨ³£ÔÚÄõ½Ò»¿éеÄÓ²ÅÌʱ£¬»á½«Ó²ÅÌ·Ö¸î³É¼¸¸ö²»Í¬µÄ·ÖÇø(partition)
2) ·ÖºÃ·ÖÇøºó£¬Òª°ÑÕâЩ·ÖÇø¸ñʽ»¯(Format)³ÉÌØ¶¨µÄÎļþϵͳ¸ñʽ(File System Format)£¬²ÅÄܹ»ÓÃÀ´´¢´æÎļþ¡£¸ñʽ»¯¾ÍÊǰѷÖÇøÇиî³ÉÒ»¸ö¸öСµ¥Î»(³ÆÎªblock)£¬²¢ÇÒblockÒÀÐò±àºÅ¡£blockÊÇ´¢´æÎļþÄÚÈݵÄ×îСµ¥Î»¡£ÔÚÔ¤Éè ......
ÒÔÏÂÊDZ¾ÈËÔÚѧϰlinux±à³Ìʱ²éÕÒ²¢ÕûÀíµÄһЩ¶«Î÷£¬Óë´ó¼Ò·ÖÏí£º
Vi´ó¼Ò¶¼ºÜÊìϤ£¬Ä³Ð©Çé¿öÏÂËüÊÇÎÒÃÇÔÚLinuxÏÂΨһ¿ÉÓõÄÎı¾±à¼Æ÷¡£ÆäʵÎÒÃÇÆ½Ê±ËùÖ¸µÄVIÆäʵÊÇVIM£¨ViImproved£¬VIÔöÇ¿°æ£©¡£ÓÐÈ˳£³£ÄÃVIMºÍemacs±È½Ï£¬VIM¾¡¹Ü²»ÏóemacsÄÇÑùÓÐÄÇô¶àµÄ¹¦ÄÜ£¬µ«ÊDZÈemacs¸ü·½±ã¡¢ºÃÓá£VIM¼òµ¥Ò×Óã¬Ö»Òª¿´¿´V ......