ORA-02097

How to Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

by Ed Chen
April 16, 2018December 11, 2022

ORA-16018 Got an error "ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST" when I tried to set the parameter like this: SQL> alter system set… Read More »

How to Raise SGA_TARGET or MEMORY_TARGET

by Ed Chen
December 12, 2016October 14, 2021

Tuning ASSM or ASM target can never be done within SCOPE=MEMORY or even SCOPE=BOTH, which is not allowed. SQL> alter system set sga_target=64g scope=both; alter… Read More »

How to Resolve ORA-01220: file based sort illegal before database is open

by Ed Chen
October 9, 2016January 12, 2021

When I queried the archive gap on the standby database which is a 9i database, I got this error: SQL> select * from v$archive_gap; select… Read More »

How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid

by Ed Chen
December 9, 2012December 11, 2022

When you ALTER SYSTEM to modify an initialization parameter, it sometimes fails with ORA-02097 ORA-02097: parameter cannot be modified because specified value is invalid Reproduce… Read More »

How to Startup a Misconfigured Database ORA-00837

by Ed Chen
October 26, 2012May 31, 2023

A misconfigured database is a database which was set with wrong values of initialization parameters in SPFILE, it will prevent the database from startup. Let's… Read More »

JavaScript is not enabled. Please enable it and reload the page.