Solução
sudo pas...
Home » Archives for novembro 2013
Bundle Script Log Files - INCOMPLETE

Problema
* Found the following unexpected
errors:
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2732:
PLS-00201
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2738:
PLS-00302
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:2744:
PLS-00302
catbundle_SBP_TST_APPLY_2013Nov27_13_12_29.log:63955:
PLS-00302
*****...
GC 3 The active profile was modified

Problema
- Na SM21.
GC 3 The active profile was modified
Documentation
for system log message GC 3 :
Das aktive
Profile wurde modifiziert.
The profile
in the database does not match the active profile in the
operating
system. After...
Brspace-f tscreate - Options

http://help.sap.com/saphelp_nw04/helpdata/en/99/eaac06eec707428e2b0b9d9d9d647a/content....
Listando tablespaces, tamanho total, espaço livre

Referencia
http://psoug.org/snippet/TABLESPACE--List-tablespaces-files-allocated-and-free-space_852.htm
Script
SELECT df.tablespace_name TABLESPACE, df.total_space
TOTAL_SPACE,
fs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB,
(df.total_space_mb...
Checking swap space: 0 MB available, 150 MB required. Failed

Checking swap space: 0 MB available, 150 MB required. Failed <<<<
I checked the tmp file system space and the swap from Aix, there any
problem with it.
maqtst@root:/oracle/TST:>swap -l
device maj,min total free
/dev/paging03 10,...
ANR2410E: Command: Unable to access volume volume name - access mode is set to "unavailable".

Problema
ANR2410E: Command:
Unable to access volume volume name - access mode is set to
"unavailable".
Solução
update
vol * acce=readw whereacc=un...
ANR8356E - Incorrect volume was mounted instead of volume in library

Problema
11/21/13 17:24:02
ANR8356E Incorrect volume 392AHHL4 was mounted instead of
...
Error IcmJ2EEScheduleFunc - Please check host configuration

Problema
- Na transação ST11, no arquivo dev_icm.
*** ERROR
=> Connection request from (-1/65535/0) to host: unbru03.unifi.br, service:
9902 failed (NIEHOST_UNKNOWN) {00000098} [icxxconn_mt.c 2712]
*** ERROR
=> IcmJ2EEScheduleFunc:...
DB13 não exibe logs do arquivo alert log

Problema
- Após migação do Oracle 10g para o Oracle 11g, a transação DB13 não exibie os logs do arquivo alert.log.
Solução
- Na postagem EXCEPTION CX_DBA_ADBC, CX_SQL_EXCEPTION - ORA-00942 indiquei um script para correção de um erro ao tentar...
Alterando um datafile para autoextend on
Modelo
alter database tempfile '/path/datafile_name' autoextend on next valueM maxsize sizeM'
onde,
path: Caminho do datafile
datafile_name: Nome do datafile
value: Valor que será acrecido quando um datafile precisa de espaço
size:...
ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Problema
BR0301E SQL error -1652 in thread 3 at
location tab_onl_reorg-26, SQL statement:
'CREATE UNIQUE INDEX
"SAPR3"."MLCRP~0#$" ON
"SAPR3"."MLCRP#$" ("MANDT", "BELNR",
"KJAHR", "POSNR", "BDATJ", "POPER",
"CURTP")
PCTFREE 10 INITRANS...
Exibindo espaço usado por datafile
http://learndbas.blogspot.com.br/2009/01/show-used-sapce-free-space-per-datafile.h...
ORA-20002: Version of statistics table is too old
Problema
BR0280I BRSPACE thread 2: time stamp:
2013-11-21 12.12.07
BR0301W SQL error -20002 in thread 2 at
location tab_onl_reorg-12, SQL statement:
'BEGIN DBMS_STATS.EXPORT_TABLE_STATS
(OWNNAME => '"SAPR3"', TABNAME => '"WWWDATA"',
STATTAB...
No Server Parameter File (SPFILE) created
Problema
**********************************************************************
SAP-Specific Pre-Upgrade Warnings
**********************************************************************
WARNING: ----> No Server Parameter File (SPFILE) created.
...
Reorganization of tables with BRSPACE

Reorganizing Tables with BR*Tools
646681 - Reorganization of tables with BRSP...
R3trans - Error 2EETW169 - Listener
Problema
maqtst:tstadm 1> R3trans -x
This is R3trans version 6.24 (release 720 - 14.03.13 - 20:13:02 ).
sizeof(Selection_t) = 336
2EETW169 no connect possible: "DBMS = ORACLE ...
BRCONNECT - A file or directory in the path name does not exist
Problema
maqtst:oratst 3> brconnect -u system/zebra*01 -c -f stats -t oradict_stats
system/: A file or directory in the path name does not exist.
Solução
- Execute o comando com o usuário e a senha entre aspas duplas.
maqtst:oratst 3> brconnect...
PSAPTEMP is empty

Problema 1:
ORA-12012: error on auto
execute of job 8936
ORA-25153: Temporary Tablespace
is Empty
Problema 2:
- No alert.log.
WARNING: The
following temporary tablespaces contain no files.
This condition can
occur when a backup controlfile...
Particionando HD sem formatação - Windows 7
http://www.profissionaisti.com.br/2012/09/particionar-o-hd-no-windows-7-sem-formatar-e-sem-programas-adiciona...
Setting the national character set to UTF8
Referência
669902 - Setting
the national character set to UTF8
Aplicável
- Oracle 9, Oracle 10 e Oracle 11
Solução
###################################################
Antes de
realizar esta alteração, faça um backup do banco de...
Oracle Database 11.2.0.3 - Patches by SAP
Note 1631931 -
Oracle 11.2.0: Patches / Patch collections for 11.2.0...
Erro na porta 21200 durante instalação do SAP Ecc 6

-Verificar o arquivo
/etc/hosts. Check o ip da maquina e o seu hostname.
- Adicionar no $PATH o
caminho do “java1.4.2”.
export PATH=/usr/java14_64/jre/bin:/usr/java14_64/bin:$PATH
set –o ...
Extending MAXPPs of a Logical Volume
Problema
maqtst@root:/oracle/TST:#chfs -a size=+5G /oracle/TST/sapdata2
0516-787 extendlv: Maximum allocation for logical volume tstsapdata2lv
is 900.
Solução
- Formato do camando:
#chlv -x maxpps
logicalvolume
...