{"id":62,"date":"2011-12-21T15:32:19","date_gmt":"2011-12-21T14:32:19","guid":{"rendered":"http:\/\/dev.qualilogy.com\/en\/?p=62"},"modified":"2013-01-08T17:23:58","modified_gmt":"2013-01-08T16:23:58","slug":"sonar-our-environment","status":"publish","type":"post","link":"http:\/\/qualilogy.com\/en\/sonar-our-environment\/","title":{"rendered":"Sonar &#8211; Our environment"},"content":{"rendered":"<p>This is the first post in a series presenting the installation and the use of Sonar to analyse source code quality.<\/p>\n<p>The objective here is to present our environment and as, a pre-requisite, the creation of an Oracle user. <!--more--><\/p>\n<h3><span style=\"text-decoration: underline\">Environment<\/span><\/h3>\n<p>Windows 7 Profesional SP1, Oracle 11.2, Tomcat 7.0, Java 6. Very close to anything you would find in any customer, except you would probably have a Windows Server.<\/p>\n<p>Tomcat has been installed as a Windows service, so that I just click on a &#8216;Services&#8217; icon to start\/stop\/restart it as I want. <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>Installation has been done on port 8888, in order to avoid conflict with applications that install by defaut on 8080 port. I also have an icon to launch the GUI application (Tomcat7w.exe) to configure Tomcat. Notice the 512 Mb Java memory pool.<\/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-406\" title=\"Tomcat_Properties\" 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>We need an Oracle user so that Sonar will be able to create its own schema. We also want to dedicate a tablespace to this user, for reasons of performance and ease of management. Use your favorite SQL tool. Hereunder the resulting command line instructions.<\/p>\n<ul>\n<li>Creation of a tablespace, 500 Mb autoextended.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><strong>CREATE<\/strong> SMALLFILE <strong>TABLESPACE<\/strong> &#8220;SONAR&#8221; <strong>DATAFILE<\/strong> &#8216;C:\\ORACLE\\ORADATA\\JPORA11\\SONAR.DBS&#8217; <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>Creation of the Sonar user on the previous tablespace, with DBA privilege.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px\"><strong>CREATE<\/strong> <strong>USER<\/strong> &#8220;SONAR&#8221; <strong>PROFILE<\/strong> &#8220;DEFAULT&#8221; <strong>IDENTIFIED<\/strong> <strong>BY<\/strong> &#8220;sonar&#8221; <strong>DEFAULT<\/strong> <strong>TABLESPACE<\/strong> &#8220;SONAR&#8221; <strong>TEMPORARY<\/strong> <strong>TABLESPACE<\/strong> &#8220;TEMP&#8221; <strong>ACCOUNT<\/strong> <strong>UNLOCK<\/strong><br \/>\n<strong>GRANT<\/strong> &#8220;CONNECT&#8221; <strong>TO<\/strong> &#8220;SONAR&#8221;<br \/>\n<strong>GRANT<\/strong> &#8220;DBA&#8221; <strong>TO<\/strong> &#8220;SONAR&#8221;<\/p>\n<p>It is not mandatory to create the Sonar user with DBA profile, but as nothing forbids it, why not.<\/p>\n<p>Next post: <a title=\"Sonar - Installation\" href=\"http:\/\/qualilogy.com\/en\/sonar-installation\/\">Install Sonar<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the first post in a series presenting the installation and the use of Sonar to analyse source code quality. The objective here is to present our environment and as, a pre-requisite, the creation of an Oracle user.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-sonar-installation"],"_links":{"self":[{"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/posts\/62"}],"collection":[{"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":3,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":218,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/posts\/62\/revisions\/218"}],"wp:attachment":[{"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/qualilogy.com\/en\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}