Denis Fernandes Gomes no SAP Forum Brasil 2014

Boa tarde!
   Serei palestrante no SAP Forum Brasil 2014 com o seguinte tema "Case Unifi: Otimizando processos de armazenagem". 
   No dia 12/02/14, às 01:30 PM no Transamérica Expo Center em São Paulo.
   Abordaremos a utilização do SAP ITSMobile na solução de problemas de armazenagem. 

Nos encontramos em Fevereiro!
Abraços

Mais informações

Optimist x Pessimist

Mais informações

Excluindo tablespace via brtools

Referencia
http://help.sap.com/saphelp_nw70/helpdata/en/99/364d3f51a9995ee10000000a114084/content.htm

Solução
- Execute o comando no formato abaixo:

brspace -f tsdrop -t tablespace_nome

onde,
tablespace_nome = Nome da tablespace que se deseja excluir. Caso o nome da sua tablespace possua espaço, utilize aspas duplas.

Exemplo
maqtst:oratst 5> brspace -f tsdrop -t "PSAPCLUI ADD"
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: semuadom.tsd 2013-12-18 13.45.40
BR0484I BRSPACE log file: /oracle/TST/sapreorg/semuadom.tsd

BR0280I BRSPACE time stamp: 2013-12-18 13.45.41
BR1009I Name of database instance: TST
BR1010I BRSPACE action ID: semuadom
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop

BR0280I BRSPACE time stamp: 2013-12-18 13.45.42
BR0657I Input menu 310 - please enter/check input values
-------------------------------------------------------------------------------
Options for dropping of tablespace PSAPCLUI ADD

 1 * Number of files in tablespace (files) . [1]
 2 * Total tablespace size in MB (size) .... [40]
 3 - Force tablespace drop (force) ......... [no]
 4 - SQL command (command) ................. [drop tablespace PSAPCLUI ADD]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

BR0662I Enter your choice:
c

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2013-12-18 13.47.36

BR1090I Dropping tablespace PSAPCLUI ADD ...

BR0280I BRSPACE time stamp: 2013-12-18 13.47.36

BR1016I SQL statement 'drop tablespace "PSAPCLUI ADD"' executed successfully

BR1069I Tablespace PSAPCLUI ADD dropped successfully

BR0794I Database file /oracle/TST/sapdata1/clui_1/clui.data1 deleted

BR0480I Directory /oracle/TST/sapdata1/clui_1 deleted

BR1821I Table data class (tabart) handling will be executed now

BR0280I BRSPACE time stamp: 2013-12-18 13.47.36

BR0675I This is a recommended action - do you want to execute it now?

BR0676I Enter 'y[es]/c[ont]' to execute the action, 'n[o]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2013-12-18 13.47.56

BR0257I Your reply: 'y'

BR0677I The action will be executed...

BR1822I Table data class (tabart) handling executed successfully

BR0280I BRSPACE time stamp: 2013-12-18 13.47.57

BR0340I Switching to the next online redolog file for database instance TST ...

BR0321I Switch to the next online redolog file for database instance TST successful

BR0280I BRSPACE time stamp: 2013-12-18 13.47.59

BR0319I Control file copy created: /oracle/TST/sapreorg/semuadom/cntrlTST.new 15056896

BR0280I BRSPACE time stamp: 2013-12-18 13.47.59

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:

Abraços

Mais informações

Purging AWR Reports from SYSAUX tablespaces

http://remidian.com/2009/08/purging-sysaux-tablespace-purging-awr-reports/

Mais informações

Extend a tablespace via brtools

Problema
- Extend uma tablespace via brtools

Solução
- Faça login com o usuário ora<.sid>.
- Execute o comando brtools.
- Siga os passos abaixo.

maqtst:oratst 2> brtools
BR0651I BRTOOLS 7.20 (34)

BR0280I BRTOOLS time stamp: 2013-12-18 08.15.17
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.05

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.05

BR0656I Choice menu 5 - please make a selection

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

Database space management

 1 = Extend tablespace

 2 - Create tablespace

 3 - Drop tablespace

 4 - Alter tablespace

 5 - Alter data file

 6 - Move data file

 7 - Additional space functions

 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.13

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.13

BR0657I Input menu 81 - please enter/check input values

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

BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) ...... [initTST.sap]

 2 - Database user/password (user) .. [/]

 3 ~ Tablespace name (tablespace) ... []

 4 - Confirmation mode (confirm) .... [yes]

 5 - Scrolling line count (scroll) .. [20]

 6 - Message language (language) .... [E]

 7 - BRSPACE command line (command) . [-p initTST.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.22

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initTST.sap -s 20 -l E -f tsextend'

BR0280I BRTOOLS time stamp: 2013-12-18 08.21.22

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2013-12-18 08.22.24

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.20 (34)

BR1002I Start of BRSPACE processing: semtzawm.tse 2013-12-18 08.22.24

BR0484I BRSPACE log file: /oracle/TST/sapreorg/semtzawm.tse

BR0280I BRSPACE time stamp: 2013-12-18 08.22.25

BR1009I Name of database instance: TST

BR1010I BRSPACE action ID: semtzawm

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2013-12-18 08.22.25

BR0656I Choice menu 301 - please make a selection

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

Tablespace extension main menu

 1 = Extend tablespace

 2 - Show tablespaces

 3 - Show data files

 4 - Show disk volumes

 5 * Exit program

 6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

1

BR0280I BRSPACE time stamp: 2013-12-18 08.22.42

BR0663I Your choice: '1'

BR0280I BRSPACE time stamp: 2013-12-18 08.22.43

BR0658I List menu 302 - please select one entry

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

List of tablespaces for extension

Pos.  Tablespace    Files/AuExt.   Total[KB]   Used[%]    Free[KB]  MaxSize[KB]

  1 - PSAPBTABD         3/0         9977856     40.75     5911808      9977856

  2 - PSAPBTABI         2/0         5267456     52.02     2527488      5267456

  3 - PSAPCLUD          2/0          302080     15.17      256256       302080

  4 - PSAPCLUI          1/0          204800      6.91      190656       204800

  5 - PSAPCLUI ADD      1/0           40960      0.16       40896        40960

  6 - PSAPDDICD         3/0         8956928     29.72     6295040      8956928

  7 - PSAPDDICI         3/0         4313088     29.25     3051328      4313088

  8 - PSAPTST          10/0        15861760      0.00    15861120     15861760

  9 - PSAPTST46C        9/0        13414400      0.00    13413824     13414400

 10 - PSAPTSTUSR        1/0           20480      0.31       20416        20480

 11 - PSAPDIMD          1/0          104448      0.12      104320       104448

 12 - PSAPDIMI          1/0          104448      0.12      104320       104448

 13 - PSAPDOCUD         1/0          204800     23.38      156928       204800

 14 - PSAPDOCUI         1/0          276480     13.08      240320       276480

 15 - PSAPEL702D        3/2         1801216      0.01     1801024      3107840

 16 - PSAPEL702DX       1/0         6518784     51.55     3158144      6518784

 17 - PSAPEL702I        1/0         1048576      0.01     1048512      1048576

 18 - PSAPEL702IX       1/0         2099200      0.56     2087360      2099200

 19 - PSAPES702D        2/0        35622912      0.00    35622784     35622912

 20 - PSAPES702DX       2/0        23173120     75.11     5767616     23173120

Press <Rtn> - scroll, <n> - select, c - cont, s - skip, b - back, h - header

c

 21 - PSAPES702I        2/0        21060608      0.00    21060480     21060608

 22 - PSAPES702IX       1/0        14927872     75.09     3717888     14927872

 23 - PSAPFACTD         1/0          104448      0.18      104256       104448

 24 - PSAPFACTI         1/0          104448      0.31      104128       104448

 25 - PSAPLOADD         3/0         2244608      2.99     2177536      2244608

 26 - PSAPLOADI         2/0         1316864      0.54     1309696      1316864

 27 - PSAPODSD          1/0          114688      0.33      114304       114688

 28 - PSAPODSI          1/0          114688      0.45      114176       114688

 29 - PSAPPOOLD         4/0        12429312     67.92     3987072     12429312

 30 - PSAPPOOLI         4/0         9472000     63.48     3458816      9472000

 31 - PSAPPROTD         4/0         1476608     12.25     1295744      1476608

 32 - PSAPPROTI         3/0          489472     19.61      393472       489472

 33 - PSAPSOURCED       4/0          950272     60.96      371008       950272

 34 - PSAPSOURCEI       4/0         2096128     61.25      812224      2096128

 35 - PSAPSR3USR        1/0         1048576      0.02     1048320      1048576

 36 - PSAPSTABD         4/0        10102784     57.57     4286464     10102784

 37 - PSAPSTABI         3/0        10244096     61.94     3898624     10244096

 38 - PSAPSTAI          1/0         2560000      0.00     2559936      2560000

 39 - PSAPTEMP          1/0         3072000      0.00     3072000      3072000

 40 - PSAPUNDO          2/0         7954432      0.00     7954304      7954432

 41 - PSAPUSER1D        1/0          102400      1.81      100544       102400

 42 - PSAPUSER1I        1/0          204800      0.94      202880       204800

 43 - SYSAUX            2/0         1126400     95.27       53248      1126400

 44 - SYSTEM            3/1         1996800     76.44      470400      3686400

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your selection:

43

BR0280I BRSPACE time stamp: 2013-12-18 08.23.20

BR0663I Your selection: '43'

BR0280I BRSPACE time stamp: 2013-12-18 08.23.20

BR0657I Input menu 303 - please enter/check input values

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

Options for extension of tablespace SYSAUX (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/TST/sapdata2/system_4/sysaux04.dbf]

 2 * Last added file size in MB (lastsize) . [1000]

 3 - New file to be added (file) ........... [/oracle/TST/sapdata2/system_5/sysaux04.dbf]

 4 ~ Raw disk / link target (rawlink) ...... []

 5 - Size of the new file in MB (size) ..... [1000]

 6 - File autoextend mode (autoextend) ..... [no]

 7 # Maximum file size in MB (maxsize) ..... []

 8 # File increment size in MB (incrsize) .. []

 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux04.dbf' size 1000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

3

BR0280I BRSPACE time stamp: 2013-12-18 08.24.55

BR0663I Your choice: '3'

BR0681I Enter string value for "file" (<file>|<sapdata>|<N>) [/oracle/TST/sapdata2/system_5/sysaux04.dbf]:

/oracle/TST/sapdata2/system_5/sysaux05.dbf

BR0280I BRSPACE time stamp: 2013-12-18 08.25.02

BR0683I New value for "file": '/oracle/TST/sapdata2/system_5/sysaux05.dbf'

BR0280I BRSPACE time stamp: 2013-12-18 08.25.02

BR0657I Input menu 303 - please enter/check input values

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

Options for extension of tablespace SYSAUX (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/TST/sapdata2/system_4/sysaux04.dbf]

 2 * Last added file size in MB (lastsize) . [1000]

 3 - New file to be added (file) ........... [/oracle/TST/sapdata2/system_5/sysaux05.dbf]

 4 ~ Raw disk / link target (rawlink) ...... []

 5 - Size of the new file in MB (size) ..... [1000]

 6 - File autoextend mode (autoextend) ..... [no]

 7 # Maximum file size in MB (maxsize) ..... []

 8 # File increment size in MB (incrsize) .. []

 9 - SQL command (command) ................. [alter tablespace SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux05.dbf' size 1000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

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

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2013-12-18 08.25.21

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2013-12-18 08.25.21

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

n

BR0280I BRSPACE time stamp: 2013-12-18 08.25.42

BR0257I Your reply: 'n'

BR0678I The action will be skipped...

BR0370I Directory /oracle/TST/sapreorg/semtzawm created

BR0280I BRSPACE time stamp: 2013-12-18 08.25.43

BR0319I Control file copy created: /oracle/TST/sapreorg/semtzawm/cntrlTST.old 15056896

BR0370I Directory /oracle/TST/sapdata2/system_5 created

BR0280I BRSPACE time stamp: 2013-12-18 08.25.43

BR1088I Extending tablespace SYSAUX ...

BR0280I BRSPACE time stamp: 2013-12-18 08.26.27

BR1016I SQL statement 'alter tablespace SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux05.dbf' size 1000M autoextend off' executed successfully

BR1051I Tablespace SYSAUX extended successfully with file: /oracle/TST/sapdata2/system_5/sysaux05.dbf 1000M

BR0280I BRSPACE time stamp: 2013-12-18 08.26.27

BR0340I Switching to the next online redolog file for database instance TST ...

BR0321I Switch to the next online redolog file for database instance TST successful

BR0280I BRSPACE time stamp: 2013-12-18 08.26.29

BR0319I Control file copy created: /oracle/TST/sapreorg/semtzawm/cntrlTST.new 15056896

BR0280I BRSPACE time stamp: 2013-12-18 08.26.29

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:

Abraços

Mais informações

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.

Mais informações

Reference - Installing Oracle Database 12c for Linux

http://docs.oracle.com/cd/E16655_01/install.121/e17720/toc.htm

Mais informações

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

Referencia

Note 1276337 - ITSmobile: required internet services

Solução

- Execute a transação SIAC_PUBLISH_ALL_INT 

Mais informações

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:

SQL>set linesize 300

- Executando o comando para exibir os detalhes das tablespaces novamente:

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

Mais informações

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'.

Obs: Mesmo que seu campo tenha o nome com letra minúscula, no comando SET CURSOR deve-se inserir entre aspas simples e em letra maiúscula.

Mais informações

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

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