Rodrigo Silva e Silva – Página: 16

Destruindo Interface virbr0

Publicado em 19 de abril de 2018 by rodrigosilvaesilva

Listando interface virbr0

[root@bd01 ~]# ifconfig virbr0
virbr0: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
        ether 52:54:00:f0:c0:a2  txqueuelen 0  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

[root@bd01 ~]# ifconfig virbr0

virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500

inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255

ether 52:54:00:f0:c0:a2 txqueuelen 0 (Ethernet)

RX packets 0 bytes 0 (0.0 B)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 0 bytes 0 (0.0 B)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

Listar rede padrão

[root@bd01 ~]# virsh net-list
bash: virsh: command not found...

1 2	[root@bd01 ~]# virsh net-list bash: virsh: command not found...

Instalar o pacote virsh

[root@bd01 ~]# yum install libvirt

Dependencies Resolved

==========================================================================================================================
 Package                                    Arch               Version                       Repository              Size
==========================================================================================================================
Installing:
 libvirt                                    x86_64             3.9.0-14.el7_5.2              ol7_latest             172 k
Installing for dependencies:
 autogen-libopts                            x86_64             5.18-5.el7                    ol7_latest              65 k
 gnutls-dane                                x86_64             3.3.26-9.0.1.el7              ol7_latest              34 k
 gnutls-utils                               x86_64             3.3.26-9.0.1.el7              ol7_latest             236 k
 libvirt-client                             x86_64             3.9.0-14.el7_5.2              ol7_latest             457 k
 libvirt-daemon-config-nwfilter             x86_64             3.9.0-14.el7_5.2              ol7_latest             178 k
 libvirt-daemon-driver-lxc                  x86_64             3.9.0-14.el7_5.2              ol7_latest             899 k

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

Total download size: 2.0 M
Installed size: 3.8 M
Is this ok [y/d/N]: y

[root@bd01 ~]# yum install libvirt

Dependencies Resolved

==========================================================================================================================

Package Arch Version Repository Size

==========================================================================================================================

Installing:

libvirt x86_64 3.9.0-14.el7_5.2 ol7_latest 172 k

Installing for dependencies:

autogen-libopts x86_64 5.18-5.el7 ol7_latest 65 k

gnutls-dane x86_64 3.3.26-9.0.1.el7 ol7_latest 34 k

gnutls-utils x86_64 3.3.26-9.0.1.el7 ol7_latest 236 k

libvirt-client x86_64 3.9.0-14.el7_5.2 ol7_latest 457 k

libvirt-daemon-config-nwfilter x86_64 3.9.0-14.el7_5.2 ol7_latest 178 k

libvirt-daemon-driver-lxc x86_64 3.9.0-14.el7_5.2 ol7_latest 899 k

Transaction Summary

==========================================================================================================================

Install 1 Package (+6 Dependent packages)

Total download size: 2.0 M

Installed size: 3.8 M

Is this ok [y/d/N]: y

Listar rede padrão

[root@bd01 ~]# virsh net-list
 Name                 State      Autostart     Persistent
----------------------------------------------------------
 default              active     yes           yes

[root@bd01 ~]# virsh net-list

Name State Autostart Persistent

----------------------------------------------------------

default active yes yes

Destruir a rede padrão

[root@bd01 ~]# virsh net-destroy default
Network default destroyed

1 2	[root@bd01 ~]# virsh net-destroy default Network default destroyed

Remova permanentemente a rede virtual padrão da configuração.

[root@bd01 ~]# virsh net-undefine default
Network default has been undefined

1 2	[root@bd01 ~]# virsh net-undefine default Network default has been undefined

Listando interface virbr0

[root@bd01 ~]# ifconfig virbr0
virbr0: error fetching interface information: Device not found

1 2	[root@bd01 ~]# ifconfig virbr0 virbr0: error fetching interface information: Device not found

Desabilitar interface virbr0

Publicado em 19 de abril de 2018 by rodrigosilvaesilva

Listando rede virbr0.

[root@bd01 ~]# ifconfig virbr0
virbr0: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
        ether 52:54:00:f0:c0:a2  txqueuelen 0  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

[root@bd01 ~]# ifconfig virbr0

virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500

inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255

ether 52:54:00:f0:c0:a2 txqueuelen 0 (Ethernet)

RX packets 0 bytes 0 (0.0 B)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 0 bytes 0 (0.0 B)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

Verificando status do serviço libvirtd.

[root@bd01 ~]# systemctl status libvirtd.service
● libvirtd.service - Virtualization daemon
   Loaded: loaded (/usr/lib/systemd/system/libvirtd.service; enabled; vendor preset: enabled)
   Active: active (running) since Thu 2018-04-19 10:20:09 -03; 3min 8s ago
     Docs: man:libvirtd(8)
           https://libvirt.org
 Main PID: 1251 (libvirtd)
   CGroup: /system.slice/libvirtd.service
           ├─1251 /usr/sbin/libvirtd
           ├─1487 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr...
           └─1488 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr...

[root@bd01 ~]# systemctl status libvirtd.service

● libvirtd.service - Virtualization daemon

Loaded: loaded (/usr/lib/systemd/system/libvirtd.service; enabled; vendor preset: enabled)

Active: active (running) since Thu 2018-04-19 10:20:09 -03; 3min 8s ago

Docs: man:libvirtd(8)

https://libvirt.org

Main PID: 1251 (libvirtd)

CGroup: /system.slice/libvirtd.service

├─1251 /usr/sbin/libvirtd

├─1487 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr...

└─1488 /usr/sbin/dnsmasq --conf-file=/var/lib/libvirt/dnsmasq/default.conf --leasefile-ro --dhcp-script=/usr...

Parando o serviço libvirtd.

[root@bd01 ~]# /bin/systemctl stop libvirtd.service
[root@bd01 ~]# /bin/systemctl status libvirtd.service
● libvirtd.service - Virtualization daemon
   Loaded: loaded (/usr/lib/systemd/system/libvirtd.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since Thu 2018-04-19 10:24:31 -03; 20s ago

[root@bd01 ~]# /bin/systemctl stop libvirtd.service

[root@bd01 ~]# /bin/systemctl status libvirtd.service

● libvirtd.service - Virtualization daemon

Loaded: loaded (/usr/lib/systemd/system/libvirtd.service; enabled; vendor preset: enabled)

Active: inactive (dead) since Thu 2018-04-19 10:24:31 -03; 20s ago

Desabilitando a interface virbr0.

[root@bd01 ~]# systemctl disable libvirtd.service
Removed symlink /etc/systemd/system/multi-user.target.wants/libvirtd.service.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlogd.socket.
Removed symlink /etc/systemd/system/sockets.target.wants/virtlockd.socket.

[root@bd01 ~]# systemctl disable libvirtd.service

Removed symlink /etc/systemd/system/multi-user.target.wants/libvirtd.service.

Removed symlink /etc/systemd/system/sockets.target.wants/virtlogd.socket.

Removed symlink /etc/systemd/system/sockets.target.wants/virtlockd.socket.

Reinicie o servidor.

[root@bd01 ~]# reboot

1	[root@bd01 ~]# reboot

Verificando a interface virbr0.

[root@bd01 ~]# ifconfig virbr0
virbr0: error fetching interface information: Device not found

1 2	[root@bd01 ~]# ifconfig virbr0 virbr0: error fetching interface information: Device not found

Instalando Interface Gráfica Linux

Publicado em 19 de abril de 2018 by rodrigosilvaesilva

Listando grupos disponíveis!

[root@bdora ~]# yum group list
Loaded plugins: product-id, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
There is no installed groups file.
Maybe run: yum groups mark convert (see man yum)
Available environment groups:
   Minimal Install
   Infrastructure Server
   File and Print Server
   Basic Web Server
   Virtualization Host
   Server with GUI
Available Groups:
   Compatibility Libraries
   Console Internet Tools
   Development Tools
   Graphical Administration Tools
   Legacy UNIX Compatibility
   Scientific Support
   Security Tools
   Smart Card Support
   System Administration Tools
   System Management
Done

[root@bdora ~]# yum group list

Loaded plugins: product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

There is no installed groups file.

Maybe run: yum groups mark convert (see man yum)

Available environment groups:

Minimal Install

Infrastructure Server

File and Print Server

Basic Web Server

Virtualization Host

Server with GUI

Available Groups:

Compatibility Libraries

Console Internet Tools

Development Tools

Graphical Administration Tools

Legacy UNIX Compatibility

Scientific Support

Security Tools

Smart Card Support

System Administration Tools

System Management

Done

Instalando “Server with GUI”

[root@bdora ~]# yum groupinstall 'Server with GUI'
Transaction Summary
=================
Install  270 Packages (+634 Dependent packages)

Total download size: 580 M
Installed size: 1.8 G
Is this ok [y/d/N]:y

[root@bdora ~]# yum groupinstall 'Server with GUI'

Transaction Summary

=================

Install 270 Packages (+634 Dependent packages)

Total download size: 580 M

Installed size: 1.8 G

Is this ok [y/d/N]:y

Alterando Runlevel

[root@bdora ~]# systemctl set-default graphical.target

1	[root@bdora ~]# systemctl set-default graphical.target

Consultando eventos Oracle view v$system_event

Publicado em 18 de abril de 2018 by rodrigosilvaesilva

O objetivo deste select é facilitar a identificação excessiva de eventos em espera. A análise da view v$system_event será analisado as seguintes colunas:

EVENT = nome do evento de espera
TOTAL_WAITS = Número total de esperas para o evento
TIME_WAITED = Tempo total esperado pelo evento (em centésimos de segundo)
TOTAL_TIMEOUTS = Número total de tempos limite do evento
AVERAGE_WAIT = Quantidade média de tempo esperada pelo evento (em centésimos de segundo)

EVENT = nome do evento de espera

TOTAL_WAITS = Número total de esperas para o evento

TIME_WAITED = Tempo total esperado pelo evento (em centésimos de segundo)

TOTAL_TIMEOUTS = Número total de tempos limite do evento

AVERAGE_WAIT = Quantidade média de tempo esperada pelo evento (em centésimos de segundo)

Select consultando view v$system_event

set pages 999
set lines 90

column c1 heading 'Event|Name'             format a30
column c2 heading 'Total|Waits'            format 999,999,999
column c3 heading 'Seconds|Waiting'        format 999,999
column c4 heading 'Total|Timeouts'         format 999,999,999
column c5 heading 'Average|Wait|(in secs)' format 99.999

ttitle 'System-wide Wait Analysis|for current wait events

select
   event                         c1,
   total_waits                   c2,
   time_waited / 100             c3,
   total_timeouts                c4,
   average_wait    /100          c5
from
   sys.v_$system_event
where
   event not in (
    'dispatcher timer',
    'lock element cleanup',
    'Null event',
    'parallel query dequeue wait',
    'parallel query idle wait - Slaves',
    'pipe get',
    'PL/SQL lock timer',
    'pmon timer',
    'rdbms ipc message',
    'slave wait',
    'smon timer',
    'SQL*Net break/reset to client',
    'SQL*Net message from client',
    'SQL*Net message to client',
    'SQL*Net more data to client',
    'virtual circuit status',
    'WMON goes to sleep'
   )
AND
 event not like 'DFS%'
and
   event not like '%done%'
and
   event not like '%Idle%'
AND
 event not like 'KXFX%'
order by
   c2 desc
;

set pages 999

set lines 90

column c1 heading 'Event|Name' format a30

column c2 heading 'Total|Waits' format 999,999,999

column c3 heading 'Seconds|Waiting' format 999,999

column c4 heading 'Total|Timeouts' format 999,999,999

column c5 heading 'Average|Wait|(in secs)' format 99.999

ttitle 'System-wide Wait Analysis|for current wait events

select

event c1,

total_waits c2,

time_waited / 100 c3,

total_timeouts c4,

average_wait /100 c5

from

sys.v_$system_event

where

event not in (

'dispatcher timer',

'lock element cleanup',

'Null event',

'parallel query dequeue wait',

'parallel query idle wait - Slaves',

'pipe get',

'PL/SQL lock timer',

'pmon timer',

'rdbms ipc message',

'slave wait',

'smon timer',

'SQL*Net break/reset to client',

'SQL*Net message from client',

'SQL*Net message to client',

'SQL*Net more data to client',

'virtual circuit status',

'WMON goes to sleep'

)

AND

event not like 'DFS%'

and

event not like '%done%'

and

event not like '%Idle%'

AND

event not like 'KXFX%'

order by

c2 desc

;

Resultado.

Event                                 Total  Seconds        Total      Wait
Name                                  Waits  Waiting     Timeouts (in secs)
------------------------------ ------------ -------- ------------ ---------
PGA memory operation              4,610,093       80            0      .000
log file parallel write             612,773    8,631            0      .014
log file sync                       595,143    8,682            0      .015
control file sequential read        472,261        7            0      .000
LGWR worker group idle              258,156  144,425            0      .559
jobq slave wait                     227,071  112,822      224,079      .497
DIAG idle wait                      149,646  149,635      149,643     1.000
Disk file operations I/O            106,913       85            0      .001
log file sequential read             91,427      121            0      .001
wait for unread message on bro       74,945   74,951       74,945     1.000
adcast channel

heartbeat redo informer              74,928   74,944            0     1.000
Space Manager: slave idle wait       73,101  331,945            0     4.541
watchdog main loop                   49,958  149,858            0     3.000
ADR block file read                  34,627      170            0      .005
db file sequential read              32,187       36            0      .001
control file parallel write          31,542    2,142            0      .068
LGWR all worker groups               27,558      525            0      .019
pman timer                           24,983   74,943       24,981     3.000
OFS idle                             24,982   74,951       24,981     3.000
lreg timer                           24,961   74,947       24,957     3.003
db file async I/O submit              8,594      252            0      .029
asynch descriptor resize              8,346        0        8,346      .000
os thread creation                    8,309       15            0      .002
oracle thread bootstrap               8,307      173            0      .021
LGWR any worker group                 5,819      145            0      .025
Streams AQ: qmn coordinator id        5,417   74,933            1    13.833
le wait

class slave wait                      5,343        1            0      .000
db file scattered read                4,155        5            0      .001
SQL*Net vector data to client         2,954        0            0      .000
Streams AQ: qmn slave idle wai        2,743   74,933            0    27.318
t

reliable message                      2,690        1            0      .000
get branch/thread/sequence enq        2,671        0            0      .000
ueue

Data Guard: Timer                     2,500   74,939            0    29.976
AQPC idle                             2,498   74,923        2,497    29.993
latch free                            2,264        0            0      .000
LGWR worker group ordering            1,969       12            0      .006
Log archive I/O                       1,806        2            0      .001
Log file init write                   1,806        3            0      .002
direct path read                      1,295        0            0      .000
Data Guard: Gap Manager               1,250   74,942            0    59.954
db file single write                  1,014        2            0      .002
SQL*Net more data from client           718        1            0      .001
enq: CR - block range reuse ck          650       20            0      .031
pt

row cache mutex                         633        0            0      .000
LGWR wait for redo copy                 316        0            0      .000
latch: shared pool                      281        0            0      .000
Compression analysis                    264        0            0      .000
buffer busy waits                       232        0            0      .000
log file single write                   215        0            0      .002
enq: JG - queue lock                    204        1            0      .003
library cache: mutex X                  200        0            0      .000
Parameter File I/O                      114        0            0      .000
kdic_do_merge                           102        0            0      .000
latch: In memory undo latch              94        0            0      .000
enq: RO - fast object reuse              91        0            0      .000
enq: CF - contention                     89       27            0      .303
ADR file lock                            86        0            0      .000
Redo Transport Open                      78        0            0      .000
switch logfile command                   71      134            0     1.889
rdbms ipc reply                          69        1            0      .008
ADR block file write                     65        0            0      .001
log buffer space                         54       21            0      .392
enq: PR - contention                     51        1            0      .020
row cache read                           47        0            0      .000
latch: cache buffers chains              42        0            0      .000
log file switch (checkpoint in           35        1            0      .027
complete)

undo segment extension                   23        0           22      .011
cursor: pin S                            22        0            0      .001
row cache lock                           22        0            0      .002
control file single write                21        1            0      .027
latch: call allocation                   20        0            0      .000
utl_file I/O                             19        0            0      .000
direct path write                        19        0            0      .004
Failed Logon Delay                       18       18           18     1.000
log file switch completion               18        0            0      .023
RMAN backup & recovery I/O               16        0            0      .002
log file switch (private stran           15        3            0      .198
d flush incomplete)

cursor: pin S wait on X                  15        0            0      .026
db file parallel read                    13        0            0      .001
external table write                     12        0            0      .000
latch: redo allocation                   11        0            0      .001
library cache load lock                  11        0            0      .004
library cache: bucket mutex X            10        0            0      .000
CSS initialization                        7        0            0      .004
ASM file metadata operation               6        0            0      .000
read by other session                     5        0            0      .000
resmgr:internal state change              5        1            1      .100
enq: SQ - contention                      4        0            0      .000
local write wait                          4        0            0      .003
direct path sync                          4        0            0      .000
Data file init write                      4        0            0      .003
latch: enqueue hash chains                4        0            0      .000
ksdxexeotherwait                          4        0            0      .058
KSV master wait                           3        0            3      .000
library cache lock                        3        0            0      .002
AQ Background Master: slave st            2        0            0      .002
art

latch: messages                           2        0            0      .000
external table open                       2        0            0      .002
AQPC: new master                          2        0            0      .000
latch: redo writing                       2        0            0      .000
instance state change                     2        0            0      .000
shared server idle wait                   2   74,996            0   #######
latch: active service list                2        0            0      .000
Streams AQ: load balancer idle            1       45            1    45.000
external table read                       1        2            0     2.121
library cache pin                         1        0            0      .016
enq: TX - contention                      1        0            0      .008
CRS call completion                       1        0            0      .004
cursor: mutex X                           1        0            0      .000
resmgr:plan change                        1        0            0      .005
control file heartbeat                    1        4            1     4.000
SGA: allocation forcing compon            1        0            0      .148
ent growth

DLM cross inst call completion            1        0            0      .001
enq: TX - row lock contention             1       18            0    18.270
enq: PV - syncstart                       1        0            0      .019
enq: HW - contention                      1        0            0      .016

116 rows selected.

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

Event Total Seconds Total Wait

Name Waits Waiting Timeouts (in secs)

------------------------------ ------------ -------- ------------ ---------

PGA memory operation 4,610,093 80 0 .000

log file parallel write 612,773 8,631 0 .014

log file sync 595,143 8,682 0 .015

control file sequential read 472,261 7 0 .000

LGWR worker group idle 258,156 144,425 0 .559

jobq slave wait 227,071 112,822 224,079 .497

DIAG idle wait 149,646 149,635 149,643 1.000

Disk file operations I/O 106,913 85 0 .001

log file sequential read 91,427 121 0 .001

wait for unread message on bro 74,945 74,951 74,945 1.000

adcast channel

heartbeat redo informer 74,928 74,944 0 1.000

Space Manager: slave idle wait 73,101 331,945 0 4.541

watchdog main loop 49,958 149,858 0 3.000

ADR block file read 34,627 170 0 .005

db file sequential read 32,187 36 0 .001

control file parallel write 31,542 2,142 0 .068

LGWR all worker groups 27,558 525 0 .019

pman timer 24,983 74,943 24,981 3.000

OFS idle 24,982 74,951 24,981 3.000

lreg timer 24,961 74,947 24,957 3.003

db file async I/O submit 8,594 252 0 .029

asynch descriptor resize 8,346 0 8,346 .000

os thread creation 8,309 15 0 .002

oracle thread bootstrap 8,307 173 0 .021

LGWR any worker group 5,819 145 0 .025

Streams AQ: qmn coordinator id 5,417 74,933 1 13.833

le wait

class slave wait 5,343 1 0 .000

db file scattered read 4,155 5 0 .001

SQL*Net vector data to client 2,954 0 0 .000

Streams AQ: qmn slave idle wai 2,743 74,933 0 27.318

reliable message 2,690 1 0 .000

get branch/thread/sequence enq 2,671 0 0 .000

ueue

Data Guard: Timer 2,500 74,939 0 29.976

AQPC idle 2,498 74,923 2,497 29.993

latch free 2,264 0 0 .000

LGWR worker group ordering 1,969 12 0 .006

Log archive I/O 1,806 2 0 .001

Log file init write 1,806 3 0 .002

direct path read 1,295 0 0 .000

Data Guard: Gap Manager 1,250 74,942 0 59.954

db file single write 1,014 2 0 .002

SQL*Net more data from client 718 1 0 .001

enq: CR - block range reuse ck 650 20 0 .031

row cache mutex 633 0 0 .000

LGWR wait for redo copy 316 0 0 .000

latch: shared pool 281 0 0 .000

Compression analysis 264 0 0 .000

buffer busy waits 232 0 0 .000

log file single write 215 0 0 .002

enq: JG - queue lock 204 1 0 .003

library cache: mutex X 200 0 0 .000

Parameter File I/O 114 0 0 .000

kdic_do_merge 102 0 0 .000

latch: In memory undo latch 94 0 0 .000

enq: RO - fast object reuse 91 0 0 .000

enq: CF - contention 89 27 0 .303

ADR file lock 86 0 0 .000

Redo Transport Open 78 0 0 .000

switch logfile command 71 134 0 1.889

rdbms ipc reply 69 1 0 .008

ADR block file write 65 0 0 .001

log buffer space 54 21 0 .392

enq: PR - contention 51 1 0 .020

row cache read 47 0 0 .000

latch: cache buffers chains 42 0 0 .000

log file switch (checkpoint in 35 1 0 .027

complete)

undo segment extension 23 0 22 .011

cursor: pin S 22 0 0 .001

row cache lock 22 0 0 .002

control file single write 21 1 0 .027

latch: call allocation 20 0 0 .000

utl_file I/O 19 0 0 .000

direct path write 19 0 0 .004

Failed Logon Delay 18 18 18 1.000

log file switch completion 18 0 0 .023

RMAN backup & recovery I/O 16 0 0 .002

log file switch (private stran 15 3 0 .198

d flush incomplete)

cursor: pin S wait on X 15 0 0 .026

db file parallel read 13 0 0 .001

external table write 12 0 0 .000

latch: redo allocation 11 0 0 .001

library cache load lock 11 0 0 .004

library cache: bucket mutex X 10 0 0 .000

CSS initialization 7 0 0 .004

ASM file metadata operation 6 0 0 .000

read by other session 5 0 0 .000

resmgr:internal state change 5 1 1 .100

enq: SQ - contention 4 0 0 .000

local write wait 4 0 0 .003

direct path sync 4 0 0 .000

Data file init write 4 0 0 .003

latch: enqueue hash chains 4 0 0 .000

ksdxexeotherwait 4 0 0 .058

KSV master wait 3 0 3 .000

library cache lock 3 0 0 .002

AQ Background Master: slave st 2 0 0 .002

art

latch: messages 2 0 0 .000

external table open 2 0 0 .002

AQPC: new master 2 0 0 .000

latch: redo writing 2 0 0 .000

instance state change 2 0 0 .000

shared server idle wait 2 74,996 0 #######

latch: active service list 2 0 0 .000

Streams AQ: load balancer idle 1 45 1 45.000

external table read 1 2 0 2.121

library cache pin 1 0 0 .016

enq: TX - contention 1 0 0 .008

CRS call completion 1 0 0 .004

cursor: mutex X 1 0 0 .000

resmgr:plan change 1 0 0 .005

control file heartbeat 1 4 1 4.000

SGA: allocation forcing compon 1 0 0 .148

ent growth

DLM cross inst call completion 1 0 0 .001

enq: TX - row lock contention 1 18 0 18.270

enq: PV - syncstart 1 0 0 .019

enq: HW - contention 1 0 0 .016

116 rows selected.

Fonte:dba-oracle.com , Oracle.com

Instalação Oracle XE

Publicado em 18 de abril de 2018 by rodrigosilvaesilva

Instalação Oracle XE Documentação Oficial Instalação Pacotes Requeridos Packages glibc should be greater than or equal to 2.3.4-2.41 make should be greater than or equal to 3.80 binutils should be greater than or equal to 2.16.91.0.5 gcc should be greater than or equal to 4.1.2 libaio should be greater than or equal to 0.3.104

[root@bdxe~]# yum -y install glibc make binutils gcc libaio

Dependencies Resolved

==========================================================================================================================
 Package                         Arch                   Version                          Repository                  Size
==========================================================================================================================
Updating:
 binutils                        x86_64                 2.27-27.base.el7                 ol7_latest                 5.9 M
 gcc                             x86_64                 4.8.5-28.0.1.el7                 ol7_latest                  16 M
 glibc                           x86_64                 2.17-222.el7                     ol7_latest                 3.6 M
Updating for dependencies:
 cpp                             x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 6.0 M
 gcc-c++                         x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 7.2 M
 glibc-common                    x86_64                 2.17-222.el7                     ol7_latest                  11 M
 glibc-devel                     x86_64                 2.17-222.el7                     ol7_latest                 1.1 M
 glibc-headers                   x86_64                 2.17-222.el7                     ol7_latest                 678 k
 libgcc                          x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 100 k
 libgomp                         x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 156 k
 libstdc++                       x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 303 k
 libstdc++-devel                 x86_64                 4.8.5-28.0.1.el7                 ol7_latest                 1.5 M

Transaction Summary
==========================================================================================================================
Upgrade  3 Packages (+9 Dependent packages)

Total download size: 54 M
Is this ok [y/d/N]: y

[root@bdxe~]# yum -y install glibc make binutils gcc libaio

Dependencies Resolved

==========================================================================================================================

Package Arch Version Repository Size

==========================================================================================================================

Updating:

binutils x86_64 2.27-27.base.el7 ol7_latest 5.9 M

gcc x86_64 4.8.5-28.0.1.el7 ol7_latest 16 M

glibc x86_64 2.17-222.el7 ol7_latest 3.6 M

Updating for dependencies:

cpp x86_64 4.8.5-28.0.1.el7 ol7_latest 6.0 M

gcc-c++ x86_64 4.8.5-28.0.1.el7 ol7_latest 7.2 M

glibc-common x86_64 2.17-222.el7 ol7_latest 11 M

glibc-devel x86_64 2.17-222.el7 ol7_latest 1.1 M

glibc-headers x86_64 2.17-222.el7 ol7_latest 678 k

libgcc x86_64 4.8.5-28.0.1.el7 ol7_latest 100 k

libgomp x86_64 4.8.5-28.0.1.el7 ol7_latest 156 k

libstdc++ x86_64 4.8.5-28.0.1.el7 ol7_latest 303 k

libstdc++-devel x86_64 4.8.5-28.0.1.el7 ol7_latest 1.5 M

Transaction Summary

==========================================================================================================================

Upgrade 3 Packages (+9 Dependent packages)

Total download size: 54 M

Is this ok [y/d/N]: y

…

← Posts recentes Posts antigos →