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

IMP-00058: ORACLE error 1017 encountered

Problema
IMP-00058: ORACLE error 1017 encountered

Solução

- Verifique a senha do usuário utilizado no comando imp.

Mais informações

SAP Solution Manager 7.0 EHP 1 - Media List

https://websmp106.sap-ag.de/~sapidb/011000358700000204832011E

Mais informações

BRTOOLS - BR0253E errno 13: Permission denied

Referência

583861-Unix-Errors due to Oracle Executable

97953 - UNIX-Relinking of the Oracle executables

113747 - Permissions dba tools and sapdba

134592 - Importing the SAPDBA role

Note 113747 - Owners and authorizations for BR*Tools

Problema 1

- Na db13.

Job started

Step 001 started (program RSDBAJOB, variant &0000000000183, user ID DENISGOMES)

Execute logical command BRCONNECT On host unbru10

Parameters: -u / -jid CLNUP20111027162839 -c -f cleanup

BR0801I BRCONNECT 7.00 (32)

BR0252E Function fopen() failed for '/oracle/TSA/102_64/dbs/initTSA.sap' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile /oracle/TSA/102_64/dbs/initTSA.sap

BR0806I End of BRCONNECT processing: cehbzqhk.log2011-10-27 16.28.40

BR0280I BRCONNECT time stamp: 2011-10-27 16.28.40

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Solução 1

- Entre no diretório $ORACLE_HOME/dbs. Verifique se o arquivo init<SID>.sap existe, senão existir, verifique se existe com outro SID e altere o SID para o corrente.

Problema 2

- Na db13

Job started

Step 001 started (program RSDBAJOB, variant &0000000000184, user ID DENISGOMES)

Execute logical command BRCONNECT On host unbru10

Parameters: -u / -jid CLNUP20111027163102 -c -f cleanup

BR0801I BRCONNECT 7.00 (32)

BR0805I Start of BRCONNECT processing: cehbzqmw.cln 2011-10-27 16.31.02

BR0252E Function fopen() failed for '/oracle/TSA/sapcheck/cehbzqmw.cln' at location main-11

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/TSA/sapcheck/cehbzqmw.cln failed

BR0806I End of BRCONNECT processing: cehbzqmw.cln2011-10-27 16.31.03

BR0280I BRCONNECT time stamp: 2011-10-27 16.31.03

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Problema 3

01.05.2013      21:00:16         BR0806I End of BRCONNECT processing: celckhfc.log2013-05-01 21.00.16

01.05.2013      21:00:16         BR0280I BRCONNECT time stamp: 2013-05-01 21.00.16

01.05.2013      21:00:16         BR0804I BRCONNECT terminated with errors

01.05.2013      21:00:16         External program terminated with exit code 3

01.05.2013      21:00:16         Internal session terminated with a runtime error (see ST22)

01.05.2013      21:00:16         Job cancelled

Solução 2

- No diretorio /sapmnt/<SID>/exe.

Formato:

chmod 4775 brarchive brbackup brconnect

chown ora<sid>:sapsys brarchive brbackup brconnect

chmod 755 brrestore brrecover brspace brtools

chown <sid>adm:sapsys brrestore brrecover brspace brtools

Exemplo:

chmod 4775 brarchive brbackup brconnect

chown oratsa:sapsys brarchive brbackup brconnect

chmod 755 brrestore brrecover brspace brtools

chown tsaadm:sapsys brrestore brrecover brspace brtools 

Mais informações