{"id":417,"date":"2016-07-02T20:01:25","date_gmt":"2016-07-02T23:01:25","guid":{"rendered":"http:\/\/wordpress.jpcorp.eti.br\/?p=417"},"modified":"2021-12-26T12:31:33","modified_gmt":"2021-12-26T15:31:33","slug":"aprendendo-oracle-12c-instalacao","status":"publish","type":"post","link":"https:\/\/wordpress.jpcorp.eti.br\/?p=417","title":{"rendered":"Oracle &#8211; Aprendendo Instala\u00e7\u00e3o do 12c"},"content":{"rendered":"<p style=\"text-align: justify;\">Instala\u00e7\u00e3o do Oracle 12c no Oracle Linux 7, se atentarem nas observa\u00e7\u00f5es abaixo:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Vari\u00e1veis: Acertar conforme seu ambiente o \".bashrc\" e scripts de \"startup.sh\", \"shutdown.sh\" e \"dbora.service\", e dar aten\u00e7\u00e3o em todos detalhes, inclusive no final da ORACLE_BASE e ORACLE_HOME no \"\/\" se tiver pode apresentar algum erro de sintaxe por estar duplicando a \"\/\".<\/li>\n<li style=\"text-align: justify;\">Hostname: N\u00e3o esquecer de acertar o arquivos \"hosts\" e ficar atento nos locais que \u00e9 colocado o hostname.<\/li>\n<li style=\"text-align: justify;\">Listener: Nome do servi\u00e7o deve ser igual ao da Inst\u00e2ncia, caso esteja divergente pode ter os erros ORA-00119 e ORA-00132 [SQL&gt; ORA-00119: invalid specification for system parameter LOCAL_LISTENER | syntax error or unresolved network name 'NOME']. (No v\u00eddeo coloquei divergente e tive o problema, mais um aprendizado pra conta)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>1 - Prepara\u00e7\u00e3o ambiente para instala\u00e7\u00e3o Oracle<\/h3>\n<pre class=\"lang:sh decode:true\">[root@srv01 ~]# yum -y update\r\n[root@srv01 ~]# setenforce Permissive\r\n[root@srv01 ~]# vim \/etc\/selinux\/config\r\n\t\t\t\tSELINUX=permissive\r\n[root@srv01 ~]# firewall-cmd --add-port=1521\/tcp --permanent\r\n[root@srv01 ~]# firewall-cmd --reload\r\n[root@srv01 ~]# vim \/etc\/fstab\r\n\t\t\t\ttmpfs \/dev\/shm tmpfs defaults,size=3G 0 0\r\n[root@srv01 ~]# mount -o remount tmpfs\r\n[root@srv01 ~]# vim \/etc\/hosts\r\n\t\t\t\t192.168.200.13 srv01.labs.eti.br srv01\r\n[root@srv01 ~]# yum -y install oracle-rdbms-server-12cR1-preinstall\r\n[root@srv01 ~]# less \/etc\/sysctl.conf\r\n[root@srv01 ~]# grep oracle \/etc\/passwd\r\n[root@srv01 ~]# mkdir \/u01\/\r\n[root@srv01 ~]# chown -R oracle:oracle \/u01\/<\/pre>\n<h3>2 - Download do pacote e instala\u00e7\u00e3o<\/h3>\n<pre class=\"lang:sh decode:true\">[oracle@srv01 ~]# cd \/u01\/\r\n[oracle@srv01 ~]# wget http:\/\/download.oracle.com\/otn\/linux\/oracle12c\/121020\/linuxamd64_12102_database_1of2.zip\r\n[oracle@srv01 ~]# wget http:\/\/download.oracle.com\/otn\/linux\/oracle12c\/121020\/linuxamd64_12102_database_2of2.zip\r\n[oracle@srv01 ~]# unzip linuxamd64_12102_database_1of2.zip &amp;&amp; unzip linuxamd64_12102_database_2of2.zip;\r\n[oracle@srv01 ~]# cd database\/\r\n[oracle@srv01 ~]# .\/runInstaller<\/pre>\n<h3>3 - Criar configura\u00e7\u00e3o do Listener<\/h3>\n<pre class=\"lang:sh decode:true\">[oracle@srv01 ~]# cd \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/bin\r\n[oracle@srv01 ~]# .\/netca<\/pre>\n<h3>4 - Criar Base de dados<\/h3>\n<pre class=\"lang:sh decode:true \">[oracle@srv01 ~]# cd \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/bin\r\n[oracle@srv01 ~]# .\/dbca<\/pre>\n<h3>5 - V\u00eddeo instala\u00e7\u00e3o<\/h3>\n<p><iframe loading=\"lazy\" title=\"Instala\u00e7\u00e3o Oracle 12c\" src=\"https:\/\/player.vimeo.com\/video\/173167050?dnt=1&amp;app_id=122963\" width=\"644\" height=\"362\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write\"><\/iframe><\/p>\n<h3>6 - P\u00f3s instala\u00e7\u00e3o, vari\u00e1veis e unit systemd<\/h3>\n<pre class=\"lang:sh decode:true \">[root@srv01 ~]# vim \/home\/oracle\/.bashrc\r\n# Oracle\r\nexport VISUAL=\"vim\"\r\nexport EDITOR=\"vim\"\r\nexport TMP=\/tmp\r\nexport TMPDIR=$TMP\r\nexport ORACLE_BASE=\/u01\/app\/oracle\r\nexport ORACLE_HOME=$ORACLE_BASE\/product\/12.1.0\/dbhome_1\r\nexport ORACLE_SID=syserp\r\nexport ORACLE_TERM=xterm\r\nexport PATH=$ORACLE_HOME\/bin:\/usr\/sbin:$PATH\r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib;\r\nexport CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib;\r\nexport ORACLE_OWNER=oracle\r\n\r\n# User specific aliases and functions\r\nalias sqlplus=\"rlwrap sqlplus\"\r\nalias vi=\"vim\"\r\n\r\n[root@srv01 ~]# vim \/lib\/systemd\/system\/dbora.service\r\n[Unit]\r\nDescription=The Oracle Database Service\r\nAfter=syslog.target network.target\r\n\r\n[Service]\r\n# systemd ignores PAM limits, so set any necessary limits in the service.\r\n# Not really a bug, but a feature.\r\n# https:\/\/bugzilla.redhat.com\/show_bug.cgi?id=754285\r\nLimitMEMLOCK=infinity\r\nLimitNOFILE=65535\r\n\r\nType=simple\r\nRemainAfterExit=yes\r\nUser=oracle\r\nGroup=oinstall\r\nExecStart=\/home\/oracle\/scripts\/startup.sh &gt;&gt; \/home\/oracle\/scripts\/startup_shutdown.log 2&gt;&amp;1 &amp;\r\nExecStop=\/home\/oracle\/scripts\/shutdown.sh &gt;&gt; \/home\/oracle\/scripts\/startup_shutdown.log 2&gt;&amp;1\r\n\r\n[Install]\r\nWantedBy=multi-user.target\r\n\r\n[root@srv01 ~]# mkdir \/home\/oracle\/scripts\/\r\n[root@srv01 ~]# vim \/home\/oracle\/scripts\/startup.sh\r\n#!\/bin\/bash\r\nexport TMP=\/tmp\r\nexport TMPDIR=$TMP\r\nexport PATH=\/usr\/sbin:\/usr\/local\/bin:$PATH\r\nexport ORACLE_HOSTNAME=srv01.labs.eti.br\r\nexport ORACLE_UNQNAME=srv01\r\n\r\nexport ORACLE_SID=syserp\r\nORAENV_ASK=NO\r\n. oraenv\r\nORAENV_ASK=YES\r\n\r\n# Start Listener\r\nlsnrctl start\r\n\t\t\r\n# Start Database\r\nsqlplus \/ as sysdba &lt;&lt; EOF\r\nSTARTUP;\r\nEXIT;\r\nEOF\r\n\r\n[root@srv01 ~]# vim \/home\/oracle\/scripts\/shutdown.sh\r\n#!\/bin\/bash\r\nexport TMP=\/tmp\r\nexport TMPDIR=$TMP\r\nexport PATH=\/usr\/sbin:\/usr\/local\/bin:$PATH\r\nexport ORACLE_HOSTNAME=srv01.labs.eti.br\r\nexport ORACLE_UNQNAME=srv01\r\n\r\nexport ORACLE_SID=syserp\r\nORAENV_ASK=NO\r\n. oraenv\r\nORAENV_ASK=YES\r\n\r\n# Stop Database\r\nsqlplus \/ as sysdba &lt;&lt; EOF\r\nSHUTDOWN IMMEDIATE;\r\nEXIT;\r\nEOF\r\n\r\n# Stop Listener\r\nlsnrctl stop\r\n\r\n[root@srv01 ~]# chmod +x \/home\/oracle\/scripts\/*\r\n[root@srv01 ~]# chown -R oracle:oinstall \/home\/oracle\/scripts\/\r\n[root@srv01 ~]# systemctl status dbora\r\n\u25cf dbora.service - The Oracle Database Service\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/dbora.service; disabled; vendor preset: disabled)\r\n   Active: inactive (dead)\r\n[root@srv01 ~]# systemctl enable dbora\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/dbora.service to \/usr\/lib\/systemd\/system\/dbora.service.\r\n[root@srv01 ~]# systemctl stop dbora\r\n[root@srv01 ~]# systemctl start dbora\r\n[root@srv01 ~]# systemctl status dbora\r\n\u25cf dbora.service - The Oracle Database Service\r\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/dbora.service; enabled; vendor preset: disabled)\r\n   Active: active (running) since S\u00e1b 2016-07-02 19:21:15 BRT; 7s ago<\/pre>\n<h3>7 - Listener<\/h3>\n<p style=\"text-align: justify;\">Listener \u00e9 o servi\u00e7o de rede do Oracle, ao qual abre conex\u00e3o e roda na porta 1521\/tcp por padr\u00e3o, abaixo comando e arquivos para troubleshooting:<\/p>\n<pre class=\"lang:sh decode:true\">[oracle@srv01 ~]$ lsnrctl status\r\n[oracle@srv01 ~]$ ll \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/listener.ora\r\n[oracle@srv01 ~]$ ll \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/network\/admin\/tnsnames.ora<\/pre>\n<h3>8 - Opera\u00e7\u00f5es no banco<\/h3>\n<pre class=\"lang:sh decode:true \"># Modos de login\r\nsqlplus \/ as sysdba\r\nsqlplus sys as sysdba\r\nsqlplus system\/senha@instancia\r\n\r\n# Iniciar instancia, verificar status, baixar\r\nSQL&gt; startup;\r\nSQL&gt; shutdown immediate\r\nSQL&gt; select status from v$instance;\r\nSQL&gt; select INSTANCE_NAME, status from v$instance;\r\n\r\n# Verificar arquivos Control File\r\nSQL&gt; show parameter control;\r\nSQL&gt; show parameter control_file;\r\n\r\n# Consultar local dos Datafiles\r\nSQL&gt; set line 200;\r\nSQL&gt; col name for a50;\r\nSQL&gt; select FILE#, TS#, name from v$datafile;\r\n\r\n# Verificar status dos Redo Logs\r\nSQL&gt; col member for a40;\r\nSQL&gt; select GROUP#, STATUS, TYPE, MEMBER from v$logfile;\r\n\r\n# Pular de Redo Log\r\nSQL&gt; alter system switch logfile;\r\n\r\n# Checar todos Redo Log e inativar\r\nSQL&gt; alter system checkpoint;\r\n\r\n# Listar inst\u00e2ncias\r\nSQL&gt; select sys_context('USERENV','INSTANCE_NAME') from dual;\r\n\r\n# Listar Databases\r\nSQL&gt; SELECT NAME FROM v$database;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"lang:mysql decode:true\"># Desbloquear usuario\r\nSQL&gt; set line 200;\r\nSQL&gt; col username for a50;\r\nSQL&gt; select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';\r\nSQL&gt; ALTER USER zabbix IDENTIFIED BY senha;\r\nSQL&gt; ALTER USER zabbix ACCOUNT UNLOCK;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"lang:sh decode:true \"># RMAN\r\n\r\n# Logar no RMAN\r\n$ rman target \/\r\n\r\n# Apagar archivelog\r\n$ RMAN&gt; delete archivelog all;\r\n\r\n# Caso seja apagado via rm os archives deve ser executado o comando abaixo para acertar as referencias\r\n$ RMAN&gt; crosscheck archivelog all;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>9 - Pacote rlwrap<\/h3>\n<p style=\"text-align: justify;\">O pacote \"rlwrap\" acerta o sqlplus para podemos trabalhar o hist\u00f3rico e maior facilidade no manuseio dentro dele:<\/p>\n<pre class=\"lang:sh decode:true\">[root@srv01 ~]# wget http:\/\/dl.fedoraproject.org\/pub\/epel\/7\/x86_64\/e\/epel-release-7-7.noarch.rpm\r\n[root@srv01 ~]# rpm -ivh epel-release-7-7.noarch.rpm\r\n[root@srv01 ~]# yum -y install rlwrap\r\n[root@srv01 ~]# vim \/home\/oracle\/.bashrc\r\n                    alias sqlplus=\"rlwrap sqlplus\"<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3>10 -\u00a0ADRCI Oracle<\/h3>\n<p>http:\/\/www.dba-oracle.com\/t_linux_oracle_adr_directory.htm<\/p>\n<p>14400 = minutos = 30 dias<br \/>\n720 = horas<br \/>\n8760 = horas<\/p>\n<pre class=\"lang:sh decode:true \">[root@oracle]# su - oracle                                                                                                                  \r\n[oracle@oracle ~]$ adrci\r\nadrci&gt; set home diag\/rdbms\/orcl\/orcl\r\nadrci&gt; select SHORTP_POLICY,LONGP_POLICY from ADR_CONTROL;\r\nadrci&gt; set control (SHORTP_POLICY=168);\r\nadrci&gt; set control (LONGP_POLICY=720);\r\nadrci&gt; purge -age 14400<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instala\u00e7\u00e3o do Oracle 12c no Oracle Linux 7, se atentarem nas observa\u00e7\u00f5es abaixo: Vari\u00e1veis: Acertar conforme seu ambiente o &#8220;.bashrc&#8221; e scripts de &#8220;startup.sh&#8221;, &#8220;shutdown.sh&#8221; e &#8220;dbora.service&#8221;, e dar aten\u00e7\u00e3o em todos detalhes, inclusive no final da ORACLE_BASE e ORACLE_HOME no &#8220;\/&#8221; se tiver pode apresentar algum erro de sintaxe por estar duplicando a &#8220;\/&#8221;&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,40],"tags":[67,68,9,69,29],"class_list":["post-417","post","type-post","status-publish","format-standard","hentry","category-linux","category-oracle","tag-adrci","tag-dbca","tag-linux","tag-netca","tag-oracle"],"_links":{"self":[{"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/posts\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=417"}],"version-history":[{"count":19,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.jpcorp.eti.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}