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

Optimist x Pessimist


Excluindo tablespace via brtools

SAP

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

Purging AWR Reports from SYSAUX tablespaces

Extend a tablespace via brtools

 SAP

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

Modificando a SYSAUX após ajuste de retenção AWR

Oracle

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.



Reference - Installing Oracle Database 12c for Linux

Internal error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD - W3_TOOL001

SAP

Problema
Internal error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD; inform person
responsible

Message no. W3_TOOL001

Referencia

Solução

- Execute a transação SIAC_PUBLISH_ALL_INT 

Setando caracteres por linha no sqlplus

Oracle

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


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

SAP

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.