Éî¿ÌÀí½â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ϵͳ¶ÁÈ¡¿ØÖÆÎļþÖйØÓÚÊý¾ÝÎļþºÍÖØ×÷ÈÕÖ¾ÎļþµÄÄÚÈÝ£¬µ«²¢²»´ò¿ª¸ÃÎļþ¡£ÕâÖÖ´ò¿ª·½Ê½³£ÔÚÊý¾Ý¿âά»¤²Ù×÷ÖÐʹÓã¬Èç¶ÔÊý¾ÝÎļþµÄ¸üÃû¡¢¸Ä±äÖØ×÷ÈÕÖ¾ÒÔ¼°´ò¿ª¹éµµ·½Ê½µÈ¡£ÔÚÕâÖÖ´ò¿ª·½Ê½Ï£¬³ýÁ
Ïà¹ØÎĵµ£º
³õѧlinux+oracle£¬²ÉÓõı¾µØÐéÄâ»ú°²×°linuxµÄ·½Ê½£¬°æ±¾ÊÇRed Hat 5£¬Î¨Ò»¸úÐéÄâ»ú°²×°ÆäËûϵͳ²»Í¬µÄÊÇ£º¶¨ÖÆ£¬Ñ¡IDEÓ²ÅÌ£¬·ñÔò°²×°¹ý³ÌÌáʾÕÒ²»µ½Ó²ÅÌʧ°Ü¡£
±¾ÎÄÖصãÊÇOracle°²×°¹ý³Ì£¬°æ±¾ 10.1.0¡£
3¡¢°²×°Ïà¹ØµÄ¿ª·¢°ü£¨rpm°ü£©£º
rpm -q binutils co ......
This course is aim to train the great DBA with good English speaking.
In recent years, more demands of Oracle DBA, but most of Senior DBAs are required to speak good English.
English has become the great barrier for more peoples in their career development, you must have the deep feeling about it ......
1¡¢select TIMESTAMP'2009-11-03 09:26:50.124' from dual --ĬÈϺÁÃë±£´æÁùλ
2¡¢´ËÓï¾äÖ»ÄÜÔÚ·þÎñÆ÷¶ËÔËÐУ¬Èç¹ûÖ´ÐÐÒÔϲÙ×÷£¬ÔòÔÚ²åÈëoracleʱ£¬¿ÉÒÔÖ±½Óдnls_date_formatÉ趨µÄ¸ñʽ£¬µ«ÊÇÖ»ÄÜÕë¶ÔÒ»´Î»æ»£¬Èç¹û¹Øµô´°¿ÚÔòʧЧ¡£
alter session set nls_d ......
½ñÌìÔÚnet managerÅäÖñ¾µØ·þÎñʱ³öÏÖÕâÑùµÄÎÊÌâ
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
ÔÚgoogleÉÏËÑË÷µÃµ½Èô¸É´ð°¸£¬×ÜÊDz»¶Ô£¬ºóÀ´ÔÚͬʵİïÖúϽâ¾öÁËÎÊÌ⣬ÏÖÔÚ×ܽáһϸú´ó¼Ò·ÖÏí¡£
1¡¢Ñ¡Öб¾µØ——·þÎñÃüÃû£¬ÔÚ±à¼Öд´½¨
2¡¢ÊäÈënet·þÎñÃû£¬×¢ÒâÕâÊÇ ......