Server Parameter File of ORACLE 11g - I

1. Default location of PFILE and SPFILE in UNIX and WINDOWS are?

For UNIX :              $ORACLE_HOME/dbs                  or   /d02/app/oracle/product/11.2.0/dbhome/dbs

For WINDOWS :  %ORACLE_HOME\database      or  c:\app\oracle\product\11.2.0\dbhome\database

SQL> show parameter spfile

NAME      TYPE        VALUE

--------- ----------- ------------------------------

spfile    string      /d01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora

2. Check database started whether with PFILE or SPFILE?

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" 

     FROM sys.v_$parameter 

     WHERE name = 'spfile';

3. Create PFILE or SPFILE from PFILE or SPFILE or MEMORY?

i. Using SPFILE (start database using spfile)

SQL> CREATE pfile FROM spfile;

or

SQL> CREATE pfile='/backup/pfile/init[SID].ora' FROM spfile;

ii. Using PFILE (start database using pfile)

SQL> CREATE spfile FROM pfile;

SQL> CREATE spfile FROM pfile='/backup/pfile/init[SID].ora';

iii. Using MEMORY

SQL> CREATE SPFILE FROM MEMORY;

iv. Using alert_[ORACLE_SID].log

....

....

....

....

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /d01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
  processes                = 150
  sessions                 = 248
  memory_target            = 6256M
  control_files            = "/d01/app/oracle/oradata/orcl/control01.ctl"
  control_files            = "/d01/app/oracle/flash_recovery_area/orcl/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  log_archive_format       = "%t_%s_%r.dbf"
  db_recovery_file_dest    = "/d01/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 5050M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/d01/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  diagnostic_dest          = "/d01/app/oracle"



......
.....