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
Ïà¹ØÎĵµ£º
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......
oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3 Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l ABS
Óï·¨: ABS(x)
¹¦ÄÜ: µÃµ½xµÄ¾ø¶ÔÖ ......
²úÉú±í¿Õ¼äÒ»°ã¶¼ÊÇDBA»òÌØÈ¨Óû§À´Íê³ÉµÄ£¬Èç¹ûÒªÒÔÆäËûµÄÉí·ÝÀ´²úÉú£¬Õâ¸öÓû§±ØÐëÓÉCreate tablespaceȨÏÞ²ÅÐС£²úÉúÒ»¸ö±í¿Õ¼äʱ£¬Ò»°ãÐèÒª²úÉúÒ»¸öÊý¾ÝÎļþ£¬²¢È·¶¨ÎļþµÄ´óСºÍ¶ÎµÄ´óС¡£
²úÉúÒ»¸ö±í¿Õ¼ä£¬È·¶¨Êý¾ÝÎļþ£¬Îļþ´óСºÍÇø´óС¡£
create tablespace date01 datafile d:\oracle\oradata\scut\date01.dbf ......
ÎÄÕÂ×÷ÕߣºSlyar ÎÄÕÂÀ´Ô´£ºSlyar Home (www.slyar.com) ×ªÔØÇë×¢Ã÷£¬Ð»Ð»ºÏ×÷¡£
¸øÅ®ÅóÓѸ´ÖÆÁËÒ»·ÝÎÒÅäÖúõÄUbuntu Server Vmware vmdk£¬ÔÚËýµçÄÔÉÏÓÃÕâ¿éÐéÄâÓ²ÅÌн¨³öµÄUbuntuÒ²ÄÜÓã¬Î¨Ò»ÓÐÎÊÌâµÄ¾ÍÊÇÕÒ²»µ½Íø¿¨ÁË£¬Ìáʾ"No such device eth0"...
½â¾ö¹ý³Ì²»Ð´ÁË£¬·´ÕýºÄµôÁËÎҺü¸¸öСʱ...
ÔÒòÊÇVmware±£´æµÄÓ ......
ÎÒÊÇÓÃÐéÄâ»ú×°ÁËLinux£¬ÕæÊµÏµÍ³ÊÇWindows XP£¬ÔÚWindows XPÏÂÓÃServ-uÈí¼þ¼ÜÉèÁËFTP·þÎñÆ÷£¬È»ºóÎÒÃǾͿÉÒÔÔÚÐéÄâ»úµÄLinuxϵǼ¸ÃFTP·þÎñÆ÷ÏÂÔØ»òÉÏ´«ÎļþÁË£¬²»Í¬µÄ½öÊÇÔÚLinuxÏÂÊÇÔÚÃüÁîÐÐÀïÊäÈëÏà¹ØFTPÃüÁîÀ´Íê³ÉµÄ£¬Ó¦¸ÃÒ²ÓÐÏñFlashFXP¡¢CuteFTPÕâÒ»ÀàµÄLinuxרÓÃÈí¼þ£¬²»¹ýÎҹª¹ÑÎÅ£¬²»Á˽⣬Ҳ¾Í²»ÎóÈË×ÓµÜÁË¡£ ......