Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'create pfile from spfile' - pfile shows the 'underscore' parameters but ..

garywickeMar 8 2012 — edited Mar 8 2012
Environment:

Oracle 11.2.0.3 on Solaris 10.5

I have two (2) databases on two (2) different servers that were created at the same time and using the same method.

I executed a 'create pfile from spfile' on both databases.

One pfile has the list of expected parameters.

The other one has about 150 parameters that start with either a single or double underscore.

I know what the underscore parameters are.

My question is, why does one pfile have them and the other one not?

Just curious.

Many thanks for any feedback or documentation references.

-gary
This post has been answered by Hans Forbrich on Mar 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2012
Added on Mar 8 2012
11 comments
2,107 views