³£¼ûÎÊÌâ¼°ÉîÈëÅŲéÒªÁì
Êý¾Ý¿âÁ¬½ÓÎÊÌ⣺֢״£ºÎÞ·¨Á¬½Óµ½Êý¾Ý¿â£¬±¨´íÈç¡°ORA-12505¡±¡£ÉîÈëÅŲéÒªÁ죺Ê×Ïȼì²é¼àÌýÆ÷ÅäÖÃÎļþ£¨listener.ora£©£¬È·±£¼àÌýÆ÷ÕýÈ·µØ°ó¶¨µ½Êý¾Ý¿âʵÀý¡£¿ÉÒÔʹÓÃÃüÁîlsnrctlstatus¼ì²ì¼àÌýÆ÷״̬¡£Èç¹û¼àÌýÆ÷ÎÞ·¨Æô¶¯£¬ÐèÒª¼ì²éÏà¹ØÅäÖú͹ýʧÈÕÖ¾¡£
»¹ÐèҪȷÈÏÍøÂçÅäÖÃÕýÈ·£¬·À»ðǽÉèÖÃÊÇ·ñÔÊÐíÊý¾Ý¿âÁ¬½Ó¡£ÐÔÄÜÆ¿¾±ÎÊÌ⣺֢״£ºÅÌÎÊËÙ¶ÈÂý¡¢ÏìӦʱ¼ä³¤¡£ÉîÈëÅŲéÒªÁ죺ʹÓÃOracleÌṩµÄÐÔÄÜÆÊÎö¹¤¾ßÈçAWR£¨AutomaticWorkloadRepository£©ºÍASH£¨ActiveSessionHistory£©½øÐÐÐÔÄÜÆÊÎö¡£
ÅäÖüàÌýÆ÷ʱ£¬ÐèҪȷ±£¼àÌýÆ÷ÕýÈ·µØ°ó¶¨µ½Êý¾Ý¿âʵÀý£¬²¢ÔÊÐíÍⲿӦÓóÌÐò»á¼û¡£¿ÉÒÔͨ¹ý±à?¼listener.oraÎļþÀ´½øÐÐÅäÖá£ÆôÓÃÊý¾Ý¿â×Ô¶¯±¸?·ÝºÍ»Ö¸´£ºÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÊÇÈ·±£Êý¾ÝÄþ¾²µÄÖØÒª»·½Ú¡£¿ÉÒÔʹÓÃOracleµÄRMAN£¨RecoveryManager£©¹¤¾ß½øÐÐ×Ô¶¯±¸·ÝºÍ»Ö¸´ÅäÖá£
ÔÚ½øÐб¸·Ýʱ£¬ÐèҪѡÔñºÏÊʵı¸·ÝÕ½ÂÔ£¬ÈçÈ«±¸·Ý¡¢ÔöÁ¿±¸·ÝµÈ£¬ÒÔÌá¸ß±¸·ÝЧÂʺͻָ´ËÙ¶È¡£
½â¾öÒªÁ죺
¼ì²éÒÀÀµÏȷ±£?ËùÓÐÐëÒªµÄÒÀÀµ¿â£¨Èç.NETFramework£©ÒѾװÖá£Äã¿ÉÒÔÔÚ¹Ù·½ÍøÕ¾ÉÏÏÂÔØ²¢×°Öá£È¨ÏÞÎÊÌ⣺ȷ±£ÄãµÄÓû§ÕË»§ÓµÓÐÖÎÀíԱȨÏÞ£¬ÒÔ±ã×°ÖúÍÔËÐÐÈí¼þ¡£ÖØÐ°²?×°£ºÐ¶ÔØÈí¼þ£¬È»ºóÖØÐÂ×°Öá£ÔÚÖØÐÂ×°ÖÃǰ£¬É¾³ýÈí¼þ²ÐÁôÎļþºÍ×¢²á±íÏÒÔÖÆÖ¹³åÍ»¡£
ϵͳ¼æÈÝÐÔ£ºÈ·±£?ÄãµÄ²Ù×÷ϵͳÓëÈí¼þ°æ±¾?¼æÈÝ¡£Èç¹ûʹÓõÄÊǾɰ汾Windowsϵͳ£¬ÊµÑéÉý¼¶²Ù?×÷ϵͳ»òʹÓüæÈÝģʽÆô¶¯Èí¼þ¡£
ÕâЩ¹¤¾ß¿ÉÒÔ×ÊÖúʶ±ð?ÐÔÄÜÆ¿¾±ËùÔÚ£¬ÈçSQLÓï¾äÖ´ÐÐʱ¼ä³¤¡¢CPUÕ¼Óøߵȡ£¿ÉÒÔÆ¾¾ÝÆÊÎö½á¹û½øÐÐSQLÓÅ»¯¡¢²ÎÊýµ÷½âµÈ¸ïв½·¥¡£Êý¾Ýɥʧ»òËð»µÎÊÌ⣺֢״£ºÊý¾Ýɥʧ»ò·ºÆðÊý¾ÝËð»µÇé¿ö¡£ÉîÈëÅŲé?ÒªÁ죺Ê×Ïȼì²éÊý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´ÅäÖã¬È·±£±¸·Ý²ß?ÂÔÕýÈ·¡£
¿ÉÒÔʹÓÃRMAN¹¤¾ß»Ö¸´É¥Ê§»òË𻵵ÄÊý¾Ý¡£Èç¹ûÊý¾Ýɥʧ»òËð»µÔÒò²»Ã÷£¬¿ÉÒÔͨ¹ý¼ì²ìOracleÈÕÖ¾Îļþ£¨Èçalert.log£©ºÍ¼ì²éÊý¾ÝÎļþ״̬À´½øÐÐÏêϸÅŲ顣´æ´¢¿Õ¼äȱ·¦ÎÊÌ⣺֢״£ºÊý¾Ý¿â±í¿Õ¼äȱ·¦£¬ÎÞ·¨´´Á¢Ðµıí»òË÷Òý¡£ÉîÈëÅŲéÒªÁ죺Ê×Ïȼì²éÄ¿½ñ±í¿Õ¼äµÄʹÓÃÇé¿ö£¬Ê¹ÓÃÃüÁîÈçSELECT*FROMv$datafile;¼ì²ì¸÷¸öÊý¾ÝÎļþµÄ?ʹÓÃÇé¿ö¡£
Èç¹û±í¿Õ¼äȱ·¦£¬¿ÉÒÔ¿¼ÂÇÀ©Õ¹Êý¾ÝÎļþ»òÌí¼ÓеÄÊý¾ÝÎļþ¡£»¹ÐèÒª¼ì²éÊÇ·ñÓÐÈßÓàÊý¾Ý»ò´óÎļþδʵʱÇåÀí£¬ÒÔÊÍ·Å´æ´¢¿Õ¼ä¡£
½â¾öÒªÁ죺
¸üÐÂÈí¼þ£ºÈ·±£ÄãʹÓõÄÊÇ×îа汾µÄÈí¼þ£¬¸üпÉÄܰüÀ¨¶Ô¹¦Ð§ÎÊÌâµÄÐÞ¸´¡£ÖØÖÃÉèÖãºÊµÑ齫Èí¼þµÄÉèÖûָ´Îª³ö³§Ä¬ÈÏÉèÖã¬ÒÔÅųýÉèÖÃÎÊÌâ¡£¼ì²ìÈÕÖ¾Îļþ£ºÈí¼þͨ³£»áÉú³ÉÈÕÖ¾Îļþ£¬¼Í¼ÔËÐÐÀú³ÌÖгö?ÏֵĹýʧ¡£¼ì²ìÕâЩÈÕÖ¾Îļþ¿ÉÒÔ×ÊÖúÄ㶨λÎÊÌâ¡£ÁªÏµ¼¼ÊõÖ§³Ö£ºÈç¹ûÎÊÌâÒÀÈ»±£´æ£¬¿ÉÒÔÁªÏµ17cÒ»Æð²ÝµÄ¼¼ÊõÖ§³ÖÍŶӣ¬ÌṩÏêϸµÄÎÊÌâÃèÊöºÍÈÕÖ¾Îļþ£¬ÒÔ±ãËûÃǽøÐнøÒ»²½µÄÕï¶ÏÏ¢Õù¾ö¡£
×ܽá
×°ÖúÍʹÓÃ17cÒ»Æð²ÝÈí¼þËäÈ»ÐèҪһЩ³õʼµÄÉèÖúÍÅäÖ㬵«Í¨¹ýÒÔÉϰ취ºÍÅŲéÒªÁ죬Äã¿ÉÒÔ˳Àû½â¾ö´ó´ó¶¼³£¼ûÎÊÌâ¡£°´ÆÚ¸üÐÂÈí¼þ¡¢¼á³Öϵͳ×ÊÔ´¸»×ãÒÔ¼°°´ÆÚ±¸·ÝÊý¾ÝÊÇÈ·±£Èí¼þƽÎÈÔËÐеÄÖØÒª²½·¥¡£Èç¹ûÓöµ½ÎÞ·¨½â¾öµÄÎÊÌ⣬²»ÒªÓÌÔ¥£¬ÊµÊ±ÁªÏµ×¨Òµ¼¼ÊõÖ§³ÖÍŶӣ¬ËûÃǽ«ÌṩרҵµÄ×ÊÖúºÍÖ§³Ö¡£
Ï£ÍûÕâÆªÎÄÕÂÄܹ»×ÊÖúÄãÀÖ³É×°ÖúÍʹÓÃ17cÒ»Æð²ÝÈí¼þ£¬×£ÄãʹÓÃÓä¿ì£¡
У¶Ô£º¿µ»Ô(1C0m4pJyqZtPma0S7t9ZFfz4hTykKag)


