New Features of Oracle 11g-spfile Management

 

 

 

Before Oracle 11g, we can create pfile from spfile or use pfile to create spfile. In Oracle 11g, spfile management is enhanced. You can use memory to create pfile and spfile.

 

Syntax:

Create pfile [= 'pfile _ name']

From {spfile [= 'spfile _ name']} | memory };

 

Create spfile [= 'spfile _ name']

From {pfile [= 'pfile _ name']} | memory };

 

 

 

Example:

 

[:43 Oracle @ Dave/u01/backup] $ ora Si

 

SQL * Plus: Release 11.2.0.3.0 production onfri Oct 12 15:43:22 2012

 

Copyright (c) 1982,201 1, Oracle. All rights reserved.

 

 

Connected:

Oracle Database 11g enterprise editionrelease 11.2.0.3.0-64bit Production

With the partitioning, OLAP, data miningand real application testing options

 

SQL> Create pfile from memory;

 

File Created.

 

SQL> Create spfile from memory;

Create spfile from memory

*

Error at line 1:

ORA-32002: cannot createspfile already being used by the instance

-- For Open instances, spfile cannot be created from memory.

 

SQL> startup Mount force;

Oracle instance started.

 

Total system global area 730714112 bytes

Fixed size 2231952 bytes

Variable Size 285213040 bytes

Database buffers 419430400 bytes

Redo buffers 23838720 bytes

Database mounted.

SQL> select open_mode from V $ database;

 

Open_mode

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

Mounted

 

SQL> Create spfile from memory;

Create spfile from memory

*

Error at line 1:

ORA-32002: cannot createspfile already being used by the instance

-- The Mount status cannot be used either.

 

SQL> startup nomount force;

Oracle instance started.

 

Total system global area 730714112 bytes

Fixed size 2231952 bytes

Variable Size 285213040 bytes

Database buffers 419430400 bytes

Redo buffers 23838720 bytes

SQL> Create spfile from memory;

Create spfile from memory

*

Error at line 1:

ORA-32002: cannot createspfile already being used by the instance

-- Nomount status is not allowed.

 

SQL> shutdown abort;

Oracle instance shut down.

SQL> Create spfile from memory;

Create spfile from memory

*

Error at line 1:

ORA-00922: Missing or invalid option

-- The syntax cannot be used after the database is closed.

 

 

We use pfile to start the database and create the spfile:

SQL> startuppfile = '/u01/APP/Oracle/product/11.2.0/db_1/dbs/initdave. ora'

Oracle instance started.

 

Total system global area 730714112 bytes

Fixed size 2231952 bytes

Variable Size 285213040 bytes

Database buffers 419430400 bytes

Redo buffers 23838720 bytes

Database mounted.

Database opened.

SQL> Create spfile from memory;

 

File Created.

-- This creation is successful.

 

Note:

(1) In the RAC environment, the generated script will contain parameters of all nodes.

(2) You must use the sysdba or sysoper role to execute this command.

 

 

 

 

 

 

Bytes ---------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

QQ: tianlesoftware@gmail.com

Email: tianlesoftware@gmail.com

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware