Unable to create SPFILE. 2005-10-12 - By Chirag DBA
I have started my Database with pfile and now want to create spfile.
I am using create spfile='location' from pfile;
When I see the audit parameters in pfile, it is AUDIT_TRAIL=DB,
but in SPFILE it is showing as AUDIT_TRAIL=OS, set previously but changed
now.
same with few other parameters.
I changed my init file, bounce DB with pfile and now creating spfile.
This is 9i with Solaris.
regards - chirag
<div>I have started my Database with pfile and now want to create spfile.</div>
<div> </div>
<div>I am using create spfile='location' from pfile;</div>
<div> </div>
<div>When I see the audit parameters in pfile, it is AUDIT_TRAIL=DB,</div>
<div>but in SPFILE it is showing as AUDIT_TRAIL=OS, set previously but changed
now.</div>
<div>same with few other parameters.</div>
<div>I changed my init file, bounce DB with pfile and now creating spfile.</div>
<div> </div>
<div>This is 9i with Solaris.</div>
<div> </div>
<div>regards - chirag </div>
<div> </div>
<div> </div>
<div> </div>
|
|
