Problema
- Após o ajuste de retenção do AWR indicado no post Increasing AWR Retention, percebemos que o espaço livre na tablespace SYSAUX diminuiu.
Solução
- Faça um extend na tablespace SYSAUX via brtools.
Modificando a SYSAUX após ajuste de retenção AWR
Problema
- Após o ajuste de retenção do AWR indicado no post Increasing AWR Retention, percebemos que o espaço livre na tablespace SYSAUX diminuiu.
Solução
- Faça um extend na tablespace SYSAUX via brtools.
Internal error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD - W3_TOOL001
Problema
Internal
error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD; inform person
responsible
Message no. W3_TOOL001
responsible
Message no. W3_TOOL001
Referencia
Solução
- Execute a transação SIAC_PUBLISH_ALL_INT
Setando caracteres por linha no sqlplus
Referencia
http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12040.htm#i2678481
Sintaxe
SET LIN[ESIZE] {80 | n} SET LIN[ESIZE] {150 | n}
Explicação
- Configura o número total de caracteres que o SQL Plus exibe em uma linha antes de começar uma nova.
Exemplo
- Exibindo as informações sobre tablespaces.
TABLESPACE TOTAL_SPACE FREE_SPACE TOTAL_SPACE_MB
------------------------------ ----------- ---------- --------------
USED_SPACE_MB FREE_SPACE_MB PCT_FREE
------------- ------------- ----------
SYSAUX 1384120320 458293248 1320
883 437 33.11
SYSTEM 3135242240 1517944832 2990
1542 1448 48.42
- Executando o comando set linesize antes:
TABLESPACE TOTAL_SPACE FREE_SPACE TOTAL_SPACE_MB USED_SPACE_MB FREE_SPACE_MB PCT_FREE
------------------------------ ----------- ---------- -------------- ------------- ------------- ----------
SYSAUX 1384120320 458293248 1320 883 437 33.11
SYSTEM 3135242240 1517944832 2990 1542 1448 48.42
ABAP - Setando o Foco em um campo
Referencia
http://scn.sap.com/thread/621726
Sintaxe
SET CURSOR { { FIELD field [LINE line] [[DISPLAY] OFFSET off] }
| { col lin } }.
Explicação
- Por exemplo, caso sua tela tenha três campos e com seus respectivos nomes name, address e cell. Queremos colocar o foco no campo address, podemos fazer:
SET CURSOR FIELD 'ADDRESS'.
Type of role XXXXXX is undetermined
Problema
Type
of role XXXXXX is undetermined
Message no. S#431
Diagnosis
The type of the role XXXXXX
is undetermined, since there is no entry for the type COLL_AGR for this role in
the table AGR_FLAGS.
System
Response
The operation cannot
be performed for this role.
Procedure
Enter the missing
type indicator for this and all other affected roles in accordance with the
instructions in SAP Note 770358, then repeat the process.
Solução
- Aplique a
nota 770358.
BR0121E Processing of log file /oracle/SID/sapreorg/semslywd.tse failed
Problema
BR1001I BRSPACE 7.20 (34)
BR0252E Function fopen() failed for '/oracle/TST/sapreorg/semslywd.tse' at location main-5
BR0253E errno 13: Permission denied
BR0121E Processing of log file /oracle/TST/sapreorg/semslywd.tse failed
BR0700E Fatal errors occurred - terminating processing...
BR1008I End of BRSPACE processing: semslywd.tse 2013-12-10 09.35.19
BR0280I BRSPACE time stamp: 2013-12-10 09.35.19
BR1007I BRSPACE terminated with errors
###############################################################################
BR0292I Execution of BRSPACE finished with return code 3
Solução
- Altere as permissões do diretório /oracle/<SID>/sapreorg.
chmod 777 /oracle/<SID>/sapreorg
chown ora<sid>:dba /oracle/<SID>/sapreorg
BR1014I Please delete file /oracle/SID/sapreorg/.lock_tse.brs if BRSPACE was killed
Problema
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: semslxsn.tse 2013-12-10 09.22.29
BR0484I BRSPACE log file: /oracle/TST/sapreorg/semslxsn.tse
BR1013E BRSPACE currently running with function 'tsextend' or was killed
BR1014I Please delete file /oracle/TST/sapreorg/.lock_tse.brs if BRSPACE was killed
BR1015E Setting of BRSPACE lock failed
BR0700E Fatal errors occurred - terminating processing...
BR1008I End of BRSPACE processing: semslxsn.tse 2013-12-10 09.22.29
BR0280I BRSPACE time stamp: 2013-12-10 09.22.29
BR1007I BRSPACE terminated with errors
Solução
- Exclua o arquivo /oracle/<SID>/sapreorg/.lock_tse.brs.
BR0301E SQL error -14063 at location tab_onl_reorg-10
Problema
BR0301E
SQL error -14063 at location tab_onl_reorg-10, SQL statement:
'ALTER
TABLE "SAPR3"."CDCLS" ADD PRIMARY KEY ("MANDANT",
"OBJECTCLAS", "OBJECTID", "CHANGENR",
"PAGENO")'
ORA-14063:
Unusable index exists on unique/primary constraint key
BR0280I
BRSPACE time stamp: 2013-12-06 13.54.55
BR1106E
Reorganization of table SAPR3.CDCLS failed
Solução
-
Identificando o nome do index.
select
index_name,index_type,status,table_owner from dba_indexes
where table_name='RFBLG' and table_owner='SAPR3';
INDEX_NAME INDEX_TYPE STATUS
------------------------------
--------------------------- --------
TABLE_OWNER
------------------------------
SYS_IL0000437505C00008$$ LOB VALID
SAPR3
RFBLG~0 NORMAL UNUSABLE
SAPR3
- Faça um rebuild no index com status
UNUSABLE.
SQL> connect sapr3
Enter password:
Connected.
SQL> alter index SAPR3."RFBLG~0"
rebuild online;
Index
altered.
- Repita o comando da brspace para reorganização da tabela.
Exibir tamanho total de uma tabela
Problema
- Exibir tamanho total de uma tabela em mega bytes
Solução
select
segment_name table_name,
sum(bytes)/(1024*1024) MBytes
from
user_extents
where
segment_type='TABLE'
and
segment_name = 'CDCLS'
group by segment_name;
Postagens
