{"id":99,"date":"2011-12-21T11:10:51","date_gmt":"2011-12-21T10:10:51","guid":{"rendered":"http:\/\/dev.qualilogy.com\/fr\/?p=99"},"modified":"2013-01-08T16:58:57","modified_gmt":"2013-01-08T15:58:57","slug":"sonar-notre-environnement","status":"publish","type":"post","link":"http:\/\/qualilogy.com\/fr\/sonar-notre-environnement\/","title":{"rendered":"Sonar &#8211; Notre environnement"},"content":{"rendered":"<p>Premier post d&rsquo;une s\u00e9rie pr\u00e9sentant l&rsquo;installation et l&rsquo;utilisation de Sonar afin de mesurer la qualit\u00e9 d&rsquo;applications.<\/p>\n<p>L&rsquo;objectif est de pr\u00e9senter notre environnement et, comme pr\u00e9-requis, la cr\u00e9ation d&rsquo;un user Oracle. <!--more--><\/p>\n<h3><span style=\"text-decoration: underline\">Environnement<\/span><\/h3>\n<p>Windows 7 Profesional SP1, Oracle 11.2, Tomcat 7.0, Java 6. Tr\u00e8s proche de ce que vous pourriez trouver chez la plupart des clients, sauf que notre installation se ferait probablement sur un serveur Windows avec une version Windows Server.<\/p>\n<p>Tomcat a \u00e9t\u00e9 install\u00e9 en tant que service Windows, de sorte qu&rsquo;il me suffit de clicker sur une ic\u00f4ne &lsquo;Services&rsquo; pour le d\u00e9marrer\/stopper\/relancer.<\/p>\n<p><a href=\"http:\/\/qualilogy.com\/wp-content\/uploads\/2011\/12\/Tomcat_Service.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-405\" title=\"Tomcat_Service\" alt=\"\" src=\"http:\/\/qualilogy.com\/wp-content\/uploads\/2011\/12\/Tomcat_Service.jpg\" width=\"443\" height=\"105\" \/><\/a>L&rsquo;installation a \u00e9t\u00e9 effectu\u00e9e sur le port 8888, afin d&rsquo;\u00e9viter tout conflit avec d&rsquo;autres applications qui s&rsquo;installent par d\u00e9faut sur le port 8080. J&rsquo;ai \u00e9galement une ic\u00f4ne pour lancer Tomcat7w.exe et configurer Tomcat. Remarquez le Java memory pool \u00e1 512 Mo.<\/p>\n<p><a href=\"http:\/\/qualilogy.com\/wp-content\/uploads\/2011\/12\/Tomcat_Properties.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-406title=\" alt=\"\" src=\"http:\/\/qualilogy.com\/wp-content\/uploads\/2011\/12\/Tomcat_Properties.jpg\" width=\"417\" height=\"398\" \/><\/a><\/p>\n<h3><span style=\"text-decoration: underline\">Oracle<\/span><\/h3>\n<p>Il nous faut un user Oracle afin que Sonar puisse cr\u00e9er son propre sch\u00e9ma de base de donn\u00e9es. Nous voulons aussi un tablespace d\u00e9di\u00e9 \u00e1 cet utilisateur, pour des raisons de performance et de facilit\u00e9 de gestion de notre DB. Utiliser votre outil SQL pr\u00e9f\u00e9r\u00e9 pour cr\u00e9er ce user. Ci-dessous, les instructions correspondantes:<\/p>\n<ul>\n<li>Creation du tablespace, 500 Mb autoextended.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><strong>CREATE<\/strong> SMALLFILE <strong>TABLESPACE<\/strong> \u00ab\u00a0SONAR\u00a0\u00bb <strong>DATAFILE<\/strong> &lsquo;C:\\ORACLE\\ORADATA\\JPORA11\\SONAR.DBS&rsquo; <strong>SIZE<\/strong> 500M <strong>AUTOEXTEND<\/strong> <strong>ON<\/strong> <strong>NEXT<\/strong> 50M <strong>MAXSIZE<\/strong> <strong>UNLIMITED<\/strong> <strong>LOGGING<\/strong> <strong>EXTENT<\/strong> <strong>MANAGEMENT<\/strong> <strong>LOCAL<\/strong> <strong>SEGMENT<\/strong> <strong>SPACE<\/strong> <strong>MANAGEMENT<\/strong> AUTO<\/p>\n<ul>\n<li>Cr\u00e9ation du user Sonar sur le tablespace pr\u00e9c\u00e9dent, avec privil\u00e8ges de DBA.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><strong>CREATE<\/strong> <strong>USER<\/strong> \u00ab\u00a0SONAR\u00a0\u00bb <strong>PROFILE<\/strong> \u00ab\u00a0DEFAULT\u00a0\u00bb <strong>IDENTIFIED<\/strong> <strong>BY<\/strong> \u00ab\u00a0sonar\u00a0\u00bb <strong>DEFAULT<\/strong> <strong>TABLESPACE<\/strong> \u00ab\u00a0SONAR\u00a0\u00bb <strong>TEMPORARY<\/strong> <strong>TABLESPACE<\/strong> \u00ab\u00a0TEMP\u00a0\u00bb <strong>ACCOUNT<\/strong> <strong>UNLOCK<\/strong><br \/>\n<strong>GRANT<\/strong> \u00ab\u00a0CONNECT\u00a0\u00bb <strong>TO<\/strong> \u00ab\u00a0SONAR\u00a0\u00bb<br \/>\n<strong>GRANT<\/strong> \u00ab\u00a0DBA\u00a0\u00bb <strong>TO<\/strong> \u00ab\u00a0SONAR\u00a0\u00bb<\/p>\n<p>Il n&rsquo;y a pas d&rsquo;obligation \u00e1 cr\u00e9er le user Sonar avec un profil DBA, mais comme rien ne nous l&rsquo;interdit avec notre propre instance Oracle, autant ne pas s&rsquo;en priver.<\/p>\n<p>Le prochain post sera consacr\u00e9e \u00e1 l&rsquo;<a title=\"Sonar - Installation\" href=\"http:\/\/qualilogy.com\/fr\/sonar-installation\/\">installation de Sonar<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Premier post d&rsquo;une s\u00e9rie pr\u00e9sentant l&rsquo;installation et l&rsquo;utilisation de Sonar afin de mesurer la qualit\u00e9 d&rsquo;applications. L&rsquo;objectif est de pr\u00e9senter notre environnement et, comme pr\u00e9-requis, la cr\u00e9ation d&rsquo;un user Oracle.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-sonar-installation"],"_links":{"self":[{"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/posts\/99"}],"collection":[{"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/comments?post=99"}],"version-history":[{"count":13,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":105,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/posts\/99\/revisions\/105"}],"wp:attachment":[{"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/media?parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/categories?post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/qualilogy.com\/fr\/wp-json\/wp\/v2\/tags?post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}