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

When the SPFILE is Missing

Posted on
When you met the following situation, you are about to restore the spfile for your database.SQL> startup open;ORA-01078: failure in processing system parametersORA-01565: error in identifying file ‘+DATA/compdb/spfileprimdb.ora’ORA-17503: ksfdopn:2 Failed to open file +DATA/compdb/spfileprimdb.oraORA-15056: additional error messageORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATA/compdb/spfileprimdb.oraORA-17503: ksfdopn:2 Failed to open file +DATA/compdb/spfileprimdb.oraORA-15173: entry ‘spfileprimdb.ora’ does not exist in […]