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