锘??xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>&#22269;&#20135;&#27704;&#20037;&#20813;&#36153;&#39640;&#28165;&#22312;&#32447;&#35266;&#30475;&#44;&#21866;&#21866;&#20813;&#36153;&#35270;&#39057;&#19968;&#21306;&#44;&#20037;&#20037;&#25104;&#20154;&#22269;&#20135;&#31934;&#21697;</title><link>http://www.aygfsteel.com/Glorin/</link><description /><language>zh-cn</language><lastBuildDate>Tue, 17 Jun 2025 19:06:52 GMT</lastBuildDate><pubDate>Tue, 17 Jun 2025 19:06:52 GMT</pubDate><ttl>60</ttl><item><title>浠?IClassFactory 涓?CLSID 涓?{17BCA6E8-A95D-497E-B2F9-AF6AA475916F} 鐨?COM 緇勪歡鍒涘緩瀹炰緥澶辮觸錛屽師鍥犳槸鍑虹幇浠ヤ笅閿欒: c001f011鐨勮В鍐蟲柟娉?/title><link>http://www.aygfsteel.com/Glorin/archive/2017/01/17/432268.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Tue, 17 Jan 2017 05:17:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2017/01/17/432268.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/432268.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2017/01/17/432268.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/432268.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/432268.html</trackback:ping><description><![CDATA[浠婂ぉ鍦ㄧ粰瀹㈡埛鏈嶅姟鍣∕icrosoft SQL Server2008鏁版嵁搴撴湇鍔″櫒娣誨姞緇存姢璁″垝鏃舵姤閿欙細(xì)<div>鍒涘緩緇存姢璁″垝澶辮觸銆?br />------------------------------<br />鍏朵粬淇℃伅:<br />浠?IClassFactory 涓?CLSID 涓?{17BCA6E8-A95D-497E-B2F9-AF6AA475916F} 鐨?COM 緇勪歡鍒涘緩瀹炰緥澶辮觸錛屽師鍥犳槸鍑虹幇浠ヤ笅閿欒: c001f011銆?(Microsoft.SqlServer.ManagedDTS)<br />------------------------------<br />浠?IClassFactory 涓?CLSID 涓?{17BCA6E8-A95D-497E-B2F9-AF6AA475916F} 鐨?COM 緇勪歡鍒涘緩瀹炰緥澶辮觸錛屽師鍥犳槸鍑虹幇浠ヤ笅閿欒: c001f011銆?(Microsoft.SqlServer.ManagedDTS)<br />瑙ｅ喅鏂規(guī)硶錛?br />C:\Documents and Settings\Administrator&gt;regsvr32 "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll"錛?br />錛堟垨鑰?div>C:\Documents and Settings\Administrator&gt;regsvr32 "C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn\DTS.dll"錛?/div></div><img src ="http://www.aygfsteel.com/Glorin/aggbug/432268.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2017-01-17 13:17 <a href="http://www.aygfsteel.com/Glorin/archive/2017/01/17/432268.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>shutdown鐨勫嚑縐嶆柟寮?/title><link>http://www.aygfsteel.com/Glorin/archive/2015/11/02/428023.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Mon, 02 Nov 2015 07:04:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2015/11/02/428023.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/428023.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2015/11/02/428023.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/428023.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/428023.html</trackback:ping><description><![CDATA[<div><p>1銆乻hutdown normal&nbsp; <br />&nbsp;&nbsp; 姝ｅ父鏂瑰紡鍏抽棴鏁版嵁搴撱�?nbsp;</p> <p><br />2銆乻hutdown immediate&nbsp; <br />&nbsp;&nbsp; 绔嬪嵆鏂瑰紡鍏抽棴鏁版嵁搴撱�?nbsp; <br />&nbsp;&nbsp; 鍦⊿VRMGRL涓墽琛宻hutdown immediate錛屾暟鎹簱騫朵笉绔嬪嵆鍏抽棴錛?nbsp; <br />&nbsp;&nbsp; 鑰屾槸鍦∣racle鎵ц鏌愪簺娓呴櫎宸ヤ綔鍚庢墠鍏抽棴錛堢粓姝細(xì)璇濄�侀噴鏀句細(xì)璇濊祫婧愶級(jí)錛?nbsp; <br />&nbsp;&nbsp; 褰撲嬌鐢╯hutdown涓嶈兘鍏抽棴鏁版嵁搴撴椂錛宻hutdown immediate鍙互瀹屾垚鏁版嵁搴撳叧闂殑鎿嶄綔銆?<br />&nbsp;</p> <p>3銆乻hutdown abort&nbsp; <br />&nbsp;&nbsp; 鐩存帴鍏抽棴鏁版嵁搴擄紝姝ｅ湪璁塊棶鏁版嵁搴撶殑浼?xì)璇濅細(xì)琚H佺劧緇堟錛?nbsp; <br />&nbsp;&nbsp; 濡傛灉鏁版嵁搴撲腑鏈夊ぇ閲忔搷浣滄鍦ㄦ墽琛岋紝榪欐椂鎵цshutdown abort鍚庯紝閲嶆柊鍚姩鏁版嵁搴撻渶瑕佸緢闀挎椂闂?<br />-------------------------------------------------------- <br /><strong>shutdown abort </strong><strong>鐨勬椂鍊欙紝璺?/strong><strong>kill </strong><strong>榪涚▼鏄竴鏍風(fēng)殑鏁堟灉</strong><strong> <br /></strong>鏁版嵁搴撶珛鍗沖叧闂紝榪欎釜鏃跺�欐枃浠剁姸鎬佸彲鑳戒笉涓�鑷?<br />鍥犱負(fù)姝ｅ父鍏抽棴鏁版嵁搴撲細(xì)鍚屾鏍￠獙鍚勬枃浠訛紝浣垮緱閲嶆柊鍚姩鐨勬椂鍊欐枃浠舵椂闂寸偣涓�鑷村茍涓斾笉鐢ㄨ繘琛屽穿婧冩仮澶?/p> <p>鑻ユ鏌ョ偣淇℃伅涓�鑷達(dá)紝鍒欏仛宕╂簝鎭㈠ <br />鑻ユ鏌ョ偣淇℃伅涓嶄竴鑷達(dá)紙姝ｅソ鍦ㄦ洿鏂版枃浠跺ご錛夊垯闇�瑕佸仛浠嬭川鎭㈠</p> <p>榪欎簺闂閮藉ソ澶勭悊錛屾渶鎬曠殑闂鏄繖涓椂鍊欑郴緇熸湁澶ч噺IO錛岀粨鏋滆繖鏍烽�犳垚鍐欑殑紿佺劧涓柇錛岀宸ч�犳垚鏂囦歡鍧楃殑閫昏緫鍧忓潡錛岄偅楹葷儲(chǔ)姣旇緝澶т竴浜涳紝灝ゅ叾鏄郴緇熻〃絀洪棿鐨刡lock鎹熷潖</p> <p><br />铏界劧shutdown abort 鍑洪敊鐨勫嚑鐜囧緢灝忥紝1000涓漢鍙兘鍙湁涓�涓漢紕板埌錛屼絾鏄垜浠繕鏄灝忓績銆?<br />姝ｇ‘鐨勫鐞嗘祦紼嬫槸錛宻hutdown immediate ,鑻ユ暟鎹簱榪熻繜涓嶈兘down涓嬫潵錛屽湪os涓婅瀵烮O鐘跺喌錛屽嚑涔庢病鏈塱o鐨勬椂鍊欙紝鍙﹀紑涓�紿楀彛shutdown&nbsp; abort 錛屽嚑涔庝笉浼?xì)鍑洪棶棰樹?br />--------------------------------------------------------<br /><a  target="_blank">http://www.itpub.net/showthread.php?threadid=180315&amp;pagenumber</a>=&nbsp; <br />鍏堢敤IMMEDIATE鏉OWN錛屽疄鍦ㄤ笉琛屼簡錛岀湅涓�涓嬫暟鎹簱鏂囦歡涓婃病IO浜嗭紝鍐嶇敤ABORT&nbsp; <br />------------------------------------------------------------------------------<br />浣犲彲浠ュ皾璇曞厛鍦ㄧ郴緇熺駭鏉�鎺夐潪鍚庡彴Oracle榪涚▼錛屽湪榪炴帴shutdown immediate灝卞畨鍏ㄥ浜?/p> <p>鍦∣racle8i閲岋紝褰撴暟鎹簱澶卞幓鍝嶅簲浠ュ悗錛屼綘鍦ㄦ搷浣滅郴緇熶笂鏉�鎺夌敤鎴瘋繘紼嬪悗錛屼竴鑸暟鎹簱灝卞彲浠ユ仮澶嶆甯鎬簡 <br />-------------------------------------------------------------------------------<br />鍏?shutdown immediate 搴旇鏄閫?/p> <p>鐒跺悗涓嶈鍐嶉噸鏂皊hutdown abort</p> <p>鍏跺疄璧蜂笉鏉ヤ篃鏄洜涓簅s鐨勭紭鏁咃紝鍦ㄦ枃浠舵鍦ㄥ啓鐨勬椂鍊欏嚭鐜伴棶棰樺鑷存枃浠朵笉涓�鑷存垨鑰呮崯鍧?#8230;&#8230;</p></div><img src ="http://www.aygfsteel.com/Glorin/aggbug/428023.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2015-11-02 15:04 <a href="http://www.aygfsteel.com/Glorin/archive/2015/11/02/428023.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>mysql鏁版嵁搴撳鍑烘椂鎶ラ敊mysqldump: Got error: 145鐨勮В鍐蟲柟娉?/title><link>http://www.aygfsteel.com/Glorin/archive/2015/09/30/427564.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Wed, 30 Sep 2015 01:56:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2015/09/30/427564.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/427564.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2015/09/30/427564.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/427564.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/427564.html</trackback:ping><description><![CDATA[鍦ㄧ粰mysql鏁版嵁搴撳浠芥椂錛屾姤閿欙細(xì)mysqldump: Got error: 145: Table './jxzhtopenfire/ofoffline' is marked as crashed and should be repaired when using LOCK TABLES銆?br />濡備笂閿欒鐨勮В鍐蟲柟娉曞涓嬶細(xì)<br />1銆佽繘鍏ユ暟鎹簱瀵硅琛ㄨ繘琛屾嫻嬶細(xì)<br />mysql&gt; check tables ofoffline;<br />+-------------------------+-------+----------+-------------------------------------------------------+<br />| Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Op&nbsp;&nbsp;&nbsp; | Msg_type | Msg_text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />+-------------------------+-------+----------+-------------------------------------------------------+<br />| jxzhtopenfire.ofoffline | check | warning&nbsp; | Table is marked as crashed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />| jxzhtopenfire.ofoffline | check | warning&nbsp; | 1 client is using or hasn't closed the table properly |<br />| jxzhtopenfire.ofoffline | check | error&nbsp;&nbsp;&nbsp; | Record at pos: 1175720 is not remove-marked&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />| jxzhtopenfire.ofoffline | check | error&nbsp;&nbsp;&nbsp; | record delete-link-chain corrupted&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />| jxzhtopenfire.ofoffline | check | error&nbsp;&nbsp;&nbsp; | Corrupt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />+-------------------------+-------+----------+-------------------------------------------------------+<br />5 rows in set<br />2銆佷嬌鐢╮epair瑙ｅ喅鏂規(guī)硶錛?br />mysql&gt; repair table ofoffline;<br />+-------------------------+--------+----------+------------------------------------------+<br />| Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Op&nbsp;&nbsp;&nbsp;&nbsp; | Msg_type | Msg_text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />+-------------------------+--------+----------+------------------------------------------+<br />| jxzhtopenfire.ofoffline | repair | warning&nbsp; | Number of rows changed from 2349 to 2451 |<br />| jxzhtopenfire.ofoffline | repair | status&nbsp;&nbsp; | OK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br />+-------------------------+--------+----------+------------------------------------------+<br />鍐嶆榪涜dump澶囦喚灝卞彲浠ヤ簡銆?br /><br />澶囦喚mysql鏁版嵁搴撴椂鎶ラ敊錛歮ysqldump: Got error: 145: Table './jxzhtopenfire/ofoffline' is marked as crashed and should be repaired when using LOCK TABLES銆?br />
<p>榪欐牱鐨勯敊璇�?br /><wbr>鎼滅儲(chǔ)浜嗕竴涓嬶紝鍙戠幇鍙鍦╩ysqldump鐨勬椂鍊欏姞涓?-lock-tables=false灝卞彲浠ヨВ鍐抽棶棰樸�?br />mysqldump -u root -pMyPassword DbName --lock-tables=false &gt; data.sql</p><img src ="http://www.aygfsteel.com/Glorin/aggbug/427564.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2015-09-30 09:56 <a href="http://www.aygfsteel.com/Glorin/archive/2015/09/30/427564.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>ORA-01113: file 26 needs media recovery瑙ｅ喅鏂規(guī)硶</title><link>http://www.aygfsteel.com/Glorin/archive/2013/09/26/404453.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Thu, 26 Sep 2013 01:49:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2013/09/26/404453.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/404453.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2013/09/26/404453.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/404453.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/404453.html</trackback:ping><description><![CDATA[闂錛?br />
<p>SQL&gt; startup<br />ORACLE instance started.</p>
<p>Total System Global Area&nbsp; 538514184 bytes<br />Fixed Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 451336 bytes<br />Variable Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 503316480 bytes<br />Database Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33554432 bytes<br />Redo Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1191936 bytes<br />Database mounted.<br />ORA-01113: file 26 needs media recovery<br />ORA-01110: data file 26: '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'<br />瑙ｅ喅鏂規(guī)硶錛?br /></p>
<p>SQL&gt; recover datafile '/opt/ora9/product/oradata/NTDB/EXAMPLE02.dbf'<br />ORA-00279: change 244674111 generated at 09/24/2013 15:20:41 needed for thread<br />1<br />ORA-00289: suggestion : /opt/ora9/product/oracle/dbs/arch1_1123.dbf<br />ORA-00280: change 244674111 for thread 1 is in sequence #1123</p>
<p><br />Specify log: {&lt;RET&gt;=suggested | filename | AUTO | CANCEL}<br />auto<br />Log applied.<br />Media recovery complete.<br />SQL&gt; alter database open;</p>
<p>Database altered.</p><img src ="http://www.aygfsteel.com/Glorin/aggbug/404453.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2013-09-26 09:49 <a href="http://www.aygfsteel.com/Glorin/archive/2013/09/26/404453.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>oracle9i鍦ㄨ繘琛屽叏搴撳浠芥椂鍑虹幇EXP-00008: ORACLE error 1187 encountered鐨勮В鍐沖姙娉?/title><link>http://www.aygfsteel.com/Glorin/archive/2013/06/17/400625.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Mon, 17 Jun 2013 01:58:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2013/06/17/400625.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/400625.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2013/06/17/400625.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/400625.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/400625.html</trackback:ping><description><![CDATA[oracle9i鍦ㄨ繘琛屾暟鎹簱鍏ㄥ簱澶囦喚鏃跺嚭鐜板涓嬮敊璇細(xì)<br />
<p>Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production<br />With the Partitioning, OLAP and Oracle Data Mining options<br />JServer Release 9.2.0.8.0 - Production<br />Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set</p>
<p>About to export the entire database ...<br />. exporting tablespace definitions<br />EXP-00008: ORACLE error 1187 encountered<br />ORA-01187: cannot read from file 201 because it failed verification tests<br />ORA-01110: data file 201: '/opt/ora9/product/oradata/NTDB/temp1.dbf'<br />EXP-00000: Export terminated unsuccessfully<br />浠庝笂闈㈢殑閿欒淇℃伅鍙互鐪嬪嚭鏄痶emp涓存椂琛ㄧ┖闂寸殑鏁版嵁鏂囦歡鏈夐棶棰橈紝瑙ｅ喅鍔炴硶錛?br />1銆佸垹闄や復(fù)鏃惰〃絀洪棿錛?nbsp;alter database tempfile '/opt/ora9/product/oradata/NTDB/temp1.dbf' drop;<br />2銆侀噸寤烘暟鎹枃浠訛細(xì)<br />alter tablespace temp add tempfile '/opt/ora9/product/oradata/NTDB/temp01.dbf' size 512M REUSE AUTOEXTEND ON NEXT&nbsp; 1M MAXSIZE UNLIMITED;<br />閫氳繃涓婅堪涓や釜姝ラ灝卞彲浠ヨВ鍐沖湪榪涜鏁版嵁搴撳浠芥椂鍑虹幇鐨凮RACLE error 1187 encountered閿欒銆?/p><img src ="http://www.aygfsteel.com/Glorin/aggbug/400625.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2013-06-17 09:58 <a href="http://www.aygfsteel.com/Glorin/archive/2013/06/17/400625.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>oracle10G闅廘inux緋葷粺鍚姩鑰岃嚜鍔ㄥ惎鍔?/title><link>http://www.aygfsteel.com/Glorin/archive/2012/08/31/386662.html</link><dc:creator>Glorin</dc:creator><author>Glorin</author><pubDate>Fri, 31 Aug 2012 02:04:00 GMT</pubDate><guid>http://www.aygfsteel.com/Glorin/archive/2012/08/31/386662.html</guid><wfw:comment>http://www.aygfsteel.com/Glorin/comments/386662.html</wfw:comment><comments>http://www.aygfsteel.com/Glorin/archive/2012/08/31/386662.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/Glorin/comments/commentRss/386662.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/Glorin/services/trackbacks/386662.html</trackback:ping><description><![CDATA[<div>1銆佹煡鐪?etc/oratab榪欎釜鏂囦歡錛?br />
<p>[oracle@readhatAS53 etc]$ cat /etc/oratab <br />#</p>
<p>&nbsp;</p>
<p># This file is used by ORACLE utilities.&nbsp; It is created by root.sh<br /># and updated by the Database Configuration Assistant when creating<br /># a database.</p>
<p># A colon, ':', is used as the field terminator.&nbsp; A new line terminates<br /># the entry.&nbsp; Lines beginning with a pound sign, '#', are comments.<br />#<br /># Entries are of the form:<br />#&nbsp;&nbsp; $ORACLE_SID:$ORACLE_HOME:&lt;N|Y&gt;:<br />#<br /># The first and second fields are the system identifier and home<br /># directory of the database respectively.&nbsp; The third filed indicates<br /># to the dbstart utility that the database should , "Y", or should not,<br /># "N", be brought up at system boot time.<br />#<br /># Multiple entries with the same $ORACLE_SID are not allowed.<br />#<br />#<br />ORCL:/u01/oracle/product/ora10g:Y<br />褰?ORACLE_SID:$ORACLE_HOME:&lt;N|Y&gt; 璁劇疆涓篩鏃訛紝鍏佽瀹炰緥鑷惎鍔紝褰撹緗負(fù)N鏃訛紝鍒欎笉鍏佽鑷惎鍔ㄣ�?榪欎釜鏂囦歡閲岀殑閰嶇疆浠呬粎璧蜂竴涓紑鍏崇殑浣滅敤錛屽叾騫朵笉浼?xì)鍏蜂綋鐨勬墽琛屽惎鍔ㄥ拰鍏抽棴锛屽叿浣撶殑鎿嶄綔鐢?ORACLE_HOME/bin/dbstart鍜宒bshut 鑴氭湰鏉ュ疄鐜般�?榪?涓剼鏈湪鎵ц鏃朵細(xì)媯�(gè)鏌?etc/oratab 鏂囦歡閲岀殑閰嶇疆錛屼負(fù)Y鏃舵墠鑳界戶緇墽琛屻�傚洜姝ゅ彧瑕佸皢ORCL:/u01/oracle/product/ora10g:N淇敼涓篩灝辮浜嗐�?br />2銆佷嬌鐢╮oot鐢ㄦ埛鍦?font face="Verdana">/etc/rc.d/rc.local榪欎釜鏂囦歡涓坊鍔犲涓嬪唴瀹癸細(xì)<br /></font></p>
<p>#!/bin/sh<br />#<br /># This script will be executed *after* all the other init scripts.<br /># You can put your own initialization stuff in here if you don't<br /># want to do the full Sys V style init stuff.</p>
<p>touch /var/lock/subsys/local<br />su - oracle -c'lsnrctl start'//鍚姩oracle鏁版嵁搴撶洃鍚?br />su - oracle -c'/u01/oracle/product/ora10g/bin/dbstart start'//鍚姩oracle鏁版嵁搴撳疄渚?br />su - oracle -c'/opt/tomcat/apache-tomcat-6.0.20/bin/startup.sh'//鍚姩tomcat鏈嶅姟鍣ㄧ殑閰嶇疆銆?br /><br />3銆乺eboot緋葷粺錛宱racle鏁版嵁搴撲笌tomcat鏈嶅姟鍣ㄥ氨鍙互鑷姩鍚姩浜嗐�?br /></p></div><img src ="http://www.aygfsteel.com/Glorin/aggbug/386662.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/Glorin/" target="_blank">Glorin</a> 2012-08-31 10:04 <a href="http://www.aygfsteel.com/Glorin/archive/2012/08/31/386662.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss>                                                                  <footer>
<div class="friendship-link">
<a href="http://www.aygfsteel.com/" title="&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;">&#29408;&#29408;&#20037;&#20037;&#20122;&#27954;&#27431;&#32654;&#19987;&#21306;&#95;&#20013;&#25991;&#23383;&#24149;&#20122;&#27954;&#32508;&#21512;&#20037;&#20037;&#50;&#48;&#50;&#95;&#22269;&#20135;&#31934;&#21697;&#20122;&#27954;&#31532;&#20116;&#21306;&#22312;&#32447;&#95;&#26085;&#26412;&#20813;&#36153;&#32593;&#31449;&#35270;&#39057;</a>

</div>

</footer>


主站蜘蛛池模板：
<a href="http://" target="_blank">兰州市</a>|
<a href="http://" target="_blank">铅山县</a>|
<a href="http://" target="_blank">保亭</a>|
<a href="http://" target="_blank">襄樊市</a>|
<a href="http://" target="_blank">肥城市</a>|
<a href="http://" target="_blank">莱芜市</a>|
<a href="http://" target="_blank">廉江市</a>|
<a href="http://" target="_blank">浙江省</a>|
<a href="http://" target="_blank">陕西省</a>|
<a href="http://" target="_blank">嘉峪关市</a>|
<a href="http://" target="_blank">桂东县</a>|
<a href="http://" target="_blank">淮滨县</a>|
<a href="http://" target="_blank">庆阳市</a>|
<a href="http://" target="_blank">建平县</a>|
<a href="http://" target="_blank">陆丰市</a>|
<a href="http://" target="_blank">新安县</a>|
<a href="http://" target="_blank">晋城</a>|
<a href="http://" target="_blank">池州市</a>|
<a href="http://" target="_blank">阳信县</a>|
<a href="http://" target="_blank">资中县</a>|
<a href="http://" target="_blank">镇雄县</a>|
<a href="http://" target="_blank">麻阳</a>|
<a href="http://" target="_blank">石台县</a>|
<a href="http://" target="_blank">石狮市</a>|
<a href="http://" target="_blank">涿州市</a>|
<a href="http://" target="_blank">河曲县</a>|
<a href="http://" target="_blank">屏东县</a>|
<a href="http://" target="_blank">名山县</a>|
<a href="http://" target="_blank">布拖县</a>|
<a href="http://" target="_blank">呼伦贝尔市</a>|
<a href="http://" target="_blank">重庆市</a>|
<a href="http://" target="_blank">安达市</a>|
<a href="http://" target="_blank">湘西</a>|
<a href="http://" target="_blank">桐庐县</a>|
<a href="http://" target="_blank">长沙市</a>|
<a href="http://" target="_blank">礼泉县</a>|
<a href="http://" target="_blank">盐津县</a>|
<a href="http://" target="_blank">连山</a>|
<a href="http://" target="_blank">丰原市</a>|
<a href="http://" target="_blank">遂溪县</a>|
<a href="http://" target="_blank">嘉禾县</a>|
<script>
(function(){
    var bp = document.createElement('script');
    var curProtocol = window.location.protocol.split(':')[0];
    if (curProtocol === 'https') {
        bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
    }
    else {
        bp.src = 'http://push.zhanzhang.baidu.com/push.js';
    }
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(bp, s);
})();
</script>
</body>