Hi experts:
We have 11.2.0.4 on Linux.
- I set the compatible = 11.2.0 in the pfile. I installed 11.2.0.4 software. What compatible parameter I should set?
- We use spfile file. A developer wants me to change the compatible to 11.2.0.4. I did in the pfile and bounced the database. When I startup database I used startup pfile=zzzz.ora. But when I did "show parameter compatible" it still shows 11.2.0. Is this because the spfile has not changed?
- How to create a spfile from pfile in my case?
Thank you very much for your help.