Shulou(Shulou.com)05/31 Report--

This article mainly introduces the matters needing attention of changing pfile under RAC or GI environment, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

The content of the pfile file named initsid.ora is generally as follows

Spfile='+DATA/data/sid/spfile.ora'

Create pfile from spfile

Then the original content has changed from spfile='+DATA/data/sid/spfile.ora' to the same as the content in spfile, which is still not a big problem. The most important thing is that you must not create spfile from pfile; directly, otherwise the spfile content will become spfile='+DATA/data/sid/spfile.ora', and the contents of all parameter files will be lost.

The general modifications are as follows

Create pfile='/home/pfile' from spfile='+DATA/data/sid/spfile.ora'

Modify the / home/pfile file again

Re-create spfile='+DATA/data/sid/spfile.ora' from pfile='/home/pfile'

Thank you for reading this article carefully. I hope the article "what are the points for attention in changing pfile under RAC or GI environment" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.