{"id":1103,"date":"2015-09-10T11:41:48","date_gmt":"2015-09-10T09:41:48","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=1103"},"modified":"2015-09-10T11:41:48","modified_gmt":"2015-09-10T09:41:48","slug":"add-tablespace","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/09\/10\/add-tablespace\/","title":{"rendered":"Add tablespace"},"content":{"rendered":"<p>Add tablespace oracle<\/p>\n<p><a href=\"http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1.png\"><img decoding=\"async\" class=\"alignleft size-full wp-image-1102\" alt=\"add_tablespace\" src=\"http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1.png\" width=\"1232\" height=\"473\" srcset=\"http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1.png 1232w, http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1-300x115.png 300w, http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1-768x295.png 768w, http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1-1024x393.png 1024w, http:\/\/les-fougs.com\/wordpress\/wp-content\/uploads\/2015\/09\/add_tablespace-1-1200x461.png 1200w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/a><\/p>\n<p>La limite physique g\u00e9r\u00e9e par Oracle est de 32Go.<br \/>\nQuand on arrive \u00e0 cette limite il faut en cr\u00e9er nouveau.<\/p>\n<p>&nbsp;<\/p>\n<pre>----------------------------------------------\n Recherche des erreurs dans les log\n----------------------------------------------\n\nFile : \/soft\/oracle\/diag\/diag\/rdbms\/zabprd\/ZABPRD\/trace\/alert_ZABPRD.log\nmonth : Sep\nyear : 2015\nday : 13\nerror : ORA-\nnom de lignes dans le fichier log :  14775247\nErreur trouv\u00e9e en ligne :  14774733\nSun Sep 13 00:01:30 2015\nStarting background process VKRM\nSun Sep 13 00:01:30 2015\nVKRM started with pid=28, OS id=20244 \nSun Sep 13 00:01:44 2015\nORA-1652: unable to extend temp segment by 128 in tablespace                 IDX \nORA-1652: unable to extend temp segment by 128 in tablespace                 IDX \nSun Sep 13 00:01:45 2015\nStarting ORACLE instance (restrict)\nSun Sep 13 00:01:45 2015\nThread 1 advanced to log sequence 24884 (LGWR switch)\n  Current log# 2 seq# 24884 mem# 0: \/data3\/oracle\/ZABPRD\/redo02a.rdo<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Add tablespace oracle La limite physique g\u00e9r\u00e9e par Oracle est de 32Go. Quand on arrive \u00e0 cette limite il faut en cr\u00e9er nouveau. &nbsp; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- Recherche des erreurs dans les log &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- File : \/soft\/oracle\/diag\/diag\/rdbms\/zabprd\/ZABPRD\/trace\/alert_ZABPRD.log month : Sep year : 2015 day : 13 error : ORA- nom de lignes dans le fichier log : &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/09\/10\/add-tablespace\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Add tablespace&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1103"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1103"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1103\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}