Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡ÒªÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬±ØÐëÒªÒÔ¾ßÓÐOracle ¹ÜÀíԱȨÏÞµÄÓû§µÇ½£¬Í¨³£Ò²¾ÍÊÇÒÔ¾ßÓÐSYSDBAȨÏÞµÄÓû§µÇ½¡£Ò»°ãÎÒÃdz£ÓÃINTERNALÓû§À´Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¨INTERNALÓû§Êµ¼ÊÉÏÊÇSYSÓû§ÒÔSYSDBAÁ¬½ÓµÄͬÒå´Ê£©¡£OracleÊý¾Ý¿âµÄа汾½«Öð²½ÌÔÌINTERNALÕâ¸öÄÚ²¿Óû§£¬ËùÒÔÎÒÃÇ×îºÃ»¹ÊÇÉèÖÃDBAÓû§¾ßÓÐSYSDBAȨÏÞ¡£
¡¡¡¡¶þ¡¢Êý¾Ý¿âµÄÆô¶¯£¨STARTUP£©
¡¡¡¡Æô¶¯Ò»¸öÊý¾Ý¿âÐèÒªÈý¸ö²½Ö裺
¡¡¡¡¡¡1¡¢ ´´½¨Ò»¸öOracleʵÀý£¨·Ç°²×°½×¶Î£©
¡¡¡¡¡¡2¡¢ ÓÉʵÀý°²×°Êý¾Ý¿â£¨°²×°½×¶Î£©
¡¡¡¡¡¡3¡¢ ´ò¿ªÊý¾Ý¿â£¨´ò¿ª½×¶Î£©
¡¡¡¡ÔÚStartupÃüÁîÖУ¬¿ÉÒÔͨ¹ý²»Í¬µÄÑ¡ÏîÀ´¿ØÖÆÊý¾Ý¿âµÄ²»Í¬Æô¶¯²½Öè¡£
¡¡¡¡1¡¢STARTUP NOMOUNT
¡¡¡¡NONOUNTÑ¡Ïî½ö½ö´´½¨Ò»¸öOracleʵÀý¡£¶ÁÈ¡init.ora³õʼ»¯²ÎÊýÎļþ¡¢Æô¶¯ºǫ́½ø³Ì¡¢³õʼ»¯ÏµÍ³È«¾ÖÇø£¨SGA£©¡£Init.oraÎļþ¶¨ÒåÁËʵÀýµÄÅäÖ㬰üÀ¨ÄÚ´æ½á¹¹µÄ´óСºÍÆô¶¯ºǫ́½ø³ÌµÄÊýÁ¿ºÍÀàÐ͵ȡ£ÊµÀýÃû¸ù¾ÝOracle_SIDÉèÖ㬲»Ò»¶¨ÒªÓë´ò¿ªµÄÊý¾Ý¿âÃû³ÆÏàͬ¡£µ±ÊµÀý´ò¿ªºó£¬ÏµÍ³½«ÏÔʾһ¸öSGAÄÚ´æ½á¹¹ºÍ´óСµÄÁÐ±í£¬ÈçÏÂËùʾ£º
SQL> startup nomount
ORACLE Àý³ÌÒѾÆô¶¯¡£
Total System Global Area 35431692 bytes
Fixed Size 70924 bytes
Variable Size 18505728 bytes
Database Buffers 16777216 bytes
Redo Buffers 77824 bytes
¡¡¡¡2¡¢STARTUP MOUNT
¡¡¡¡¸ÃÃüÁî´´½¨ÊµÀý²¢ÇÒ°²×°Êý¾Ý¿â£¬µ«Ã»Óдò¿ªÊý¾Ý¿â¡£Oracleϵͳ¶ÁÈ¡¿ØÖÆÎļþÖйØÓÚÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþµÄÄÚÈÝ£¬µ«²¢²»´ò¿ª¸ÃÎļþ¡£ÕâÖÖ´ò¿ª·½Ê½³£ÔÚÊý¾Ý¿âά»¤²Ù×÷ÖÐʹÓã¬Èç¶ÔÊý¾ÝÎļþµÄ¸üÃû¡¢¸Ä±äÖØ×÷ÈÕÖ¾ÒÔ¼°´ò¿ª¹éµµ·½Ê½µÈ¡£ÔÚÕâÖÖ´ò¿ª·½Ê½Ï£¬³ýÁË¿ÉÒÔ¿´µ½SGAϵͳÁбíÒÔÍ⣬ϵͳ»¹»á¸ø³ö"Êý¾Ý¿â×°ÔØÍê±Ï"µÄÌáʾ¡£
¡¡¡¡3¡¢STARTUP
¡¡¡¡¸ÃÃüÁîÍê³É´´½¨ÊµÀý¡¢°²×°ÊµÀýºÍ´ò¿ªÊý¾Ý¿âµÄËùÓÐÈý¸ö²½Öè¡£´ËʱÊý¾Ý¿âʹÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþÔÚÏߣ¬Í¨³£»¹»áÇëÇóÒ»¸ö»òÕßÊǶà¸ö»Ø¹ö¶Î¡£Õâʱϵͳ³ýÁË¿ÉÒÔ¿´µ½Ç°ÃæStartup Mount·½Ê½ÏµÄËùÓÐÌáʾÍ⣬»¹»á¸ø³öÒ»¸ö"Êý¾Ý¿âÒѾ´ò¿ª"µÄÌáʾ¡£´Ëʱ£¬Êý¾Ý¿âϵͳ´¦ÓÚÕý³£¹¤×÷״̬£¬¿ÉÒÔ½ÓÊÜÓû§ÇëÇó¡£
¡¡¡¡Èç¹û²ÉÓÃSTARTUP NOMOUNT»òÕßÊÇSTARTUP MOUNTµÄÊý¾Ý¿â´ò¿ªÃüÁʽ£¬±ØÐë²ÉÓÃALTER DATABASEÃüÁîÀ´Ö´Ðдò¿ªÊý¾Ý¿âµÄ²Ù×÷¡£ÀýÈ磬Èç¹ûÄãÒÔSTARTUP NOMOUNT·½Ê½´ò¿ªÊý¾Ý¿â£¬Ò²¾ÍÊÇ˵ʵÀýÒѾ´´½¨£¬µ«ÊÇÊý¾Ý¿âûÓа²×°ºÍ´ò¿ª¡£ÕâÊDZØÐëÔËÐÐÏÂÃæµÄÁ½ÌõÃüÁÊý¾Ý¿â²ÅÄÜÕýÈ·Æô¶¯¡£
Ïà¹ØÎĵµ£º
CLOB:ÓÃÀ´´æ´¢µ¥×Ö½ÚµÄ×Ö·ûÊý¾Ý
NCLOB:ÓÃÀ´´æ´¢¶à×Ö½ÚµÄ×Ö·ûÊý¾Ý
BLOB£ºÓÃÓÚ´æ´¢¶þ½øÖÆÊý¾Ý
BFILE:´æ´¢ÔÚÎļþÖеĶþ½øÖÆÊý¾Ý£¬Õâ¸öÎļþÖеÄÊý¾ÝÖ»Äܱ»Ö»¶Á·Ã¡£µ«¸ÃÎļþ²»°üº¬ÔÚÊý¾Ý¿âÄÚ¡£
CLOB£¬NCLOB£¬BLOB¶¼ÊÇÄÚ²¿µÄLOBÀàÐÍ£¬×4G£¬Ã»ÓÐLONGÖ»ÄÜÓÐÒ»ÁеÄÏÞÖÆ¡£
select lpad(to_number(nvl(max(classid),to_number( ......
Ò»¡¢³£ÓÃÊý¾ÝÀàÐÍ£º
Number£ºÊý×ÖÀàÐÍ
Int£ºÕûÊýÐÍ
Pls_integer£ºÕûÊýÐÍ£¬²úÉúÒç³öµÄ´íÎó
Binary_integer£ºÕûÊýÐÍ
Char£º¶¨³¤×Ö·û£¬×255¸ö×Ö·û
Varchar2£º±ä³¤×Ö·û£¬×2000¸ö×Ö·û
Long£º±ä³¤×Ö·û£¬×2GB
Date£ºÈÕÆÚÐÍ
Boolean£º²¼¶ûÐÍ
¶þ¡¢¶¨Òå³£Á¿
¸ñʽ£º³£Á¿Ãû constant &nbs ......
ÎÒ½ñÌìѧϰÁËOracle Êý¾Ý¿âµÄÅäÖü°¹ÜÀí£º
1 Oracle Êý¾Ý¿âÌåϵ½á¹¹¼ò½é
1.1 ƽ³£Ëù˵µÄ Oracle »ò Oracle Êý¾Ý¿âÖ¸µÄÊÇ Oracle Êý¾Ý¿â¹ÜÀíϵͳ. Oracle Êý¾Ý¿â¹ÜÀíϵͳÊǹÜÀíÊý¾Ý¿â·ÃÎʵļÆËã»úÈí¼ ......