{"id":1612,"date":"2020-04-29T23:55:52","date_gmt":"2020-04-29T23:55:52","guid":{"rendered":"https:\/\/swiv.com.br\/oracle-database-19c-standalone-installation-on-oracle-linux-7\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"oracle-database-19c-standalone-installation-on-oracle-linux-7","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2020\/04\/29\/oracle-database-19c-standalone-installation-on-oracle-linux-7\/","title":{"rendered":"ORACLE DATABASE 19C STANDALONE INSTALLATION ON ORACLE LINUX 7"},"content":{"rendered":"

No \u00faltimo post, eu abordei a instala\u00e7\u00e3o do GRID 19C (link AQUI<\/a>), e darei a continuidade neste artigo com a instala\u00e7\u00e3o do Oracle Software + Cria\u00e7\u00e3o de Banco de Dados.<\/p>\n\n\n

Resetando usu\u00e1rio oracle:<\/p>\n\n\n

\n[root@oel7 ~]# passwd oracle\nChanging password for user oracle.\nNew password:\nBAD PASSWORD: The password is shorter than 8 characters\nRetype new password:\npasswd: all authentication tokens updated successfully.\n[root@oel7 ~]#\n<\/pre><\/div>\n\n\n
Ajustando bash_profile:<\/p>\n\n\n
\n[oracle@oel7 ~]$ cd\n[oracle@oel7 ~]$ vi .bash_profile\n<\/pre><\/div>\n\n\n
Conte\u00fado:<\/p>\n\n\n
\n# .bash_profile\n \n# Get the aliases and functions\nif [ -f ~\/.bashrc ]; then\n        . ~\/.bashrc\nfi\n \n# User specific environment and startup programs\n \nPATH=$PATH:$HOME\/.local\/bin:$HOME\/bin\n \nexport PATH\n \nORACLE_SID=cortex; export ORACLE_SID\nJAVA_HOME=\/usr\/bin\/java; export JAVA_HOME\nORACLE_BASE=\/oracle\/19.3.0\/base; export ORACLE_BASE\nORACLE_HOME=\/oracle\/19.3.0\/product; export ORACLE_HOME\nORACLE_TERM=xterm; export ORACLE_TERM\nTNS_ADMIN=$ORACLE_HOME\/network\/admin; export TNS_ADMIN\nPATH=.:${JAVA_HOME}\/bin:${PATH}:$HOME\/bin:$ORACLE_HOME\/bin\nPATH=${PATH}:\/usr\/bin:\/bin:\/usr\/local\/bin\nexport PATH\nexport TEMP=\/tmp\nexport TMPDIR=\/tmp\numask 022\n<\/pre><\/div>\n\n\n
Mudando owner do diret\u00f3rio:<\/p>\n\n\n
\n[root@oel7 ~]# chown -R oracle:oinstall \/oracle\/\n[root@oel7 ~]# chmod -R 775 \/oracle\/\n[root@oel7 ~]#\n<\/pre><\/div>\n\n\n
Criando diret\u00f3rio, carregando valores da bash_profile e validando:<\/p>\n\n\n
\n[oracle@oel7 ~]$ mkdir -p \/oracle\/19.3.0\/base\n[oracle@oel7 ~]$ mkdir -p \/oracle\/19.3.0\/product\n[oracle@oel7 ~]$ . .bash_profile\n[oracle@oel7 ~]$ echo $ORACLE_SID ; echo $ORACLE_BASE ; echo $ORACLE_HOME\ncortex\n\/oracle\/19.3.0\/base\n\/oracle\/19.3.0\/product\n[oracle@oel7 ~]$\n<\/pre><\/div>\n\n\n
Ap\u00f3s copiar o bin\u00e1rio para o ambiente, realizando o unzip:<\/p>\n\n\n
\n[oracle@oel7 ~]$ cd $ORACLE_HOME\n[oracle@oel7 product]$ ll\ntotal 2988000\n-rw-r--r--. 1 oracle oinstall 3059705302 Apr 27 22:48 V982063-01.zip\n[oracle@oel7 product]$ unzip V982063-01.zip\n<\/pre><\/div>\n\n\n
Invocando o instalador:<\/p>\n\n\n
\n[oracle@oel7 product]$ export DISPLAY=192.168.0.106:0.0\n[oracle@oel7 product]$ .\/runInstaller &amp;\n[1] 29141\n[oracle@oel7 product]$\n<\/pre><\/div>\n\n\n
Instalar apenas o Software:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Single:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Grupos:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Valida\u00e7\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Vou ignorar a solicita\u00e7\u00e3o de aumento de swap (por ser apenas ambiente de estudos):<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Sum\u00e1rio de instala\u00e7\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Progresso:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Script:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Executado:<\/p>\n\n\n
\n[root@oel7 ~]# \/oracle\/19.3.0\/product\/root.sh\nPerforming root user operation.\n \nThe following environment variables are set as:\n    ORACLE_OWNER= oracle\n    ORACLE_HOME=  \/oracle\/19.3.0\/product\n \nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]:\nThe contents of "dbhome" have not changed. No need to overwrite.\nThe contents of "oraenv" have not changed. No need to overwrite.\nThe contents of "coraenv" have not changed. No need to overwrite.\n \nEntries will be added to the \/etc\/oratab file as needed by\nDatabase Configuration Assistant when a database is created\nFinished running generic part of root script.\nNow product-specific root actions will be performed.\nOracle Trace File Analyzer (TFA - Standalone Mode) is available at :\n    \/oracle\/19.3.0\/product\/bin\/tfactl\n \nNote :\n1. tfactl will use TFA Service if that service is running and user has been granted access\n2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed\n \n[root@oel7 ~]#\n<\/pre><\/div>\n\n\n
Software instalado com sucesso:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Invocando o utilit\u00e1rio gr\u00e1fico dbca:<\/p>\n\n\n
\n[oracle@oel7 product]$ dbca &amp;\n[1] 3586\n[oracle@oel7 product]$\n<\/pre><\/div>\n\n\n
Create database:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Advanced:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
General:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Definindo nome do banco:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Escolhendo o disco ASM para abrigar os dados do banco, al\u00e9m de viabilizar a multiplexa\u00e7\u00e3o dos redo logs e control files:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Definindo a \u00e1rea de FRA e seu tamanho, al\u00e9m de habilitar o archivelog mode e seu destino:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Criando um listener para o banco:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Configurando tamanho da SGA e PGA:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Character set:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Habilitando a op\u00e7\u00e3o para criar os sample schemas:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Senha:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Sum\u00e1rio:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Progresso:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Banco criado com sucesso:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Consultando o novo banco de dados:<\/p>\n\n\n
\n[oracle@oel7 ~]$ ps -ef | grep pmon\ngrid      3360     1  0 20:00 ?        00:00:00 asm_pmon_+ASM\noracle   11300     1  0 20:42 ?        00:00:00 ora_pmon_cortex\noracle   11857  5046  0 20:45 pts\/1    00:00:00 grep --color=auto pmon\n[oracle@oel7 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Apr 29 20:46:36 2020\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL> select instance_name,status from v$instance;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\ncortex           OPEN\n \nSQL>\n<\/pre><\/div>\n\n\n
Editando o \/etc\/oratab:<\/p>\n\n\n
\n[oracle@oel7 ~]$ cat \/etc\/oratab\n#Backup file is  \/grid\/19.3.0\/base\/crsdata\/oel7\/output\/oratab.bak.oel7.grid line added by Agent\n#\n \n \n \n# This file is used by ORACLE utilities.  It is created by root.sh\n# and updated by either Database Configuration Assistant while creating\n# a database or ASM Configuration Assistant while creating ASM instance.\n \n# A colon, ':', is used as the field terminator.  A new line terminates\n# the entry.  Lines beginning with a pound sign, '#', are comments.\n#\n# Entries are of the form:\n#   $ORACLE_SID:$ORACLE_HOME:&lt;N|Y>:\n#\n# The first and second fields are the system identifier and home\n# directory of the database respectively.  The third field indicates\n# to the dbstart utility that the database should , "Y", or should not,\n# "N", be brought up at system boot time.\n#\n# Multiple entries with the same $ORACLE_SID are not allowed.\n#\n#\n+ASM:\/grid\/19.3.0\/product:Y             # line added by Agent\ncortex:\/oracle\/19.3.0\/product:Y\n[oracle@oel7 ~]$\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
No \u00faltimo post, eu abordei a instala\u00e7\u00e3o do GRID 19C (link AQUI), e darei a continuidade neste artigo com a instala\u00e7\u00e3o do Oracle Software + Cria\u00e7\u00e3o de Banco de Dados. Resetando usu\u00e1rio oracle: Ajustando bash_profile: Conte\u00fado: Mudando owner do diret\u00f3rio: Criando diret\u00f3rio, carregando valores da bash_profile e validando: Ap\u00f3s copiar o bin\u00e1rio para o ambiente, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[20],"class_list":["post-1612","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-installation"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1612"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1612\/revisions"}],"predecessor-version":[{"id":9292,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1612\/revisions\/9292"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}