{"id":142,"date":"2018-04-18T16:55:05","date_gmt":"2018-04-18T19:55:05","guid":{"rendered":"http:\/\/wordpress.rodrigosilvaesilva.com.br\/?p=142"},"modified":"2018-04-18T16:55:05","modified_gmt":"2018-04-18T19:55:05","slug":"instalacao-oracle-xe","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/18\/instalacao-oracle-xe\/","title":{"rendered":"Instala\u00e7\u00e3o Oracle XE"},"content":{"rendered":"<p>Instala\u00e7\u00e3o Oracle XE<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E17781_01\/install.112\/e18802\/toc.htm#XEINL110\" target=\"_blank\" rel=\"noopener\">Documenta\u00e7\u00e3o Oficial<\/a><\/p>\n<p><strong>Instala\u00e7\u00e3o Pacotes Requeridos<\/strong><\/p>\n<p><strong>Packages<\/strong><\/p>\n<ul>\n<li style=\"text-align: left;\"><code>glibc<\/code> should be greater than or equal to <code>2.3.4-2.41<\/code><\/li>\n<li style=\"text-align: left;\"><code>make<\/code> should be greater than or equal to <code>3.80<\/code><\/li>\n<li style=\"text-align: left;\"><code>binutils<\/code> should be greater than or equal to <code>2.16.91.0.5<\/code><\/li>\n<li style=\"text-align: left;\"><code>gcc<\/code> should be greater than or equal to <code>4.1.2<\/code><\/li>\n<li style=\"text-align: left;\"><code>libaio<\/code> should be greater than or equal to <code>0.3.104<\/code><\/li>\n<\/ul>\n<pre class=\"lang:sh decode:true\">[root@bdxe~]# yum -y install glibc make binutils gcc libaio\n\nDependencies Resolved\n\n==========================================================================================================================\n Package                         Arch                   Version                          Repository                  Size\n==========================================================================================================================\nUpdating:\n binutils                        x86_64                 2.27-27.base.el7                 ol7_latest                 5.9 M\n gcc                             x86_64                 4.8.5-28.0.1.el7                 ol7_latest                  16 M\n glibc                           x86_64                 2.17-222.el7                     ol7_latest                 3.6 M\nUpdating for dependencies:\n cpp                             x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 6.0 M\n gcc-c++                         x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 7.2 M\n glibc-common                    x86_64                 2.17-222.el7                     ol7_latest                  11 M\n glibc-devel                     x86_64                 2.17-222.el7                     ol7_latest                 1.1 M\n glibc-headers                   x86_64                 2.17-222.el7                     ol7_latest                 678 k\n libgcc                          x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 100 k\n libgomp                         x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 156 k\n libstdc++                       x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 303 k\n libstdc++-devel                 x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 1.5 M\n\nTransaction Summary\n==========================================================================================================================\nUpgrade  3 Packages (+9 Dependent packages)\n\nTotal download size: 54 M\nIs this ok [y\/d\/N]: y\n<\/pre>\n<p>Adicionar os seguintes par\u00e2metros de Kernel<\/p>\n<pre class=\"lang:sh decode:true\">[root@bdxe~]# vim \/etc\/sysctl.conf\n\nkernel.sem = 250 32000 100 128\nkernel.shmmni = 4096\nfs.file-max = 6815744\nnet.ipv4.ip_local_port_range = 9000 65500<\/pre>\n<p>Baixar Oracle <strong>XE<\/strong>: <a href=\"http:\/\/www.oracle.com\/technetwork\/database\/database-technologies\/express-edition\/downloads\/index.html\" target=\"_blank\" rel=\"noopener\">Download<\/a><\/p>\n<p>Descompactar o arquivo: oracle-xe-11.2.0-1.0.x86_64.rpm.zip<\/p>\n<pre class=\"lang:sh decode:true\">[root@bdxe \/]# unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip\nArchive:  oracle-xe-11.2.0-1.0.x86_64.rpm.zip\n   creating: Disk1\/\n   creating: Disk1\/upgrade\/\n  inflating: Disk1\/upgrade\/gen_inst.sql\n   creating: Disk1\/response\/\n  inflating: Disk1\/response\/xe.rsp\n  inflating: Disk1\/oracle-xe-11.2.0-1.0.x86_64.rpm<\/pre>\n<p>Instalar com o RPM -ivh<\/p>\n<pre class=\"lang:sh decode:true\">[root@bdxe \/]# rpm -ivh Disk1\/oracle-xe-11.2.0-1.0.x86_64.rpm\nPreparing...                ########################################### [100%]\n   1:oracle-xe              ########################################### [100%]\nExecuting post-install steps...\nYou must run '\/etc\/init.d\/oracle-xe configure' as the root user to configure the database.\n<\/pre>\n<p>Executar etapa p\u00f3s instala\u00e7\u00e3o com usu\u00e1rio <strong>root<\/strong>.<\/p>\n<pre class=\"lang:sh decode:true\">[root@bdxe \/]# \/etc\/init.d\/oracle-xe configure\n\nOracle Database 11g Express Edition Configuration\n-------------------------------------------------\nThis will configure on-boot properties of Oracle Database 11g Express\nEdition.  The following questions will determine whether the database should\nbe starting upon system boot, the ports it will use, and the passwords that\nwill be used for database accounts.  Press &lt;Enter&gt; to accept the defaults.\nCtrl-C will abort.\n\nSpecify the HTTP port that will be used for Oracle Application Express [8080]:\n\nSpecify a port that will be used for the database listener [1521]:\n\nSpecify a password to be used for database accounts.  Note that the same\npassword will be used for SYS and SYSTEM.  Oracle recommends the use of\ndifferent passwords for each database account.  This can be done after\ninitial configuration:\nConfirm the password:\n\nDo you want Oracle Database 11g Express Edition to be started on boot (y\/n) [y]:y\n\nStarting Oracle Net Listener...Done\nConfiguring database...Done\nStarting Oracle Database 11g Express Edition instance...Done\nInstallation completed successfully.\n<\/pre>\n<p>Login usu\u00e1rio\u00a0 oracle<\/p>\n<pre class=\"lang:sh decode:true\">[root@localhost \/]# su - oracle\n-bash-4.1$ sqlplus \/ as sysdba\n-bash: sqlplus: command not found\n-bash-4.1$ source product\/11.2.0\/xe\/bin\/oracle_env.sh\n-bash-4.1$ sqlplus \/ AS SYSDBA\n<\/pre>\n<p>Consultando a view v$instance<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt; select status from v$instance;\n\nSTATUS\n------------\nOPEN\n<\/pre>\n<p>Consultar nome inst\u00e2ncia<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt; SELECT * FROM GLOBAL_NAME;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\nXE\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Fonte:<a href=\"http:\/\/nervinformatica.com.br\/blog\/index.php\/2014\/03\/05\/oracle-xe-database-configuration-failed\/\" target=\"_blank\" rel=\"noopener\">Portilho &#8211; Nerv Inform\u00e1tica<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\"><strong>\u00a0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instala\u00e7\u00e3o Oracle XE Documenta\u00e7\u00e3o Oficial Instala\u00e7\u00e3o Pacotes Requeridos Packages glibc should be greater than or equal to 2.3.4-2.41 make should be greater than or equal to 3.80 binutils should be greater than or equal to 2.16.91.0.5 gcc should be greater than or equal to 4.1.2 libaio should be greater than or equal to 0.3.104 [root@bdxe~]#&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[157,285,386],"class_list":["post-142","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-instalacao-oracle-xe","tag-oracle-xe","tag-xe"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/142\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}