Este artigo explora a instalação de um Oracle GRID 19C, porém com alguns problemas (e soluções) no percurso. Geralmente quando fazemos o post, é apenas evidenciando o “caminho feliz”, mas refletindo, notei que o aprendizado vem justamente quando você tenta reproduzir uma atividade, e enfrenta situações adversas (mesmo que isso não fique esteticamente legal em um blog). E documentá-las também é uma forma de perpetuar o conhecimento.
Criando os discos VDI no VirtualBox que serão usados para a crição dos DGs:
Adicionando uma nova controladora:
Adicionando VDI:
Criar:
VDI:
Dinamicamente alocado:
GRID:
Escolher:
Eu repeti o processo para criar os seguintes discos:
RECO:
DATA:
Discos:
Após ligar a VM, vou realizar uma configuração de rede para IP estático:
Selecionar “Network” e ir em configurações:
Realizar a mudança para o Método Manual, e incluir as informações nos campos Addres, Netmask e Gateway:
Após isso, realizar o reboot da máquina. Na sequência, já é possível validar que o IP está sendo utilizado:
Editando o /etc/hosts com o novo IP e realizando o teste de ping:
Nesse ponto, eu tentei já iniciar a instalações dos pacotes de S.O, mas me deparei com este erro:
[root@oel7 ~]# yum install -y oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
https://yum.oracle.com/repo/OracleLinux/OL7/UEKR5/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: glibc-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: glibc-headers = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: glibc = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
---> Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-39.0.3.el7 will be installed
--> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.3.el7 for package: libstdc++-devel-4.8.5-39.0.3.el7.x86_64
--> Running transaction check
---> Package glibc.x86_64 0:2.17-292.0.1.el7 will be updated
--> Processing Dependency: glibc = 2.17-292.0.1.el7 for package: glibc-common-2.17-292.0.1.el7.x86_64
---> Package glibc.x86_64 0:2.17-307.0.1.el7.1 will be an update
---> Package glibc-headers.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
---> Package libstdc++.x86_64 0:4.8.5-39.0.1.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-39.0.3.el7 will be an update
--> Running transaction check
---> Package glibc-common.x86_64 0:2.17-292.0.1.el7 will be updated
---> Package glibc-common.x86_64 0:2.17-307.0.1.el7.1 will be an update
---> Package kernel-headers.x86_64 0:3.10.0-1127.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 k
Installing for dependencies:
compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k
glibc-devel x86_64 2.17-307.0.1.el7.1 ol7_latest 1.1 M
glibc-headers x86_64 2.17-307.0.1.el7.1 ol7_latest 691 k
kernel-headers x86_64 3.10.0-1127.el7 ol7_latest 8.9 M
ksh x86_64 20120801-142.0.1.el7 ol7_latest 882 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
libstdc++-devel x86_64 4.8.5-39.0.3.el7 ol7_latest 1.5 M
Updating for dependencies:
glibc x86_64 2.17-307.0.1.el7.1 ol7_latest 3.6 M
glibc-common x86_64 2.17-307.0.1.el7.1 ol7_latest 12 M
libstdc++ x86_64 4.8.5-39.0.3.el7 ol7_latest 306 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package (+7 Dependent packages)
Upgrade ( 3 Dependent packages)
Total download size: 29 M
Downloading packages:
No Presto metadata available for ol7_latest
glibc-2.17-307.0.1.el7.1.x86_6 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/glibc-2.17-307.0.1.el7.1.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
compat-libcap1-1.10-7.el7.x86_ FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/compat-libcap1-1.10-7.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
glibc-common-2.17-307.0.1.el7. FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/glibc-common-2.17-307.0.1.el7.1.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
glibc-devel-2.17-307.0.1.el7.1 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/glibc-devel-2.17-307.0.1.el7.1.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
glibc-headers-2.17-307.0.1.el7 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/glibc-headers-2.17-307.0.1.el7.1.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
kernel-headers-3.10.0-1127.el7 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/kernel-headers-3.10.0-1127.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
ksh-20120801-142.0.1.el7.x86_6 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/ksh-20120801-142.0.1.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
libaio-devel-0.3.109-13.el7.x8 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libaio-devel-0.3.109-13.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
libstdc++-4.8.5-39.0.3.el7.x86 FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libstdc%2B%2B-4.8.5-39.0.3.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
libstdc++-devel-4.8.5-39.0.3.e FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/libstdc%2B%2B-devel-4.8.5-39.0.3.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
oracle-database-preinstall-19c FAILED
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"
Trying other mirror.
Error downloading packages:
glibc-devel-2.17-307.0.1.el7.1.x86_64: [Errno 256] No more mirrors to try.
compat-libcap1-1.10-7.el7.x86_64: [Errno 256] No more mirrors to try.
glibc-common-2.17-307.0.1.el7.1.x86_64: [Errno 256] No more mirrors to try.
libstdc++-devel-4.8.5-39.0.3.el7.x86_64: [Errno 256] No more mirrors to try.
libstdc++-4.8.5-39.0.3.el7.x86_64: [Errno 256] No more mirrors to try.
ksh-20120801-142.0.1.el7.x86_64: [Errno 256] No more mirrors to try.
libaio-devel-0.3.109-13.el7.x86_64: [Errno 256] No more mirrors to try.
oracle-database-preinstall-19c-1.0-2.el7.x86_64: [Errno 256] No more mirrors to try.
kernel-headers-3.10.0-1127.el7.x86_64: [Errno 256] No more mirrors to try.
glibc-headers-2.17-307.0.1.el7.1.x86_64: [Errno 256] No more mirrors to try.
glibc-2.17-307.0.1.el7.1.x86_64: [Errno 256] No more mirrors to try.
[root@oel7 ~]#
Para resolver:
[root@oel7 ~]# dhclient
[root@oel7 ~]#
Pacote Instalado:
[root@oel7 ~]# yum install -y oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
ol7_UEKR5 | 2.5 kB 00:00:00
ol7_latest | 2.7 kB 00:00:00
(1/2): ol7_latest/x86_64/updateinfo | 2.8 MB 00:00:04
(2/2): ol7_latest/x86_64/primary_db | 31 MB 00:00:22
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: glibc-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: glibc-headers = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: glibc = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
---> Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-39.0.3.el7 will be installed
--> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.3.el7 for package: libstdc++-devel-4.8.5-39.0.3.el7.x86_64
--> Running transaction check
---> Package glibc.x86_64 0:2.17-292.0.1.el7 will be updated
--> Processing Dependency: glibc = 2.17-292.0.1.el7 for package: glibc-common-2.17-292.0.1.el7.x86_64
---> Package glibc.x86_64 0:2.17-307.0.1.el7.1 will be an update
---> Package glibc-headers.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
---> Package libstdc++.x86_64 0:4.8.5-39.0.1.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-39.0.3.el7 will be an update
--> Running transaction check
---> Package glibc-common.x86_64 0:2.17-292.0.1.el7 will be updated
---> Package glibc-common.x86_64 0:2.17-307.0.1.el7.1 will be an update
---> Package kernel-headers.x86_64 0:3.10.0-1127.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-2.el7 ol7_latest 19 k
Installing for dependencies:
compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k
glibc-devel x86_64 2.17-307.0.1.el7.1 ol7_latest 1.1 M
glibc-headers x86_64 2.17-307.0.1.el7.1 ol7_latest 691 k
kernel-headers x86_64 3.10.0-1127.el7 ol7_latest 8.9 M
ksh x86_64 20120801-142.0.1.el7 ol7_latest 882 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
libstdc++-devel x86_64 4.8.5-39.0.3.el7 ol7_latest 1.5 M
Updating for dependencies:
glibc x86_64 2.17-307.0.1.el7.1 ol7_latest 3.6 M
glibc-common x86_64 2.17-307.0.1.el7.1 ol7_latest 12 M
libstdc++ x86_64 4.8.5-39.0.3.el7 ol7_latest 306 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package (+7 Dependent packages)
Upgrade ( 3 Dependent packages)
Total download size: 29 M
Downloading packages:
No Presto metadata available for ol7_latest
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/compat-libcap1-1.10-7.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY B --:--:-- ETA
Public key for compat-libcap1-1.10-7.el7.x86_64.rpm is not installed
(1/11): compat-libcap1-1.10-7.el7.x86_64.rpm | 17 kB 00:00:00
(2/11): glibc-2.17-307.0.1.el7.1.x86_64.rpm | 3.6 MB 00:00:04
(3/11): glibc-devel-2.17-307.0.1.el7.1.x86_64.rpm | 1.1 MB 00:00:01
(4/11): glibc-headers-2.17-307.0.1.el7.1.x86_64.rpm | 691 kB 00:00:00
(5/11): kernel-headers-3.10.0-1127.el7.x86_64.rpm | 8.9 MB 00:00:10
(6/11): ksh-20120801-142.0.1.el7.x86_64.rpm | 882 kB 00:00:00
(7/11): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:00
(8/11): libstdc++-4.8.5-39.0.3.el7.x86_64.rpm | 306 kB 00:00:00
(9/11): glibc-common-2.17-307.0.1.el7.1.x86_64.rpm | 12 MB 00:00:19
(10/11): oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm | 19 kB 00:00:00
(11/11): libstdc++-devel-4.8.5-39.0.3.el7.x86_64.rpm | 1.5 MB 00:00:01
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.4 MB/s | 29 MB 00:00:20
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.7-1.0.5.el7.x86_64 (@anaconda/7.7)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : glibc-common-2.17-307.0.1.el7.1.x86_64 1/14
Updating : glibc-2.17-307.0.1.el7.1.x86_64 2/14
Updating : libstdc++-4.8.5-39.0.3.el7.x86_64 3/14
Installing : libstdc++-devel-4.8.5-39.0.3.el7.x86_64 4/14
Installing : ksh-20120801-142.0.1.el7.x86_64 5/14
Installing : compat-libcap1-1.10-7.el7.x86_64 6/14
Installing : kernel-headers-3.10.0-1127.el7.x86_64 7/14
Installing : glibc-headers-2.17-307.0.1.el7.1.x86_64 8/14
Installing : glibc-devel-2.17-307.0.1.el7.1.x86_64 9/14
Installing : libaio-devel-0.3.109-13.el7.x86_64 10/14
Installing : oracle-database-preinstall-19c-1.0-2.el7.x86_64 11/14
Cleanup : libstdc++-4.8.5-39.0.1.el7.x86_64 12/14
Cleanup : glibc-common-2.17-292.0.1.el7.x86_64 13/14
Cleanup : glibc-2.17-292.0.1.el7.x86_64 14/14
Verifying : glibc-2.17-307.0.1.el7.1.x86_64 1/14
Verifying : libstdc++-4.8.5-39.0.3.el7.x86_64 2/14
Verifying : glibc-common-2.17-307.0.1.el7.1.x86_64 3/14
Verifying : ksh-20120801-142.0.1.el7.x86_64 4/14
Verifying : libstdc++-devel-4.8.5-39.0.3.el7.x86_64 5/14
Verifying : compat-libcap1-1.10-7.el7.x86_64 6/14
Verifying : libaio-devel-0.3.109-13.el7.x86_64 7/14
Verifying : glibc-devel-2.17-307.0.1.el7.1.x86_64 8/14
Verifying : glibc-headers-2.17-307.0.1.el7.1.x86_64 9/14
Verifying : kernel-headers-3.10.0-1127.el7.x86_64 10/14
Verifying : oracle-database-preinstall-19c-1.0-2.el7.x86_64 11/14
Verifying : glibc-common-2.17-292.0.1.el7.x86_64 12/14
Verifying : glibc-2.17-292.0.1.el7.x86_64 13/14
Verifying : libstdc++-4.8.5-39.0.1.el7.x86_64 14/14
Installed:
oracle-database-preinstall-19c.x86_64 0:1.0-2.el7
Dependency Installed:
compat-libcap1.x86_64 0:1.10-7.el7 glibc-devel.x86_64 0:2.17-307.0.1.el7.1 glibc-headers.x86_64 0:2.17-307.0.1.el7.1 kernel-headers.x86_64 0:3.10.0-1127.el7
ksh.x86_64 0:20120801-142.0.1.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libstdc++-devel.x86_64 0:4.8.5-39.0.3.el7
Dependency Updated:
glibc.x86_64 0:2.17-307.0.1.el7.1 glibc-common.x86_64 0:2.17-307.0.1.el7.1 libstdc++.x86_64 0:4.8.5-39.0.3.el7
Complete!
[root@oel7 ~]#
Adicionando grupo asmadmin,asmoper e asmdba e usuário grid:
[root@oel7 ~]# groupadd -g 54327 asmdba
[root@oel7 ~]# groupadd -g 54328 asmoper
[root@oel7 ~]# groupadd -g 54329 asmadmin
[root@oel7 ~]# useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper grid
[root@oel7 ~]# passwd grid
Changing password for user grid.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@oel7 ~]
Instalando pacote do oracleasm:
[root@oel7 ~]# rpm -qa | grep oracleasm
[root@oel7 ~]# yum install -y oracleasm-support.x86_64
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.11-2.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
oracleasm-support x86_64 2.1.11-2.el7 ol7_latest 85 k
Transaction Summary
========================================================================================================================================================================
Install 1 Package
Total download size: 85 k
Installed size: 266 k
Downloading packages:
oracleasm-support-2.1.11-2.el7.x86_64.rpm | 85 kB 00:00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : oracleasm-support-2.1.11-2.el7.x86_64 1/1
Note: Forwarding request to 'systemctl enable oracleasm.service'.
Created symlink from /etc/systemd/system/multi-user.target.wants/oracleasm.service to /usr/lib/systemd/system/oracleasm.service.
Verifying : oracleasm-support-2.1.11-2.el7.x86_64 1/1
Installed:
oracleasm-support.x86_64 0:2.1.11-2.el7
Complete!
[root@oel7 ~]#
Próximo pacote:
[root@oel7 ~]# yum install kmod-oracleasm
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package kmod-oracleasm.x86_64 0:2.0.8-27.0.1.el7 will be installed
--> Processing Dependency: kernel >= 3.10.0-1082.el7 for package: kmod-oracleasm-2.0.8-27.0.1.el7.x86_64
--> Running transaction check
---> Package kernel.x86_64 0:3.10.0-1127.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Installing:
kernel x86_64 3.10.0-1127.el7 ol7_latest 50 M
kmod-oracleasm x86_64 2.0.8-27.0.1.el7 ol7_latest 298 k
Transaction Summary
========================================================================================================================================================================
Install 2 Packages
Total download size: 50 M
Installed size: 66 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for ol7_latest
(1/2): kmod-oracleasm-2.0.8-27.0.1.el7.x86_64.rpm | 298 kB 00:00:00
(2/2): kernel-3.10.0-1127.el7.x86_64.rpm | 50 MB 00:00:31
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.6 MB/s | 50 MB 00:00:31
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : kernel-3.10.0-1127.el7.x86_64 1/2
Installing : kmod-oracleasm-2.0.8-27.0.1.el7.x86_64 2/2
Verifying : kernel-3.10.0-1127.el7.x86_64 1/2
Verifying : kmod-oracleasm-2.0.8-27.0.1.el7.x86_64 2/2
Installed:
kernel.x86_64 0:3.10.0-1127.el7 kmod-oracleasm.x86_64 0:2.0.8-27.0.1.el7
Complete!
[root@oel7 ~]#
Configurando o ASM:
[root@oel7 ~]# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface [grid]: grid
Default group to own the driver interface [dba]: asmadmin
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
[root@oel7 ~]#
Carrengando:
[root@oel7 ~]# /usr/sbin/oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm
[root@oel7 ~]#
Consultando o status:
[root@oel7 ~]# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
[root@oel7 ~]#
Consultando discos:
[root@oel7 ~]# fdisk -l | grep "Disk /dev/sd"
Disk /dev/sda: 12.9 GB, 12884901888 bytes, 25165824 sectors
Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors
Disk /dev/sdc: 21.5 GB, 21474836480 bytes, 41943040 sectors
Disk /dev/sdd: 10.7 GB, 10737418240 bytes, 20971520 sectors
Disk /dev/sde: 32.2 GB, 32212254720 bytes, 62914560 sectors
[root@oel7 ~]#
Criando partições:
[root@oel7 ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x8afab776.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-20971519, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]#
[root@oel7 ~]# fdisk /dev/sdc
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x0c4f9e34.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-41943039, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039):
Using default value 41943039
Partition 1 of type Linux and of size 20 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]#
[root@oel7 ~]# fdisk /dev/sdd
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x89221df6.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-20971519, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]#
[root@oel7 ~]# fdisk /dev/sde
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xe8e74fb0.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-62914559, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]#
Confirmando a criação:
[root@oel7 ~]# fdisk -l | grep "/dev/s"
Disk /dev/sda: 12.9 GB, 12884901888 bytes, 25165824 sectors
/dev/sda1 * 2048 2099199 1048576 83 Linux
/dev/sda2 2099200 25165823 11533312 8e Linux LVM
Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdb1 2048 20971519 10484736 83 Linux
Disk /dev/sdc: 21.5 GB, 21474836480 bytes, 41943040 sectors
/dev/sdc1 2048 41943039 20970496 83 Linux
Disk /dev/sdd: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdd1 2048 20971519 10484736 83 Linux
Disk /dev/sde: 32.2 GB, 32212254720 bytes, 62914560 sectors
/dev/sde1 2048 62914559 31456256 83 Linux
[root@oel7 ~]#
Criando os discos no oracleasm:
[root@oel7 ~]# oracleasm createdisk GRID01 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@oel7 ~]# oracleasm createdisk FRA01 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@oel7 ~]# oracleasm createdisk RECO01 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@oel7 ~]# oracleasm createdisk DATA01 /dev/sde1
Writing disk header: done
Instantiating disk: done
[root@oel7 ~]#
Consultando:
[root@oel7 ~]# cd /dev/oracleasm/disks/
[root@oel7 disks]# ll
total 0
brw-rw----. 1 grid asmadmin 8, 65 Apr 25 19:37 DATA01
brw-rw----. 1 grid asmadmin 8, 33 Apr 25 19:37 FRA01
brw-rw----. 1 grid asmadmin 8, 17 Apr 25 19:37 GRID01
brw-rw----. 1 grid asmadmin 8, 49 Apr 25 19:37 RECO01
[root@oel7 disks]#
Vou desligar a VM e adicionar 2 discos que serão usados para os binários do produto (oracle e grid):
Binário GRID:
Após ligar a VM, consultando os novos discos:
[root@oel7 ~]# fdisk -l | grep sd
Disk /dev/sda: 12.9 GB, 12884901888 bytes, 25165824 sectors
/dev/sda1 * 2048 2099199 1048576 83 Linux
/dev/sda2 2099200 25165823 11533312 8e Linux LVM
Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdb1 2048 20971519 10484736 83 Linux
Disk /dev/sdc: 21.5 GB, 21474836480 bytes, 41943040 sectors
/dev/sdc1 2048 41943039 20970496 83 Linux
Disk /dev/sdd: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdd1 2048 20971519 10484736 83 Linux
Disk /dev/sdf: 32.2 GB, 32212254720 bytes, 62914560 sectors
Disk /dev/sde: 32.2 GB, 32212254720 bytes, 62914560 sectors
/dev/sde1 2048 62914559 31456256 83 Linux
Disk /dev/sdg: 32.2 GB, 32212254720 bytes, 62914560 sectors
[root@oel7 ~]#
Criando a partição:
[root@oel7 ~]# fdisk /dev/sdf
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xd689ea02.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-62914559, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]# fdisk /dev/sdg
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xc3c8cce6.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-62914559, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@oel7 ~]#
Consultando novas partições:
[root@oel7 ~]# fdisk -l | grep sd
Disk /dev/sda: 12.9 GB, 12884901888 bytes, 25165824 sectors
/dev/sda1 * 2048 2099199 1048576 83 Linux
/dev/sda2 2099200 25165823 11533312 8e Linux LVM
Disk /dev/sdb: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdb1 2048 20971519 10484736 83 Linux
Disk /dev/sdc: 21.5 GB, 21474836480 bytes, 41943040 sectors
/dev/sdc1 2048 41943039 20970496 83 Linux
Disk /dev/sdd: 10.7 GB, 10737418240 bytes, 20971520 sectors
/dev/sdd1 2048 20971519 10484736 83 Linux
Disk /dev/sdf: 32.2 GB, 32212254720 bytes, 62914560 sectors
/dev/sdf1 2048 62914559 31456256 83 Linux
Disk /dev/sde: 32.2 GB, 32212254720 bytes, 62914560 sectors
/dev/sde1 2048 62914559 31456256 83 Linux
Disk /dev/sdg: 32.2 GB, 32212254720 bytes, 62914560 sectors
/dev/sdg1 2048 62914559 31456256 83 Linux
[root@oel7 ~]#
Criando os filesystem:
[root@oel7 ~]# mkfs.ext4 /dev/sdf1
mke2fs 1.42.9 (28-Dec-2013)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
1966080 inodes, 7864064 blocks
393203 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2155872256
240 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000
Allocating group tables: done
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
[root@oel7 ~]# mkfs.ext4 /dev/sdg1
mke2fs 1.42.9 (28-Dec-2013)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
1966080 inodes, 7864064 blocks
393203 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=2155872256
240 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000
Allocating group tables: done
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
[root@oel7 ~]#
Montando os FSs:
[root@oel7 ~]# mkdir /grid
[root@oel7 ~]# mount -t ext4 -o rw /dev/sdf1 /grid
[root@oel7 ~]# mkdir /oracle
[root@oel7 ~]# mount -t ext4 -o rw /dev/sdg1 /oracle
[root@oel7 ~]#
Persistindo no /etc/fstab:
[root@oel7 ~]# cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Thu Apr 16 20:00:25 2020
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/ol_oel7-root / xfs defaults 0 0
UUID=8c627eb0-e8f9-496a-bc04-9b6d80254769 /boot xfs defaults 0 0
/dev/mapper/ol_oel7-swap swap swap defaults 0 0
/dev/sdf1 /grid ext4 defaults 1 2
/dev/sdg1 /oracle ext4 defaults 1 2
[root@oel7 ~]#
Preparando diretório do GRID:
[root@oel7 ~]# mkdir -p /grid/19.3.0/product
[root@oel7 ~]# mkdir -p /grid/19.3.0/base
[root@oel7 ~]# chown -R grid:oinstall /grid/
[root@oel7 ~]# chmod -R 775 /grid/
[root@oel7 ~]#
Configurando o bash_profile do usuário grid:
# .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=+ASM; export ORACLE_SID
JAVA_HOME=/usr/bin/java; export JAVA_HOME
ORACLE_BASE=/grid/19.3.0/base; export ORACLE_BASE
ORACLE_HOME=/grid/19.3.0/product; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
Carregando valores e consultando:
[grid@oel7 ~]$ echo $ORACLE_SID ; echo $ORACLE_HOME ; echo $ORACLE_BASE
+ASM
/grid/19.3.0/product
/grid/19.3.0/base
Após copiar o binário do GRID para a VM, realizando o unzip:
[grid@oel7 ~]$ cd /grid/19.3.0/product/
[grid@oel7 product]$ ll
total 2821476
-rw-r--r--. 1 grid oinstall 2889184573 Apr 25 20:18 V982068-01.zip
[grid@oel7 product]$ unzip V982068-01.zip
Ajustando os limits do usuário grid:
[root@oel7 ~]# cd /etc/security/
[root@oel7 security]# ll
total 56
-rw-r--r--. 1 root root 4564 Jan 28 2018 access.conf
-rw-r--r--. 1 root root 82 Jan 28 2018 chroot.conf
drwxr-xr-x. 2 root root 4096 Apr 16 20:12 console.apps
-rw-r--r--. 1 root root 604 Jan 28 2018 console.handlers
-rw-r--r--. 1 root root 939 Jan 28 2018 console.perms
drwxr-xr-x. 2 root root 6 Jan 28 2018 console.perms.d
-rw-r--r--. 1 root root 3635 Jan 28 2018 group.conf
-rw-r--r--. 1 root root 2422 Jan 28 2018 limits.conf
drwxr-xr-x. 2 root root 70 Apr 24 22:57 limits.d
-rw-r--r--. 1 root root 1440 Jan 28 2018 namespace.conf
drwxr-xr-x. 2 root root 6 Jan 28 2018 namespace.d
-rwxr-xr-x. 1 root root 1019 Jan 28 2018 namespace.init
-rw-------. 1 root root 0 Jan 28 2018 opasswd
-rw-r--r--. 1 root root 2972 Jan 28 2018 pam_env.conf
-rw-r--r--. 1 root root 1718 Dec 6 2011 pwquality.conf
-rw-r--r--. 1 root root 419 Jan 28 2018 sepermit.conf
-rw-r--r--. 1 root root 2179 Jan 28 2018 time.conf
[root@oel7 security]# cd limits.d
[root@oel7 limits.d]# ll
total 8
-rw-r--r--. 1 root root 191 Jan 28 2018 20-nproc.conf
-rw-r--r--. 1 root root 1205 Apr 24 22:57 oracle-database-preinstall-19c.conf
[root@oel7 limits.d]# cp oracle-database-preinstall-19c.conf grid-database-preinstall-19c.conf
[root@oel7 limits.d]# vi grid-database-preinstall-19c.conf
Replace de oracle para grid:
Alterado com sucesso:
[root@oel7 limits.d]# cat grid-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
grid soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
grid hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
grid soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
grid hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
grid soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
grid hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
grid hard memlock 134217728
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
grid soft memlock 134217728
# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
grid soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
grid hard data unlimited
[root@oel7 limits.d]#
Por fim, chamando o instalador:
[grid@oel7 product]$ cd $ORACLE_HOME
[grid@oel7 product]$ export DISPLAY=192.168.0.106:0.0
[grid@oel7 product]$ ./gridSetup.sh &
Escolhendo a opção de Standalone:
De início, os discos não foram reconhecidos, mas basta clicar em Change Discovery Path:
Criando o Diskgroup DG_GRID:
Senha:
Registro no EM farei posteriormente:
Oracle_base:
Pré-requisitos:
O instalador reporta que a memória da máquina deve possuir 8GB, e o Swap deve subir para 3.5GB, além da necessidade de instalar o pacote cvudisk:
Pacote realmente não está instalado:
[root@oel7 ~]# rpm -qi cvuqdisk
package cvuqdisk is not installed
Instalando:
[root@oel7 cv]# cd /grid/19.3.0/product/cv/rpm/
[root@oel7 rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@oel7 rpm]#
Aumentando memória da máquina:
Após ligar a máquina, só faltaria aumentar o swap, mas vou ignorar este item no instalador (por ser um ambiente de estudos):
Sumário:
Progresso da instalação:
Scripts:
Executando scripts:
[root@oel7 ~]# /grid/19.3.0/oraInventory/orainstRoot.sh
Changing permissions of /grid/19.3.0/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /grid/19.3.0/oraInventory to oinstall.
The execution of the script is complete.
[root@oel7 ~]#
[root@oel7 ~]# /grid/19.3.0/product/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /grid/19.3.0/product
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
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.
Using configuration parameter file: /grid/19.3.0/product/crs/install/crsconfig_params
The log of current session can be found at:
/grid/19.3.0/base/crsdata/oel7/crsconfig/roothas_2020-04-27_09-43-57PM.log
2020/04/27 21:44:04 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node oel7 successfully pinned.
2020/04/27 21:44:19 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
oel7 2020/04/27 21:45:17 /grid/19.3.0/base/crsdata/oel7/olr/backup_20200427_214517.olr 724960844
2020/04/27 21:45:19 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@oel7 ~]#
Instalado com sucesso:
Criando os outros diskgroups:
[grid@oel7 product]$ asmca &
[1] 23627
[grid@oel7 product]$
Discos criados:
Consultando ambiente:
[grid@oel7 product]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 27 21:59:09 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
+ASM STARTED
SQL> !asmcmd lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 30716 30628 0 30628 0 N DG_DATA/
MOUNTED EXTERN N 512 512 4096 4194304 20476 20388 0 20388 0 N DG_FRA/
MOUNTED EXTERN N 512 512 4096 4194304 10236 10136 0 10136 0 N DG_GRID/
MOUNTED EXTERN N 512 512 4096 4194304 10236 10148 0 10148 0 N DG_RECO/
SQL>
Como referência para fazer essas instalações, utilizei a documentação oficial da Oracle (link AQUI), um procedimento muito rico do Ahmed Baraka (link AQUI), artigos do Tim Hall (linkS AQUI e AQUI) e os ricos materiais que o Portilho disponibiliza no site da Nerv (link AQUI). Para resolução de problemas, do CVUQDISK, por exemplo, usei esta referência do Ramil AQUI.
Portuguese
English
Spanish
Pingback: ORACLE DATABASE 19C STANDALONE INSTALLATION ON ORACLE LINUX 7 – Bruno Santos da Silva
Pingback: ORACLE DATABASE 19C STANDALONE INSTALLATION ON ORACLE LINUX 7 – SWIV