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