{"id":787,"date":"2020-03-17T22:52:38","date_gmt":"2020-03-17T22:52:38","guid":{"rendered":"https:\/\/swiv.com.br\/instalacao-do-oracle-software-criacao-de-banco-de-dados-12-1-0-2\/"},"modified":"2026-05-27T20:02:54","modified_gmt":"2026-05-27T19:02:54","slug":"instalacao-do-oracle-software-criacao-de-banco-de-dados-12-1-0-2","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2020\/03\/17\/instalacao-do-oracle-software-criacao-de-banco-de-dados-12-1-0-2\/","title":{"rendered":"Instala\u00e7\u00e3o do Oracle Software + Cria\u00e7\u00e3o de Banco de Dados 12.1.0.2 Standalone"},"content":{"rendered":"

As instala\u00e7\u00f5es novas que ser\u00e3o demonstradas aqui utilizaram um ambiente GRID Infrastructure que foi criado neste ARTIGO<\/a>.<\/p>\n\n\n

Caso voc\u00ea n\u00e3o tenha as m\u00eddias de instala\u00e7\u00e3o, pode realizar o download conforme abaixo:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Escolhendo vers\u00e3o 12.1.0.2:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Ap\u00f3s o check-out:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Aceitando os termos:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Criando os diret\u00f3rios:<\/p>\n\n\n

\n[user@hostname 12.1.0.2]$ mkdir -p \/oracle\/12.1.0\/product\n[user@hostname 12.1.0.2]$ mkdir -p \/oracle\/12.1.0\/base\n<\/pre><\/div>\n\n\n
Editando a bash_profile:<\/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=XXXXX\nORACLE_BASE=\/oracle\/12.1.0\/base\nORACLE_HOME=\/oracle\/12.1.0\/product\nGRID_HOME=$ORACLE_HOME\nORA_CRS_HOME=$ORACLE_HOME\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib\nPATH=$ORACLE_HOME\/bin:$PATH\n \nexport ORACLE_SID ORACLE_BASE ORACLE_HOME GRID_HOME LD_LIBRARY_PATH PATH\n \nalias ll='ls -l --color'\nalias home='cd $ORACLE_HOME'\nalias base='cd $ORACLE_BASE'\nalias sql='sqlplus "\/ as sysdba"'\nalias crs='cd $ORACLE_HOME\/bin'\nalias tns='cd $ORACLE_HOME\/network\/admin'\nalias asmtrace='cd $ORACLE_BASE\/diag\/asm\/+asm\/+ASM1\/trace'\n<\/pre><\/div>\n\n\n
Carregando a bash_profile:<\/p>\n\n\n
\n[user@hostname ~]$ . .bash_profile\n[user@hostname ~]$\n<\/pre><\/div>\n\n\n
Ap\u00f3s o dowload das m\u00eddias, as copiei para o ORACLE_HOME:<\/p>\n\n\n
\n[user@hostname product]$ pwd\n\/oracle\/12.1.0\/product\n[user@hostname product]$ ll\ntotal 2625088\n-rwxr-xr-x 1 user oinstall 1673544724 Mar  7 13:08 V46095-01_1of2.zip\n-rwxr-xr-x 1 user oinstall 1014530602 Mar  7 13:09 V46095-01_2of2.zip\n<\/pre><\/div>\n\n\n
Descompactando:<\/p>\n\n\n
\n[user@hostname product]$ unzip V46095-01_1of2.zip\nArchive:  V46095-01_1of2.zip\n   creating: database\/\n   creating: database\/rpm\/\n. . . \ninflating: database\/stage\/sizes\/oracle.server12.1.0.2.0SE.sizes.properties\n extracting: database\/stage\/sizes\/oracle.server.Custom.sizes.properties\n \n \n[user@hostname product]$ unzip V46095-01_2of2.zip\nArchive:  V46095-01_2of2.zip\n   creating: database\/stage\/Components\/oracle.ctx\/\n   creating: database\/stage\/Components\/oracle.ctx\/12.1.0.2.0\/\n. . . \n \n inflating: database\/stage\/Components\/oracle.javavm.containers\/12.1.0.2.0\/1\/DataFiles\/filegroup1.jar\n  inflating: database\/install\/.oui\n<\/pre><\/div>\n\n\n
As m\u00eddias podem ser removidas. Com a descompacta\u00e7\u00e3o, foi criada a pasta database:<\/p>\n\n\n
\n[user@hostname product]$ ll\ntotal 2625092\ndrwxr-xr-x 7 user oinstall 4096 Jul 7 2014 database\n-rwxr-xr-x 1 user oinstall 1673544724 Mar 7 13:08 V46095-01_1of2.zip\n-rwxr-xr-x 1 user oinstall 1014530602 Mar 7 13:09 V46095-01_2of2.zip\n[user@hostname product]$ rm -rf V46095-01_1of2.zip V46095-01_2of2.zip\n<\/pre><\/div>\n\n\n
Entrando na pasta database, realizando o EXPORT DISPLAY e chamando o instalador:<\/p>\n\n\n
\n[user@hostname product]$ cd database\/\n[user@hostname database]$ ll\ntotal 36\ndrwxr-xr-x  4 user oinstall 4096 Mar  7 13:17 install\ndrwxrwxr-x  2 user oinstall 4096 Jul  7  2014 response\ndrwxr-xr-x  2 user oinstall 4096 Jul  7  2014 rpm\n-rwxr-xr-x  1 user oinstall 8533 Jul  7  2014 runInstaller\ndrwxrwxr-x  2 user oinstall 4096 Jul  7  2014 sshsetup\ndrwxr-xr-x 14 user oinstall 4096 Jul  7  2014 stage\n-rwxr-xr-x  1 user oinstall  500 Feb  6  2013 welcome.html\n[user@hostname database]$ export DISPLAY=XXX.XX.XX.XXX:0.0\n[user@hostname database]$ .\/runInstaller &amp;\n[1] 2612\n[user@hostname database]$ Starting Oracle Universal Installer...\n \nChecking Temp space: must be greater than 500 MB.   Actual 4605 MB    Passed\nChecking swap space: must be greater than 150 MB.   Actual 11718 MB    Passed\nChecking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed\nPreparing to launch Oracle Universal Installer from \/tmp\/OraInstall2020-03-07_01-20-48PM. Please wait ...\n[user@hostname database]$\n<\/pre><\/div>\n\n\n
Instalador:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Selecionando a op\u00e7\u00e3o de instalar apenas o Software:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Dessa vez, ser\u00e1 a instala\u00e7\u00e3o de um Single:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Escolhendo idioma:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Escolhendo edi\u00e7\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Os diret\u00f3rios ser\u00e3o herdados do que foi setado na bash_profile:<\/p>\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
Validando Pr\u00e9-Requisitos:<\/p>\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 que deve ser executado como root:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Executado:<\/p>\n\n\n
\n[root@hostname product]# \/oracle\/12.1.0\/product\/root.sh\nPerforming root user operation.\n \n  \n \nThe following environment variables are set as:\n    ORACLE_OWNER= user\n    ORACLE_HOME=  \/oracle\/12.1.0\/product\n \n  \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 \n  \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.\n<\/pre><\/div>\n\n\n
Software instalado com sucesso:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Etapa 2: cria\u00e7\u00e3o do banco de dados atrav\u00e9s do DBCA:<\/p>\n\n\n
\n[user@hostname database]$ dbca &amp;\n[1] 11865\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Modo avan\u00e7ado:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
General:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Inserindo nome do banco e inst\u00e2ncia:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Monitora\u00e7\u00e3o via Enterprise Manager ser\u00e1 realizada posteriormente:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Credenciais:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Selecionando o Listener j\u00e1 existente:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Esta etapa \u00e9 importante. Selecione corretamente o DG que abrigar\u00e1 os dados do banco, bem como o DG destinado para a Fast Recovery Area. Depois disso, habilite o ArchiveLog Mode, o destino dos archives, e realize a multiplexa\u00e7\u00e3o dos RedoLogs e Control File:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Multiplexa\u00e7\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Archives:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Schemas sample:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Vault:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Definindo tamanho da SGA e PGA:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Processos:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Escolha o character set solicitado:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Modo de conex\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Se necess\u00e1rio, edite aqui os par\u00e2metros de inicializa\u00e7\u00e3o:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Nesta etapa, voc\u00ea pode aumentar o n\u00famero limite de datafile no controlfile, al\u00e9m de criar mais grupos ou membros de redolog:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Controlfile:<\/p>\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
\"\"<\/figure>\n\n\n\n
Criando banco:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Banco criado:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Consultando o banco:<\/p>\n\n\n
\n[user@hostname database]$ ps -ef | grep pmon\nuser  16402      1  0 15:33 ?        00:00:00 ora_pmon_XXXX\nuser  16760 130706  0 15:35 pts\/0    00:00:00 grep --color=auto pmon\nuser  127192      1  0 12:07 ?        00:00:00 asm_pmon_+ASM\n[user@hostname database]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 7 15:35:09 2020\n \nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics\nand Real Application Testing options\n \nSQL> select instance_name,status from v$instance;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\nXXXXXXXX         OPEN\n \nSQL> select banner from v$version;\n \nBANNER\n--------------------------------------------------------------------------------\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\nPL\/SQL Release 12.1.0.2.0 - Production\nCORE    12.1.0.2.0      Production\nTNS for Linux: Version 12.1.0.2.0 - Production\nNLSRTL Version 12.1.0.2.0 - Production\n \nSQL>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
As instala\u00e7\u00f5es novas que ser\u00e3o demonstradas aqui utilizaram um ambiente GRID Infrastructure que foi criado neste ARTIGO. Caso voc\u00ea n\u00e3o tenha as m\u00eddias de instala\u00e7\u00e3o, pode realizar o download conforme abaixo: Escolhendo vers\u00e3o 12.1.0.2: Ap\u00f3s o check-out: Aceitando os termos: Criando os diret\u00f3rios: Editando a bash_profile: Carregando a bash_profile: Ap\u00f3s o dowload das m\u00eddias, as […]<\/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":[19],"class_list":["post-787","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/787","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=787"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/787\/revisions"}],"predecessor-version":[{"id":9305,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/787\/revisions\/9305"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}