Skip to main content

OS - yum - preinstall


English Version

Install pre reqs para Oracle DB


Uma das pre tasks necessarias para base de dados Oracle e installar previamente uma lista enorme de packages. Oracle Linux  vem com os repositorios do yum , o que facilita muito a tarefa de preparar o servidor para Oracle.

[root@dbserver ~]# yum install oracle-rdbms-server-12cR1-preinstall
Loaded plugins: langpacks
Resolving Dependencies
--> Running transaction check
---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-7.el7 will be installed
--> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed
---> Package gcc-c++.x86_64 0:4.8.5-36.0.1.el7 will be installed
--> Processing Dependency: libstdc++ = 4.8.5-36.0.1.el7 for package: gcc-c++-4.8.5-36.0.1.el7.x86_64
--> Processing Dependency: gcc = 4.8.5-36.0.1.el7 for package: gcc-c++-4.8.5-36.0.1.el7.x86_64
---> Package ksh.x86_64 0:20120801-139.0.1.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
--> Processing Dependency: libaio(x86-64) = 0.3.109-13.el7 for package: libaio-devel-0.3.109-13.el7.x86_64
---> Package libstdc++-devel.x86_64 0:4.8.5-36.0.1.el7 will be installed
--> Running transaction check
---> Package gcc.x86_64 0:4.8.3-9.el7 will be updated
---> Package gcc.x86_64 0:4.8.5-36.0.1.el7 will be an update
--> Processing Dependency: libgomp = 4.8.5-36.0.1.el7 for package: gcc-4.8.5-36.0.1.el7.x86_64
--> Processing Dependency: cpp = 4.8.5-36.0.1.el7 for package: gcc-4.8.5-36.0.1.el7.x86_64
--> Processing Dependency: libgcc >= 4.8.5-36.0.1.el7 for package: gcc-4.8.5-36.0.1.el7.x86_64
---> Package libaio.x86_64 0:0.3.109-12.el7 will be updated
---> Package libaio.x86_64 0:0.3.109-13.el7 will be an update
---> Package libstdc++.x86_64 0:4.8.3-9.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-36.0.1.el7 will be an update
--> Running transaction check
---> Package cpp.x86_64 0:4.8.3-9.el7 will be updated
---> Package cpp.x86_64 0:4.8.5-36.0.1.el7 will be an update
---> Package libgcc.x86_64 0:4.8.3-9.el7 will be updated
---> Package libgcc.x86_64 0:4.8.5-36.0.1.el7 will be an update
---> Package libgomp.x86_64 0:4.8.3-9.el7 will be updated
---> Package libgomp.x86_64 0:4.8.5-36.0.1.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================
Installing:
oracle-rdbms-server-12cR1-preinstall x86_64 1.0-7.el7 ol7_latest 21 k
Installing for dependencies:
compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k
compat-libstdc++-33 x86_64 3.2.3-72.el7 ol7_latest 190 k
gcc-c++ x86_64 4.8.5-36.0.1.el7 ol7_latest 7.2 M
ksh x86_64 20120801-139.0.1.el7 ol7_latest 883 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
libstdc++-devel x86_64 4.8.5-36.0.1.el7 ol7_latest 1.5 M
Updating for dependencies:
cpp x86_64 4.8.5-36.0.1.el7 ol7_latest 5.9 M
gcc x86_64 4.8.5-36.0.1.el7 ol7_latest 16 M
libaio x86_64 0.3.109-13.el7 ol7_latest 24 k
libgcc x86_64 4.8.5-36.0.1.el7 ol7_latest 101 k
libgomp x86_64 4.8.5-36.0.1.el7 ol7_latest 157 k
libstdc++ x86_64 4.8.5-36.0.1.el7 ol7_latest 304 k

Transaction Summary
==============================================================================================================================================
Install 1 Package (+6 Dependent packages)
Upgrade ( 6 Dependent packages)

Total download size: 32 M
Is this ok [y/d/N]: y
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
Public key for compat-libcap1-1.10-7.el7.x86_64.rpm is not installed
(1/13): compat-libcap1-1.10-7.el7.x86_64.rpm | 17 kB 00:00:01
(2/13): cpp-4.8.5-36.0.1.el7.x86_64.rpm | 5.9 MB 00:00:01
(3/13): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm | 190 kB 00:00:03
(4/13): gcc-4.8.5-36.0.1.el7.x86_64.rpm | 16 MB 00:00:04
(5/13): gcc-c++-4.8.5-36.0.1.el7.x86_64.rpm | 7.2 MB 00:00:06
(6/13): ksh-20120801-139.0.1.el7.x86_64.rpm | 883 kB 00:00:03
(7/13): libaio-0.3.109-13.el7.x86_64.rpm | 24 kB 00:00:01
(8/13): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:01
(9/13): libgcc-4.8.5-36.0.1.el7.x86_64.rpm | 101 kB 00:00:01
(10/13): libgomp-4.8.5-36.0.1.el7.x86_64.rpm | 157 kB 00:00:01
(11/13): libstdc++-devel-4.8.5-36.0.1.el7.x86_64.rpm | 1.5 MB 00:00:00
(12/13): libstdc++-4.8.5-36.0.1.el7.x86_64.rpm | 304 kB 00:00:01
(13/13): oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64.rpm | 21 kB 00:00:01
----------------------------------------------------------------------------------------------------------------------------------------------
Total 1.9 MB/s | 32 MB 00:00:17
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) "
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.1-1.0.5.el7.x86_64 (@anaconda/7.1)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Updating : libgcc-4.8.5-36.0.1.el7.x86_64 1/19
Updating : libstdc++-4.8.5-36.0.1.el7.x86_64 2/19
Installing : libstdc++-devel-4.8.5-36.0.1.el7.x86_64 3/19
Updating : libaio-0.3.109-13.el7.x86_64 4/19
Installing : libaio-devel-0.3.109-13.el7.x86_64 5/19
Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64 6/19
Updating : libgomp-4.8.5-36.0.1.el7.x86_64 7/19
Installing : compat-libcap1-1.10-7.el7.x86_64 8/19
Updating : cpp-4.8.5-36.0.1.el7.x86_64 9/19
Updating : gcc-4.8.5-36.0.1.el7.x86_64 10/19
Installing : gcc-c++-4.8.5-36.0.1.el7.x86_64 11/19
Installing : ksh-20120801-139.0.1.el7.x86_64 12/19
Installing : oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 13/19
Cleanup : gcc-4.8.3-9.el7.x86_64 14/19
Cleanup : libstdc++-4.8.3-9.el7.x86_64 15/19
Cleanup : libgcc-4.8.3-9.el7.x86_64 16/19
Cleanup : cpp-4.8.3-9.el7.x86_64 17/19
Cleanup : libgomp-4.8.3-9.el7.x86_64 18/19
Cleanup : libaio-0.3.109-12.el7.x86_64 19/19
Verifying : gcc-c++-4.8.5-36.0.1.el7.x86_64 1/19
Verifying : libstdc++-4.8.5-36.0.1.el7.x86_64 2/19
Verifying : ksh-20120801-139.0.1.el7.x86_64 3/19
Verifying : cpp-4.8.5-36.0.1.el7.x86_64 4/19
Verifying : compat-libstdc++-33-3.2.3-72.el7.x86_64 5/19
Verifying : libgcc-4.8.5-36.0.1.el7.x86_64 6/19
Verifying : compat-libcap1-1.10-7.el7.x86_64 7/19
Verifying : gcc-4.8.5-36.0.1.el7.x86_64 8/19
Verifying : libaio-devel-0.3.109-13.el7.x86_64 9/19
Verifying : libstdc++-devel-4.8.5-36.0.1.el7.x86_64 10/19
Verifying : oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64 11/19
Verifying : libaio-0.3.109-13.el7.x86_64 12/19
Verifying : libgomp-4.8.5-36.0.1.el7.x86_64 13/19
Verifying : cpp-4.8.3-9.el7.x86_64 14/19
Verifying : gcc-4.8.3-9.el7.x86_64 15/19
Verifying : libaio-0.3.109-12.el7.x86_64 16/19
Verifying : libstdc++-4.8.3-9.el7.x86_64 17/19
Verifying : libgcc-4.8.3-9.el7.x86_64 18/19
Verifying : libgomp-4.8.3-9.el7.x86_64 19/19

Installed:
oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-7.el7

Dependency Installed:
compat-libcap1.x86_64 0:1.10-7.el7 compat-libstdc++-33.x86_64 0:3.2.3-72.el7 gcc-c++.x86_64 0:4.8.5-36.0.1.el7
ksh.x86_64 0:20120801-139.0.1.el7 libaio-devel.x86_64 0:0.3.109-13.el7 libstdc++-devel.x86_64 0:4.8.5-36.0.1.el7

Dependency Updated:
cpp.x86_64 0:4.8.5-36.0.1.el7 gcc.x86_64 0:4.8.5-36.0.1.el7 libaio.x86_64 0:0.3.109-13.el7 libgcc.x86_64 0:4.8.5-36.0.1.el7
libgomp.x86_64 0:4.8.5-36.0.1.el7 libstdc++.x86_64 0:4.8.5-36.0.1.el7

Complete!


Referencias:
https://docs.oracle.com/database/121/LADBI/olinrpm.htm#LADBI7477
https://www.oracle.com/technetwork/articles/servers-storage-admin/ginnydbinstallonlinux-488779.html


Obrigado pela leitura, espero que este post o tenha ajudado.
Rogerio

Labels:

Comments

Post a Comment

Popular posts from this blog

DB - How to monitor Oracle datapump jobs

These days there is lot of work around database migrations not only but mainly to cloud providers. One of the ways to migrate Oracle databases is using data pump (expdp/impdp). In general works fine, it allows an easy way to bring the database even different OS. It is always good to monitor the progress, to know where we are and estimate how long we are from the end. In this post, I am sharing some queries to help with database monitoring progress. The queries can be easily tailed to various scenarios. Starting with a simple one - the track the number of objects loaded during an import operation. When there is a massive amount of errors during the import. Drop and run the import again. The bellow query can be useful also to monitor the number of objects if we are dropping the users. Here, I’m making the assumption there were no other database activity in progress on the last 24 hours. select owner, count(0) from dba_objects where owner in ( select username from dba_users where created...
Post a Comment
Read more

VM - Partilhar Pastas Windows - Linux

Neste post escrevo como partilhar pastas entre Windows (Host) e uma VM Guest, neste caso Linux. Ha algumas formas de fazer isto, esta parece me a mais facil. Seleccionar a Pasta Windows Na consola Virtual Box > Devices > Shared Folder Seleccionar a pasta windows para partilhar no Linux   O   Montar a pasta Windows na VM Ha duas opcoes : 1) Reiniciar a VM (Auto-mount) 2) Linha de comando [root@host ~]# mkdir -p /u01/stage/win_ebs_sw [root@host ~]# chmod 777 /u01/stage/win_ebs_sw [root@host ~]# mount -t vboxsf Oracle_EBS /u01/stage/win_ebs_sw/ [root@host ~]# ls /u01/stage/win_ebs_sw ebs_weblogic_webtier [root@host ~]# df -h /u01/stage/win_ebs_sw Filesystem Size Used Avail Use% Mounted on Oracle_EBS 895G 494G 401G 56% /u01/stage/win_ebs_sw Guardar a Configuracao no /etc/fstab para tornar as alteracoes permanentes. [root@host ~]# echo "Oracle_EBS /u01/stage/win_ebs_sw vboxsf defaults 0 0" >> /etc/fstab [root@host ~]# cat /etc/fstab # /etc/...
Post a Comment
Read more

DB – How to monitor Oracle database long ops ?

As DBAs, some questions we are often asked and to be fair we ask ourselfs when we are doing massive operations, are : Is the database doing something? How long the database takes to complete the task? There a data dictionary view, GV$SESSION_LONGOPS whom is really usefull for monitoring and to provide estimated time to get the task done. Starting with a first example, a query for general propose . set lines 240 col message form a100 col opname form a50 select * from ( select round(l.sofar/l.totalwork*100,2) as complete, --l.* l.sid, --l.opname, l.message, l.start_time, l.time_remaining/60 "minuts remaining", l.elapsed_seconds from gv$session_longops l where totalwork !=0 ) where complete < 100; The view is also usefull on specific operations such as Oracle Recovery Manager (RMAN) jobs monitoring, this query returns information about backup,restore and recovery. select sid, serial#,opname, context, sofar, totalwork, round(sofar/totalwork*100,2) "%_complet...
Post a Comment
Read more