Administration

How to Move Oracle Database

Posted on
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 any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
PFILE and SPFILE

The Default Location of SPFILE and PFILE for Linux and Windows

Posted on
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 PFILE <ORACLE_HOME>/dbs/init<ORACLE_SID>.ora For Windows Please note that, for Windows, directory name and filename are case-insensitive. SPFILE <ORACLE_HOME>\database\spfile<ORACLE_SID>.ora PFILE <ORACLE_BASE>\admin\<ORACLE_SID>\pfile\init.ora.<n> There’s no tyops in the above path. The default location of […]
Memory

How to Raise SGA_TARGET or MEMORY_TARGET

Posted on
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 at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-00823: Specified value of sga_target greater than sga_max_sizeDid you have ever set SGA_MAX_SIZE? Let’s make sure this by inspecting […]
DDL

The Default Values in “ALTER SYSTEM SET” Statement

Posted on
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 default.If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify.Started bySCOPEspfileBOTHpfileMEMORYWithout declaring SIDIf you do […]
PFILE and SPFILE

How to Resolve SPFILE Does Not Work

Posted on
You might notice that the newly created SPFILE for a RAC database was not taking effective after restarts. I think you might create the SPFILE in the wrong places.Oracle 11g RAC stores all the shared files in ASM, including control files, spfile, data files. Thus, it starts all the instances with the shared SPFILE. If […]