As instalações novas que serão demonstradas aqui utilizaram um ambiente GRID Infrastructure que foi criado neste ARTIGO.
Caso você não tenha as mídias de instalação, pode realizar o download conforme abaixo:
Escolhendo versão 12.1.0.2:
Após o check-out:
Aceitando os termos:
Criando os diretórios:
[user@hostname 12.1.0.2]$ mkdir -p /oracle/12.1.0/product
[user@hostname 12.1.0.2]$ mkdir -p /oracle/12.1.0/base
Editando a bash_profile:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
ORACLE_SID=XXXXX
ORACLE_BASE=/oracle/12.1.0/base
ORACLE_HOME=/oracle/12.1.0/product
GRID_HOME=$ORACLE_HOME
ORA_CRS_HOME=$ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID ORACLE_BASE ORACLE_HOME GRID_HOME LD_LIBRARY_PATH PATH
alias ll='ls -l --color'
alias home='cd $ORACLE_HOME'
alias base='cd $ORACLE_BASE'
alias sql='sqlplus "/ as sysdba"'
alias crs='cd $ORACLE_HOME/bin'
alias tns='cd $ORACLE_HOME/network/admin'
alias asmtrace='cd $ORACLE_BASE/diag/asm/+asm/+ASM1/trace'
Carregando a bash_profile:
[user@hostname ~]$ . .bash_profile
[user@hostname ~]$
Após o dowload das mídias, as copiei para o ORACLE_HOME:
[user@hostname product]$ pwd
/oracle/12.1.0/product
[user@hostname product]$ ll
total 2625088
-rwxr-xr-x 1 user oinstall 1673544724 Mar 7 13:08 V46095-01_1of2.zip
-rwxr-xr-x 1 user oinstall 1014530602 Mar 7 13:09 V46095-01_2of2.zip
Descompactando:
[user@hostname product]$ unzip V46095-01_1of2.zip
Archive: V46095-01_1of2.zip
creating: database/
creating: database/rpm/
. . .
inflating: database/stage/sizes/oracle.server12.1.0.2.0SE.sizes.properties
extracting: database/stage/sizes/oracle.server.Custom.sizes.properties
[user@hostname product]$ unzip V46095-01_2of2.zip
Archive: V46095-01_2of2.zip
creating: database/stage/Components/oracle.ctx/
creating: database/stage/Components/oracle.ctx/12.1.0.2.0/
. . .
inflating: database/stage/Components/oracle.javavm.containers/12.1.0.2.0/1/DataFiles/filegroup1.jar
inflating: database/install/.oui
As mídias podem ser removidas. Com a descompactação, foi criada a pasta database:
[user@hostname product]$ ll
total 2625092
drwxr-xr-x 7 user oinstall 4096 Jul 7 2014 database
-rwxr-xr-x 1 user oinstall 1673544724 Mar 7 13:08 V46095-01_1of2.zip
-rwxr-xr-x 1 user oinstall 1014530602 Mar 7 13:09 V46095-01_2of2.zip
[user@hostname product]$ rm -rf V46095-01_1of2.zip V46095-01_2of2.zip
Entrando na pasta database, realizando o EXPORT DISPLAY e chamando o instalador:
[user@hostname product]$ cd database/
[user@hostname database]$ ll
total 36
drwxr-xr-x 4 user oinstall 4096 Mar 7 13:17 install
drwxrwxr-x 2 user oinstall 4096 Jul 7 2014 response
drwxr-xr-x 2 user oinstall 4096 Jul 7 2014 rpm
-rwxr-xr-x 1 user oinstall 8533 Jul 7 2014 runInstaller
drwxrwxr-x 2 user oinstall 4096 Jul 7 2014 sshsetup
drwxr-xr-x 14 user oinstall 4096 Jul 7 2014 stage
-rwxr-xr-x 1 user oinstall 500 Feb 6 2013 welcome.html
[user@hostname database]$ export DISPLAY=XXX.XX.XX.XXX:0.0
[user@hostname database]$ ./runInstaller &
[1] 2612
[user@hostname database]$ Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 4605 MB Passed
Checking swap space: must be greater than 150 MB. Actual 11718 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-03-07_01-20-48PM. Please wait ...
[user@hostname database]$
Instalador:
Selecionando a opção de instalar apenas o Software:
Dessa vez, será a instalação de um Single:
Escolhendo idioma:
Escolhendo edição:
Os diretórios serão herdados do que foi setado na bash_profile:
Grupos:
Validando Pré-Requisitos:
Sumário de instalação:
Progresso:
Script que deve ser executado como root:
Executado:
[root@hostname product]# /oracle/12.1.0/product/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= user
ORACLE_HOME= /oracle/12.1.0/product
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Software instalado com sucesso:
Etapa 2: criação do banco de dados através do DBCA:
[user@hostname database]$ dbca &
[1] 11865
Modo avançado:
General:
Inserindo nome do banco e instância:
Monitoração via Enterprise Manager será realizada posteriormente:
Credenciais:
Selecionando o Listener já existente:
Esta etapa é importante. Selecione corretamente o DG que abrigará 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ção dos RedoLogs e Control File:
Multiplexação:
Archives:
Schemas sample:
Vault:
Definindo tamanho da SGA e PGA:
Processos:
Escolha o character set solicitado:
Modo de conexão:
Se necessário, edite aqui os parâmetros de inicialização:
Nesta etapa, você pode aumentar o número limite de datafile no controlfile, além de criar mais grupos ou membros de redolog:
Controlfile:
Sumário de instalação:
Criando banco:
Banco criado:
Consultando o banco:
[user@hostname database]$ ps -ef | grep pmon
user 16402 1 0 15:33 ? 00:00:00 ora_pmon_XXXX
user 16760 130706 0 15:35 pts/0 00:00:00 grep --color=auto pmon
user 127192 1 0 12:07 ? 00:00:00 asm_pmon_+ASM
[user@hostname database]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 7 15:35:09 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
XXXXXXXX OPEN
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
SQL>
Portuguese
English
Spanish