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=unav
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
volume 275AHHL4 in
library LIB3100. (SESSION: 66,
PROCESS: 11)
Solução
>audit
library LIB3100 checkl=barcode
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: Connection to unbru03.unifi.br:9902 failed - please
check host configuration (-8) [icxxman_mt.c 2477]
Referencia
Solução
- Adicione o FQDN no parâmetro icm/host_name_full da profile.
Formato:
icm/host_name_full
hostname.domain
Exemplo:
icm/host_name_full
maqtst.workgroup.com.br
- Ajuste o arquivo /etc/hosts inserindo o FQDN.
Formato:
ip FQDN
Exemplo:
10.0.0.5 maqtst.workgroup.com.br
DB13 não exibe logs do arquivo alert log
- 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 ler o arquivo alert.log.
- Para resolver o problema acima, basta obter o mesmo script, alterando apenas a linha abaixo,
create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/background';
para,
create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/diag/rdbms/tmp/TMP/trace/alert_TMP.log';
Lembrando:
- Altere o valor TMP para o SID do seu sistema.
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: Tamanho máximo de crescimento
Exemplo
alter database tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' autoextend on next 10M maxsize 10000M'
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: Tamanho máximo de crescimento
Exemplo
alter database tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' autoextend on next 10M maxsize 10000M'
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 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PSAPBTABI" '
ORA-01652: unable to extend temp
segment by 128 in tablespace PSAPTEMP
- Faça um extend na PSAPTEMP e
altere os datafiles para auto extend.
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 => '"STATTAB"', STATID =>
'"20131121114343-81481"', CASCADE => TRUE, STATOWN =>
'"SYSTEM"'); END;'
ORA-20002: Version of statistics table
SYSTEM.STATTAB is too old. Please try
upgrading it with dbms_stats.upgrade_stat_table
ORA-06512: at
"SYS.DBMS_STATS", line 11229
ORA-06512: at
"SYS.DBMS_STATS", line 12429
ORA-06512: at line 1
BR0280I BRSPACE thread 1: time stamp:
2013-11-21 12.12.11
Solução
- No sqlplus, execute:
exec DBMS_STATS.UPGRADE_STAT_TABLE('SYSTEM','STATTAB');
No Server Parameter File (SPFILE) created
Problema
**********************************************************************
SAP-Specific Pre-Upgrade Warnings
**********************************************************************
WARNING: ----> No Server Parameter File (SPFILE) created.
Recommendation: Configure a Server Parameter File.
See SAP note 601157.
Solução
601157 - Oracle9i: Server Parameter File
**********************************************************************
SAP-Specific Pre-Upgrade Warnings
**********************************************************************
WARNING: ----> No Server Parameter File (SPFILE) created.
Recommendation: Configure a Server Parameter File.
See SAP note 601157.
Solução
601157 - Oracle9i: Server Parameter File
Postagens
