oracle@srv-db-01:/u01/app/oracle/product/11.2.0/db_1/dbs$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 11:23:42 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn sys@oracle as sysdba
Enter password:
SQL> conn sys / as sysdba
Enter password:
Connected to an idle instance.
Subindo banco
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
Para resolver o problema editei o arquivo init.ora da instância orcl:
nano oracle@srv-db-01:/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora
Agora alteraremos o memory_target de 1GB para 500M
memory_target=500M
Logue novamente no sqlplus, vamos iniciar o banco com o arquivo init.ora que alteramos:
SQL> startup pfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora’
ORACLE instance started.
Total System Global Area 523108352 bytes
Fixed Size 1337632 bytes
Variable Size 314574560 bytes
Database Buffers 201326592 bytes
Redo Buffers 5869568 bytes
Database mounted.
Database opened.
Finalizando Criaremos agora o spfile apartir do arquivo init.ora, que modificamos o memory_target, para que na proxima inicializacao ele ja carregue com os novos parametros sem precisar setar o arquivo pfile:
SQL> create spfile from pfile=’/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora’
File created.
Veja mais dicas sobre oracle aqui.