Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Quick Tips

Verify Database and ASM instances use same SPFILE

0 Comments

Benefit / Impact:

All instances for a particular database or ASM cluster should be using the same spfile. Making changes to databases and ASM instances needs to be done in a reliable and consistent way across all instances.

Risk:

Multiple 'sources of truth' can cause confusion and possibly unintended values being set.

Action / Repair:

Verify what spfile is used across all instances of one particular ASM or database cluster. If multiple spfiles for one database are found, provide a recommendation to consolidate them into one.

Scope includes all machine types, os types and db versions

SQL> select name, value from gv$parameter where name = 'spfile';

 

NAME                           VALUE

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

spfile                         +DATA/racone/spfileracone.ora

 

The value for pfile should be empty:

SQL> select name, value from gv$parameter where name = 'pfile';

no rows selected

 

Ref: 1274318.1

Posted on : by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Open world 2018 is on the corner! Are you attending?
Posted on :   9/7/2018

Step by Step Oracle Database 18c Installation on Oracle Linux 6
Posted on :   9/4/2018

APACOUC Session - Oracle 12cR1 was great Oracle 12c R2 is awesome! by Anuj Mohan
Posted on :   9/4/2018

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c