{"id":840,"date":"2014-04-24T00:26:50","date_gmt":"2014-04-24T03:26:50","guid":{"rendered":"http:\/\/www.viazap.com.br\/?p=840"},"modified":"2014-04-23T19:31:19","modified_gmt":"2014-04-23T22:31:19","slug":"dspace-no-ubuntu-12-04-instalacao-via-banco-de-dados-oracle-11g","status":"publish","type":"post","link":"https:\/\/blog.clusterweb.com.br\/?p=840","title":{"rendered":"DSpace no Ubuntu 12.04 &#8211; Instala\u00e7\u00e3o via Banco de Dados Oracle 11g"},"content":{"rendered":"<table border=\"0\" width=\"100%\" cellspacing=\"3\" cellpadding=\"3\">\n<tbody>\n<tr>\n<td colspan=\"2\"><b>Introdu\u00e7\u00e3o<\/b><\/p>\n<div>\n<p>O\u00a0<em>DSpace<\/em>\u00a0\u00e9 um reposit\u00f3rio digital constru\u00eddo para indexa\u00e7\u00e3o, preserva\u00e7\u00e3o e compartilhamento de produ\u00e7\u00f5es intelectuais em formato digital, tais como: imagens, artigos, teses, disserta\u00e7\u00f5es, v\u00eddeos e etc, permitindo a disponibiliza\u00e7\u00e3o destes conte\u00fados na Internet.<\/p>\n<p>O sistema DSpace \u00e9 utilizado, principalmente, como reposit\u00f3rio institucional e desempenha alguns pap\u00e9is importantes:<\/p>\n<ul>\n<li>Facilita o dep\u00f3sito e a gest\u00e3o dos documentos;<\/li>\n<li>Agiliza o acesso aos documentos atrav\u00e9s de listas e pesquisas;<\/li>\n<li>Aumenta a preserva\u00e7\u00e3o dos documentos ao longo do tempo;<\/li>\n<li>Possibilita a publica\u00e7\u00e3o r\u00e1pida de produ\u00e7\u00f5es cient\u00edficas;<\/li>\n<li>Aumenta a visibilidade da produ\u00e7\u00e3o cientifica;<\/li>\n<li>Centraliza\u00e7\u00e3o das produ\u00e7\u00f5es cient\u00edficas em um \u00fanico local;<\/li>\n<li>Facilita a quantifica\u00e7\u00e3o de quantos downloads foram efetuados para cada uma das produ\u00e7\u00f5es e quantas vezes foram visualizadas;<\/li>\n<li>Possibilita definir um identificador \u00fanico para cada documento.<\/li>\n<\/ul>\n<p>Refer\u00eancias:\u00a0<a href=\"http:\/\/projeto.rcaap.pt\/formar\/mod1\/contents\/o_sistema_dspace.html\">projeto.rcaap.pt &#8211; sistema_dspace.html<\/a><\/p>\n<p>A instala\u00e7\u00e3o foi constru\u00edda no seguinte cen\u00e1rio:<\/p>\n<ul>\n<li>Distribui\u00e7\u00e3o\/Vers\u00e3o de S.O:\u00a0Ubuntu 12.04.4 LTS<\/li>\n<li>Aplica\u00e7\u00e3o\/Vers\u00e3o:\u00a0dspace-4.1-release<\/li>\n<li>Banco\/Vers\u00e3o:\u00a0Banco de dados Oracle 11g release (11.2)<\/li>\n<\/ul>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><b>Instala\u00e7\u00e3o de depend\u00eancias<\/b><\/p>\n<div>\n<p>1. Atualize a lista de pacotes dos reposit\u00f3rios do Ubuntu\u00a0<a href=\"http:\/\/www.vivaolinux.com.br\/linux\/\">Linux<\/a>:<\/p>\n<p><strong>$ sudo apt-get upadete<\/strong><!--more--><\/p>\n<p>2. Instale o JDK:<\/p>\n<p><strong>$ sudo apt-get install openjdk-7-jdk<\/strong><\/p>\n<p>3. Instale o Tomcat 6:<\/p>\n<p><strong>$ sudo apt-get install tomcat6 tomcat6-admin tomcat6-common tomcat6-user tomcat6-docs tomcat6-examples<\/strong><\/p>\n<p>4. Instale o Apache Ant e o Maven:<\/p>\n<p><strong>$ sudo apt-get install ant maven2<\/strong><\/p>\n<p>5. Edite o arquivo do Tomcat\u00a0\/etc\/tomcat6\/server.xml, alterando a forma de conex\u00e3o com a aplica\u00e7\u00e3o e criando os contextos necess\u00e1rios para o DSpace:<\/p>\n<p><strong># vim \/etc\/tomcat6\/server.xml<\/strong><\/p>\n<div class=\"codigo\">&lt;Connector port=&#8221;8080&#8243; protocol=&#8221;HTTP\/1.1&#8243;<br \/>\nmaxThreads=&#8221;150&#8243;<br \/>\nminSpareThreads=&#8221;25&#8243;<br \/>\nmaxSpareThreads=&#8221;75&#8243;<br \/>\nenableLookups=&#8221;false&#8221;<br \/>\nredirectPort=&#8221;8443&#8243;<br \/>\nacceptCount=&#8221;100&#8243;<br \/>\nconnectionTimeout=&#8221;20000&#8243;<br \/>\ndisableUploadTimeout=&#8221;true&#8221;<br \/>\nURIEncoding=&#8221;UTF-8&#8243;\/&gt;&lt;Host name=&#8221;localhost&#8221; appBase=&#8221;webapps&#8221;<br \/>\nunpackWARs=&#8221;true&#8221; autoDeploy=&#8221;true&#8221;<br \/>\nxmlValidation=&#8221;false&#8221; xmlNamespaceAware=&#8221;false&#8221;&gt;<\/p>\n<p>&lt;Context path=&#8221;\/xmlui&#8221; docBase=&#8221;\/dspace\/webapps\/xmlui&#8221; allowLinking=&#8221;true&#8221;\/&gt;<br \/>\n&lt;Context path=&#8221;\/jspui&#8221; docBase=&#8221;\/dspace\/webapps\/jspui&#8221; allowLinking=&#8221;true&#8221;\/&gt;<br \/>\n&lt;Context path=&#8221;\/solr&#8221; docBase=&#8221;\/dspace\/webapps\/solr&#8221; allowLinking=&#8221;true&#8221;\/&gt;<\/p>\n<\/div>\n<p>6. Fa\u00e7a a download do DSpace via browser, ou atrav\u00e9s do Wget:<\/p>\n<p>Obs.: lembrando que este tutorial foi baseado na release 4.1.<\/p>\n<ul>\n<li><a href=\"http:\/\/sourceforge.net\/projects\/dspace\/files\/DSpace%20Stable\/4.1\/dspace-4.1-src-release.zip\/download\">http:\/\/sourceforge.net\/projects\/dspace\/files\/DSpace%20Stable\/4.1\/dspace-4.1-src-release.zip\/download<\/a><\/li>\n<\/ul>\n<p>Ou:<\/p>\n<p><strong># wget<\/strong>\u00a0<a href=\"http:\/\/sourceforge.net\/projects\/dspace\/files\/DSpace%20Stable\/4.1\/dspace-4.1-src-release.zip\">http:\/\/sourceforge.net\/projects\/dspace\/files\/DSpace%20Stable\/4.1\/dspace-4.1-src-release.zip<\/a><\/p>\n<p>7. Descompacte o arquivo:<\/p>\n<p><strong># unzip dspace-4.1-src-release.zip<\/strong><\/p>\n<p>8. Crie o usu\u00e1rio do DSpace:<\/p>\n<p><strong># useradd -m dspace<\/strong><\/p>\n<p>9. Crie na raiz\u00a0\/\u00a0o diret\u00f3rio\u00a0dspace, neste local ser\u00e1 instalada a aplica\u00e7\u00e3o:<\/p>\n<p><strong># mkdir dspace<\/strong><\/p>\n<p>10. Baixe o cliente Oracle no site:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.oracle.com\/technetwork\/topics\/linuxx86-64soft-092277.html\">http:\/\/www.oracle.com\/technetwork\/topics\/linuxx86-64soft-092277.html<\/a><\/li>\n<\/ul>\n<p>Baixe os pacotes:<\/p>\n<ul>\n<li>oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm<\/li>\n<li>oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm<\/li>\n<li>oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm<\/li>\n<li>oracle-instantclient11.2-precomp-11.2.0.4.0-1.x86_64.rpm<\/li>\n<li>oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm<\/li>\n<li>oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm<\/li>\n<\/ul>\n<p>11. No site da Oracle, s\u00f3 existe dispon\u00edvel pacotes no formato\u00a0.rpm, ent\u00e3o, ser\u00e1 necess\u00e1rio convert\u00ea-los em\u00a0.deb\u00a0e, na sequ\u00eancia, instal\u00e1-los.<\/p>\n<p>Exemplo:<\/p>\n<p><strong># alien oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm<br \/>\n# dpkg -i oracle-instantclient11.2-basic_11.2.0.4.0-2_amd64.deb<\/strong><\/p>\n<p>Fa\u00e7a este procedimento para todos os pacotes.<\/p>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><b>tnsnames \/ ojdbc6.jar \/ build.properties<\/b><\/p>\n<div>\n<h1>Cria\u00e7\u00e3o do arquivo &#8220;tnsnames&#8221;<\/h1>\n<p>12. Crie o arquivo de\u00a0tnsnames\u00a0do Oracle e inclua as informa\u00e7\u00f5es do seu banco:<\/p>\n<p><strong># touch \/usr\/lib\/oracle\/11.2\/client64\/lib\/network\/admin\/tnsnames.ora<\/strong><\/p>\n<div class=\"codigo\">DSNV =<br \/>\n(DESCRIPTION =<br \/>\n(LOAD_BALANCE = YES)<br \/>\n(ADDRESS_LIST =<br \/>\n(ADDRESS = (PROTOCOL = TCP)(HOST =)(PORT = 1521))<br \/>\n)<br \/>\n(CONNECT_DATA =<br \/>\n(SERVICE_NAME = ***** )<br \/>\n(FAILOVER_MODE =<br \/>\n(TYPE = SELECT)<br \/>\n(METHOD = BASIC)<br \/>\n(RETRIES = 20)<br \/>\n(DELAY = 3)<br \/>\n)<br \/>\n)<br \/>\n)<\/div>\n<p>13. Acesse o arquivo do\u00a0dspace-4.1-src-release:<\/p>\n<p><strong># cd dspace-4.1-src-release<\/strong><\/p>\n<p>Para instalar o DSpace com um banco Oracle \u00e9 um pouco diferente, voc\u00ea vai precisar fazer o download do driver JDBC Oracle, mas, em vez de copi\u00e1-lo em um diret\u00f3rio\u00a0lib, voc\u00ea precisar\u00e1 instal\u00e1-lo em seu reposit\u00f3rio local Maven.<\/p>\n<h1>Instala\u00e7\u00e3o do ojdbc6.jar<\/h1>\n<p>Acesse o site abaixo e fa\u00e7a o download do arquivo\u00a0ojdbc6.jar:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/jdbc-112010-090769.html\">Oracle Database 11g Release 2 JDBC Driver Downloads Document<\/a><\/li>\n<\/ul>\n<p>14. Instale o\u00a0ojdbc6.jar\u00a0com o seguinte comando:<\/p>\n<p><strong># mvn install:install-file -Dfile=ojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.3.0 -Dpackaging=jar -DgeneratePom=true<\/strong><\/p>\n<p>Obs.: todo o comando na mesma linha.<\/p>\n<p>15. Voc\u00ea precisa recompilar o DSpace com um driver Oracle\u00a0ojdbc6.jar\u00a0correspondente \u00e0 sua vers\u00e3o do Oracle. Atualize a vers\u00e3o, conforme abaixo:<\/p>\n<p><strong># vim dspace-4.1-src-release\/pom.xml<\/strong><\/p>\n<div class=\"codigo\">&lt;dependency&gt;<br \/>\n&lt;groupId&gt;com.oracle&lt;\/groupId&gt;<br \/>\n&lt;artifactId&gt;ojdbc6&lt;\/artifactId&gt;<br \/>\n&lt;version&gt;11.2.0.3.0&lt;\/version&gt;<br \/>\n&lt;\/dependency&gt;<\/div>\n<h1>Edi\u00e7\u00e3o do build.properties<\/h1>\n<p>16. Acesse o\u00a0dspace-4.1-src-release\u00a0e edite o arquivo\u00a0build.properties. Este arquivo de propriedades, cont\u00e9m as configura\u00e7\u00f5es b\u00e1sicas necess\u00e1rias para a realiza\u00e7\u00e3o da constru\u00e7\u00e3o\/instala\u00e7\u00e3o do DSpace pela primeira vez.<\/p>\n<p><strong># cd dspace-4.1-src-release<br \/>\n# vim build.properties<\/strong><\/p>\n<div class=\"codigo\">dspace.install.dir=\/dspace<br \/>\ndspace.hostname = &lt;seu dom\u00ednio&gt;<br \/>\nspace.baseUrl = http:\/\/&lt;seu dom\u00ednio&gt;:8080<br \/>\ndspace.name = DSpace &lt; nome da sua institui\u00e7\u00e3o &gt;<br \/>\nsolr.server=http:\/\/&lt;seu dom\u00ednio&gt;:8080\/solr<br \/>\ndefault.language = pt_BR<br \/>\ndb.name=oracle<br \/>\ndb.driver= oracle.jdbc.OracleDriver<br \/>\ndb.url=jdbc:oracle:thin:@\/\/&lt;nome do seu banco&gt;:1521\/&lt;SID do banco de dados definido no tnsnames.ora&gt;<br \/>\ndb.username=&lt;usu\u00e1rio do Banco&gt;<br \/>\ndb.password=&lt;senha do bando&gt;<br \/>\ndb.schema = &lt;esquema do Banco&gt;<br \/>\ndb.maxconnections = 30<br \/>\nmail.server = smtp.&lt;seu servidor smtp&gt;.com.br<br \/>\nmail.server.username = &lt;e-mail valido para aplica\u00e7\u00e3o usar &gt;<br \/>\nmail.server.password = &lt;senha do e-mail&gt;<br \/>\nalert.recipient =<br \/>\nregistration.notify =<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"2\"><b>Constru\u00e7\u00e3o do banco e instala\u00e7\u00e3o do DSpace<\/b><\/p>\n<div>\n<p>17. Com o comando abaixo, vamos construir e gerar o pacote de instala\u00e7\u00e3o do DSpace:<\/p>\n<p><strong># cd \/dspace-4.1-src-release\/dspace\/<br \/>\n# mvn package<\/strong><\/p>\n<p>18. Por padr\u00e3o, o DSpace foi criado para inicializar a instala\u00e7\u00e3o em um banco PostgreSQL. Como vamos usar um banco Oracle, mais especificamente o 11.2g, ser\u00e1 necess\u00e1rio recompilar a instala\u00e7\u00e3o.<\/p>\n<p>Fa\u00e7a o seguinte comando:<\/p>\n<p><strong># mvn &#8211; Ddb.name = pacote Oracle<\/strong><\/p>\n<p>19. O pr\u00f3ximo comando ir\u00e1 instalar e inicializar a base de dados do DSpace:<\/p>\n<p>Obs.: o usu\u00e1rio do banco necessita de GRANT completo, pois trata-se de um pacote (fechado) que cria novas tabelas.<\/p>\n<p><strong># cd dspace-4.1-src-release\/dspace\/target\/dspace-4.1-build<br \/>\n# ant fresh_install<\/strong><\/p>\n<p>20. Vamos criar uma conta de administrador no DSpace:<\/p>\n<p><strong># \/dspace\/bin\/dspace create-administrator<\/strong><\/p>\n<p>21. Defina as permiss\u00f5es para o Apache Tomcat. Depois, reinicie o servi\u00e7o de aplica\u00e7\u00e3o:<\/p>\n<p><strong># chown tomcat6:tomcat6 \/dspace -R<br \/>\n# service tomcat6 restart<\/strong><\/p>\n<p>22. Abra a aplica\u00e7\u00e3o, pronta para ser utilizada:<\/p>\n<ul>\n<li>http:\/\/localhost:8080\/jspui\/<\/li>\n<li>http:\/\/locolhost:8080\/xmlui\/<\/li>\n<\/ul>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introdu\u00e7\u00e3o O\u00a0DSpace\u00a0\u00e9 um reposit\u00f3rio digital constru\u00eddo para indexa\u00e7\u00e3o, preserva\u00e7\u00e3o e compartilhamento de produ\u00e7\u00f5es intelectuais em formato digital, tais como: imagens, artigos, teses, disserta\u00e7\u00f5es, v\u00eddeos e etc, permitindo a disponibiliza\u00e7\u00e3o destes conte\u00fados na Internet. O sistema DSpace \u00e9 utilizado, principalmente, como reposit\u00f3rio institucional e desempenha alguns pap\u00e9is importantes: Facilita o dep\u00f3sito e a gest\u00e3o dos documentos; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[91,1,42,51,571,271],"tags":[573,93,572,181,361,575,273,574],"class_list":["post-840","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-viazap","category-leitura-recomendada","category-linux-linuxrs","category-oracle","category-seguranca-2","tag-12-04","tag-banco-de-dados-2","tag-dspace","tag-instalacao","tag-no","tag-oracle-11g","tag-ubuntu","tag-via"],"_links":{"self":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=840"}],"version-history":[{"count":3,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/840\/revisions"}],"predecessor-version":[{"id":843,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/840\/revisions\/843"}],"wp:attachment":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}