How to Move Oracle Database
Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »How to Move Oracle Database
Parameter File (PFILE)
Where is Oracle SPFILE Location
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora PFILE… Read More »Where is Oracle SPFILE Location
How to Point to SPFILE in PFILE to Trick Scripts
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
SPFILE or PFILE?
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 »SPFILE or PFILE?
Where is Oracle PFILE Location
If we were trying to change parameters in an unfamiliar database that was handed over from other DBA, we have to figure it out whether… Read More »Where is Oracle PFILE Location
Show Parameter Spfile
Show Parameter Spfile Whenever you want to know the location of Server Parameter File (SPFILE), I think the first thing you want to do is… Read More »Show Parameter Spfile
How to Raise SGA_TARGET or MEMORY_TARGET
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 Raise SGA_TARGET or MEMORY_TARGET
Don't Forget to Add Tempfiles Back After Restoring 9i Database
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
Alter System Scope, SID and Container
ALTER SYSTEM SET When we issue ALTER SYSTEM SET to modify parameter, some scope clauses can be used to specify how new value is applied… Read More »Alter System Scope, SID and Container
How to Startup a Misconfigured Database ORA-00837
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