ORA-00842

Errors in new init parameters for Oracle 11g

SQL> startup nomount pfile=”C:\db\init.ora”; ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00842: DB_BLOCK_BUFFERS cannot be set with SGA_TARGET or MEMORY_TARGET ORA-01078: failure in processing system parameters

 

Solution: comment out

#memory_target=1716518912

Leave a Reply