Oracle – Página: 11 – Rodrigo Silva e Silva

ORA-01017 – SEC_CASE_SENSITIVE_LOGON

Publicado em 24 de abril de 2018 by rodrigosilvaesilva

Quando é habilitado o parametro de SEC_CASE_SENSITIVE_LOGON no Oracle 12.2.0.1, o usuário SYS para de autenticar. Para contornar esse problema aplicamos a seguinte solução desabilitando senha case sensitive

SQL> alter system set sec_case_sensitive_logon=false scope=spfile;
SQL> 
SQL> shutdown immediate; 
SQL> 
SQL> startup 
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

SQL> alter system set sec_case_sensitive_logon=false scope=spfile;

SQL>

SQL> shutdown immediate;

SQL>

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Editar o arquivo sqlnet.ora

[oracle@bdora ~]$ vim $ORACLE_HOME/network/admin/sqlnet.ora

Adicionar linha abaixo
 
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

[oracle@bdora ~]$ vim $ORACLE_HOME/network/admin/sqlnet.ora

Adicionar linha abaixo

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

Verificando parâmetro de PASSWORD_VERSION

SQL > select username, password_versions from DBA_USERS where username IN ('SYSTEM','SYS');

USERNAME   PASSWORD_VERSIONS
---------- -----------------
SYS        10G 11G 12C
SYSTEM     10G 11G 12C

SQL > select username, password_versions from DBA_USERS where username IN ('SYSTEM','SYS');

USERNAME PASSWORD_VERSIONS

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

SYS 10G 11G 12C

SYSTEM 10G 11G 12C

É necessário alterar a senha do usuário.

alter user NOME_USUARIO identified by SENHA;

1	alter user NOME_USUARIO identified by SENHA;

Fonte: André Spadini

DataPump erro ORA-31633: unable to create master table “SYSTEM.SYS_IMPORT_SCHEMA_06”

Publicado em 24 de abril de 2018 by rodrigosilvaesilva

[oracle@bdora]$ time impdp system/senha schemas=Nome directory=BKPDIR dumpfile=NOME_SCHEMA.dmp logfile=impNovo.log EXCLUDE=STATISTICS

Import: Release 11.2.0.2.0 - Production on Tue Apr 24 10:12:49 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_IMPORT_SCHEMA_06"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

real    0m0.397s
user    0m0.022s
sys     0m0.022s

[oracle@bdora]$ time impdp system/senha schemas=Nome directory=BKPDIR dumpfile=NOME_SCHEMA.dmp logfile=impNovo.log EXCLUDE=STATISTICS

Import: Release 11.2.0.2.0 - Production on Tue Apr 24 10:12:49 2018

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

ORA-31626: job does not exist

ORA-31633: unable to create master table "SYSTEM.SYS_IMPORT_SCHEMA_06"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT", line 1020

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

real 0m0.397s

user 0m0.022s

sys 0m0.022s

Visualizando eventos ddl

SYS@XE > select owner, object_name, object_type, status from dba_objects where lower(object_name) like '%evs_monitoring_ddl';
no rows selected

1 2	SYS@XE > select owner, object_name, object_type, status from dba_objects where lower(object_name) like '%evs_monitoring_ddl'; no rows selected

Verificando fila de execução datapump

column owner_name format a20;
column job_name format a20;
column operation format a10;
column job_mode format a10;
column state format a15;
column attached_sessions format a10;

column owner_name format a20;

column job_name format a20;

column operation format a10;

column job_mode format a10;

column state format a15;

column attached_sessions format a10;

SYS@XE > SELECT owner_name, job_name, operation, job_mode, state, attached_sessions
FROM dba_datapump_jobs;

OWNER_NAME           JOB_NAME             OPERATION  JOB_MODE   STATE           ATTACHED_SESSIONS
-------------------- -------------------- ---------- ---------- --------------- -----------------
SYSTEM               SYS_IMPORT_SCHEMA_01 IMPORT     SCHEMA     NOT RUNNING            ##########

SYS@XE > SELECT owner_name, job_name, operation, job_mode, state, attached_sessions

FROM dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE ATTACHED_SESSIONS

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

SYSTEM SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA NOT RUNNING ##########

Dropando table system.SYS_IMPORT_SCHEMA_01

SYS@XE > drop table system.SYS_IMPORT_SCHEMA_01;
Table dropped.

1 2	SYS@XE > drop table system.SYS_IMPORT_SCHEMA_01; Table dropped.

Verificando Jobs

SYS@XE > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs;
no rows selected

1 2	SYS@XE > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs; no rows selected

Listar espaço Livre Tablespaces

Publicado em 23 de abril de 2018 by rodrigosilvaesilva

Select para listar espaço disponível Tablespaces

column dummy noprint
column pct_used format 999.9 heading "%|Used"
column name format a16 heading "Tablespace Name"
column Kbytes format 999,999,999 heading "KBytes"
column used format 999,999,999 heading "Used"
column free format 999,999,999 heading "Free"
column largest format 999,999,999 heading "Largest"
break on report
compute sum of kbytes on report
compute sum of free on report
compute sum of used on report

column dummy noprint

column pct_used format 999.9 heading "%|Used"

column name format a16 heading "Tablespace Name"

column Kbytes format 999,999,999 heading "KBytes"

column used format 999,999,999 heading "Used"

column free format 999,999,999 heading "Free"

column largest format 999,999,999 heading "Largest"

break on report

compute sum of kbytes on report

compute sum of free on report

compute sum of used on report

SYS@XE >
select nvl(b.tablespace_name,
nvl(a.tablespace_name,'UNKOWN')) name,
kbytes_alloc kbytes,
kbytes_alloc-nvl(kbytes_free,0) used,
nvl(kbytes_free,0) free,
((kbytes_alloc-nvl(kbytes_free,0))/
kbytes_alloc)*100 pct_used,
nvl(largest,0) largest
from ( select sum(bytes)/1024 Kbytes_free,
max(bytes)/1024 largest,
tablespace_name
from sys.dba_free_space
group by tablespace_name ) a,
( select sum(bytes)/1024 Kbytes_alloc,
tablespace_name
from sys.dba_data_files
group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
order by &1
/

SYS@XE >

select nvl(b.tablespace_name,

nvl(a.tablespace_name,'UNKOWN')) name,

kbytes_alloc kbytes,

kbytes_alloc-nvl(kbytes_free,0) used,

nvl(kbytes_free,0) free,

((kbytes_alloc-nvl(kbytes_free,0))/

kbytes_alloc)*100 pct_used,

nvl(largest,0) largest

from ( select sum(bytes)/1024 Kbytes_free,

max(bytes)/1024 largest,

tablespace_name

from sys.dba_free_space

group by tablespace_name ) a,

( select sum(bytes)/1024 Kbytes_alloc,

tablespace_name

from sys.dba_data_files

group by tablespace_name )b

where a.tablespace_name (+) = b.tablespace_name

order by &1

Enter value for 1: 1
old  19: order by &1
new  19: order by 1

                                                             %
Tablespace Name        KBytes         Used         Free   Used      Largest
---------------- ------------ ------------ ------------ ------ ------------
PROD01_DATA         4,706,304    4,337,664      368,640   92.2      368,640
PROD01_INDX         5,242,880        4,096    5,238,784     .1    2,096,128
SYSAUX                675,840      638,784       37,056   94.5       36,864
SYSTEM                614,400      613,568          832   99.9          832
UNDOTBS1              179,200      155,456       23,744   86.8        4,096
USERS                 102,400        2,624       99,776    2.6       99,776
                 ------------ ------------ ------------
sum                11,521,024    5,752,192    5,768,832

6 rows selected.

Enter value for 1: 1

old 19: order by &1

new 19: order by 1

Tablespace Name KBytes Used Free Used Largest

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

PROD01_DATA 4,706,304 4,337,664 368,640 92.2 368,640

PROD01_INDX 5,242,880 4,096 5,238,784 .1 2,096,128

SYSAUX 675,840 638,784 37,056 94.5 36,864

SYSTEM 614,400 613,568 832 99.9 832

UNDOTBS1 179,200 155,456 23,744 86.8 4,096

USERS 102,400 2,624 99,776 2.6 99,776

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

sum 11,521,024 5,752,192 5,768,832

6 rows selected.

Kbytes = espaço alocado para o espaço de tabela atualmente.
Usado = espaço alocado dentro do espaço de tabela para específico
objetos
Livre = espaço ainda não alocado para qualquer objeto
Usado =% do espaço alocado para objetos no espaço de tabela
Maior = Maior extensão contígua gratuita disponível (NEXT_EXTENTS
maior então isso irá falhar

Kbytes = espaço alocado para o espaço de tabela atualmente.

Usado = espaço alocado dentro do espaço de tabela para específico

objetos

Livre = espaço ainda não alocado para qualquer objeto

Usado =% do espaço alocado para objetos no espaço de tabela

Maior = Maior extensão contígua gratuita disponível (NEXT_EXTENTS

maior então isso irá falhar

Fonte: Ask Tom

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 →