Re: 11g RedHat 5 and Hugepages? anybody successful ?

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: Jon.Crisler@xxxxxxx
  • Date: Mon, 11 Oct 2010 20:17:58 +0200

two possibile solution:

1. Open SQLPlus and even with instance in idle execute:
create pfile='/tmp/pfilename' from spfile='+ASM/path/to/spfile';

Modify the pfile and then following the same procedure create a new spfile
from memory

2. Create a standard pfile, startup nomount your instance and do the step 1
3. With asmcmd you may copy the spfile from ASM to disk, using strings
command convert it in plain text and then use if as a pfile

BTW, I always avoid to have the spfile in ASM for this and many other
similar reasons.


Other related posts: