{"id":338,"date":"2009-03-27T12:12:53","date_gmt":"2009-03-27T09:12:53","guid":{"rendered":"http:\/\/blog.yavor.info\/?p=338"},"modified":"2009-03-27T12:32:28","modified_gmt":"2009-03-27T09:32:28","slug":"%d1%85%d0%b0%d1%80%d0%b0%d0%ba%d0%b8%d1%80%d0%b8-%d0%bd%d0%b0-oracle-%d1%81%d0%b5%d1%81%d0%b8%d1%8f","status":"publish","type":"post","link":"http:\/\/blog.yavor.info\/?p=338","title":{"rendered":"\u0425\u0430\u0440\u0430\u043a\u0438\u0440\u0438 \u043d\u0430 Oracle \u0441\u0435\u0441\u0438\u044f"},"content":{"rendered":"<p>\u0422\u043e\u0432\u0430 \u0433\u043e \u0432\u0438\u0434\u044f\u0445 \u043e\u0442 \u0431\u043b\u043e\u0433\u0430 \u043d\u0430 <a href=\"http:\/\/laurentschneider.com\/wordpress\/2009\/03\/commit-suicide.html\">Laurent Schneider<\/a> \ud83d\ude42<\/p>\n<pre lang=\"plsql\">\r\nC:\\>sqlplus system@XXXX\r\n\r\nSQL*Plus: Release 11.1.0.6.0 - Production on \u041f\u0442 \u041c\u0430\u0440\u0442. 27 11:04:46 2009\r\n\r\nCopyright (c) 1982, 2007, Oracle.  All rights reserved.\r\n\r\nEnter password:\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL> select * from dual;\r\n\r\nD\r\n-\r\nX\r\n\r\nSQL> alter session set events 'immediate crash';\r\nalter session set events 'immediate crash'\r\n*\r\nERROR at line 1:\r\nORA-03113: end-of-file on communication channel\r\nProcess ID: 852\r\nSession ID: 135 Serial number: 13\r\n\r\n\r\nSQL>  select * from dual;\r\nERROR:\r\nORA-03114: not connected to ORACLE\r\n<\/pre>\n<p>\u0410 \u0435\u0442\u043e \u0438 <a href=\"http:\/\/blog.tanelpoder.com\/2008\/06\/19\/killing-an-oracle-process-from-inside-oracle\/\">\u0435\u0434\u0438\u043d \u043f\u0440\u0438\u043c\u0435\u0440<\/a> \u043a\u043e\u0433\u0430 \u0442\u0430\u0437\u0438 \u0432\u0440\u0430\u0442\u0438\u0447\u043a\u0430 \u043f\u043e\u043c\u0430\u0433\u0430 \u043d\u0430\u0438\u0441\u0442\u0438\u043d\u0430. \u0412 \u0441\u043b\u0443\u0447\u0430\u044f \u0438\u043c\u0430\u043c\u0435:<br \/>\n&#8211; \u0437\u0430\u043a\u043b\u044e\u0447\u0435\u043d \u0440\u0435\u0441\u0443\u0440\u0441 (\u0442\u0430\u0431\u043b\u0438\u0446\u0430)<br \/>\n&#8211; \u0437\u0430\u043a\u043b\u044e\u0447\u0432\u0430\u043d\u0435\u0442\u043e \u0435 \u043e\u0442 \u0441\u0435\u0441\u0438\u044f, \u043a\u043e\u044f\u0442\u043e \u0435 \u043e\u0442\u043d\u0435\u0441\u043b\u0430 \u043f\u043b\u0443\u0432\u043a\u0430\u0442\u0430 (\u043d\u044f\u043c\u0430 \u0434\u0430 \u0441\u0435 \u0441\u044a\u0431\u0443\u0434\u0438)<br \/>\n&#8211; \u043d\u044f\u043c\u0430\u043c\u0435 \u0434\u043e\u0441\u0442\u044a\u043f \u0434\u043e \u041e\u0421 \u0437\u0430 \u0434\u0430 \u043f\u0443\u0441\u043d\u0435\u043c <em>kill<\/em> \u0438\u043b\u0438 <em>orakill<\/em><\/p>\n<p>\u041d\u0430\u043c\u044a\u043a\u0432\u0430\u043c\u0435 \u0441\u0435 \u0432 \u0441\u0435\u0441\u0438\u044f\u0442\u0430 \u0441 oradebug \u0438 \u043f\u0440\u0430\u0449\u0430\u043c\u0435 \u0441\u044a\u043e\u0442\u0432\u0435\u0442\u043d\u044f\u0438 event:<\/p>\n<pre lang=\"plsql\">\r\nSQL> oradebug setospid 3872;\r\nSQL> oradebug event immediate crash;\r\n<\/pre>\n<p>\u0414\u043e\u0441\u0442\u0430 \u0434\u0435\u0441\u0442\u0440\u0443\u043a\u0442\u0438\u0432\u043d\u043e, \u043d\u043e \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0430\u0442\u0430 \u043f\u043e\u043a\u0430\u0437\u0432\u0430, \u0447\u0435 \u043f\u043e\u043d\u044f\u043a\u043e\u0433\u0430 \u0441\u0435 \u043d\u0430\u043b\u0430\u0433\u0430 (\u0442\u043e \u0437\u0430 \u0442\u043e\u0432\u0430 \u0433\u0438 \u0438\u043c\u0430 <em>kill<\/em> \u0438 <em>orakill<\/em>)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0422\u043e\u0432\u0430 \u0433\u043e \u0432\u0438\u0434\u044f\u0445 \u043e\u0442 \u0431\u043b\u043e\u0433\u0430 \u043d\u0430 <a href=\"http:\/\/laurentschneider.com\/wordpress\/2009\/03\/commit-suicide.html\">Laurent Schneider<\/a> \ud83d\ude42<\/p>\n<p><code>C:\\>sqlplus system@XXXX<\/p>\n<p>SQL*Plus: Release 11.1.0.6.0 - Production on \u041f\u0442 \u041c\u0430\u0440\u0442. 27 11:04:46 2009<\/p>\n<p>Copyright (c) 1982, 2007, Oracle.  All rights reserved.<\/p>\n<p>Enter password:<\/p>\n<p>Connected to:<br \/>\nOracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/p>\n<p>SQL> select * from dual;<\/p>\n<p>D<br \/>\n-<br \/>\nX<\/p>\n<p>SQL> <strong>alter session set events 'immediate crash';<\/strong><br \/>\nalter session set events 'immediate crash'<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-03113: end-of-file on communication channel<br \/>\nProcess ID: 852<br \/>\nSession ID: 135 Serial number: 13<\/p>\n<p>\nSQL>  select * from dual;<br \/>\nERROR:<br \/>\nORA-03114: not connected to ORACLE<\/code><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/338"}],"collection":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=338"}],"version-history":[{"count":0,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/338\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=338"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}