martes, 14 de abril de 2015

CAMBIO PARAMETROS SPFILE +ASM

SQL> startup pfile=initORCLTEST.ora
ORACLE instance started.
Total System Global Area 2138521600 bytes
Fixed Size                  2183272 bytes
Variable Size             603983768 bytes
Database Buffers         1526726656 bytes
Redo Buffers                5627904 bytes
Database mounted.
Database opened.

SQL> show parameter spfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> show parameter sga;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 2G
sga_target                           big integer 2G
SQL> show parameter memory;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 4G
memory_target                        big integer 3G
shared_memory_address                integer     0

SQL> create spfile='+DG_DATA1/orcltest/spfileorcltest.ora' from pfile='/u01/app/oracledb/product/11.2.0/db_1/dbs/initORCLTEST.ora';
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

ANTES BORRAR EL ARCHIVO SPFILE EN SISTEMA OPERATIVO PARA OBLIGAR QUE CONSULTE EL DE +ASM Y VERIFICAR A NIVEL DE SISTEMA OPERATIVO QUE EXISTA EL ARCHIVO INIT QUE APUNTE A +ASM

SQL> startup
ORACLE instance started.
Total System Global Area 2138521600 bytes
Fixed Size                  2183272 bytes
Variable Size             587206552 bytes
Database Buffers         1543503872 bytes
Redo Buffers                5627904 bytes
Database mounted.
Database opened.
SQL>
SQL> show parameter spfile;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DG_DATA1/orcltest/spfileorclt
                                                 est.ora
SQL> show parameter memory;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 4G
memory_target                        big integer 3G
shared_memory_address                integer     0
SQL>