Monday, January 26, 2015

fun facts of the day : SPFILE vs PFILE

Nothing spectacular 
some random observations made today


PFILE vs INIT.ora

when you startup with init.ora with deprecated parameters you get this 


 SQL>  startup nomount pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initU041P15.ora'ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecatedORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecatedORA-32006: USER_DUMP_DEST initialization parameter has been deprecatedORACLE instance started. 


same thing with spfile


ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8554127360 bytes
Fixed Size                  2198680 bytes
Variable Size            1006637928 bytes
Database Buffers         7532969984 bytes
Redo Buffers               12320768 bytes

No comments: