Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora… Read More »The Default Location of SPFILE and PFILE for Linux and Windows
In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »How to Point to SPFILE in PFILE to Trick Scripts
If we need to change some values of parameters persistently, what should we start? First of all, we have to know whether the database started… Read More »Whether Database Started with SPFILE or PFILE?
Tunning ASSM or ASM target can never be done within memory scope, which is not allowed.SQL> alter system set sga_target=64g scope=both;alter system set sga_target=64g scope=both*ERROR… Read More »How to Raise SGA_TARGET or MEMORY_TARGET
If your database is 10g onward, you don't have to worry about it, the control file will recreate the tempfiles after database restore, but for… Read More »Don't Forget to Add Tempfiles Back After Restoring 9i Database
Without declaring SCOPEIf you do not specify this clause, then:If a server parameter file was used to start up the database, then BOTH is the… Read More »The Default Values in "ALTER SYSTEM SET" Statement
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 »How to Startup a Misconfigured Database ORA-00837