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.

770358 - PFCG: Role copy fails due to data inconsistency

Mais informações

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

Mais informações

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.

Mais informações

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.

Mais informações

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;

Mais informações

SAP Client Administration

http://www.datadisk.co.uk/html_docs/sap/basis/client_admin.htm

Mais informações

Analisando performance de uma transação

Referencia
http://wiki.scn.sap.com/wiki/display/ABAP/Single+Transaction+Analysis

Solução
- Execute a transação SE30 e analise as estatísticas geradas.

Mais informações

RFC Wizard

Problema
- Criar RFC utilizando um wizard.

Solução
-Utilize a transação FINB_TR_WZ

Mais informações

Export a tablespace

Applied
Oracle 11.2.0.3, 10.2.0.4

Format

exp user/pass FILE=/path/file_name.dmp tablespaces=tablespace_name

Example

exp system/manger FILE=/oracle/TST/sapdata3/clud.dmp tablespaces=PSAPCLUD 

Mais informações

EXP-00026: conflicting modes specified

Referencia
http://docs.oracle.com/cd/B10501_01/server.920/a96525/expus.htm

Problema 
maqtst:oratst 16> exp system/manager FILE=clud.dmp tablespaces=PSAPCLUD owner=SAPR3 full=y rows=y

Export: Release 11.2.0.3.0 - Production on Wed Dec 4 10:10:20 2013

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


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

Solução

- Execute o comando sem os parâmetros desnecessários.

exp system/manager FILE=clud.dmp tablespaces=PSAPCLUD

Mais informações