oracle error- ORA-00398: abort thread recovery due to reconfiguration

Oracle error

ORA-00398:	abort thread recovery due to reconfiguration
Cause:	Global enqueue service reconfiguration occurred during instance/crash recovery.
Action:	This is used internally, no action is required.

ORA-00397: instance recovery process terminated with error

Oracle error

ORA-00397:	instance recovery process terminated with error
Cause:	The foreground process doing instance recovery died.
Action:	Check the foreground trace file for the cause of recovery failure.

Oracle- Recriando tablespace temp no oracle 11g no linux.

Primeiro vamos acessar o sqlplus e verificarmos onde esta armazenada a tablespace temporária do oracle.

oracle@meuservidor:~ sqlplus /nolog

sql>conn sys@brancoproducao as sysdba

sql>select name from v$tempfile;

/u01/app/oracle/oradata/temp01.dbf

2)Vamos criar uma tablespace intermediária:

sql>CREATE TEMPORARY TABLESPACE TEMP2
TEMPFILE '/u01/app/oracle/oradata/temp02.dbf' SIZE 5M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

3)Definimos essa tablespace temporária como default:

sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;

4)Apagaremos  a tablespace TEMP antiga para que possamos recria-la novamente:

sql>DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;


5) Recriamos agora  a tablespace TEMP :

sql>CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/u01/app/oracle/oradata/temp01.dbf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

6) Definimos a tablespace temp como padrão novamente:

sql>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

7) E finalizando o nosso  tutorial apagamos a tablespace temp2 já que ela não terá mais uso:

sql>DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;