Home » All posts

ORA-20002: Version of statistics table is too old

Em , , - 21 novembro 2013 - As 15:09 - Sem Comentarios
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');
Mais informações
Marcadores: , ,

No Server Parameter File (SPFILE) created

Em , - - As 09:06 - Sem Comentarios
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


Mais informações
Marcadores: ,

Reorganization of tables with BRSPACE

Em , - - As 08:11 - Sem Comentarios
Mais informações
Marcadores: ,

Creating OPS$ users on Unix

Em , - 20 novembro 2013 - As 14:32 - Sem Comentarios
Mais informações
Marcadores: ,

R3trans - Error 2EETW169 - Listener

Em , - 19 novembro 2013 - As 15:36 - Sem Comentarios
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                           --- dbs_ora_tnsname = 'TST'"
R3trans finished (0012).

Analise

maqtst:oratst 2> lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 14-NOV-2013 08:29:27

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=TST.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
Start Date                08-NOV-2013 13:25:47
Uptime                    5 days 19 hr. 3 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/TST/102_64/network/admin/listener.ora
Listener Log File         /oracle/TST/102_64/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))
Services Summary...
Service "TST" has 1 instance(s).
  Instance "TST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Solução
- Ajuste as variaveis de ambiente para o diretorio da nova versão.
- Execute a opção stop do listener.
- Execute a opção start do listener e observe a alteração

maqtst:oratst 4> lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 14-NOV-2013 08:30:15

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /oracle/TST/112_64/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
System parameter file is /oracle/TST/112_64/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/maqtst/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=TST.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
Start Date                14-NOV-2013 08:30:19
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/TST/112_64/network/admin/listener.ora
Listener Log File         /oracle/diag/tnslsnr/maqtst/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=TST)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=maqtst)(PORT=1527)))
Services Summary...
Service "TST" has 1 instance(s).
  Instance "TST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


Mais informações
Marcadores: ,

BRCONNECT - A file or directory in the path name does not exist

Em , - - As 14:35 - Sem Comentarios
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 -u "system/zebra*01" -c -f stats -t oradict_stats

 Abraços



Mais informações
Marcadores: ,

PSAPTEMP is empty

Em , - - As 10:16 - Sem Comentarios
Oracle

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 has
been restored.  It may be necessary to add files to these
tablespaces.  That can be done using the SQL statement:

SAP





Referencia

Note 600513 - ORA-25153 after recovery due to missing tempfiles

Solução
- Rode o comando find / -name file para localizar os datafiles referentes a esta tablespace.
Ex:
maqtst@root:/:#find / -name temp.*
/oracle/TST/sapdata1/temp_1/temp.data1
maqtst@root:/:#

- No sqlplus rodar o comando abaixo para cada datafile localizado.
Comando: alter tablespace PSAPTEMP add tempfile '<filename>' reuse;
Ex:
SYS@TST>alter tablespace PSAPTEMP add tempfile '/oracle/TST/sapdata1/temp_1/temp.data1' reuse;

Tablespace altered.

SYS@TST>

- Executar novamente o job na db13 e verificar na db02.

Abraços
Mais informações
Marcadores: ,

Particionando HD sem formatação - Windows 7

Em - 18 novembro 2013 - As 09:00 - Sem Comentarios
Mais informações
Marcadores:

Setting the national character set to UTF8

Em , - 14 novembro 2013 - As 15:59 - Sem Comentarios
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 dados
###################################################

- Verifique a versão atual.

maq01:oramaq 3> sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 14 15:08:03 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select property_value from database_properties
     where upper(property_name) = 'NLS_NCHAR_CHARACTERSET';

PROPERTY_VALUE
--------------------------------------------------------------------------------
AL16UTF16

- Verifique se seu banco de dados não está usando nenhum campo do tipo NCHAR, NVARCHAR2 or NCLOB. Caso encontre, entre em contato com o suporte da SAP.

SQL> select owner, table_name, column_name
     from dba_tab_columns
    where (data_type = 'NCHAR' or
            data_type = 'NVARCHAR2' or
            data_type = 'NCLOB') and
            owner != 'SYS' and
            owner != 'SYSTEM';

no rows selected

Changing the national character set
- Para realizar esta alteração, é necessário possuir permissão SYSDBA.

- Execute os comandos nesta ordem.

sqlplus “/as sysdba”
CONNECT / AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE = MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE = MEMORY;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET UTF8;
SHUTDOWN IMMEDIATE
STARTUP

- Verificando o national character set.

SQL> select property_value from database_properties
     where upper(property_name  2  ) = 'NLS_NCHAR_CHARACTERSET';

PROPERTY_VALUE
--------------------------------------------------------------------------------

UTF8
Mais informações
Marcadores: ,

Oracle Database 11.2.0.3 - Patches by SAP

Em , , - - As 14:40 - Sem Comentarios
Mais informações
Marcadores: , ,