Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ

OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе½ÁËSQL*PlusÖУ¬Ò²¾ÍÊÇ˵´Ó8iÒÔºó¶ÔÓÚÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ¿ÉÒÔÖ±½Óͨ¹ýSQL*PlusÀ´Íê³É£¬¶ø²»ÔÙÁíÍâÐèÒªServer Manager£¬µ«ÏµÍ³ÎªÁ˱£³ÖÏòϼæÈÝ£¬ÒÀ¾É±£ÁôÁËServer Manager¹¤¾ß¡£ÁíÍâÒ²¿Éͨ¹ýͼÐÎÓû§¹¤¾ß£¨GUI£©µÄOracle Enterprise ManagerÀ´Íê³ÉϵͳµÄÆô¶¯ºÍ¹Ø±Õ£¬Í¼ÐÎÓû§½çÃæInstance Manager·Ç³£¼òµ¥£¬ÕâÀï²»ÔÙÏêÊö¡£
¡¡¡¡ÒªÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬±ØÐëÒªÒÔ¾ßÓÐ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ϵͳ¶ÁÈ¡¿ØÖÆÎļþÖйØÓÚÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþµÄÄÚÈÝ£¬µ«²¢²»´ò¿ª¸ÃÎļþ¡£ÕâÖÖ´ò¿ª·½Ê½³£ÔÚÊý¾Ý¿âά»¤²Ù×÷ÖÐʹÓã¬Èç¶ÔÊý¾ÝÎļþµÄ¸üÃû¡¢¸Ä±äÖØ×÷ÈÕÖ¾ÒÔ¼°´ò¿ª¹éµµ·½Ê½µÈ¡£ÔÚÕâÖÖ´ò¿ª·½Ê½Ï£¬³ýÁ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleµÄ¼¸¸ö¼¯ºÏ²Ù×÷

 
Union£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Union All£¬¶ÔÁ½¸ö½á¹û¼¯½øÐв¢¼¯²Ù×÷£¬°üÀ¨Öظ´ÐУ¬²»½øÐÐÅÅÐò£»
Intersect£¬¶ÔÁ½¸ö½á¹û¼¯½øÐн»¼¯²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò£»
Minus£¬¶ÔÁ½¸ö½á¹û¼¯½øÐвî²Ù×÷£¬²»°üÀ¨Öظ´ÐУ¬Í¬Ê±½øÐÐĬÈϹæÔòµÄÅÅÐò¡£
¿ÉÒÔÔÚ×î ......

OracleÖÐÓйØÈÕÆÚµÄһЩÉèÖÃ

1¡¢select TIMESTAMP'2009-11-03 09:26:50.124' from  dual  --ĬÈϺÁÃë±£´æÁùλ
 
2¡¢´ËÓï¾äÖ»ÄÜÔÚ·þÎñÆ÷¶ËÔËÐУ¬Èç¹ûÖ´ÐÐÒÔϲÙ×÷£¬ÔòÔÚ²åÈëoracleʱ£¬¿ÉÒÔÖ±½Óдnls_date_formatÉ趨µÄ¸ñʽ£¬µ«ÊÇÖ»ÄÜÕë¶ÔÒ»´Î»æ»­£¬Èç¹û¹Øµô´°¿ÚÔòʧЧ¡£
alter   session   set   nls_d ......

oracleµÄ¹éµµÄ£Ê½

Ò»¡£²é¿´oracleÊý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º
1.select name,log_mode from v$database;
NAME               LOG_MODE
------------------ ------------------------
QUERY           NOARCHIVELO ......

oracleÎÊÌâÖ®Ò»£º±¾»úÁ¬½ÓÊý¾Ý¿â·þÎñÆ÷

½ñÌìÔÚnet managerÅäÖñ¾µØ·þÎñʱ³öÏÖÕâÑùµÄÎÊÌâ
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
ÔÚgoogleÉÏËÑË÷µÃµ½Èô¸É´ð°¸£¬×ÜÊDz»¶Ô£¬ºóÀ´ÔÚͬʵİïÖúϽâ¾öÁËÎÊÌ⣬ÏÖÔÚ×ܽáһϸú´ó¼Ò·ÖÏí¡£
1¡¢Ñ¡Öб¾µØ——·þÎñÃüÃû£¬Ôڱ༭Öд´½¨
2¡¢ÊäÈënet·þÎñÃû£¬×¢ÒâÕâÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ