Error oracle- Corrigindo ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Esse erro acontece quando o spfile não está sendo usado no banco vejamos um exemplo abaixo:

sql> ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile;
ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile;
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use

Para resolver esse problema primeiro vamos verificar se o spfile esta ou não sendo usado:


sqlplus /nolog

sql>Conn sys / as sysdba


sql>show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string

No exemplo acima vemos que o value está em branco  o que significa que não está sendo usado.

Criando o spfile:


sql> create spfile from pfile;

Após isso iremos desativar e ativar novamente a instancia para que a mesma carregue as informações do spfile:


sql> shutdown immediate

sql> startup

agora iremos ver se o spfile foi carregado:


sql> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/11.2.0
                                                 /db_1/dbs/spfileprodnew.ora



Agora basta rodar o comando novamente para que a opção seja alterada:

sql> ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile;
System altered.

oracle error- ORA-00332: archived log is too small - may be incompletely archived

ORA-00332:	archived log is too small - may be incompletely archived
Cause:	The log is smaller than the space allocated in it. May be the result of a shutdown abort while it was being written by the archiver.
Action:	Get a complete version of this log and use it for recovery. There should either be an online version of it or a copy that was successfully archived.

oracle error- ORA-00331: log version string incompatible with ORACLE version string

ORA-00331:	log version string incompatible with ORACLE version string
Cause:	The log was written by incompatible version of Oracle.
Action:	Recover the database with the compatible software, shut it down cleanly, then restart with current software.